def Delete(TransID):
TransID = str(TransID)
query = ("DELETE FROM tTransaction WHERE transID=" + TransID + ";")
cur = Tlbx.dbConnectDict()
cur.execute(query)
balance = Tlbx.Balance()
cur = Tlbx.dbConnect()
query = ("Select COUNT(tempID) FROM tTemporary")
cur.execute(query)
Transaction = cur.fetchone()[0]
if Transaction is None:
Transaction = "0"
return render_template('HomePage/index.html',
balance=balance,
Transaction=Transaction)
def index():
#Get the current balance
balance = Tlbx.Balance()
#Connect to the database to post number of incomplete transactions
cur = Tlbx.dbConnect()
query = ("Select COUNT(tempID) FROM tTemporary")
cur.execute(query)
Transaction = cur.fetchone()[0]
#A catch from testing to prevent a crash
if Transaction is None:
Transaction = "0"
#Render the page
return render_template('HomePage/index.html',
balance=balance,
Transaction=Transaction)
