[sqlalchemy] sqlalchemy 0.8.2 postgres dialects array append does not dirty

2013-07-31 Thread notedit
hi, i just come accross this, i use sqlalchemy 0.7.8 before these all work. when i update to 0.8.2 this does not work. -- 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

[sqlalchemy] Problems with eager loading instances of a class which is part of an inheritance hierarchy where polymorphic_identity has been set dynamically.

2013-07-31 Thread Etienne Rouxel
Hello Better than a long speech, here are two files (eagerloading1.py, eagerloading2.py) which, I though, were supposed to do the same thing. Indeed, the difference is that in the first file, the polymorphic_identity is hard coded and in the second file, it is set dynamically afterward (like

Re: [sqlalchemy] sqlalchemy 0.8.2 postgres dialects array append does not dirty

2013-07-31 Thread Michael Bayer
see http://docs.sqlalchemy.org/en/rel_0_8/changelog/migration_08.html#mutabletype On Jul 31, 2013, at 4:02 AM, notedit note...@gmail.com wrote: hi, i just come accross this, i use sqlalchemy 0.7.8 before these all work. when i update to 0.8.2 this does not work. -- You received

Re: [sqlalchemy] sqlalchemy 0.8.2 postgres dialects array append does not dirty

2013-07-31 Thread notedit
yes i have noticed these. but i still do not know how to use these with array. can you give me some example code? 2013/7/31 Michael Bayer mike...@zzzcomputing.com see http://docs.sqlalchemy.org/en/rel_0_8/changelog/migration_08.html#mutabletype On Jul 31, 2013, at 4:02 AM, notedit

Re: [sqlalchemy] sqlalchemy 0.8.2 postgres dialects array append does not dirty

2013-07-31 Thread Michael Bayer
I dont' have an example specific to ARRAY handy, did you read the documentation at http://docs.sqlalchemy.org/en/rel_0_8/orm/extensions/mutable.html ? On Jul 31, 2013, at 10:12 AM, notedit note...@gmail.com wrote: yes i have noticed these. but i still do not know how to use these with

Re: [sqlalchemy] sqlalchemy 0.8.2 postgres dialects array append does not dirty

2013-07-31 Thread notedit
yes i have readed the doc, but i just can not make it work with ARRAY. 2013/7/31 Michael Bayer mike...@zzzcomputing.com I dont' have an example specific to ARRAY handy, did you read the documentation at http://docs.sqlalchemy.org/en/rel_0_8/orm/extensions/mutable.html ? On Jul 31, 2013,

Re: [sqlalchemy] Problems with eager loading instances of a class which is part of an inheritance hierarchy where polymorphic_identity has been set dynamically.

2013-07-31 Thread Michael Bayer
I've isolated what's happening here, but please send me scripts that generate data next time so that I don't need to take the time to reproduce all of this.the issue is not related to eager loading, it has to do with a many-to-one load of TaxonRelationship.referenced_taxon should pull from the

Re: [sqlalchemy] sqlalchemy 0.8.2 postgres dialects array append does not dirty

2013-07-31 Thread Michael Bayer
can you pass along a short code example? I can try to edit it. On Jul 31, 2013, at 10:27 AM, notedit note...@gmail.com wrote: yes i have readed the doc, but i just can not make it work with ARRAY. 2013/7/31 Michael Bayer mike...@zzzcomputing.com I dont' have an example specific to

[sqlalchemy] Re: Problems with eager loading instances of a class which is part of an inheritance hierarchy where polymorphic_identity has been set dynamically.

2013-07-31 Thread Etienne Rouxel
Hello Michael Thank you very much for your quick answer. I did provide the file test-data.sql that generates data. Didn't you see it or maybe would you like something different next time? Thank you Le mercredi 31 juillet 2013 10:09:54 UTC+2, Etienne Rouxel a écrit : Hello Better than a

Re: [sqlalchemy] Problems with eager loading instances of a class which is part of an inheritance hierarchy where polymorphic_identity has been set dynamically.

2013-07-31 Thread Michael Bayer
ack ! totally missed that, sorry. On Jul 31, 2013, at 10:56 AM, Etienne Rouxel rouxel.etie...@gmail.com wrote: Hello Michael Thank you very much for your quick answer. I did provide the file test-data.sql that generates data. Didn't you see it or maybe would you like something

Re: [sqlalchemy] sqlalchemy 0.8.2 postgres dialects array append does not dirty

2013-07-31 Thread Michael Bayer
here you go, note MutableList is copied from MutableDict except adapted for lists, works as advertised (you'd need to add other list methods besides append()): from sqlalchemy import * from sqlalchemy.orm import * from sqlalchemy.ext.declarative import declarative_base from

Re: [sqlalchemy] Mocking RowProxy and ResultProxy objects

2013-07-31 Thread tiadobatima
Great! I'm gonna check it out :) Thanks! On Saturday, 27 July 2013 12:11:12 UTC-7, Michael Bayer wrote: take a look in test/engine/test_pool and test/engine/test_reconnect for examples On Jul 27, 2013, at 1:50 PM, tiadobatima gbar...@gmail.com javascript: wrote: Hi Michael, Yeah...

[sqlalchemy] Extending sqlalchemy.schema.Table

2013-07-31 Thread tiadobatima
Hello there, When this application starts, we reflect the DB into a MetaData() object and this is made available for everyone to use. I'd like to add a few more methods to the table objects within that MetaData(). Is there any easy way to extend these already instantiated

Re: [sqlalchemy] Extending sqlalchemy.schema.Table

2013-07-31 Thread Michael Bayer
You'd probably implement your own reflect_all function/method: from sqlalchemy import inspect def reflect(metadata, bind): inspector = inspect(bind) for tname in inspector.get_table_names(): MySpecialTable(tname, metadata, autoload=True, autoload_with=bind) On Jul 31, 2013, at

Re: [sqlalchemy] Extending sqlalchemy.schema.Table

2013-07-31 Thread Michael Bayer
oh, except you might have problems with tables in there that are reflected due to a foreign key.Table is not really intended for subclassing, unless you want to do SQLAlchemy-Migrate's approach of monkeypatching Table.__bases__ at the global level, I'd seek some other way to achieve what

Re: [sqlalchemy] Extending sqlalchemy.schema.Table

2013-07-31 Thread Gustavo Baratto
Thanks for the reply Michael... I had a hunch this wouldn't be easy to tackle, but this is more than I can chew at the moment: ) For now, I'll just keeping doing what I'm already doing which is to instantiate a new class taking the table as an argument, and then within my class reference the

[sqlalchemy] Enforcing order of operations when using SQL Expression Language

2013-07-31 Thread Matt Murphy
I am defining a Comparator as follows: class VersionComparator(CompositeProperty.Comparator): def __eq__(self, other): return and_(*[a == b for a, b in zip(self.__clause_element__().clauses, other.__composite_values__())]) def __lt__(self, other): lhs =

Re: [sqlalchemy] Enforcing order of operations when using SQL Expression Language

2013-07-31 Thread Michael Bayer
On Jul 31, 2013, at 10:53 PM, Matt Murphy matthew.john.mur...@gmail.com wrote: When I look at the SQL that is created it looks like this: FROM components WHERE NOT (components.major %(major_1)s OR components.major = %(major_2)s AND components.minor %(minor_1)s OR components.major =

Re: [sqlalchemy] sqlalchemy 0.8.2 postgres dialects array append does not dirty

2013-07-31 Thread notedit
thanks micheal, 2013/8/1 Michael Bayer mike...@zzzcomputing.com here you go, note MutableList is copied from MutableDict except adapted for lists, works as advertised (you'd need to add other list methods besides append()): from sqlalchemy import * from sqlalchemy.orm import * from