FfE6CqD2

1import sqlite3
2
3# Connection to database
4con = sqlite3.connect(':memory:')
5# con = sqlite3.connect('testdatenbank.db')
6
7cur = con.cursor()
8run = cur.execute
9
10# Query's
11run("""
12    CREATE TABLE IF NOT EXISTS person
13    (
14        "ID" INTEGER,
15        "Vorname" TEXT,
16        "Nachname" TEXT,
17        "Telefonnummer" TEXT,
18        PRIMARY KEY("ID" AUTOINCREMENT)
19    );
20""")
21
22vorname = "sdufz"
23nachname = "Elsen"
24nummer = "0123456789"
25
26run("""
27    INSERT INTO person (Vorname, Nachname, Telefonnummer)
28    VALUES
29    (
30        ?, ?, ?
31    )
32""", (vorname, nachname, nummer))
33
34# Write into database
35con.commit()
36
37# Print results
38result = run("""
39    SELECT * FROM person;
40""")
41
42print(result.fetchall())
43
44# Close database
45con.close()