import sqlite3 as sql

print("1 - добавление\n2 - получение")
choice = int(input("> "))

con = sql.connect('test12.db')
with con:
    cur = con.cursor()
    cur.execute("CREATE TABLE IF NOT EXISTS test (`name` STRING, `surname` STRING)")
    if choice == 1:
        name = input("Имя\n")
        surname = input("Фамилия\n")
        cur.execute(f"INSERT INTO test VALUES ('{name}', '{surname}')")
    elif choice == 2:
        name1 = input("Имя /n")
        cur.execute("SELECT * FROM test WHERE name = ?;",(name1))
        rows = cur.fetchall()
        for row in rows:
            print(row)
        else:
            print("Вы ошиблись")

    con.commit()
    cur.close()