Advertisement
Guest User

Untitled

a guest
Aug 1st, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. DatabaseError: ORA-00928: missing SELECT keyword
  2.  
  3. def Create_list():
  4. reader = csv.reader(open("Query_result_combined.csv","r"))
  5. lines=[]
  6. for line in reader:
  7. lines.append(line)
  8. print(lines[:1])
  9. print(lines[:2])
  10. return lines
  11.  
  12. def Insert_data():
  13. db_user = "XXXXXXX" # replace this with correct user name
  14. db_password = "********" # Set the environment variable DB_PASSWORD
  15. db_connection_name = "***********"# repalce this with correct database name
  16. #db_driver = "oracle.jdbc.OracleDriver","C:/Oracle/32bitclient/product/11.2.0/client_1/jdbc/lib/ojdbc6.jar"
  17. print("Connecting Now!!")
  18. con = cx_Oracle.connect(db_user,db_password,db_connection_name)
  19. print("Connected to Oracle!!")
  20. lines=Create_list()
  21. #print lines
  22. cur=con.cursor()
  23. print("Inserting data")
  24. cur.executemany("INSERT INTO BRIODB.A608232_QUERY_RESULT ('InteractionId','QueryId','Score','StartOffsetInMs','EndOffsetInMs','SpeakerRole','QueryIdentity','SpeakerId') VALUES(:1,:2,:3,:4,:5,:6,:7,:8)",lines)
  25. con.commit ()
  26. cur.close()
  27. print("completed")
  28.  
  29. [['InteractionId', 'QueryId', 'Score', 'StartOffsetInMs', 'EndOffsetInMs',
  30. 'SpeakerRole', 'QueryIdentity', 'SpeakerId']]
  31. [['InteractionId', 'QueryId', 'Score', 'StartOffsetInMs', 'EndOffsetInMs',
  32. 'SpeakerRole', 'QueryIdentity', 'SpeakerId'], ['34118470', '27', '45.63345',
  33. '89900', '90980', 'U', 'e54fd492-8877-4534-997b-9dbe9a8fbd74', '']]
  34. Inserting data
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement