def transaction(id):
transaction = session.query(Transaction).get(id)
return jsonify([
transaction.transactionID, transaction.date, transaction.amount,
transaction.source, transaction.destination
])
def accounts(id):
account = session.query(Accounts).get(id)
return jsonify([
account.accountID, account.customerID, account.balance,
account.interest, account.isIvestment, account.pin
])
def customers(id):
customer = session.query(Customer).get(id)
return jsonify([
customer.customer_Id, customer.first_name, customer.last_name,
customer.phone, customer.address, customer.agent_id
])
def agents(id):
agents = session.query(Agents).get(id)
return jsonify([agents.agentId, agents.firstName, agents.lastName])
def loan(id):
loan = session.query(Loan).get(id)
return jsonify([loan.loanId, loan.accountId, loan.amount, loan.interest])
def card(number):
card = session.query(Card).get(number)
return jsonify([card.cardNumber, card.accountID, card.cardType])