You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
./querycsv.py -i injectorLog-23894-eager.csv -o failures-23894-eager.log "SELECT * FROM injectorLog-23894-eager WHERE status == \\"FAILURE\\""
Traceback (most recent call last):
File "./querycsv.py", line 307, in <module>
qcsv(csvfiles, outfile, file_db, keep_db, sqlcmd)
File "./querycsv.py", line 211, in qcsv
csv_to_sqldb(conn, csvfile, tablename)
File "./querycsv.py", line 156, in csv_to_sqldb
sqldb.execute("create table %s (%s);" % (table_name, colstr))
sqlite3.OperationalError: near "-": syntax error
The issue went away when after I replaced the dashes with underscores. Perhaps a warning can be included, or at least some comment in the documentation?
Thanks for the cool tool!
The text was updated successfully, but these errors were encountered:
Perhaps it is even better to handle this issue in a way transparent to the user. That is, perform a "normalization" step for the names of the file/table so from the client point of view you don't have to care about special cases.
I got the following exception trace when doing:
The issue went away when after I replaced the dashes with underscores. Perhaps a warning can be included, or at least some comment in the documentation?
Thanks for the cool tool!
The text was updated successfully, but these errors were encountered: