I have made a database with a table called product. When I run the code below I get an error - sqlite3.OperationalError: no such table: product. I have used a database browser to check and the table does exist. Any ideas? The code and the file are both in the same folder. Thanks
from tkinter import *
from tkinter import ttk
import sqlite3
import os.path
class Product:
db_name = 'database.db'
def __init__(self, wind):
self.wind = wind
self.wind.title('IT Products')
frame = LabelFrame (self.wind, text = 'Add new record')
frame.grid (row = 0, column = 1)
Label (frame, text = 'Name: ').grid (row = 1, column = 1)
self.name = Entry (frame)
self.name.grid(row = 1, column = 2)
Label (frame, text = 'Price: ').grid (row = 2, column = 1)
self.price = Entry (frame)
self.price.grid(row = 2, column = 2)
ttk.Button (frame, text= 'Add record').grid (row = 3, column =2 )
self.message = Label (text = '',fg = 'red')
self.message.grid (row = 3, column = 0)
self.tree = ttk.Treeview (height = 10, colum =2)
self.tree.grid(row = 4, column = 0, columnspan = 2)
self.tree.heading('#0', text = 'Name', anchor = W)
self.tree.heading(2, text = 'Price', anchor = W)
ttk.Button (text = 'Delete record').grid (row = 5, column = 0)
ttk.Button (text = 'Edit record').grid (row = 5, column = 1)
self.viewing_records ()
def run_query (self, query, parameters = ()): # database connection
with sqlite3.connect(self.db_name) as conn:
cursor = conn.cursor()
query_result = cursor.execute (query, parameters)
conn.commit()
return query_result
def viewing_records(self):
records = self.tree.get_children()
for element in records:
self.tree.delete (element)
query = 'SELECT * FROM product ORDER BY name DESC'
db_rows = self.run_query (query)
for row in db_rows:
self.tree.insert ('', 0, text = row[1], values = row[2])
if __name__ == '__main__':
wind = Tk()
application = Product (wind)
wind.mainloop()
