python - sqlite3中的错误元组对象错误如何解决

Question

我收到如下所示的错误：任何解决错误的建议，我尝试将元组转换为列表并运行代码，但它不起作用。

当我执行测试脚本时，“元组”对象不支持项目分配。解决错误的任何建议

import sqlite3
import os


class sqlite1():

    
    def __init__(self, pa, na, rq):

        
        self.dbname = None
        self.name = None
        self.id1 = 0



        if rq == 'open':
          
            print(pa, na)
            self.hdl = (os.path.join(pa, na),'open')
            if not b'id1' in self.hdl or not b'ns' in self.hdl:
                print("open")

            try:
                self.id1 = int(self.hdl[b'id1'])
                self.name = self.hdl[b'ns']
            except:
                pass

        else:
           
            self.hdl = (os.path.join(pa, na),'c')
            self.id1 = 0
            print("File created")

            self.hdl[b'id1'] = str(self.id1)
            #sqlite1.reqdict = self.hdl


    def db_connect(self):
       
        con = sqlite3.connect(self.na)
        return con

测试脚本是：

from sqlite25 import *
from sqlite25 import sqlite1

class Test1:
    def __init__(self, pa, na, rq):
        self.pa = pa
        self.na = na
        self.id1 = 0
        self.scm1 = sqlite1(pa, na, rq)
        


    def fileopen(self, pa, na, rq):
        self.scm1 = sqlite1(pa, na, rq)
        



if __name__ == '__main__':
   
    tst = Test1('', 'file1.db', 'c')
    tst.fileopen('', 'file1.db', 'open')
   
    con1 = sqlite1.db_connect(tst) # connect to the database
    #cur = con1.cursor()

标签： pythonsqlite