Laba DB

import sqlite3

connection = sqlite3.connect('person.db')

cursor = connection.cursor()

cursor.execute('DROP TABLE IF EXISTS person;')

cursor.execute(
'''
    CREATE TABLE person (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        first_name TEXT,
        last_name TEXT
    )
'''
)

connection.commit()

##################### INSERT SECTION BEGINS #################################
cursor.execute('INSERT INTO person(first_name, last_name) VALUES ("Andy", "Konstantinov")')
cursor.execute('INSERT INTO person(first_name, last_name) VALUES ("Alex", "Lomako")')
cursor.execute('INSERT INTO person(first_name, last_name) VALUES ("Andy", "Suvorov")')
cursor.execute('SELECT * FROM person');

connection.commit()

for record in cursor.fetchall():
    print(record)
##################### INSERT SECTION ENDS   #################################

print('====================================================================')

##################### UPDATE SECTION BEGINS #################################
cursor.execute('UPDATE person SET first_name = "Andrew" WHERE first_name = "Andy"');
cursor.execute('SELECT * FROM person');

connection.commit()

for record in cursor.fetchall():
    print(record)
##################### UPDATE SECTION ENDS   #################################

print('====================================================================')

##################### DELETE SECTION BEGINS #################################
cursor.execute('DELETE FROM person WHERE first_name = "Alex"');
cursor.execute('SELECT * FROM person');

connection.commit()

for record in cursor.fetchall():
    print(record)
##################### DELETE SECTION ENDS   #################################