[sqlalchemy] Re: Calling flush after delete causes ObjectDeletedError..

2009-05-13 Thread Toby Bradshaw
that. On May 1, 2009, at 12:50 PM, Toby Bradshaw wrote: Very straightforward, this one. The following: session.delete(p) session.flush() Reliably gets me an ObjectDeletedError exception. p is a known valid object before the delete. No other update, insert or deletes have

[sqlalchemy] Re: _should_log_info - Setting up logging correctly.

2009-04-03 Thread Toby Bradshaw
wont in fact work for any other configuration other than the default one. However.. I know the turbogears guys have got this working so perhaps I should go dig around there and see how they've managed to do it. Thanks again. t o b e Michael Bayer wrote: Toby Bradshaw wrote: Hi

[sqlalchemy] Possible caching problem

2009-04-03 Thread Toby Bradshaw
I wasn't aware SQLAlchemy had any kind of cache built in but I do seem to be seeing some behaviour that sure looks like it. I have an SQA/cherrypy app which shares the DB with another app using MySQLdb only. Updates in the thirdparty are visible to the thirdparty immediately. They're not

[sqlalchemy] _should_log_info - Setting up logging correctly.

2009-04-02 Thread Toby Bradshaw
Hi, Succintly: What's the correct way to set up logging in SQLAlchemy 0.5.2 ?? The docs say simply set the logger level correctly. However I notice in the source that most classes make a check on _should_log_info (which is set during __init__) before deciding whether to call the logger. This

[sqlalchemy] Can polymorphic_identity be a range of values ?

2009-02-05 Thread Toby Bradshaw
Hi, So I (think I) understand that that polymorphic_on and polymorphic_identity can be used to determine which class is instantiated for a query result row. Is there any way I can use a range of values for polymorphic_identity to map to the same class ? Of specific interest to me right now

[sqlalchemy] Re: Mixing synonyms and properties with reflected tables..

2009-01-27 Thread Toby Bradshaw
of SQLAlchemy here in London. Regards, Toby Bradshaw Senior Networking Engineer, Ideawork 3d, London, UK. Michael Bayer wrote: On Jan 26, 2009, at 1:29 PM, Toby Bradshaw wrote: Michael Bayer wrote: also your example should read like this: a = session.query(A).all()[0] print a.time_units

[sqlalchemy] Re: Mixing synonyms and properties with reflected tables..

2009-01-26 Thread Toby Bradshaw
. Thanks in advance, -- Toby Bradshaw Ideaworks 3d Ltd, London, UK. Michael Bayer wrote: On Jan 23, 2009, at 1:43 PM, Toby Bradshaw wrote: the synonym() construct and the mapped attribute it creates represents a proxy to the mapped column only in the context of accessing and setting values

[sqlalchemy] Re: Mixing synonyms and properties with reflected tables..

2009-01-26 Thread Toby Bradshaw
. a.time_units. On Jan 26, 2009, at 12:59 PM, Toby Bradshaw wrote: CREATE TABLE example_a ( id integer NOT NULL, time_units integer, CONSTRAINT example_a_pkey PRIMARY KEY (id) ) and (based on http://www.sqlalchemy.org/docs/05/mappers.html#using-descriptors) http

[sqlalchemy] Mixing synonyms and properties with reflected tables..

2009-01-23 Thread Toby Bradshaw
schemes that might work but they seem to lose me the ability to use the synonym as spelled in filter expressions Thanks in advance, Toby Bradshaw -- Ideaworks 3d, London, UK. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google