Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- conn = sqlite3.connect('example.db')
- c = conn.cursor()
- create_users = "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, " \
- "login VARCHAR(200),password VARCHAR(200))"
- c.execute(create_users)
- a = raw_input("Input L to login, R for register \n")
- if a == 'R':
- print("Please type login and password \n")
- login, password = raw_input().split()
- insert_user = "INSERT INTO users (login,password) VALUES ('{}','{}')".format(login,password)
- print(insert_user)
- c.execute(insert_user)
- conn.commit()
- else:
- get_users = "SELECT * FROM users "
- c.execute(get_users)
- result = c.fetchone()
- if result is None:
- print("GO AWAY OTSUDA PLS")
- else:
- print("Hello, " + result[1])
- conn.close()
Add Comment
Please, Sign In to add comment