/
sseerr
/
Python_curs_Module_14
Обзор
Документация
Войти
/
sseerr
/
Python_curs_Module_14
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
crud_functions.py
39 строк
1 KB
sseerr1
Update crud_functions.py
18 янв 2025, 21:57
Не верифицирован
18 янв 2025, 21:57
af2ff68
Код
Авторство
О чём код?
import sqlite3 def initiate_db(): connection = sqlite3.connect('initiate_db') cursor = connection.cursor() cursor.execute(''' CREATE TABLE IF NOT EXISTS Products( id INT PRIMARY KEY, title TEXT NOT NULL, description TEXT, price INT NOT NULL ); ''') connection.commit() connection.close() def insert_products(): for i in range(1, 5): id=i title = f'Продукт {i}' description = f'Описание {i}' price = i*100 connection = sqlite3.connect('initiate_db') cursor = connection.cursor() cursor.execute(''' INSERT INTO Products (id, title, description, price) VALUES (?, ?, ?, ?) ''', (id, title, description, price)) connection.commit() connection.close() def get_all_products(): connection = sqlite3.connect('initiate_db') cursor = connection.cursor() cursor.execute('SELECT * FROM Products') connection.commit() prod = cursor.fetchall() connection.commit() connection.close() return prod