元组可以直接添加进数据库吗,将元组的元素插入数据库

I have a tuple that i wanna store its elements, I'm trying to insert it as following and it gives the following error, what am i doing wrong ? records_to_be_inserted is the tuple that has 8 elements.

with self.connection:

cur = self.connection.cursor()

cur.executemany("INSERT INTO rehberim(names, phone, mobile, email, \

photo, address, note, date) VALUES(?, ?, ?, ?, ?, ?, ?, ?)", self.records_to_be_inserTed)

Traceback (most recent call last):

File "/home/tayfun/workspace/personal_guide/modules/mainwindow.py", line 57, in save_records

photo, address, note, date) VALUES(?, ?, ?, ?, ?, ?, ?, ?)", self.records_to_be_inserTed)

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 8, and there are 0 supplied.

解决方案

The query must have all the data ready to be inserted.

You are calling a function in the query, which i guess you want that provides the data but that wont work.

You need to pass all the data in variables or locate them in the tuple index (like: tuple_name[1], tuple_name[4], etc.)

Example:

myTuple = ['a','b','c','d','e','f','g']

cur.executemany("INSERT INTO rehberim(names, phone, mobile, email, \

photo, address, note, date) VALUES({0}, {1}, {2}, {3}, {4}, {5}, {6}" .format (myTuple[1], myTuple[2], myTuple[3], myTuple[4], myTuple[5], myTuple[6], myTuple[7])