def get_player_names(self): result = DBSession.query(model.PlayerRecord.player_name)\ .filter(model.PlayerRecord.points>=1000)\ .group_by(model.PlayerRecord.ogameid).all() return dict(names=[n[0] for n in result])
def by_email_address(cls, email): """Return the user object whose email address is ``email``.""" return DBSession.query(cls).filter(cls.email_address==email).first()
def by_user_name(cls, username): """Return the user object whose user name is ``username``.""" return DBSession.query(cls).filter(cls.user_name==username).first()
def test_query_obj(self): obj = DBSession.query(self.klass).one() for key, value in self.attrs.iteritems(): assert_equals(getattr(obj, key), value)