def make_transfer(transfer_schema: TransferSchema, username=Depends(auth_wrapper)):
try:
with SQLITE_DB.atomic():
person = Person.select().where(Person.username == username).get()
friend = Person.select().where(Person.user_id == transfer_schema.friend_id).get()
card = Card.select().where(Card.card_id == transfer_schema.billing_card.card_id).get()
BankStatement.create(
user_id=person,
friend_id=friend,
value=transfer_schema.total_to_transfer,
date=datetime.today().date(),
from_card=card
)
except Exception as error:
raise error
def all_bank_statement(username=Depends(auth_wrapper)):
try:
with SQLITE_DB.atomic():
bs_list = []
query = BankStatementORM.select()
for bs in query:
person = PersonORM.select().where(
PersonORM.id == bs.user_id).get()
friend = PersonORM.select().where(
PersonORM.id == bs.friend_id).get()
card = CardORM.select().where(CardORM.id == bs.from_card).get()
bs_dict = dict(user_id=person.user_id,
friend_id=friend.user_id,
value=bs.value,
date=bs.date,
from_card=card.card_id)
bs_list.append(bs_dict)
return bs_list
except Exception as error:
raise error
def bank_statement_by_userid(userid: str, username=Depends(auth_wrapper)):
try:
with SQLITE_DB.atomic():
person = PersonORM.select().where(
PersonORM.user_id == userid).get()
query = BankStatementORM.select().where(
BankStatementORM.user_id == person.id)
bs_person_list = []
for bs in query:
friend = PersonORM.select().where(
PersonORM.id == bs.friend_id).get()
card = CardORM.select().where(CardORM.id == bs.from_card).get()
bs_dict = dict(user_id=person.user_id,
friend_id=friend.user_id,
value=bs.value,
date=bs.date,
from_card=card.card_id)
bs_person_list.append(bs_dict)
return bs_person_list
except Exception as error:
pass
def get_all_cards_by_person(username=Depends(auth_wrapper)):
try:
with SQLITE_DB.atomic():
person = PersonORM.select().where(
PersonORM.username == username).get()
query = (CardORM.select().where(CardORM.owner == person))
cards = []
for card_row in query:
card_dict = {
"card_id": card_row.card_id,
"title": card_row.title,
"PAN": card_row.PAN,
"expiry_mm": card_row.expiry_mm,
"expiry_yyyy": card_row.expiry_yyyy,
"security_code": card_row.security_code,
"date": card_row.date
}
cards.append(card_dict)
return cards
except Exception as error:
raise error
