codewars/courses/sqlite/test_1.py

import sqlite3 as sq


def test_1():

    with sq.connect("saper.db") as con:
        cur = con.cursor() # Cursor
        
        cur.execute("""DROP TABLE users""") # Удалить тиблицу

        con.close()

'''
        cur.execute("""CREATE TABLE IF NOT EXISTS users (
                    name TEXT,  
                    sex INTEGER,
                    old INTEGER,
                    score INTEGER
                    )""")
'''

def saper_db():
    with sq.connect('saper.db') as con:
        cur = con.cursor()

        cur.execute("""CREATE TABLE IF NOT EXISTS users (
                    name TEXT,
                    sex INTEGER,
                    old INTEGER,
                    score INTEGER
                    )""")

        cur.execute('INSERT INTO users VALUES ("Михаил", 1, 22, 100)')
        cur.execute('INSERT INTO users VALUES ("Яна", 2, 24, 830)')
        cur.execute('INSERT INTO users VALUES ("Федор", 1, 32, 764)')


        cur.execute("""CREATE TABLE IF NOT EXISTS games (
                    user_id INTEGER,
                    score INTEGER,
                    time INTEGER
                    )""")
        
        for i in range(1, 8):
            cur.execute(f'INSERT INTO games VALUES ({i}, {i*200}, {i*10000})')        

        con.commit()



def main():
    # test_1()
    saper_db()



if __name__ == '__main__':
    main()