[sqlalchemy] Re: A General Thank You

2008-02-11 Thread iain duncan
On Sat, 2008-19-01 at 17:48 -0500, Michael Bayer wrote: youre very welcome ! glad you've had a positive experience. Yeah, the SA docs are awesome. The whole package is awesome. I was recently really impressed with how easy it was to migrate to 0.4. Iain

[sqlalchemy] Re: Entity name None

2008-02-11 Thread Werner F. Bruhin
Michael, Michael Bayer wrote: ... the entity name part of the message there is only trying to identify which mapper the given object is mapped to. but in this case it looks like you are saving an actual Mapper object (when you should be sending one of your application's object

[sqlalchemy] Re: Refresh problem in orm

2008-02-11 Thread maxi
Thanks for your replay, The easiest in this case is to use query.populate_existing(): sess.query(Person).populate_existing().filter_by().all() however, this method is only available in 0.4. How work this ? This method - populate_existing() - re-read from database ? in 0.3, several

[sqlalchemy] select in

2008-02-11 Thread Glauco
Hi all, What's the simplest way for do a simple: select * from myTable where id in (1,2,3); I've solved this by using Subquery but final qry isn't pretty as this one. Thank you Glauco -- ++ Glauco Uri

[sqlalchemy] Re: self referential query with order_by

2008-02-11 Thread David Gardner
Thank you this worked for me. You can put the child order by at the end using reset_joinpoint(): grandchildren = session.query(Node).filter(Node.c.type==var1).\ join('Parent', aliased=True).filter(Node.c.type==var2).\ order_by(Node.name).\ join('Parent',aliased=True,from_joinpoint=True).\

[sqlalchemy] pymssql delete problem

2008-02-11 Thread fw
Hi Guys, I have an application that staddles 2 databases, MySQL and MS-SQL. It is working but could be faster. To that end, I am trying to use MS- SQL with the pymssql module (so I can eagerload a number of things). The problem is that DELETE fail when more than one record is deleted. It

[sqlalchemy] Re: self referential query with order_by

2008-02-11 Thread Michael Bayer
yup that seems to be the case, was fixed in 0.4.2. On Feb 11, 2008, at 8:01 PM, David Gardner wrote: Well sort of... This worked on my local development box (0.4.2p3), but my server is still on 0.4.0 and the data is sorted by grandchild only. I am assuming this is expected and I just need

[sqlalchemy] some error at v4070

2008-02-11 Thread svilen
hi. running the dbcook tests, from v4070 onwards i get the following error: Traceback (most recent call last): File rr.py, line 68, in module for q in session.query(A).all(): print q File sqlalchemy/orm/query.py, line 746, in all return list(self) File sqlalchemy/orm/query.py, line

[sqlalchemy] Re: Entity name None

2008-02-11 Thread Michael Bayer
On Feb 11, 2008, at 12:02 PM, Werner F. Bruhin wrote: Thanks again for you quick reply. I had a case problem, my string was containing the mapper name instead of the object name. not sure if you're referring to your emailthe error basically means no mapper() is set up for the

[sqlalchemy] Re: self referential query with order_by

2008-02-11 Thread David Gardner
Well sort of... This worked on my local development box (0.4.2p3), but my server is still on 0.4.0 and the data is sorted by grandchild only. I am assuming this is expected and I just need to upgrade my server to get this working? David Gardner wrote: Thank you this worked for me. You

[sqlalchemy] Re: Refresh problem in orm

2008-02-11 Thread Michael Bayer
On Feb 11, 2008, at 10:20 AM, maxi wrote: Thanks for your replay, The easiest in this case is to use query.populate_existing(): sess.query(Person).populate_existing().filter_by().all() however, this method is only available in 0.4. How work this ? This method - populate_existing()

[sqlalchemy] Re: Refresh problem in orm

2008-02-11 Thread Michael Bayer
On Feb 11, 2008, at 9:52 AM, maxi wrote: Hi, I've a problem, aparently, with refresh data in a user concurrent system using orm lib. For instance, an user do a query request which return a objects list. people = session.query(Person).filter_by().all() and, I show this in my GUI (a

[sqlalchemy] Re: building mappers for an existing database

2008-02-11 Thread svilen
On Monday 11 February 2008 16:07:03 Chris Withers wrote: svilen wrote: search the group for things related to migrate (i call it migrene :); there are 2 approaches: - make the db match the py-model - make the model match the db It's this 2nd one I'm asking about. Is sqlautocode the

[sqlalchemy] Re: building mappers for an existing database

2008-02-11 Thread Chris Withers
svilen wrote: search the group for things related to migrate (i call it migrene :); there are 2 approaches: - make the db match the py-model - make the model match the db It's this 2nd one I'm asking about. Is sqlautocode the standard way of doing this? cheers, Chris -- Simplistix -

[sqlalchemy] Re: Polymorphic and inheritance with missing children

2008-02-11 Thread Richard Levasseur
On Feb 8, 2008 2:27 PM, Michael Bayer [EMAIL PROTECTED] wrote: On Feb 8, 2008, at 3:49 PM, Richard Levasseur wrote: Hm, we could do that, but that means that we have to outerjoin to ~15 other tables. The primary table has ~200+ columns on it, each child table has 10-20 columns, there