QuibHash

import sqlite3
from time import *
from Hash import *
def clearScreen():
    print("\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n")
userid = 0
signin = False
with open("user.txt", "r") as f:
    userid = f.readline().strip().split()
userid = int(userid[0])
userid += 1
def Exit():
    print("Goodbye :D")
    exit

with sqlite3.connect("database.db") as d:
    c = d.cursor()
    try:
        c.execute("""
        CREATE TABLE Accounts(
        UserID integer,
        Username string,
        Password string,
        Email string,
        Primary Key(UserID));""")
        print("Accounts Database Created")
    except sqlite3.OperationalError:
        print("Loaded Accounts Database")
    try:
        c.execute("""
        CREATE TABLE Users(
        AccountID integer,
        FirstName string,
        LastName string,
        FirstLineAddress string,
        SecondLineAddress string,
        Postcode string,
        Town string,
        PhoneNumber string,
        Primary Key(PhoneNumber));""")
        print("User Database Created")
    except sqlite3.OperationalError:
        print("Loaded User Database")


def Enter(ID, Username, Password, Email):
    global userid
    with sqlite3.connect("database.db") as d:
        c = d.cursor()
        c.execute("""INSERT INTO Accounts ("UserID", "Username", "Password", "Email")
        VALUES ('""" + str(ID) + """', '""" + Username + """', '""" + gethash(Password) + """', '""" + Email + """');""")
        d.commit()
    with open("user.txt", "w") as f:
        f.write(str(userid))
        userid += 1
    with sqlite3.connect("database.db") as d:
        c = d.cursor()
        c.execute("""INSERT INTO Users ("AccountID", "FirstName", "LastName", "FirstLineAddress", "SecondLineAddress", "Postcode", "Town", "PhoneNumber")
        VALUES (""" + str(userid - 1) + """, '-', '-', '-', '-', '-', '-', '-');""")

def ReadWhole():
    with sqlite3.connect("database.db") as d:
        c = d.cursor()
        c.execute("""SELECT * FROM Accounts""")
        all1 = c.fetchall()
        print(all1)

#Enter(userid, "Quib", "password", "email@email.com")
#ReadWhole()

onlineid = 0
onlineuser = ""
onlineemail = ""
hashedpss = ""
while True:
    with sqlite3.connect("database.db") as d:
        c = d.cursor()
        c.execute("""SELECT * FROM Accounts WHERE Password = '""" + hashedpss + """' AND Username = '""" + onlineuser + """';""")
        db = c.fetchall()
        try:
            if(onlineuser in db[0]):
                onlineid = db[0][0]
                onlineuser = db[0][1]
                onlineemail = db[0][3]
                signin = True
        except IndexError:
            signin = False
    if(signin == False):
        usernamein = input("Please enter your username (Caps Sensitive):\n")
        passin = input("Please enter your password (Caps Sensitive):\n")
        with sqlite3.connect("database.db") as d:
            c = d.cursor()
            passw = gethash(passin)
            c.execute("""SELECT * FROM Accounts WHERE Password = '""" + passw + """' AND Username = '""" + usernamein + """';""")
            db = c.fetchall()
            try:
                if(usernamein in db[0]):
                    print("Logged In")
                    onlineid = db[0][0]
                    onlineuser = db[0][1]
                    hashedpss = db[0][2]
                    onlineemail = db[0][3]
                    signin = True
                    sleep(1.5)
                    clearScreen()
            except IndexError:
                signin = False
    else:
        print("Welcome " + onlineuser + "\n")
        while True:
            try:
                print("Menu:\n1. Account\n2. Sign out\n3. Exit")
                i = input()
                if(i == "1"):
                    with sqlite3.connect("database.db") as d:
                        c = d.cursor()
                        c.execute("""SELECT UserID FROM Accounts WHERE Password + '""" + hashedpss + """' AND Username = '""" + onlineuser + """';""")
                        id1 = c.fetchall()[0][0]
                        c.execute("""SELECT * FROM Users WHERE AccountID = """ + str(id1) + """;""")
                        user = c.fetchall()
                        print(user)
                elif(i == "2"):
                    print()
                elif(i == "3"):
                    Exit()
                else:
                    print("Not a valid answer, please pick an option.")
            except ValueError:
                print("Not a valid number, please pick an option")