KxLCvWr9

1import sqlite3
2
3connection = sqlite3.connect('Users.db')
4cursor = connection.cursor()
5
6sql = '''CREATE TABLE IF NOT EXISTS Users (
7                "email" TEXT,
8                "password" TEXT,
9                PRIMARY KEY("email","password"))'''
10cursor.execute(sql)
11
12
13def insert_record(email, password):
14    sql = "INSERT INTO USERS (email, password) VALUES (?, ?)"
15    cursor.execute(sql, (email, password))
16
17
18def delete_record(email):
19    sql = "delete from Users where email = ?"
20    cursor.execute(sql, (email,))
21
22
23def is_registered(email, password):
24    registered = False
25
26    sql = "select * from Users where email = ? and password = ?"
27    cursor.execute(sql, (email, password,))
28    data = cursor.fetchone()
29
30    if data is None:
31        registered = False
32    else:
33        registered = True
34
35    return registered
36
37
38def delete_all():
39    sql = 'select * from Users'
40    cursor.execute(sql)
41    rows = cursor.fetchall()
42
43    for row in rows:
44        delete_record(row[0])
45
46
47email = str(input('Insert email:'))
48password = str(input('Insert password:'))
49
50if is_registered(email, password) is False:
51    insert_record(email, password)
52
53else:
54    print('Invalid details!')
55
56connection.commit()
57connection.close()