[sqlalchemy] Re: iterate_properties missing in 0.5?

2008-12-12 Thread Jorge Vargas
On Thu, Dec 11, 2008 at 6:21 PM, Michael Bayer wrote: > > > On Dec 11, 2008, at 7:08 PM, Jorge Vargas wrote: > >> >> Hi, has the behavior here >> http://www.sqlalchemy.org/trac/wiki/FAQ#Whatsthebestwaytofigureoutwhichattributesarecolumnsgivenaclass >> changed in 0.5? >> >> I'm trying that and get

[sqlalchemy] Re: Session.merge changing related objects?

2008-12-12 Thread Michael Bayer
I modified the test to run against UnitTest since I dont have nose installed, and all tests pass for me. My version is attached. Make sure you're actually running 0.5 since the test seems to be testing behavior that didn't work in older 0.4 versions of SQLA (although the other tests seem

[sqlalchemy] Session.merge changing related objects?

2008-12-12 Thread Jonathon Anderson
I am experiencing strange behavior in with Session.merge in 0.5.0rc4, where a flush cause merged objects on related entities to change object identity. I think this is a bug, but I might be missing something about Session.merge. (I've never used it before.) My test case can be viewed on pastebin

[sqlalchemy] Re: sqlite: copy from one database to another

2008-12-12 Thread rca
Hi, forced to eating my dogfood after some time and found i need something better, here is the better version -- looks complicated, but i cant see better.. class CommonDatabase(object): def duplicateToDisk(self, target_file): connection = self.engine.connect() #this is in my instance

[sqlalchemy] mssql unit tests how?

2008-12-12 Thread Lukasz Szybalski
Hello, During 0.4.6 I was getting some help on mssql via linux, and it was expressed to me that it would be nice to run unit tests of sqlalchemy on mssql. I've just got new sql server 2005 installed if you guys tell me exactly (copy paste) what do I need to do to run these tests, I will run them.

[sqlalchemy] Re: Variable_TypeByValue(): unhandled data type unicode

2008-12-12 Thread az
it's no good style to expect your input values to be autoconverted somewhere very deep without all the context u may need. > Yes, I'm supplying a value directly from the url which is a text > value as in: > > www.myserver/azienda?id=1 > > I haven't this problem using the postgres adapter because

[sqlalchemy] Re: Variable_TypeByValue(): unhandled data type unicode

2008-12-12 Thread jo
Michael Bayer ha scritto: > On Dec 12, 2008, at 5:19 AM, jo wrote: > > >> Michael Bayer ha scritto: >> >>> Look into using the Unicode type for python unicode values. >>> >>> http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html?highlight=unicode#sqlalchemy.Unicode >>> >>>

[sqlalchemy] Re: Variable_TypeByValue(): unhandled data type unicode

2008-12-12 Thread Michael Bayer
On Dec 12, 2008, at 5:19 AM, jo wrote: > > Michael Bayer ha scritto: >> Look into using the Unicode type for python unicode values. >> >> http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html?highlight=unicode#sqlalchemy.Unicode >> > > This is the 0.5 documentation > I'm using SQLAlch

[sqlalchemy] Re: Variable_TypeByValue(): unhandled data type unicode

2008-12-12 Thread az
On Friday 12 December 2008 12:19:44 jo wrote: > Michael Bayer ha scritto: > > Look into using the Unicode type for python unicode values. > > > > http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html > >?highlight=unicode#sqlalchemy.Unicode > > This is the 0.5 documentation > I'm using

[sqlalchemy] Re: Create tables with metadata

2008-12-12 Thread King Simon-NFHD78
SQLALchemy doesn't (directly) contain functions for altering tables. You may be interested in the sqlalchemy-migrate project: http://code.google.com/p/sqlalchemy-migrate/ The first example on this page shows how to add a column: http://code.google.com/p/sqlalchemy-migrate/wiki/MigrateChange

[sqlalchemy] Re: Variable_TypeByValue(): unhandled data type unicode

2008-12-12 Thread jo
Michael Bayer ha scritto: > Look into using the Unicode type for python unicode values. > > http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html?highlight=unicode#sqlalchemy.Unicode > This is the 0.5 documentation I'm using SQLAlchemy version 0.3.10. and cx_Oracle 4.3.1 Seems cx_

[sqlalchemy] Re: Unstable results using lambda function

2008-12-12 Thread az
the code u've given is quite incomplete. i couldnt get it to work with responses.join(presentations), so i put just responses, and added property presentation=relation(Presentation) and it returns same results. try just executing whole querycount() by hand twice without all the funcs, and