I would like to load CSV file into SQLite coded using SQLAlchemy (to fit other code).
The command line load looks like this:
create table MYTABLE (...);
.separator ','
.import myfile.csv MYTABLE
(Avoiding per row INSERTs) Is there an equivalent SQLAlchemy operation?
Thanks
The .import command is part of the CLI and not part of the SQLite syntax.
If you want to import the content of the CSV file you can use the python's csv reader and using SQLAlchemy to insert every row (from the CSV) to the database:
>>> import csv
>>> with open('myfile.csv', 'rb') as csvfile:
... tbl_reader = csv.reader(csvfile, delimiter=',')
... for row in tbl_reader:
... mytbl.insert().values(id=row[0], name=row[1], content=row[2])
rb mode should be just 'r', otherwise you'll get "_csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)".