MX5nJiqF

1import sqlite3
2
3conn = sqlite3.connect('kontakty.db')
4conn.executescript("""DROP TABLE IF EXISTS kontakty;
5            CREATE TABLE IF NOT EXISTS kontakty(
6            NUMBER INT PRIMARY KEY NOT NULL,
7            NAME TEXT NOT NULL,
8            SURNAME TEXT NOT NULL);""")
9
10conn.execute("INSERT INTO kontakty (NUMBER,NAME,SURNAME) VALUES ('123456789', 'JAN', 'KOWALSKI')")
11conn.execute("INSERT INTO kontakty (NUMBER,NAME,SURNAME) VALUES ('987654321', 'PAWEL', 'NOWAK')")
12conn.execute("INSERT INTO kontakty (NUMBER,NAME,SURNAME) VALUES ('123123123', 'KRZYSZTOF', 'KOWALSKI')")
13cursor = conn.execute("SELECT NUMBER, NAME, SURNAME from kontakty")
14
15def AddNumber():
16    number = int(input("Podaj numer telefonu: "))
17    name = input("Podaj imie: ")
18    surname = input("Podaj nazwisko: ")
19    conn.execute("INSERT INTO kontakty (NUMBER,NAME,SURNAME) VALUES ('{}', '{}', '{}')".format(number, name, surname))
20def ShowAllNumbers():
21    rows = cursor.fetchall()
22    for row in rows:
23        print(row)
24def Search(options, value):
25    if options == 1:
26        with conn:
27            print(cursor.execute(f'SELECT * FROM kontakty WHERE NUMBER = "{value}";'))
28    elif options == 2:
29        with conn:
30            print(cursor.execute(f'SELECT * FROM kontakty WHERE NAME = "{value}";'))
31    elif options == 3:
32        with conn:
33            cur = conn.execute(f'SELECT * FROM kontakty WHERE surname = "{value}";')
34
35            for row in cur:
36                print(row)
37
38AddNumber()
39ShowAllNumbers()
40Search(3, "NOWAK")
41
42
43
44
45conn.close()