Das deutsche Python-Forum

Code: Alles auswählen

import csv
import sqlite3


con = sqlite3.connect("LGORT")
cur = con.cursor()
cur.execute("CREATE TABLE invoice (col1 INTEGER, col2 TEXT, col3 INTEGER);")

with open('tbl_LGORT.csv') as fin:
        dr = csv.DictReader(fin)
        to_db = [(i["col1"], i["col2"], i["col3"]) for i in dr]

cur.executemany("Insert into invoice (col1, col2, col3 Values (?, ?, ?);", to_db)
con.commit()

Code: Alles auswählen

cursor.execute('INSERT INTO  prices VALUES (?,?,?)', [t])
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 3, and there are 1 supplied.

Code: Alles auswählen

import csv
import sqlite3


con = sqlite3.connect("LGORT")
cur = con.cursor()
cur.execute("CREATE TABLE ivoice (Lgort_id INTEGER, City TEXT, Werks_id INTEGER);")

with open('tbl_LGORT.csv') as input_file:
        reader = csv.DictReader(input_file)
        to_db = [(i["Lgort_id"], i["City"], i["Werks_id"]) for i in reader]

cur.executemany("Insert into invoice (Lgort_id, City, Werks_id) Values (?, ?, ?);", to_db)
con.commit()

Code: Alles auswählen

In [2]: 'LGORT_ID' == 'Lgort_id'
Out[2]: False

Code: Alles auswählen

In [1]: data = {'LGORT_ID': 123}

In [2]: data['LGORT_ID']
Out[2]: 123

In [3]: data['Lgort_id']
---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
<ipython-input-3-900b157b19d7> in <module>()
----> 1 data['Lgort_id']

KeyError: 'Lgort_id'