Guest User

Untitled

a guest
Jan 17th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. def CreateTable (daDB, daFile, daTableName): #Creates a table with column headers as first row of file
  2. con=sqlite3.connect(daDB)
  3. curs=con.cursor()
  4. LinesList=FileReadIn(daFile)
  5. Headers=LinesList[0]
  6. HeadersString=""
  7. for word in Headers:
  8. HeadersString += word + ", "
  9. DaHeadersString=HeadersString[0:-2]
  10. daQuery="'create table " + daTableName + " (" + DaHeadersString + ")'"
  11. print (daQuery)
  12. curs.execute(daQuery)
  13. con.commit()
  14. con.close()
  15.  
  16. CreateTableFromText ('animalsheaderstest.sqltdb','animals.txt','animalstable')
  17. 'create table animalstable (Owner, Name, Species)'
  18.  
  19. Traceback (most recent call last):
  20. File "<pyshell#108>", line 1, in <module>
  21. CreateTable ('animalsheaderstest.sqltdb','animals.txt','animalstable')
  22. File "/Users/zeintawil/Zeins_Files/School/Senior/OPIM_399/python/practice/ReadInPrac.py", line 62, in CreateTable
  23. curs.execute(daQuery)
  24. OperationalError: near "'create table animalstable (Owner, Name, Species)'": syntax error
  25.  
  26. daQuery="create table " + daTableName + " (" + DaHeadersString + ")"
Add Comment
Please, Sign In to add comment