def get_accounts():
return (Account.query.options(
db.contains_eager(Account.user),
db.contains_eager(Account.currency),
).join(User, User.id == Account.user_id).join(
GroupCurrency, GroupCurrency.id == Account.currency_id).filter(
Account.user_id == current_user.id))
def get_accounts():
return (
Account.query
.options(
db.contains_eager(Account.user),
db.contains_eager(Account.currency),
)
.join(User, User.id == Account.user_id)
.join(GroupCurrency, GroupCurrency.id == Account.currency_id)
.filter(Account.user_id == current_user.id)
)
def get_records():
return (
Record.query
.options(
db.contains_eager(Record.account),
db.contains_eager(Record.category),
db.contains_eager(Record.currency)
)
.join(Account, Account.id == Record.account_id)
.join(GroupCurrency, GroupCurrency.id == Record.currency_id)
.outerjoin(GroupCategory, GroupCategory.id == Record.category_id)
.filter(Record.user_id == current_user.id)
)
def get_transaction(transaction_id):
return (Transaction.query.options(
db.contains_eager(Transaction.source_account),
db.contains_eager(Transaction.target_account),
db.contains_eager(Transaction.currency)).join(
Account, Account.id == Transaction.source_account_id,
aliased=True).join(
Account,
Account.id == Transaction.target_account_id,
aliased=True).join(
GroupCurrency,
GroupCurrency.id == Transaction.currency_id).filter(
Transaction.id == transaction_id,
Transaction.user_id == current_user.id).first_or_404())
def get_transaction(transaction_id):
return (
Transaction.query
.options(
db.contains_eager(Transaction.source_account),
db.contains_eager(Transaction.target_account),
db.contains_eager(Transaction.currency)
)
.join(Account, Account.id == Transaction.source_account_id, aliased=True)
.join(Account, Account.id == Transaction.target_account_id, aliased=True)
.join(GroupCurrency, GroupCurrency.id == Transaction.currency_id)
.filter(Transaction.id == transaction_id, Transaction.user_id == current_user.id)
.first_or_404()
)
def get_user(user_id):
return (
User.query
.options(db.contains_eager(User.group))
.join(Group, Group.id == User.group_id)
.filter(User.id == user_id)
.first_or_404()
)
def get_group_categories():
return (
GroupCategory.query
.options(
db.contains_eager(GroupCategory.group),
)
.join(Group, Group.id == GroupCategory.group_id)
.filter(GroupCategory.group_id == current_user.group_id)
)
def get_group_category(group_category_id):
return (
GroupCategory.query
.options(
db.contains_eager(GroupCategory.group),
)
.join(Group, Group.id == GroupCategory.group_id)
.filter(
GroupCategory.id == group_category_id,
GroupCategory.group_id == current_user.group_id
)
.first_or_404()
)
def get_users():
return (
User.query
.options(db.contains_eager(User.group))
.join(Group, Group.id == User.group_id)
)
