# import psycopg2
# import psycopg2.extras
# import pandas as pd

# def upload():
#     conn= psycopg2.connect('postgres://qyqfclhd:0fYqqyr1sQsb00YWU_bNLsvrz3YJA74x@lallah.db.elephantsql.com/qyqfclhd')
#     cur=conn.cursor()
#     conn.cursor()
   
#     df = pd.read_csv('birthdays.csv')        
#     for index, row in df.iterrows():
#         date= row['date']
#         name = row['name']
#         email = row['email']
#         conn.cursor()
#         insert_script= 'INSERT INTO birthday (date, name, email) VALUES (%s,%s,%s)'
#         insert_value=(date,name,email)
#         cur.execute(insert_script,insert_value)
#         print('Data inserted successfully')
#         conn.commit()
#     cur.close()
#     conn.close()

# upload()