import csv import psycopg2 conn_string="dbname='Training' user='admin' password='admin' " conn=psycopg2.connect(conn_string) cursor=conn.cursor() print "Connected!\n" # reader=csv.reader(open('product.product_.csv','rb')) #reader=csv.reader(open(C:\Users\Mostafa\Downloads\New folder\product.product_.csv)) with open('C:\Users\Mostafa\Downloads\New folder\product.product_.csv', 'rb') as f: reader = csv.reader(f) for row in reader: print row Query="insert into product_template (name) VALUES ('"+str( row )+"') RETURNED id" cursor.excute(Query) conn.commit() print "Done!\n"
Traceback (most recent call last): File "D:\Code\Java\Import\src\CSV\__init__.py", line 19, in <module> cursor.excute(Query) AttributeError: 'psycopg2._psycopg.cursor' object has no attribute 'excute'
execute
excute
cursor.execute(Query)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)