Guest User

Untitled

a guest
May 5th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. import sqlite3
  2.  
  3. conn = sqlite3.connect('example.db')
  4.  
  5. c = conn.cursor()
  6.  
  7. create_users = "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, " \
  8. "login VARCHAR(200),password VARCHAR(200))"
  9.  
  10. c.execute(create_users)
  11.  
  12. a = raw_input("Input L to login, R for register \n")
  13.  
  14. if a == 'R':
  15. print("Please type login and password \n")
  16.  
  17. login, password = raw_input().split()
  18.  
  19. insert_user = "INSERT INTO users (login,password) VALUES ('{}','{}')".format(login,password)
  20.  
  21. print(insert_user)
  22.  
  23. c.execute(insert_user)
  24.  
  25. conn.commit()
  26. else:
  27.  
  28. get_users = "SELECT * FROM users "
  29.  
  30. c.execute(get_users)
  31.  
  32. result = c.fetchone()
  33.  
  34. if result is None:
  35. print("GO AWAY OTSUDA PLS")
  36. else:
  37. print("Hello, " + result[1])
  38.  
  39.  
  40. conn.close()
Add Comment
Please, Sign In to add comment