um-cseg / chez-betty

        return utility.timeseries_balance_total_daily(rows)

    @classmethod

    def get_transactions_over_time_for_user(cls, user):

        return 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'

                                ))\

                        .filter(or_(

                            cls.to_account_virt_id == user.id,

                            cls.fr_account_virt_id == user.id,

                            ))\

                        .order_by(event.Event.timestamp)\

                        .all()

account.Account.transactions = __transactions

# This is in a stupid place due to circular input problems

@limitable_all

def __get_events(self):

    return object_session(self).query(event.Event)\

            .join(Transaction)\

            .filter(or_(

                      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))

@property

def __events(self):

    # 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