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)
