Re: [sqlalchemy] Strange (Heisen)bug with dictionary association_proxy

2016-09-10 Thread Dominik George
Am Samstag, 10. September 2016 09:02:32 UTC+2 schrieb Dominik George: > > Hi Mike, > > here it is. See attached mwe.py. > Which is here ;). -nik -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe

Re: [sqlalchemy] Strange (Heisen)bug with dictionary association_proxy

2016-09-09 Thread Dominik George
om that happens inside SQLAlchemy. Cheers, Nik -- PGP-Fingerprint: 3C9D 54A4 7575 C026 FB17 FD26 B79A 3C16 A0C4 F296 Dominik George · Mobil: +49-1520-1981389 Teckids e.V. · FrOSCon e.V. · OpenRheinRuhr e.V. Fellowship of the FSFE · Piratenpartei Deutschland Opencaching Deutschland e.V. · D

Re: [sqlalchemy] Strange (Heisen)bug with dictionary association_proxy

2016-09-09 Thread Dominik George
Hi, thanks for your reply! make sure you set the environment variable PYTHONHASHSEED=random, then > run your tests repeatedly. This variable produces a random hash seed > for dictionaries and will smoke out dictionary-ordering based bugs more > clearly so that you can localize the source of

[sqlalchemy] Strange (Heisen)bug with dictionary association_proxy

2016-09-08 Thread Dominik George
FD26 B79A 3C16 A0C4 F296 Dominik George · Mobil: +49-1520-1981389 Teckids e.V. · FrOSCon e.V. · OpenRheinRuhr e.V. Fellowship of the FSFE · Piratenpartei Deutschland Opencaching Deutschland e.V. · Debian Contributor LPIC-3 Linux Enterprise Professional (Security) -- You received this message

[sqlalchemy] Re: Get nested query from Exists clause

2016-08-25 Thread Dominik George
To be more precise: I have a query like this one: session.query(osmalchemy.node).filter(osmalchemy.node.tags.any(key="name", value="Grill-Corner")).all() It ultimately compiles to this QL expression: query = SELECT osm_nodes.element_id AS osm_nodes_element_id, osm_elements.element_id AS

Re: [sqlalchemy] Get nested query from Exists clause

2016-08-25 Thread Dominik George
Hi, Am Montag, 15. August 2016 15:32:35 UTC+2 schrieb Mike Bayer: > > > nothing is string-compiled at that point, everything is just nested > inside. the Exists() should have something like "element" inside of it > (look in its __dict__) that is the underlying Selectable. > > > .element is a

Re: [sqlalchemy] Querying a dict collection by key/value pair

2016-08-12 Thread Dominik George
Hi, Am Freitag, 12. August 2016 11:12:37 UTC+2 schrieb Dominik George: > > I would probably go with monkey-patching SQLAlchemy at runtime and I am > afraid Python would actually allow that. > > > Did it, and it actually works nicely: https://github.com/Natureshadow/OSMA

Re: [sqlalchemy] Querying a dict collection by key/value pair

2016-08-12 Thread Dominik George
work-around it for now? I would probably go with monkey-patching SQLAlchemy at runtime and I am afraid Python would actually allow that. Or is there another simple way of getting that kind of query? -nik -- PGP-Fingerprint: 3C9D 54A4 7575 C026 FB17 FD26 B79A 3C16 A0C4 F296 Dominik George · Mob

[sqlalchemy] Querying a dict collection by key/value pair

2016-08-11 Thread Dominik George
Hi, first of all, thanks for SQLAlchemy - it's the one project that actually made me enjoy working with large data collections in applications ;)! I have an SQLAlchemy model that associates tags (key/value pairs) with elements, like in attached mwe.py. Element.tags is a dictionary