um-cseg / chez-betty

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

        return r

    @classmethod

    def count(cls, *, trans_type=None, start=None, end=None):

        r = DBSession.query(func.count(cls.id).label('c'))\

                            .join(event.Event)\

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

        if trans_type:

            r = r.filter(cls.type==trans_type)

        if start:

            r = r.filter(event.Event.timestamp>=start)

        if end:

            r = r.filter(event.Event.timestamp<end)

        return r.one().c

    @classmethod

    def distinct(cls, *, distinct_on=None, start=None, end=None):

        return r.one().d or Decimal(0.0)

    # Get the total amount of fees people have paid for being in debt

    @classmethod

    def fees(cls, start=None, end=None):

        r = DBSession.query(func.sum((cls.amount / (1-cls.discount)) - cls.amount).label('f'))\

                        .join(event.Event)\

                        .filter(cls.discount < 0)\

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

        if start:

            r = r.filter(event.Event.timestamp>=start)

        if end:

            r = r.filter(event.Event.timestamp<end)

        return r.one().f or Decimal(0.0)

    # 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

    # Get the total amount of discounts people have received for keeping

    # money in their account

    @classmethod

    def discounts(cls, start=None, end=None):

        r = DBSession.query(func.sum((cls.amount / (1-cls.discount)) - cls.amount).label('d'))\

                        .join(event.Event)\

                        .filter(cls.discount > 0)\

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

        if start:

            r = r.filter(event.Event.timestamp>=start)

        if end:

            r = r.filter(event.Event.timestamp<end)

        return r.one().d or Decimal(0.0)

    # Get the total amount of fees people have paid for being in debt

    @classmethod

        return r.one().c

    @classmethod

    def distinct(cls, *, distinct_on=None, start=None, end=None):

        r = DBSession.query(cls).join(event.Event)\

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

        if start:

            r = r.filter(event.Event.timestamp>=start)

        if end:

            r = r.filter(event.Event.timestamp<end)

        if distinct_on is None:

            raise NotImplementedError("required argument distinct_on missing")

        r = r.distinct(distinct_on)

        return r.count()

    @classmethod

    @datefilter_one_or_zero(label='a')