Re: [sqlalchemy] Relationship through association table

2018-12-28 Thread Mehdi Gmira
i, Dec 28, 2018 at 4:24 AM Mehdi Gmira wrote: > > > > Thanks for the reply. There is something I don't understand in the > example: > > > > B_viacd = mapper(B, j, non_primary=True, properties={ > > "b_id": [j.c.b_id, j.c.d_b_id], > > &

Re: [sqlalchemy] Relationship through association table

2018-12-28 Thread Mehdi Gmira
bject Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed

[sqlalchemy] Re: Execute with raw string not persisted to database

2016-07-25 Thread Mehdi gmira
Maybe you forgot to commit ? Le lundi 25 juillet 2016 12:08:17 UTC+2, Rogier Eggers a écrit : > > Hello, > > I have an old script that I'm upgrading. It uses sqlalchemy connect and > then execute statements to send raw sql as strings to the database (mysql). > The problem that I'm having is

Re: [sqlalchemy] Re: explicitly add objects to identity map

2016-07-22 Thread Mehdi gmira
Thanks for the link :) Le jeudi 21 juillet 2016 20:18:05 UTC+2, Mike Bayer a écrit : > > > > On 07/21/2016 01:44 PM, Simon King wrote: > > On Thu, Jul 21, 2016 at 5:58 PM, Jonathan Vanasco > wrote: > >> > >> > >> On Thursday, July 21, 2016 at 12:15:40 PM UTC-4, Simon

[sqlalchemy] Re: explicitly add objects to identity map

2016-07-21 Thread Mehdi gmira
Yeah I thought of that. I find it awkward because you have to think of using threadlocal objects, etc. I would have liked it better if sqlachemy exposed an api for that. But if that's not the case I'll do that. Le jeudi 21 juillet 2016 17:56:45 UTC+2, Jonathan Vanasco a écrit : > > I do this

Re: [sqlalchemy] explicitly add objects to identity map

2016-07-21 Thread Mehdi gmira
child.parent # will issue SQL because parents has disappeared from identity map I would like to force the identity map to save some objects even after garbage collection Le jeudi 21 juillet 2016 16:48:55 UTC+2, Simon King a écrit : > > On Thu, Jul 21, 2016 at 3:29 PM, Mehdi gmira <mgm...@wir

[sqlalchemy] explicitly add objects to identity map

2016-07-21 Thread Mehdi gmira
Is there a way to explicitely add objects to the identity map ? I would like to be able to do something like: foos = session.query(Foo).all() add_to_identity_map(foos) -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this

Re: [sqlalchemy] scoped_session, sessions and thread safety

2016-04-01 Thread Mehdi GMIRA
Le vendredi 1 avril 2016 02:30:21 UTC+2, Mike Bayer a écrit : > > > > On 03/31/2016 10:38 AM, Mehdi GMIRA wrote: > > > > > > > > 1) One limitation that i find to the scoped_session is that > you're > > > limited to exactly one

Re: [sqlalchemy] scoped_session, sessions and thread safety

2016-03-31 Thread Mehdi GMIRA
create as many independant sessions as i want within the same thread and commit them when i want to. Le mercredi 30 mars 2016 19:00:16 UTC+2, Mike Bayer a écrit : > > > > On 03/30/2016 12:37 PM, Mehdi GMIRA wrote: > > I've read a lot of stuff on scoped_session, thread sa

[sqlalchemy] scoped_session, sessions and thread safety

2016-03-30 Thread Mehdi GMIRA
I've read a lot of stuff on scoped_session, thread safety, and sessions, and i just don't get it. For me, a session is just a "wrapper" around the actual database behind it. And databases do not like concurrent updates of the same row within multiple transactions. So, it is my understanding