Bank-Management-System-Using-SQLite/dataBase.py at main · Raghavgupta1322/Bank-Management-System-Using-SQLite · 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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
import sqlite3

def openaccount(id,name,fname,phone,balance):
    conn = sqlite3.connect("BankDB.db")
    c = conn.cursor()

    sql = f"Insert into cus values ({id},'{name}','{fname}',{phone},{balance});"
    c.executescript(sql)
    conn.commit()
    c.execute(f"Select * from cus where cID = {id}")
    res = c.fetchall()
    val = res
    conn.close()
    return val

def depositemoney(id,money):
    conn = sqlite3.connect("BankDB.db")
    c = conn.cursor()
    c.execute(f"select balance from cus where cID ={id}")
    res = c.fetchall()
    if len(res)==0:
        return 0
    prebal =res[0][0]
    money= prebal+money
    sql = f"Update cus Set balance = {money} Where cID = {id};"
    c.executescript(sql)
    conn.commit()
    return res
    conn.close()

def wihdrawmoney(id,money):
    conn = sqlite3.connect("BankDB.db")
    c = conn.cursor()
    c.execute(f"select balance from cus where cID ={id}")
    res = c.fetchall()
    if len(res)==0:
        return 0
    prebal = res[0][0]
    if money>prebal:
        print("Money is greater")
    else:
        money = prebal - money
        sql = f"Update cus Set balance = {money} Where cID = {id};"
        c.executescript(sql)
    conn.commit()
    return res
    conn.close()
def viewbalance(id):
    conn = sqlite3.connect("BankDB.db")
    c= conn.cursor()
    c.execute(f"select balance from cus where cID = {id}")
    res = c.fetchall()
    if len(res)==0:
        return 0
    # bal = res
    conn.close()
    return res

def customer(id):
    conn = sqlite3.connect("BankDB.db")
    c = conn.cursor()
    c.execute(f"select * from cus where cID = {id}")
    res = c.fetchall()
    if len(res)==0:
        return 0
    conn.close()
    return res
def id_exits(id):
   conn = sqlite3.connect('BankDB.db')
   c = conn.cursor()
   sql = f""" select count(*) from cus
            where cID = {id};"""
   c.execute(sql)
   result = c.fetchone()

   return result[0]>0
   conn.commit()
   conn.close()
def delete(id):
    conn = sqlite3.connect('BankDB.db')
    c = conn.cursor()
    c.execute(f"Select cID from cus where cID = {id}")
    res = c.fetchall()
    if len(res)==0:
        return 0
    sql = f"Delete from cus where cID = {id};"
    c.executescript(sql)
    conn.commit()
    conn.close()
    return res

def fetch():
    conn= sqlite3.connect("BankDB.db")
    c=conn.cursor()
    c.execute("Select * from cus;")
    res = c.fetchall()
    val = res
    conn.close()
    return val