import sqlite3
db = sqlite3.connect("contacts.db")
cur = db.cursor()
cur.execute("""
CREATE TABLE IF NOT EXISTS contacts (
name TEXT,
phone TEXT,
email TEXT
)
""")
def add():
name = input("Имя: ")
phone = input("Телефон: ")
email = input("Email: ")
cur.execute("INSERT INTO contacts VALUES (?, ?, ?)",
(name, phone, email))
db.commit()
def show():
cur.execute("SELECT * FROM contacts")
for c in cur.fetchall():
print(c)
def search():
name = input("Имя для поиска: ")
cur.execute("SELECT * FROM contacts WHERE name = ?", (name,))
print(cur.fetchall())
def update():
name = input("Имя контакта: ")
phone = input("Новый телефон: ")
cur.execute("UPDATE contacts SET phone = ? WHERE name = ?",
(phone, name))
db.commit()
def delete():
name = input("Имя контакта: ")
cur.execute("DELETE FROM contacts WHERE name = ?", (name,))
db.commit()
while True:
print("\n1. Добавить 2. Показать 3. Найти")
print("4. Изменить телефон 5. Удалить 0. Выход")
choice = input("Выбор: ")
if choice == "1":
add()
elif choice == "2":
show()
elif choice == "3":
search()
elif choice == "4":
update()
elif choice == "5":
delete()
elif choice == "0":
break
db.close()