从insert SQLLite3中获取操作错误

Question

def insert(BookID,Author,BookFormatID,Title,BookStatus,Category,RedemptionCode,StudentAssignedId):
    BASE_DIR = os.path.dirname(os.path.abspath(__file__))
    db_path = os.path.join(BASE_DIR, "AVDatabase.db")
    conn=sqlite3.connect(db_path)
    cur=conn.cursor()
    cur.execute("INSERT INTO Books(BookID,Author,BookFormatID,Title.BookStatus,Category,RedemptionCode,StudentAssignedId) VALUES(?,?,?,?,?,?,?,?)", (BookID,Author,BookFormatID,Title,BookStatus,Category,RedemptionCode,StudentAssignedId))
    conn.commit()
    conn.close()
    view()

此事件在按钮上调用：

def add_command():
    back.insert(BookId_text.get(),Author_text.get(),Book_Format_Id_text.get(),Book_Title_text.get(),Book_Status_text.get(),Category_text.get(),Redemption_Code_text.get(),Student_Assigned_Id_text.get())
    list1.delete(0,END)
    list1.insert(END,(BookId_text.get(),Author_text.get(),Book_Format_Id_text.get(),Book_Title_text.get(),Book_Status_text.get(),Category_text.get(),Redemption_Code_text.get(),Student_Assigned_Id_text.get()))

所以，基本的入门小部件和即时通讯即将拉我的头发

Answer 1

在insert函数中，Title.BookStatus应该是Title, BookStatus

---

如果使用多行字符串，您可能会更幸运地避免这种错误 对于长SQL：

cur.execute("""INSERT INTO Books(BookID
                                 , Author
                                 , BookFormatID
                                 , Title
                                 , BookStatus
                                 , Category
                                 , RedemptionCode
                                 , StudentAssignedId) VALUES (?,?,?,?,?,?,?,?)""",
    (BookID, Author, BookFormatID, Title,
     BookStatus, Category, RedemptionCode, StudentAssignedId))