Re: [Sqlalchemy-users] Schema Tracking and Changeset generation

2006-03-07 Thread Shuo Yang
On 3/7/06, Michael Bayer <[EMAIL PROTECTED]> wrote: On Mar 7, 2006, at 12:46 AM, Kapil Thangavelu wrote:> i've been playing around with this and have generation of some> kinds of change objects.  what would be the best way to generate> the sql ddl for these changesets? i'd like to take advantage of

Re: [Sqlalchemy-users] Schema Tracking and Changeset generation

2006-03-07 Thread Michael Bayer
On Mar 7, 2006, at 12:46 AM, Kapil Thangavelu wrote: i've been playing around with this and have generation of some kinds of change objects. what would be the best way to generate the sql ddl for these changesets? i'd like to take advantage of the sql generation and abstraction capabiliti

Re: [Sqlalchemy-users] count() for selectables broken?

2006-03-07 Thread Michael Bayer
ah it was just an errant "count" variable stuck on the alias object, committed the fix to SVN. On Mar 7, 2006, at 7:42 PM, [EMAIL PROTECTED] wrote: Hi, I haven't had a chance to dig through why this is coming up, but it seems like count() for selectables is getting rebound from what FromClau

[Sqlalchemy-users] count() for selectables broken?

2006-03-07 Thread daishi
Hi, I haven't had a chance to dig through why this is coming up, but it seems like count() for selectables is getting rebound from what FromClause defines. Test code and output are below. --- test code: # Test count() on selectable import sqlalchemy as rdb engine = rdb.create_engine('sqlite:/

Re: [Sqlalchemy-users] basic problem on sqlalchemy 0.1.3 and oracle

2006-03-07 Thread Michael Bayer
hey florian - I have the oracle 10g server, but at the moment I am remote from that location, so I cant see the source of the problem you are having. I would advise to get the latest SVN trunk and see if that works, someone else is having good results with it right now. also if its possi

[Sqlalchemy-users] basic problem on sqlalchemy 0.1.3 and oracle

2006-03-07 Thread Florian Boesch
Hi, I've got a problem since 0.1.3 that didn't exist in 0.1.2, the problem is: File "/home/florian/shop_ng/shop/shop/controllers.py", line 16, in __getattr__ config = orm.Mandator.mapper.get_by_name(name) File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.1.3-py2.4.egg/sqlalchemy/map

RE: [Sqlalchemy-users] ORA-00972: identifier is too long

2006-03-07 Thread Boersma, Matt
Thanks so much, Michael! I grabbed your patch by updating to SVN head, and my Oracle queries are working just fine now with shortened aliases. For the list, somewhat off-topic: SQLAlchemy is very well thought out and far more capable than alternatives. I did a modest amount of evangelizing for