python - AttributeError：“函数”对象没有属性“提交”

Question

1) 创建数据库

store=sqlite3.connect("store . d b ")
c r =store .cursor()
c r .execute("create table if not exists store (salaries string, price integer ,numbers integer, Barcode integer primary key autoincrement)")
c r. execute("create table if not exists ban too (salaries  string  , price integer ,numbers  integer ,barcode  integer,"
           "foreign key (barcode) references store(Barcode))")
c r. execute("create table if not exists shirt (salaries  string  , price integer ,numbers  integer ,barcode  integer,"
           "foreign key (barcode) references store(Barcode))")

2）创建 3 个函数来在 GUI 中执行工作（注意 GUI 代码不在此处，但在提交中出现语法错误，但在第一次提交正在执行任务但现在我不知道发生了什么，它没有执行任务）

3）此功能的第一个

def store():
    A0 = a .get()
    B0 = b .get()
    C0 = c .get()
    c r .execute("insert  into store (salaries ,price, numbers) values(?,?,?)", (A0, B0, C0))
    sav ty ()

4）这个第二个功能它的元素也将它保存在表禁令中

def bantoo0():
    c r. execute("insert  into ban too (salaries ,price ,numbers ,barcode ) select salaries, price ,numbers ,Barcode from store ")
    cr. execute("select salaries ,price ,numbers, barcode, min( row id ) from ban too ")
    cr. execute("delete from ban too where row id not in (select min(row id)from ban too group by salaries, price, numbers ,barcode )")
    sav ty()

5) 功能编号 3 也进行相同的禁令，但在表之间

def shirt0():
    c r. execute("insert  into shirt (salaries, price , numbers ,barcode) select salaries ,price ,numbers ,Barcode from store ")
    c r. execute("select salaries ,price ,numbers ,barcode, min(row id) from shirt ")
    c r. execute("delete from shirt where row id not in (select min(row id)from shirt group by salaries ,price ,numbers ,barcode )")
    sav ty()

6）在这里，它在过去制作工作以将数据保存在表中但现在没有问题

def sav ty():
    store . commit ()

标签： pythonpython-3.xsqlite