import sqlite3

conn = sqlite3.connect('sql.db')
cursor = conn.cursor()
cursor.execute("""CREATE TABLE users (id int, name varchar(30), sorname varchar(30), adress varchar(100));""")
conn.commit()
results = cursor.fetchall()
results2 = cursor.description
print(results)
print(results2)
input("db создана. Жми Enter")
cursor.execute("""INSERT INTO users (id, name, sorname, adress) VALUES ('1', 'Test', 'TestSorname', 'Test adress');""")
conn.commit()
results1 = cursor.fetchall()
print(results1)
input("table заполнен. Жми Enter")
cursor.execute("""SELECT * FROM users""")
conn.commit()
results5 = cursor.fetchall()
desc1 = cursor.description
print(results1)
print(desc1)
input("Всё прошло на ура")
conn.close()