um-cseg / chez-betty

    # Returns an array of tuples where the first item is a millisecond timestamp,

    # the next is the total amount of debt, and the next is the total amount

    # of stored money for users.

    @classmethod

    def get_balance_total_daily(cls):

        rows = DBSession.query(cls.amount,

                               cls.type,

                               cls.to_account_virt_id,

                               cls.fr_account_virt_id,

                               event.Event.timestamp)\

                        .join(event.Event)\

                        .filter(event.Event.deleted==False)\

                        .filter(or_(

                                  cls.type=='purchase',

                                  cls.type=='cashdeposit',

                                  cls.type=='ccdeposit',

                                  cls.type=='btcdeposit',

                                  cls.type=='adjustment'

                                ))\

                        .order_by(event.Event.timestamp)\

                        .all()

        return utility.timeseries_balance_total_daily(rows)

    @classmethod

    def get_transactions_over_time_for_user(cls, user):

                      or_(

                        Transaction.to_account_virt_id == self.id,

                        Transaction.fr_account_virt_id == self.id,

                        Transaction.to_account_cash_id == self.id,

                        Transaction.fr_account_cash_id == self.id),

                      and_(

                        or_(event.Event.type == "purchase",

                            event.Event.type == "deposit"),

                        event.Event.user_id == self.id)))\

            .filter(event.Event.deleted==False)\

            .order_by(desc(event.Event.timestamp))\

@limitable_all

def __get_transactions(self):

    return __get_transactions_query(self)

@property

def __transactions(self):

    return __get_transactions(self)

account.Account.get_transactions_query = __get_transactions_query

account.Account.get_transactions = __get_transactions