Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2
- import csv
- csv_data = csv.reader(file('SampleData1.csv'))
- database = psycopg2.connect (database = "**", user="**", password="***", host="**", port="**")
- cursor = database.cursor()
- delete = """Drop table if exists "Real".SampleDataOne"""
- print (delete)
- mydata = cursor.execute(delete)
- cursor.execute("""Create Table "Real".SampleDataOne
- (Username varchar(55),
- TimeStamp timestamp,
- Week date,
- Actual_Sale_Date date,
- Estimated_Closing_Date date,
- Last_Name_First_Name varchar(55),
- Ages varchar(55)
- );""")
- print "Table created successfully"
- next(csv_data)
- for row in csv_data:
- cursor.execute("""Insert into "Real".SampleDataOne(Username,TimeStamp, Week, Actual_Sale_Date, Estimated_Closing_Date,
- Last_Name_First_Name, Ages)"""
- """VALUES (%s,%s,%s,%s,%s,%s,%s)""",
- row)
- cursor.close()
- database.commit()
- database.close()
- print "CSV imported"
- Drop table if exists "Real".SampleDataOne
- Table created successfully
- Traceback (most recent call last):
- File "C:/Users/Desktop/Programming/SampleData1Python.py", line 61, in <module>
- row)
- DataError: invalid input syntax for type date: ""
- LINE 1: ...****@jcp.com','****@comcast.net','No','FALSE','','','')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement