Пример #1
0
 def _by_name_cache(cls, name):
     q = cls._query(lower(cls.c.name) == name.lower(),
                    cls.c._spam == (True, False),
                    limit = 1)
     l = list(q)
     if l:
         return l[0]._id
Пример #2
0
 def _by_name_cache(cls, name):
     q = cls._query(lower(cls.c.name) == name.lower(),
                    cls.c._spam == (True, False),
                    limit=1)
     l = list(q)
     if l:
         return l[0]._id
Пример #3
0
            def _fetch(lnames):
                q = cls._query(lower(cls.c.name) == lnames, cls.c._spam == (True, False), limit=len(lnames), data=True)
                try:
                    srs = list(q)
                except UnicodeEncodeError:
                    print "Error looking up SRs %r" % (lnames,)
                    raise

                return dict((sr.name.lower(), sr._id) for sr in srs)
Пример #4
0
    def _by_codename(cls, codename):
        q = cls._query(lower(Award.c.codename) == codename.lower())
        q._limit = 1
        award = list(q)

        if award:
            return cls._byID(award[0]._id, True)
        else:
            raise NotFound, 'Award %s' % codename
Пример #5
0
    def _by_codename(cls, codename):
        q = cls._query(lower(Award.c.codename) == codename.lower())
        q._limit = 1
        award = list(q)

        if award:
            return cls._byID(award[0]._id, True)
        else:
            raise NotFound, 'Award %s' % codename
Пример #6
0
    def _by_codename(cls, codename):
        q = cls._query(lower(Ad.c.codename) == codename.lower())
        q._limit = 1
        ad = list(q)

        if ad:
            return cls._byID(ad[0]._id, True)
        else:
            raise NotFound, "Ad %s" % codename
Пример #7
0
 def _by_name_cache(cls, name):
     q = cls._query(lower(cls.c.name) == name.lower(), cls.c._spam == (True, False), limit=1)
     try:
         l = list(q)
     except UnicodeEncodeError:
         print "Error looking up SR %r" % name
         raise
     if l:
         return l[0]._id
Пример #8
0
    def _by_email_cache(cls, email, allow_deleted = False):
        deleted = (True, False) if allow_deleted else False
        q = cls._query(lower(Account.c.email) == email,
                       Account.c._spam == (True, False),
                       Account.c._deleted == deleted)

        q._limit = 1
        l = list(q)
        if l:
            return l[0]._id
Пример #9
0
    def _by_name_cache(cls, name, allow_deleted = False):
        deleted = (True, False) if allow_deleted else False
        q = cls._query(lower(Account.c.name) == name,
                       Account.c._spam == (True, False),
                       Account.c._deleted == deleted)

        q._limit = 1
        l = list(q)
        if l:
            return l[0]._id
Пример #10
0
    def _by_name_cache(cls, name, allow_deleted=False):
        #relower name here, just in case
        deleted = (True, False) if allow_deleted else False
        q = cls._query(
            lower(Account.c.name) == name.lower(),
            Account.c._spam == (True, False), Account.c._deleted == deleted)

        q._limit = 1
        l = list(q)
        if l:
            return l[0]._id
Пример #11
0
 def _by_name_cache(cls, name):
     q = cls._query(lower(cls.c.name) == name.lower(),
                    cls.c._spam == (True, False),
                    limit = 1)
     try:
         l = list(q)
     except UnicodeEncodeError:
         print "Error looking up SR %r" % name
         raise
     if l:
         return l[0]._id
Пример #12
0
    def _by_name_cache(cls, name, allow_deleted=False):
        # relower name here, just in case
        deleted = (True, False) if allow_deleted else False
        q = cls._query(
            lower(cls.c.name) == name.lower(), cls.c._spam == (True, False), cls.c._deleted == deleted, data=True
        )

        q._limit = 1
        l = list(q)
        if l:
            return l[0]._id
Пример #13
0
            def _fetch(lnames):
                q = cls._query(lower(cls.c.name) == lnames,
                               cls.c._spam == (True, False),
                               limit=len(lnames),
                               data=True)
                try:
                    srs = list(q)
                except UnicodeEncodeError:
                    print "Error looking up SRs %r" % (lnames, )
                    raise

                return dict((sr.name.lower(), sr._id) for sr in srs)
Пример #14
0
 def _by_name_multiple(cls, name):
     q = cls._query(lower(Account.c.name) == name.lower(),
                    Account.c._spam == (True, False),
                    Account.c._deleted == (True, False))
     return list(q)
Пример #15
0
 def _by_name_multiple(cls, name):
     q = cls._query(
         lower(Account.c.name) == name.lower(),
         Account.c._spam == (True, False),
         Account.c._deleted == (True, False))
     return list(q)
Пример #16
0
 def _by_url_cache(cls, url, sr):
     q = cls._query(base_url(lower(cls.c.url)) == utils.base_url(url.lower()))
     if sr:
         q._filter(cls.c.sr_id == sr._id)
     q = list(q)
     return [l._id for l in q]