dZmVQNBh

1import sqlite3
2
3conn = sqlite3.connect('example.db')
4
5c = conn.cursor()
6
7create_users = "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, " \
8               "login VARCHAR(200),password VARCHAR(200))"
9
10c.execute(create_users)
11
12a = raw_input("Input L to login, R for register \n")
13
14if 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()
26else:
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
40conn.close()