def info(self):
sql = "SELECT * FROM items_categories WHERE category_id = '{}'".format(
self.category_id)
cursor.execute(sql)
result = cursor.fetchone()
db.commit()
return result
def insert(self):
sql = "INSERT INTO items (category_id, item_name, item_price) VALUES('{}', '{}', '{}')".format(self.category_id, self.item_name, self.item_price)
cursor.execute(sql)
self.item_id = cursor.lastrowid
db.commit()
def delete(self):
sql = "DELETE FROM item_categories WHERE category_id = '{}'".format(
self.category_id)
cursor.execute(sql)
db.commit()
def update(self):
sql = "UPDATE item_categories SET category_name = '{}' WHERE category_id = '{}'".format(
self.category_name, self.category_id)
cursor.execute(sql)
db.commit()
def insert(self):
sql = "INSERT INTO items_categories (category_name) VALUES('{}')".format(
self.category_name)
cursor.execute(sql)
self.category_id = cursor.lastrowid
db.commit()
def get(self):
sql = "SELECT * FROM items_categories"
cursor.execute(sql)
result = cursor.fetchall()
db.commit()
return result