def entry_point(userid, key): trans = Transactions.query.filter_by(account_id=1) res = "<table>" for t in trans: res += "<tr><td>"+t.date_valuta.strftime("%Y-%m-%d") +\ "</td><td><b>"+decrypt(t.amount, key).decode('utf-8') +\ "</b></td><td>"+decrypt(t.description,key).decode('utf-8') + "</tr>" return res
def get_balance_for_account(account_id, encryption_key): transactions = Transactions.query.filter_by(account_id=account_id) balance = 0.0 for transaction in transactions: balance += float( decrypt(transaction.amount, encryption_key).decode('utf-8')) currency = Accounts.query.filter_by(id=account_id).first().currency.short pair = dict() pair['currency'] = currency pair['value'] = balance return pair
def create_transaction(date_created, date_valuta, description, amount, account_id, encryption_key, db_session): existing_transactions = Transactions.query.filter_by( date_created=date_created, date_valuta=date_valuta, account_id=account_id).all() for et in existing_transactions: if decrypt(et.description, encryption_key) == description: return 1 transaction = Transactions(date_valuta=date_valuta, date_created=date_created, description=encrypt(description, encryption_key), amount=encrypt(amount, encryption_key), account_id=account_id) db_session.add(transaction) return 0
def test_decryption(): data = request.args.get('data').encode('utf-8') key = request.cookies.get('lafin_key') return decrypt(data, key)