import sqlite3, os.path, time
from os import path
loginsuccess = 0
def signup():
    if path.exists("logindata.db") == False:

        new_db = sqlite3.connect("logindata.db")
        c=new_db.cursor()

        c.execute("""CREATE TABLE login
        (Usernamein text,
        Passwordin text)""")

        Username = input("Pleaese create a username: ")
        Password = input("Please create a password: ")

        c.execute("""INSERT INTO login VALUES (?, ?)""",(Username, Password))
        print("Creating Database...")
        time.sleep(3)
        print("Done ")
        time.sleep(1)

def signin():
    signinuser = input("Please enter your username: ")
    signinpass = input("Please enter your password: ")
    user_logon=("SELECT * FROM login WHERE usernamein = ? AND passwordin = ?", (signinuser, signinpass))
##    c.execute(user_logon,[(signinuser),(signinpass)])
    passresult = c.fetchall()
    print(passresult)
    if passresult == signinpass:
        loginsuccess = loginsuccess + 1
    else:
        print("Username or password is wrong ")

signup()

print("You have already signed up, please sign in: ")

conn = sqlite3.connect ("logindata.db")
c= conn.cursor()

signin()

if loginsuccess == 1:
    print("loginsuccessloginsuccessloginsuccessloginsuccessloginsuccessloginsuccessloginsuccessloginsuccess")
else:
    print("Login failure")