如何用sqlite创建多个数据库

Question

我想创建多个数据库，但我不知道怎么做

这是python代码:

# 1 - for import data in listbox
def clear_item_list():
items.delete(0, END)
# 2 - for import data in listbox
def fill_item_list(items):
for item_ in items:
items.insert(END, item_)
# 3 - for import data in listbox
def item_list_view():
clear_item_list()
items = app.data_1.view()
fill_item_list(items)

# and that for placement data in entries
def get_selected_row_item(event):
global selected_item
if len(items.curselection()) > 0:
index = items.curselection()[0]
selected_item = items.get(index)[:]
item_name.delete(0, END)
item_name.insert(END, selected_item[1])
item_price.delete(0, END)
item_price.insert(END, selected_item[2])




items.bind("<<ListboxSelect>>", get_selected_row_item)

这个代码是用来创建一个表的:

"CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY , Namee VARCHAR , price INTEGER )"

我不知道这是不是我的问题，因为当我想使用price时，输入data是string python会抛出这个错误:

Exception in Tkinter callback
Traceback (most recent call last):
File "C:UsersGreenAppDataLocalProgramsPythonPython39libtkinter__init__.py", line 1892, in __call__
return self.func(*args)
File "D:pythonWindowsProjectappmanagermanager_sign_in.py", line 44, in back_to_main_manager
main_screen()
NameError: name 'main_screen' is not defined
Exception in Tkinter callback
Traceback (most recent call last):
File "C:UsersGreenAppDataLocalProgramsPythonPython39libtkinter__init__.py", line 1892, in __call__
return self.func(*args)
File "D:pythonWindowsProjectappmanagersign.py", line 33, in back_to_main_mngr
main_screen()
NameError: name 'main_screen' is not defined
Exception in Tkinter callback
Traceback (most recent call last):
File "C:UsersGreenAppDataLocalProgramsPythonPython39libtkinter__init__.py", line 1892, in __call__
return self.func(*args)
File "D:pythonWindowsProjectappmain.py", line 33, in user_sign
user_screen()
NameError: name 'user_screen' is not defined
Traceback (most recent call last):
File "D:pythonWindowsProjectappmain.py", line 4, in <module>
from app.user.user_sign_in import *
File "D:pythonWindowsProjectappuseruser_sign_in.py", line 240, in <module>
user_screen()
File "D:pythonWindowsProjectappuseruser_sign_in.py", line 236, in user_screen
item_list_view()
File "D:pythonWindowsProjectappuseruser_sign_in.py", line 55, in item_list_view
fill_item_list(items)
File "D:pythonWindowsProjectappuseruser_sign_in.py", line 48, in fill_item_list
items.insert(END, item_)
TypeError: 'str' object cannot be interpreted as an integer

，这是输入数据:(1， 'pizza'， '6')

如果你可以帮助我，请告诉我，如果你需要，我给你更多的数据

Answer 1

问题出在下面的函数上:

def fill_item_list(items):  # <- items is passed argument
for item_ in items:
# "items" below is expected to be an instance of tkinter Listbox
# but it is actually the passed argument (a list object)
items.insert(END, item_)

您在传递的参数上使用了与tkinterListbox相同的名称。

为传递的参数使用另一个名称:

def fill_item_list(data):  # used "data" instead of "items"
for item_ in data:
items.insert(END, item_)