def dbTemp(WithdrawDeposit, Company, Date, Amount): print("dbTemp works!") query = ( "INSERT INTO tTemporary (WithdrawDeposit, Company, Date, Amount) VALUES (%s, %s, %s, %s)" ) data = (WithdrawDeposit, Company, Date, Amount) cur = Tlbx.dbConnect() try: cur.execute(query, data) except: print("PNC Database insert Failed! Sending email...") body = "IMAP failed. Subject was " + WithdrawDeposit + " Company was " + Company + " Date was " + Date + " Amount was " + str( Amount) Tlbx.SendEmail(body)
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 dbTrans(Name, Description, WithdrawDeposit, Company, Date, Amount, Comments, Receipt): print("dbTrans works!") cur = Tlbx.dbConnect() query = "INSERT INTO tTransaction (Name, Description, WithdrawDeposit, Company, Date, Amount, Comments, Receipt) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)" print(Date) data = (Name, Description, WithdrawDeposit, Company, Date, Amount, Comments, Receipt) try: cur.execute(query, data) except: body = "IMAP failed. Name was %s, Description was %s, Subject was %s, Company was %s, Date was %s Amount was %s Comments was %s Receipt was %s", ( Name, Description, WithdrawDeposit, Company, Date, Amount, Comments, Receipt) Tlbx.SendEmail(body)
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)