clients.py

import psycopg2
from config import config

def ajouter_client(nom, addresse, telephone, email):
	 #insert element in the table 
    sql = "INSERT INTO Vendeurs(nom, addresse, telephone, email) VALUES(%s,%s,%s,%s)"
    conn = None
    try:
        # read database configuration
        params = config()
        # connect to the PostgreSQL database
        conn = psycopg2.connect(**params)
        # create a new cursor
        cur = conn.cursor()
        # execute the INSERT statement
        cur.execute(sql,(nom,addresse,telephone,email))
        # commit the changes to the database
        conn.commit()
        # closee communication with the database
        cur.close()
    except (Exception, psycopg2.DatabaseError) as error:
        print(error)
    finally:
        if conn is not None:
            conn.close()
    print('\nOperation done well')    


def rechercher_client(telephone):
	   sql = "SELECT * FROM Vendeurs WHERE telephone = %s" # WHERE telephone = tel
    conn = None
    try:
        # read database configuration
        params = config()
        # connect to the PostgreSQL database
        conn = psycopg2.connect(**params)
        # create a new cursor
        cur = conn.cursor()
        # execute the SELECT statement
        cur.execute(sql,(telephone,))
        vendeur = cur.fetchall()
        print(vendeur)
        # commit the changes to the database
        conn.commit()
        # close communication with the database
        cur.close()
    except (Exception, psycopg2.DatabaseError) as error:
        print(error)
    finally:
        if conn is not None:
            conn.close()
    print('\nOperation done well')  

def supprimer_client(telephone):
    """ delete part by part name """
    conn = None
    rows_deleted = 0
    try:
        # read database configuration
        params = config()
        # connect to the PostgreSQL database
        conn = psycopg2.connect(**params)
        # create a new cursor
        cur = conn.cursor()
        # execute the UPDATE  statement
        cur.execute("DELETE FROM parts WHERE part_id = %s", (telephone,))
        # get the number of updated rows
        rows_deleted = cur.rowcount
        # Commit the changes to the database
        conn.commit()
        # Close communication with the PostgreSQL database
        cur.close()
    except (Exception, psycopg2.DatabaseError) as error:
        print(error)
    finally:
        if conn is not None:
            conn.close()
    #return the number of update row        
    return rows_deleted

if __name__ == '__main__':
    numberTel=int(input("give the client's number: "))
    rechercher_client(numberTel)
    #supprimer_client(numberTel)