Advertisement
Guest User

Untitled

a guest
Mar 11th, 2020
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. import sqlite3 as sql
  2.  
  3. print("1 - добавление\n2 - получение")
  4. choice = int(input("> "))
  5.  
  6. con = sql.connect('test12.db')
  7. with con:
  8. cur = con.cursor()
  9. cur.execute("CREATE TABLE IF NOT EXISTS test (`name` STRING, `surname` STRING)")
  10. if choice == 1:
  11. name = input("Имя\n")
  12. surname = input("Фамилия\n")
  13. cur.execute(f"INSERT INTO test VALUES ('{name}', '{surname}')")
  14. elif choice == 2:
  15. name1 = input("Имя /n")
  16. cur.execute("SELECT * FROM test WHERE name = ?;",(name1))
  17. rows = cur.fetchall()
  18. for row in rows:
  19. print(row)
  20. else:
  21. print("Вы ошиблись")
  22.  
  23. con.commit()
  24. cur.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement