eRwLAFKQ

1import sqlite3
2conn = sqlite3.connect('products.db')
3c = conn.cursor()
4
5# подготовка запроса на выполнение
6drop_table_products = '''
7DROP TABLE IF EXISTS product;
8'''
9create_table_products = '''
10CREATE TABLE product(
11`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
12`name` TEXT,
13`price` FLOAT
14);
15'''
16list_table_name = '''
17SELECT name FROM sqlite_master WHERE type='table';
18'''
19
20values_product = {
21    'name': 'iphone X',
22    'price': 80000
23}
24
25columns = ', '.join(values_product.keys())
26placeholders = ', '.join('?' * len(values_product))
27sql_insert_product = 'INSERT INTO Product ({}) VALUES ({})'.format(columns, placeholders)
28print(sql_insert_product)
29
30c.execute(drop_table_products)
31c.execute(create_table_products)
32# выполнение execute
33conn.commit()
34c.execute(list_table_name)
35
36for row in c.execute(list_table_name):
37    print(row)
38
39c.execute (sql_insert_product, [values_product[key] for key in columns.split(', ')])
40conn.commit()
41c.execute('SELECT * FROM Product')
42
43data_row = c.fetchone()
44
45print(data_row)
46conn.close()