Generation

generate functionWed, 29 Mar 2023

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()

Want to kickstart your project?Use the new AI Studio to create your code