zaf6hWbw

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    connection.commit()
17
18
19def delete_record(email):
20    sql = "delete from Users where email = ?"
21    cursor.execute(sql, (email,))
22    connection.commit()
23
24
25def is_registered(email, password):
26    registered = False
27
28    sql = "select * from Users where email = ? and password = ?"
29    cursor.execute(sql, (email, password,))
30    data = cursor.fetchone()
31
32    if data is None:
33        registered = False
34    else:
35        registered = True
36
37    connection.commit()
38    return registered
39
40
41def delete_all():
42    sql = 'select * from Users'
43    cursor.execute(sql)
44    rows = cursor.fetchall()
45
46    for row in rows:
47        delete_record(row[0])
48
49
50email = str(input('Insert email:'))
51password = str(input('Insert password:'))
52
53if is_registered(email, password) is False:
54    insert_record(email, password)
55
56else:
57    print('Invalid details!')
58
59connection.close()