function to add new products to a mysqlite table called products with id, name, stock, price and category columns
import sqlite3 def add_products(new_name, new_stock, new_price, new_category): conn = sqlite3.connect("products.db") cur = conn.cursor() cur.execute("""INSERT INTO products (name, stock, price, category) VALUES (?, ?, ?, ?)""",(new_name, new_stock, new_price, new_category)) conn.commit() conn.close()