Re: [sqlalchemy] automap : problem with two relationships on same foreign key

2016-01-06 Thread yoch . melka
For now, I don't have a sufficiently comprehensive view of the automap process and its effects to make a pull-request. Maybe one day I'll take time to learn more about that, and to understand the corresponding tests. Thank you Le lundi 4 janvier 2016 05:19:17 UTC+2, Michael Bayer a écrit : > >

Re: [sqlalchemy] Searching from jsonb list

2016-01-06 Thread Sami Pietilä
Can I have an example how such a cast is done for the string "third" in this case? tiistai 5. tammikuuta 2016 17.38.34 UTC+2 Jon Rosebaugh kirjoitti: > > Aha; the arrow in your message appeared to be pointing at the wrong > thing (due to variable-width fonts). My apologies. > > Looks like

Re: [sqlalchemy] Re: Connection pools

2016-01-06 Thread Chris Wood
The project is actually using mod_wsgi (presumably using MPM) - this seems to explain the rapid increase in the number of connections. It's been suggested that implementing SQLRelay could be a solution. Is this sensible? Are there any (better?) alternatives that I could look at? Cheers,

Re: [sqlalchemy] Re: Connection pools

2016-01-06 Thread Mike Bayer
On 01/06/2016 08:09 AM, Chris Wood wrote: > The project is actually using mod_wsgi (presumably using MPM) - this > seems to explain the rapid increase in the number of connections. It's > been suggested that implementing SQLRelay could be a solution. Is this > sensible? Are there any (better?)

Re: [sqlalchemy] checking unloaded attributes

2016-01-06 Thread Christopher Lee
I'm happy for the change. Having getattr (and even hasattr!) change the state of the object was occasionally infuriating to debug, because my variable watches would trigger state changes, and cause data to be overwritten with NULLs. I'll have to dig into my code a little deeper and figure out a

Re: [sqlalchemy] Bulk insertion with null values

2016-01-06 Thread Mike Bayer
I don't have a solution for that at the moment other than to use a straight Core insert, if there aren't other complicating factors. bulk_insert_mappings() tries to keep the same contract as that of a regular Session.flush(), where None means to "omit" the value, which has affects whether or not

Re: [sqlalchemy] checking unloaded attributes

2016-01-06 Thread Mike Bayer
On 01/06/2016 04:35 PM, Christopher Lee wrote: > > My code tests to see if an column on a model is loaded, in part because > I merge partial models to perform a sparse update on the database. I do > that by checking the __dict__ of the model, though sqlalchemy.inspect > also works. > > Using

[sqlalchemy] Experimental Py3 port of IBM DB2 dialect

2016-01-06 Thread 'Dr. Leo' via sqlalchemy
Hi, DB2 support has so far been limited to Py2. However, there is a recent PR porting IBM_DB_SA to Py3: https://github.com/ibmdb/python-ibmdbsa/pull/8 After a few simple queries it seems to work just fine. Any other impressions, pitfall warnings etc. would be appreciated. Leo -- You

[sqlalchemy] Re: Creating children objects within __init__

2016-01-06 Thread Jim Shepherd
Thanks for the advice. The query().get() worked well. -Jim -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to

[sqlalchemy] Bulk insertion with null values

2016-01-06 Thread Tobias
Hi, I am using Session.bulk_insert_mappings() to insert a number of entities. This works great except when there are entities with None values. For example the following call issues