Загрузка данных


import sqlite3
with sqlite3.connect("database.db") as db:
    cursor = db.cursor()
    query = """
    CREATE TABLE IF NOT EXISTS users(
        id INTEGER PRIMARY KEY,
        name VARCHAR(30),
        age INTEGER(3),
        balance INTEGER NOT NULL DEFAULT 2000,
        login VARCHAR(15),
        password VARCHAR(20)
    );
    CREATE TABLE IF NOT EXISTS casino(
        name VARCHAR(50),
        description TEXT(300),
        balance BIGINT NOT NULL DEFAULT 10000
    )
    """
    cursor.executescript(query)