Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def CreateTable (daDB, daFile, daTableName): #Creates a table with column headers as first row of file
- con=sqlite3.connect(daDB)
- curs=con.cursor()
- LinesList=FileReadIn(daFile)
- Headers=LinesList[0]
- HeadersString=""
- for word in Headers:
- HeadersString += word + ", "
- DaHeadersString=HeadersString[0:-2]
- daQuery="'create table " + daTableName + " (" + DaHeadersString + ")'"
- print (daQuery)
- curs.execute(daQuery)
- con.commit()
- con.close()
- CreateTableFromText ('animalsheaderstest.sqltdb','animals.txt','animalstable')
- 'create table animalstable (Owner, Name, Species)'
- Traceback (most recent call last):
- File "<pyshell#108>", line 1, in <module>
- CreateTable ('animalsheaderstest.sqltdb','animals.txt','animalstable')
- File "/Users/zeintawil/Zeins_Files/School/Senior/OPIM_399/python/practice/ReadInPrac.py", line 62, in CreateTable
- curs.execute(daQuery)
- OperationalError: near "'create table animalstable (Owner, Name, Species)'": syntax error
- daQuery="create table " + daTableName + " (" + DaHeadersString + ")"
Add Comment
Please, Sign In to add comment