ATM MACHINE
import mysql.connector as sql
conn=sql.connect(host='localhost',user='root',password='Tarun2820',database='ATM_PROJ')
c1=conn.cursor()
print("================================================================================
")
print(" WELCOME TO OUR BANK ")
print("================================================================================
")
print("1.To create account")
print("2.To login")
print("3.Exit")
print("================================================================================
")
op=int(input("Enter your choice :"))
print("================================================================================
")
if op==1:
c="y"
while c=="y":
m=int(input("Enter a 4 digit number as account number:"))
cb="select * from logs where ACCOUNT_NO={}".format(m)
c1.execute(cb)
d=c1.fetchall()
data=c1.rowcount
if data==1:
print("================================================================================
")
print("This account number already exists:")
c=input("Do you want to continue yes/no -")
print("================================================================================
")
if c=="y":
continue
else:
print("Thank you.")
print("Visit again")
print("================================================================================
")
else:
name=input("Enter your name:")
passw=int(input("Enter your password:"))
ab="insert into logs(ACCOUNT_NO,PASSWORD,NAME)
values({},{},'{}')".format(m,passw,name)
print("================================================================================
")
c1.execute(ab)
conn.commit()
print("Account sucessfully created")
print("The minimum balance is 1000 ")
print("================================================================================
")
s=int(input("Enter the money to be deposited :"))
print("================================================================================
")
sr="update logs set CR_AMT={} where ACCOUNT_NO={}".format(s,m)
c1.execute(sr)
conn.commit()
ef="update logs set balance=cr_amt-withdrawl where ACCOUNT_NO={}".format(m)
c1.execute(ef)
conn.commit()
print("sucessfully deposited")
print("Thank you")
print("Visit again")
break
if op==2:
y="y"
while y=="y":
acct=int(input("Enter your account number:"))
cb="select * from logs where ACCOUNT_NO={}".format(acct)
c1.execute(cb)
c1.fetchall()
data=c1.rowcount
if data==1:
pas=int(input("Enter your password :"))
print("================================================================================
")
e="select password from logs where ACCOUNT_NO={}".format(acct)
c1.execute(e)
a=c1.fetchone()
d=list(a)
if pas==d[0]:
print("correct")
print("1.Depositng money")
print("2.withdrawing money")
print("3.Transfering money")
print("4.Checking balance")
print("5.Changing Account number ")
print("================================================================================
")
r=int(input("Enter your choice:"))
print("================================================================================
")
if r==1:
amt=int(input("Enter the money to be deposited:"))
print("================================================================================
")
sr="update logs set CR_AMT=CR_AMT + {} where ACCOUNT_NO={}".format(amt,acct)
c1.execute(sr)
conn.commit()
ef="update logs set balance=cr_amt-withdrawl where ACCOUNT_NO={}".format(acct)
c1.execute(ef)
conn.commit()
print("sucessfully deposited")
t=input("Do you want to continue y/n -")
print("================================================================================
")
if t=="y":
continue
else:
print("Thank you")
if r==2:
amt=int(input("Enter the money to withdraw:"))
print("================================================================================
")
ah="select BALANCE from logs where account_no={}".format(acct)
c1.execute(ah)
m=c1.fetchone()
if amt==m[0]:
print("Your are having less than",amt)
print("Please try again")
print("================================================================================
")
else:
sr="update logs set balance=balance - {} where ACCOUNT_NO={}".format(amt,acct)
ed="update logs set WITHDRAWL ={} where ACCOUNT_NO={}".format(amt,acct)
c1.execute(ed)
c1.execute(sr)
conn.commit()
print("Sucessfully updated")
t=input("do you want to continue y/n -")
if t=="y":
continue
else:
print("Thank you")
if r==3:
act=int(input("Enter the account number to be transferrsd :"))
print("================================================================================
")
cb="select * from logs where ACCOUNT_NO={}".format(act)
c1.execute(cb)
c1.fetchall()
data=c1.rowcount
if data==1:
print(act ,"number exists")
m=int(input("Enter the money to be transferred :"))
print("================================================================================
")
ah="select BALANCE from logs where account_no={}".format(acct)
c1.execute(ah)
c=c1.fetchone()
if m == c[0]:
print("Your are having less than",m)
print("Please try again")
print("================================================================================
")
else:
av="update logs set balance=balance-{} where ACCOUNT_NO={}".format(m,acct)
cv="update logs set balance=balance+{} where ACCOUNT_NO={}".format(m,act)
w="update logs set withdrawl=withdrawl+{} where
accoUnt_no={}".format(m,acct)
t="update logs set CR_AMT=CR_AMT+{} where account_no={}".format(m,act)
c1.execute(av)
c1.execute(cv)
c1.execute(w)
c1.execute(t)
conn.commit()
print("Sucessfully transfered")
t=input("do you want to continue y/n -")
if t=="y":
continue
else:
print("Thank you")
if r==4:
ma="select BALANCE from logs where account_no={}".format(acct)
c1.execute(ma)
k=c1.fetchone()
print("Balance in your account=",k)
print("================================================================================
")
t=input("do you want to continue y/n -")
if t=="y":
continue
else:
print("Thank you")
if r==5:
i=int(input("Enter your new account number:"))
cb="select * from logs where ACCOUNT_NO={}".format(i)
c1.execute(cb)
c1.fetchall()
data=c1.rowcount
if data==1:
print("This number already exists")
print("Try again")
t=input("do you want to continue y/n -")
if t=="y":
continue
else:
print("Thank you")
else:
name=input("Enter your name:")
ar="Update logs set account_no={} where name='{}' and
password={}".format(i,name,pas)
c1.execute(ar)
conn.commit()
print("Your new account number is ",i)
else:
print("Wrong password")
print("================================================================================
")
t=input("do you want to continue y/n -")
else:
print("your Account does not exists")
if op==3:
print("Exiting")
c1.close()
