Eu acho que fiz bem o desafio, mas não consigo checar se deu certo por causa desse erro.
import sqlite3
def plugin():
conn = sqlite3.connect('TechMais.db')
return conn
def create_table_products():
conn = plugin()
cursor = conn.cursor()
cursor.execute(
"""
CREATE TABLE IF NOT EXISTS products(
id INTEGER PRIMARY KEY,
name TEXT,
price INTEGER,
)
"""
)
conn.commit()
conn.close()
def create_product(name, price):
conn = plugin()
cursor = conn.cursor()
cursor.execute(
"""
INSERT INTO products(name, price) \
VALUES (?, ?)
""", (name, price)
)
conn.commit()
conn.close()
def list_products():
conn = plugin()
cursor = conn.cursor()
cursor.execute(
"""
SELECT * FROM products
"""
)
products = cursor.fetchall()
for product in products:
print(product)
conn.commit()
conn.close()
