How to implement this stat behaviour (RPG-like stats):
players_table = Table('player',
Column('id', Integer, primary_key=True),
Column('name', String),
Column('level', Integer),
)
# SELECT 'level', count('level') as 'count' FROM player ORDER BY
'level' GROUP BY 'level'
#
class Stats(object): pass
mapper(Stats, players_table, include_properties=['level'], properties
= {
'count': column_property( func.count('level).label('count') )
})
this fails with error...
And where 'ORDER BY' and 'GROUP BY' must be placed?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---