Image-Encryption-Using-Rubik-s-Cube-Based-Algorithm/database.py at master · nirajankarki5/Image-Encryption-Using-Rubik-s-Cube-Based-Algorithm · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
import sqlite3

def connect():
    conn=sqlite3.connect("database.db")
    cur=conn.cursor()
    cur.execute("CREATE TABLE IF NOT EXISTS history (id INTEGER PRIMARY KEY, email text, date text)")
    conn.commit()
    conn.close()

def insert(email,date):
    conn=sqlite3.connect("database.db")
    cur=conn.cursor()
    cur.execute("INSERT INTO history VALUES (NULL,?,?)",(email,date))
    conn.commit()
    conn.close()
    view()

def view():
    conn=sqlite3.connect("database.db")
    cur=conn.cursor()
    cur.execute("SELECT * FROM history")
    rows=cur.fetchall()
    conn.close()
    return rows

def delete():
    conn=sqlite3.connect("database.db")
    cur=conn.cursor()
    cur.execute("DELETE FROM history")
    conn.commit()
    conn.close()

connect()