[sqlalchemy] RETURNING clause on Insert (Oracle sequences)

2008-09-18 Thread GHZ
Hi, Is there a reason why this is not used to return the id column value? Would cut down on the number of roundtrips for insert statements e.g. insert into bob (id) values (bob_sq.nextval) returning id into :id rather than what seems to be happening at the moment: select bob_sq.nextval from

[sqlalchemy] setting table and mapper arguments with Declarative

2008-09-18 Thread GHZ
I want to set table, mapper arguments automatically. The following is the only way I have found to do this. Is this supported? Am I wasting my time with Declarative and should rather use the non declarative if I want this control? class MyMeta(DeclarativeMeta): def __new__(meta, classname,

[sqlalchemy] Re: RETURNING clause on Insert (Oracle sequences)

2008-09-18 Thread Michael Bayer
On Sep 18, 2008, at 4:53 AM, GHZ wrote: Hi, Is there a reason why this is not used to return the id column value? Would cut down on the number of roundtrips for insert statements e.g. insert into bob (id) values (bob_sq.nextval) returning id into :id rather than what seems to be

[sqlalchemy] Re: How to mark an attribute dirty manually?

2008-09-18 Thread Michael Bayer
On Sep 18, 2008, at 5:46 AM, Adam Dziendziel wrote: Hi, I have a column which contains XML, this XML is parsed when a record is loaded and object attributes are populated with values from this XML. When I set an attribute, I would like to mark the XML column modified (in property()

[sqlalchemy] Oracle Express fails 0.5 ORM tutorial

2008-09-18 Thread Bruce Smith
Hello I have Oracle Express Release 10.2.0.1.0, SQLAlchemy 0.4.5, Python 2.5.2 on Ubuntu x86 8.04. When I go through the ORM tutorial at http://www.sqlalchemy.org/docs/04/ormtutorial.html it fails at the first query below the heading *Saving Objects* with an Oracle ORA-01400 error as follows:

[sqlalchemy] Re: Problem using utf-8

2008-09-18 Thread Jürgen Hauptmann
Thank you. Switching to 1.2.2 and using connect_args = {'use_unicode': False,'charset': 'utf8'} works fine for me. Jürgen Michael Bayer schrieb: I believe this is the ticket: http://sourceforge.net/tracker/index.php?func=detailaid=1592353group_id=22307atid=374932 its a little ambiguous as

[sqlalchemy] Re: grandparent id relation

2008-09-18 Thread Michael Bayer
On Sep 18, 2008, at 6:27 AM, GHZ wrote: Hi, I have a database table : 'Child' that contains the parent_id and grandparent_id. Foreign keys are present for both. I'm using declarative What is best practice to have the grandparent_id column set correctly when I insert? class

[sqlalchemy] Re: Oracle Express fails 0.5 ORM tutorial

2008-09-18 Thread Michael Bayer
On Sep 18, 2008, at 8:06 AM, Bruce Smith wrote: Hello I have Oracle Express Release 10.2.0.1.0, SQLAlchemy 0.4.5, Python 2.5.2 on Ubuntu x86 8.04. When I go through the ORM tutorial at http://www.sqlalchemy.org/docs/04/ormtutorial.html it fails at the first query below the heading

[sqlalchemy] Re: How to mark an attribute dirty manually?

2008-09-18 Thread Adam Dziendziel
This description was very hard to parse, but I think what you're   saying is an attribute changes on a *different* object somewhere,   which you would like to mark the XML-holding object as dirty. Sorry. The same object, but these attributes are pure Python attributes, they aren't mapped to

[sqlalchemy] Re: Problem using utf-8

2008-09-18 Thread Bo Shi
Switching to 1.2.2 and using connect_args = {'use_unicode': False,'charset': 'utf8'} works fine for me. Hi Jürgen, I'm curious; if you upgraded to 1.2.2, does the issue persist if you stop using connect_args = {'use_unicode': False,'charset': 'utf8'}? Bo On Thu, Sep 18, 2008 at 3:07 AM,

[sqlalchemy] Re: RETURNING clause on Insert (Oracle sequences)

2008-09-18 Thread GHZ
Thank you Michael, I found the changeset adding this to Postgresql. Will look into a similar change for Oracle. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: Problem with coverage and sqlalchemy declarative synonym?

2008-09-18 Thread Doug Latornell
With some help from Ned Batchelder I was able to confirm that this is a Python bug: http://bugs.python.org/issue1569356 that has been fixed since the 2.5.2 release. Ned confirmed that the fix is included in Python 2.6a3. Doug On Sep 16, 5:22 pm, Doug Latornell [EMAIL PROTECTED] wrote: Thanks

[sqlalchemy] Re: Oracle Express fails 0.5 ORM tutorial

2008-09-18 Thread Bruce Smith
Thanks Michael, that works neatly. - Bruce On Fri, Sep 19, 2008 at 12:03 AM, Michael Bayer [EMAIL PROTECTED]wrote: On Sep 18, 2008, at 8:06 AM, Bruce Smith wrote: Hello I have Oracle Express Release 10.2.0.1.0, SQLAlchemy 0.4.5, Python 2.5.2 on Ubuntu x86 8.04. When I go through the

[sqlalchemy] Re: any effort getting sqlalchemy to work on ironpython is going on ?

2008-09-18 Thread sakesun
Just try IronPython beta5. And it work now. :D On 12 ก.ย., 10:01, sakesun [EMAIL PROTECTED] wrote: I need sqlalchemy to work on ironpython (1.2 or 2.0b) sqlalchemy fail on ironpython even with simple use case like create simple Table definition. from sqlalchemy import Table, Column,