problem:import csv data

[ÊØÖê´ýÍÃ]

import sqlite3
con = sqlite3.connect('/home/stock.db')
cur = con.cursor()
cur.execute('''CREATE TABLE quote (ticker TEXT,date TEXT, popen TEXT, high TEXT, low TEXT,vol TEXT,adjclose TEXT);''')
i=/tmp/data.csv
cur.execute('.separator "," ')
cur.execute('.import %s quote' % i)
con.commit()
cur.close()
con.close()

the output is :
cur.execute('.separator"," ')
sqlite3.OperationalError: near ".": syntax error

how to fix it?

 

[Miki Tebeka]

..separator (and .import) are not SQL commands but "sqlite3" commands.
You can get the same effect with the following code:

with open('/tmp/data.csv') as fo:
reader = csv.reader(fo)
cur.executemany('INSERT INTO quote VALUES (?, ?, ?, ?, ?, ?, ?)'), reader)

HTH

 

[Miki Tebeka]

..separator (and .import) are not SQL commands but "sqlite3" commands.
You can get the same effect with the following code:

with open('/tmp/data.csv') as fo:
reader = csv.reader(fo)
cur.executemany('INSERT INTO quote VALUES (?, ?, ?, ?, ?, ?, ?)'), reader)

HTH