[sqlalchemy] Can we include this new url traversal with cherrypy?

2007-02-28 Thread vinjvinj
There was a post about a new url traversal implemented in turbogears on top of cherrypy (with ideas being borrowed from Nevow): https://projects.isotoma.com/tgnewtraversal Looks very cool indeed. Is there any way to integrate this with the cherrypy distribution? Vineet

[sqlalchemy] Re: How do I get columns in sqlalchemy group by function

2007-02-28 Thread vinjvinj
Thanks. On Feb 27, 11:20 am, Jonathan Ellis [EMAIL PROTECTED] wrote: group_by_column.clauses[0] is the object you passed to func.sum On 2/27/07, vinjvinj [EMAIL PROTECTED] wrote: I have the following columns in some of my select columns: group_by_column = sqlalchemy.func.sum(column1)

[sqlalchemy] Re: rev2362 fixes one thing and breaks another

2007-02-28 Thread svilen
ok, here the cleaned case. Problem appears if A-B-C, A references B, B-mapper is polymorphic too, and there are 3 instances saved - A,B,C. It is similar as in http://groups.google.com/group/sqlalchemy/browse_thread/thread/5f05c11e3c168fb5/3c956e71dc724214#3c956e71dc724214 but there the

[sqlalchemy] Re: contains_eager is somehow not loading all the instances.

2007-02-28 Thread Dennis
That's the problem, if I have use_labels=True, and I include as somecolumn in the text clause, I still get a generated label. The resulting sql = . as somecolumn as somelonglabelthatisashortenedversionofthetext. that creates an sql error. On Feb 27, 3:51 pm, Michael Bayer [EMAIL PROTECTED]

[sqlalchemy] Re: rev2362 fixes one thing and breaks another

2007-02-28 Thread svilen
like this one...this does your generating thing. but much easier to understand, since the actual test is clearly spelled out: http://www.sqlalchemy.org/trac/browser/sqlalchemy/trunk/test/orm/ abc_inheritance.py does that work under postgress? i mean the duplicating id-column issue, for

[sqlalchemy] Transaction nesting with session.create_transaction()

2007-02-28 Thread Rick Morrison
Hi all, I'm trying to mix ORM transactions and SQL transaction as follows: T1 = S.create_transaction() # do some ORM stuff C1 = T1.connection() C2.execute(sql) T2 = S.create_transaction() # nested ORM stuff C2 = T2.connection() C2.execute(sql)

[sqlalchemy] Re: Running initialization code after creating/loading an object

2007-02-28 Thread Rick Morrison
Hi Sanjay, Mapper Extension is the way to do this. I use one we call our compiler extension, it fires events before database insert, datase update and after database load; you can use these events to modify the object as needed. You can probably hack this into what you need: class

[sqlalchemy] Re: Transaction nesting with session.create_transaction()

2007-02-28 Thread Michael Bayer
the nesting should work fine I just added a small test case to check that. you can look at the test case and see if you can break it. the C1 below is closed because your T2 probably is committing for some reason but i dont know why. On Feb 28, 2007, at 11:56 AM, Rick Morrison wrote: