[sqlalchemy] Re: Update session extension after creation

I also tried session.configure(extension=MySessionExtension()) with no success On 10 sep, 10:13, Laurent Rahuel laurent.rah...@gmail.com wrote: Hi, I'm currently using a webframework which uses sqlalchemy. Each time a request hits the server, the framework creates a session object I can

[sqlalchemy] Re: : Declarative and association object same model

Here is a primaryjoin, secondaryjoin I tried without success: neighbors = relation(Place, primaryjoin=(Place.id == neighbors_table.place_id), secondaryjoin= (neighbors_table.neighbor_id == Place.id), secondary=neighbors_table) and the error is: sqlalchemy.exc.InvalidRequestError: When

[sqlalchemy] Re: ForeignKey on a ForeignKey

Hi King Simon, Thanks for your answer but this doesn't solve my problem. If I comment my parent_id definition in the objects_tree definition, everything is OK with create_all() invocation. If I change the parent_id column definition to : sa.Column('parent_id', None, sa.ForeignKey('objects.id',

[sqlalchemy] Plain SQL and session.flush in a single transaction

Hi, I'm trying to implement a nested tree via sqlalchemy. So my problem is that when I add or remove objects from the tree I need to update some records to change their left hand side and right hand side values. I order to improve the performances of these changes, and because the number of

[sqlalchemy] Re: Plain SQL and session.flush in a single transaction

Thank you very much for this link, I'm going to try asap Regards, Laurent --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To

[sqlalchemy] Re: Multilpe Table inheritance and relations

Since I'm really stupid, I have another problem which seems to be much to complex for my small brain. I'm performing some more tests with SA and I tried to add a self reference to a table which also is involved in inheritance. This is my example : employees = Table('employees', metadata,

[sqlalchemy] Re: Multilpe Table inheritance and relations

Ooops, My primaryjoin=employees.c.another_id==employees.c.person_id should be primaryjoin=employees.c.father_id==employees.c.person_id. This is just a typo. I really have this FlushError: Circular dependency detected --~--~-~--~~~---~--~~ You received this

[sqlalchemy] Multilpe Table inheritance and relations

Hi, Following the documentation about inheritance (Multiple Table Inheritance, Polymorphic), I get into troubles trying to add a relation between tables. I just used the documentation sample and modified the engineers table this way : engineers = Table('engineers', metadata,

[sqlalchemy] Re: Multilpe Table inheritance and relations

Hi, THX a lot this is working like a charm. This is a much more complex mapper than the ones I'm used to do. Regards, Laurent --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this