jpYta29X

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, login VARCHAR(200), password VARCHAR(200))'
8
9c.execute(create_users)
10conn.commit()
11
12a = raw_input("Please type your login and password \n")
13
14login, password = a.split()
15
16# insert_user = 'INSERT INTO users (login,password) VALUES("{}","{}")'.format(login,password)
17
18
19# c.execute(insert_user)
20# conn.commit()
21
22
23get_user = 'SELECT * from users WHERE login = "{}" AND password = "{}"'.format(login,password)
24
25c.execute(get_user)
26
27user = c.fetchone()
28
29
30if user is None:
31    print("NO DATA FOR YOU, LOOSER")
32else:
33    print("Hello, " + user[1])
34
35conn.close()