Re: [sqlalchemy] sqlalchemy and redis caching

2011-12-25 Thread Michael Bayer
On Dec 24, 2011, at 5:38 PM, Mengu wrote: hi all. i am caching my query results in redis with sqlalchemy.ext.serializer.loads/dumps. like results = DBSession.query(ShowContestant).all() and redis.set(key, dumps(results)) when i do loads(redis.get(key)) i get the obj without any problems

[sqlalchemy] Order by in select doesn't seem to work

2011-12-25 Thread VDK
I have the following piece of code: class ContributieNotas(object): class Admin(EntityAdmin): verbose_name = 'Contributie notas' verbose_name_plural = 'Contributienota\'s' list_display = ['id', 'achternaam', 'tussenvoegsel', 'voorletters', 'adres',

Re: [sqlalchemy] 0.7 event migration

2011-12-25 Thread Michael Bayer
yes a few change names, reconstruct_instance, init_instance, init_failed. On Dec 24, 2011, at 7:42 PM, Kent Bower wrote: Right. And reconstruct_instance() was renamed load()? On 12/24/2011 5:56 PM, Michael Bayer wrote: On Dec 24, 2011, at 10:04 AM, Kent wrote: As the migration guide

Re: [sqlalchemy] Order by in select doesn't seem to work

2011-12-25 Thread Michael Bayer
On Dec 25, 2011, at 7:36 AM, VDK wrote: I have the following piece of code: class ContributieNotas(object): class Admin(EntityAdmin): verbose_name = 'Contributie notas' verbose_name_plural = 'Contributienota\'s' list_display = ['id', 'achternaam',

Re: [sqlalchemy] SQLalchemy, PostgreSQL/tsearch/ts_rank_cd

2011-12-25 Thread Michael Bayer
On Dec 23, 2011, at 9:32 PM, Adam Tauno Williams wrote: I'm stumped how to build the following query in SQLalchemy: SELECT title, ts_rank_cd(textsearch, query) AS rank FROM apod, to_tsquery('neutrino|(dark matter)') query WHERE query @@ textsearch ORDER BY rank DESC LIMIT 10; I can do

Re: [sqlalchemy] override char() handling

2011-12-25 Thread Michael Bayer
On Dec 24, 2011, at 10:52 PM, alex bodnaru wrote: hello friends, i'm happily using sqlalchemy in a tg 2.1 project. with a legacy database, thus my queries are in the form of dbsession.execute(sql). sql is.. a string ?select() construct ? where should i hook a strip of the

[sqlalchemy] Re: Order by in select doesn't seem to work

2011-12-25 Thread VDK
With echo=True, the following sql statements are reported: INFO:sqlalchemy.engine.base.Engine.0x...9890:select version() INFO:sqlalchemy.engine.base.Engine.0x...9890:{} 2011-12-25 21:08:58,796 INFO sqlalchemy.engine.base.Engine.0x...9890 select version() 2011-12-25 21:08:58,797 INFO

Re: [sqlalchemy] Re: Order by in select doesn't seem to work

2011-12-25 Thread Michael Bayer
On Dec 25, 2011, at 3:19 PM, VDK wrote: With echo=True, the following sql statements are reported: INFO:sqlalchemy.engine.base.Engine.0x...9890:select version() INFO:sqlalchemy.engine.base.Engine.0x...9890:{} 2011-12-25 21:08:58,796 INFO sqlalchemy.engine.base.Engine.0x...9890 select