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

            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)

    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

    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

 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

    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

    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

    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

 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)

 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]