HNeyabct

1import sqlite3
2import time
3import datetime
4import sys
5
6conn = sqlite3.connect('template.db')
7c = conn.cursor()
8
9def create_table(): #
10    c.execute("CREATE TABLE IF NOT EXISTS Theft(template1 TEXT, template2 TEXT, template3 TEXT, template4 TEXT, template5 TEXT)")
11
12
13def data_entry():
14    unix = int(time.time())
15    template1 = str(datetime.datetime.fromtimestamp(unix).strftime('%Y-%m-%d %H:%M:%S'))
16
17    c.execute("INSERT INTO Theft(template1, template2, template3, template4, template5) VALUES (?, ?, ?, ?, ?)",
18                (template1, template2, template3, template4, template5))
19
20    conn.commit()
21
22template2 = input("ENTER template ")
23template3 = input("ITEM template ")
24template4 = input("INPUT template ")
25template5 = input("INPUT YOUR template: ")
26
27accept = input("Do you wanna create new record in DB? (Y/N)")
28if accept == "y":
29    create_table(), data_entry()
30elif accept == "Y":
31    create_table(), data_entry()
32else:
33    sys.exit(0)
34
35
36c.close()
37conn.close()