def create_transaction():
tag = tag_repository.select(request.form["tag_id"])
merchant = merchant_repository.select(request.form["merchant_id"])
amount = request.form["amount"]
new_transaction = Transaction(tag, merchant, amount)
transaction_repository.save(new_transaction)
return redirect("/transactions")
def update_merchant(id):
merchant = merchant_repository.select(id)
merchant.name = request.form['name']
merchant.active = request.form['active']
merchant_repository.update(merchant)
return redirect("/merchants")
def select(id):
sql = "SELECT * FROM transactions WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(merchant, result["date"], result["amount"], tag, result["id"])
return transaction
def create_transaction():
amount = request.form["amount"]
merchant_id = request.form["merchant_id"]
tag_id = request.form["tag_id"]
merchant = merchant_repository.select(merchant_id)
tag = tag_repository.select(tag_id)
new_transaction = Transaction(amount, merchant, tag)
transaction_repository.save(new_transaction)
return redirect("/transactions")
def create_transaction():
merchant_id = request.form['merchant_id']
tag_id = request.form['tag_id']
amount = request.form['amount']
merchant = merchant_repository.select(merchant_id)
tag = tag_repository.select(tag_id)
transaction = Transaction(merchant, tag, amount)
transaction_repository.save(transaction)
return redirect('/transactions')
def update_transaction(id):
amount = request.form['amount']
category = category_repository.select(request.form['category_id'])
date = request.form['date']
merchant = merchant_repository.select(request.form['merchant_id'])
user = user_repository.select(request.form['user_id'])
transaction = Transaction(amount, category, date, merchant, user, id)
transaction_repository.update(transaction)
return redirect("/transactions")
def select(id):
sql = "SELECT * FROM transactions WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
tag = tag_repository.select(result['tag_id'])
merchant = merchant_repository.select(result['merchant_id'])
user = user_repository.select(result['user_id'])
transaction = Transaction(tag, merchant, user, result['amount'], result['date'], result['id'])
return transaction
def select_all():
transactions = []
sql = "SELECT * FROM transactions ORDER BY date DESC"
results = run_sql(sql)
for row in results:
merchant = merchant_repository.select(row["merchant_id"])
tag = tag_repository.select(row["tag_id"])
transaction = Transaction(merchant, row["date"], row["amount"], tag, row["id"])
transactions.append(transaction)
return transactions
def create_transaction():
merchant_id = request.form["merchant_id"]
merchant = merchant_repository.select(merchant_id)
date = request.form["date"]
amount = float(request.form["amount"])
tag_id = request.form["tag_id"]
tag = tag_repository.select(tag_id)
new_transaction = Transaction(merchant, date, amount, tag)
transaction_repository.save(new_transaction)
return redirect("/transactions")
def update_transaction(id):
merchant_id = request.form["merchant_id"]
merchant = merchant_repository.select(merchant_id)
date = request.form["date"]
amount = request.form["amount"]
tag_id = request.form["tag_id"]
tag = tag_repository.select(tag_id)
transaction = Transaction(merchant, date, amount, tag, id)
transaction_repository.update(transaction)
return redirect("/transactions")
def sort_all_by_tag_z2a():
transactions = []
sql = "select t.* from transactions as t join tags as tg on tg.id = t.tag_id order by tg.name DESC"
results = run_sql(sql)
for row in results:
merchant = merchant_repository.select(row["merchant_id"])
tag = tag_repository.select(row["tag_id"])
transaction = Transaction(merchant, row["date"], row["amount"], tag, row["id"])
transactions.append(transaction)
return transactions
def sort_all_by_merchant_a2z():
transactions = []
sql = "select t.* from transactions as t join merchants as m on m.id = t.merchant_id order by m.name ASC"
results = run_sql(sql)
for row in results:
merchant = merchant_repository.select(row["merchant_id"])
tag = tag_repository.select(row["tag_id"])
transaction = Transaction(merchant, row["date"], row["amount"], tag, row["id"])
transactions.append(transaction)
return transactions
def log_new_transaction():
merchant_id = request.form['merchant-name']
tag_id = request.form['tag-category']
amount = request.form['amount']
merchant = merchant_repository.select(merchant_id)
tag = tag_repository.select(tag_id)
transaction = Transaction(merchant, tag, amount)
transaction_repository.save(transaction)
return redirect("/transactions")
def transactions(id):
transactions = []
sql = "SELECT * FROM transactions WHERE tag_id = %s ORDER BY date DESC"
values = [id]
results = run_sql(sql, values)
for row in results:
merchant = merchant_repository.select(row["merchant_id"])
tag = select(row["tag_id"])
transaction = Transaction(merchant, row["date"], row["amount"], tag, row["id"])
transactions.append(transaction)
return transactions
def select(id):
transaction = None
sql = "SELECT * FROM transactions WHERE id = %s"
values = [id]
result = run_sql(sql, values)
if result is not None:
merchant = merchant_repository.select(result['merchant_id'])
tag = tag_repository.select(result['tag_id'])
transaction = Transaction(merchant, tag, result['amount'], result['id'], result['time_stamp'])
return transaction
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for row in results:
tag = tag_repository.select(row['tag_id'])
merchant = merchant_repository.select(row['merchant_id'])
user = user_repository.select(row['user_id'])
transaction = Transaction(tag, merchant, user, row['amount'], row['date'], row['id'])
transactions.append(transaction)
return transactions
def update_transaction(id):
tag_id = request.form['tag_id']
merchant_id = request.form['merchant_id']
user_id = request.form['user_id']
amount = request.form['amount']
date = request.form['date']
tag = tag_repository.select(tag_id)
merchant = merchant_repository.select(merchant_id)
user = user_repository.select(user_id)
updated_transaction = Transaction(tag, merchant, user, amount, date, id)
transaction_repository.update(updated_transaction)
return redirect("/transactions")
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for row in results:
merchant = merchant_repository.select(row['merchant_id'])
tag = tag_repository.select(row['tag_id'])
transaction = Transaction(merchant, tag, row['amount'], row['id'], row['time_stamp'])
transactions.append(transaction)
return transactions
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for result in results:
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(merchant, tag, result['amount'], result["id"])
transactions.append(transaction)
return transactions
def sort_transactions(transactions):
transactions = []
sql = "SELECT * FROM transactions ORDER BY date ASC"
results = run_sql(sql)
for row in results:
merchant = merchant_repository.select(row['merchant_id'])
category = category_repository.select(row['category_id'])
user = user_repository.select(row['user_id'])
transaction = Transaction(row['amount'], category, row['date'],
merchant, user, row['id'])
transactions.append(transaction)
return transactions
def select(id):
transaction = None
sql = "SELECT * FROM transactions WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
merchant = merchant_repository.select(result['merchant_id'])
category = category_repository.select(result['category_id'])
user = user_repository.select(result['user_id'])
transaction = Transaction(result['amount'], category, result['date'],
merchant, user, result['id'])
return transaction
def create_transaction():
amount = request.form["amount"]
user = user_repository.select(request.form["user"])
merchant = merchant_repository.select(request.form["merchant"])
tag = tag_repository.select(request.form["tag"])
new_transaction = Transaction(amount, user, merchant, tag)
transaction_repository.save(new_transaction)
tags = tag_repository.select_all()
transactions = user_repository.select_transactions(user)
total = 0
for transaction in transactions:
total += transaction.amount
return render_template("/users/dashboard.html", user = user, transactions = transactions, total = total, tags = tags)
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for result in results:
amount = float(result["amount"])
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(amount, merchant, tag, result["id"],
result["time_created"])
transactions.append(transaction)
transactions.reverse()
return transactions
def select_all():
transactions = []
sql = "SELECT * FROM transactions"
results = run_sql(sql)
for result in results:
user = user_repository.select(result["user_id"])
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(user, result["date"], result["time"],
merchant, result["amount"], tag,
result["id"])
transactions.append(transaction)
return transactions
def update_transaction(id):
transaction = transaction_repository.select(id)
user = user_repository.select(transaction.user.id)
amount = request.form['amount']
merchant = merchant_repository.select(request.form['merchant'])
tag = tag_repository.select(request.form['tag'])
updated_transaction = Transaction(amount, user, merchant, tag, transaction.id)
transaction_repository.update(updated_transaction)
transactions = user_repository.select_transactions(user)
tags = tag_repository.select_all()
total = 0
for transaction in transactions:
total += transaction.amount
return render_template("/users/dashboard.html", user = user, transactions = transactions, total = total, tags = tags)
def select_by_tag(id):
transactions = []
sql = "SELECT * FROM transactions where tag_id = %s"
values = [id]
results = run_sql(sql, values)
for result in results:
user = user_repository.select(result["user_id"])
merchant = merchant_repository.select(result["merchant_id"])
tag = tag_repository.select(result["tag_id"])
transaction = Transaction(user, result["date"], result["time"],
merchant, result["amount"], tag,
result["id"])
transactions.append(transaction)
return transactions
def filter_by_month(month):
transactions = []
sql = "SELECT * FROM transactions WHERE EXTRACT (MONTH from date) = %s "
values = [month]
results = run_sql(sql, values)
for row in results:
merchant = merchant_repository.select(row['merchant_id'])
category = category_repository.select(row['category_id'])
user = user_repository.select(row['user_id'])
transaction = Transaction(row['amount'], category, row['date'],
merchant, user, row['id'])
transactions.append(transaction)
return transactions
def transactions(tag):
transactions = []
sql = "SELECT * FROM merchants INNER JOIN transactions ON transactions.merchant_id = merchants.id WHERE transactions.tag_id = %s"
values = [tag.id]
results = run_sql(sql, values)
for row in results:
merchant_id = row['merchant_id']
user_id = row['user_id']
merchant = merchant_repository.select(merchant_id)
user = user_repository.select(user_id)
transaction = Transaction(tag, merchant, user, row['amount'],
row['date'])
transactions.append(transaction)
return transactions
def create_transaction():
user_id = request.form["user_id"]
date = request.form["date"]
time = request.form["time"]
merchant_id = request.form["merchant_id"]
amount = float(request.form["amount"])
tag_id = request.form["tag_id"]
user = user_repository.select(user_id)
merchant = merchant_repository.select(merchant_id)
tag = tag_repository.select(tag_id)
if user.can_afford(amount) == True:
transaction = Transaction(user, date, time, merchant, amount, tag)
transaction_repository.save(transaction)
return redirect("/transactions")
else:
error = "I'm sorry, this transaction will put you over your budget."
return render_template("/transactions/error.html",
error=error,
title="Error")
def edit_merchant(id):
merchant = merchant_repository.select(id)
return render_template('merchants/edit.html', merchant=merchant)
