属性错误:'sqlite3.Connection'对象属性'execute'是只读的 - Python



我得到一个AttributeError:"sqlite3.Connection"对象属性"execute"是只读的,我真的不知道为什么,因为我成功地对其他表使用了相同的INSERT INTO方法。你能告诉我问题出在哪里吗?

import os, sys
import sqlite3
from sqlite3 import Error
connection = None
try:
connection = sqlite3.connect('database.db')
cursor = connection.cursor()
print("Connection to SQLite DB successful")
except Error as e:
print(f"The error '{e}' occurred")
cursor.execute("""CREATE TABLE IF NOT EXISTS Tickets ( 
id INT,
indexNumber INT,
movieNumber INT,
screeningHall VARCHAR(30),
movieName VARCHAR(30),
screeningDate VARCHAR(30),
screeningTime VARCHAR(30),
ticketRow INT,
ticketCol INT,
ticketType VARCHAR(30),
ticketPrice VARCHAR(30))"""
)
idNum = 0
tempInfoDict = {'indexNumber': 0, 'movieNumber': 1, 'hall': 'Hall 1', 'name': 'Terminator', 'date': '2020-09-01', 'time': '10:40', 'row': 1, 'col': 0}
connection.execute = ("INSERT INTO Tickets (id, indexNumber, movieNumber, screeningHall, movieName, screeningDate, screeningTime, ticketRow, ticketCol, ticketType, ticketPrice) values(?,?,?,?,?,?,?,?,?,?,?)",
(idNum, tempInfoDict['indexNumber'], tempInfoDict['movieNumber'], tempInfoDict['hall'], tempInfoDict['name'],
tempInfoDict['date'], tempInfoDict['time'], tempInfoDict['row'], tempInfoDict['col'], 'Basic', '$20'))
connection.commit()
connection.close()

谢谢!

connection.execute = ("INSERT INTO Tickets (id, indexNumber, movieNumber, screeningHall, movieName, screeningDate, screeningTime, ticketRow, ticketCol, ticketType, ticketPrice) values(?,?,?,?,?,?,?,?,?,?,?)",
(idNum, tempInfoDict['indexNumber'], tempInfoDict['movieNumber'], tempInfoDict['hall'], tempInfoDict['name'],
tempInfoDict['date'], tempInfoDict['time'], tempInfoDict['row'], tempInfoDict['col'], 'Basic', '$20'))

应该是

cursor.execute("INSERT INTO Tickets (id, indexNumber, movieNumber, screeningHall, movieName, screeningDate, screeningTime, ticketRow, ticketCol, ticketType, ticketPrice) values(?,?,?,?,?,?,?,?,?,?,?)",
(idNum, tempInfoDict['indexNumber'], tempInfoDict['movieNumber'], tempInfoDict['hall'], tempInfoDict['name'],
tempInfoDict['date'], tempInfoDict['time'], tempInfoDict['row'], tempInfoDict['col'], 'Basic', '$20'))

最新更新