[sqlalchemy] ActiveMapper : adding a DB column after a model change

2007-01-07 Thread remi jolin
I have defined a class like class Image(AciveMapper): class mapping: __table__ = image id = column(Integer, primary_key=True) url = column(Unicode(128)) and created the DB according to the model. I have modified the Image class to add a new column class Image(AciveMapper): class

[sqlalchemy] Re: un-deferring columns

2007-01-07 Thread Michael Bayer
there are defer() and undefer() MapperOptions: session.query(Class).options(undefer('somefield')).select() and they even have unit tests so they might actually work... On Jan 7, 2007, at 11:06 AM, Jonathan Ellis wrote: Is there a way to defer or un-defer columns at the query level?

[sqlalchemy] Re: ActiveMapper : adding a DB column after a model change

2007-01-07 Thread Michael Bayer
if youre looking for automated ALTER-style operations, you can take a look at Migrate: http://erosson.com/migrate/trac/ personally for a one-time operation id just go into the console and type an ALTER statement...(or write a script...) On Jan 7, 2007, at 6:32 AM, remi jolin wrote: I

[sqlalchemy] Update on MS-SQL work

2007-01-07 Thread Paul Johnston
Hi, Here's an update on the problems I've been working on. 1) commit issue Ticket #411 raised and the fix has been applied. I am working on a unit test; see below. 2) coinitialize My current feeling is that this is an adodbapi bug, nothing to do with sa. I'll work with them in the first

[sqlalchemy] Re: Update on MS-SQL work

2007-01-07 Thread Paul Johnston
Hi, return adodbapi.connect('Provider=SQLOLEDB;Data Source=.;User Id=pythonweb;Password=mdi*2mdO1;Initial Catalog=test') Ooops! I thought I had just managed to cancel that mail in time :-) Paul --~--~-~--~~~---~--~~ You received this message because you

[sqlalchemy] bitwise operators?

2007-01-07 Thread dykang
Hi, I was wondering if there was any way to write the following query without having to use a text block. select * from table where table.flags 1 = 1 and table.flags 4 = 0 I couldn't find any indication that it would be supported in the docs. The closest I found was the the ability to use

[sqlalchemy] Mapping special child rows

2007-01-07 Thread Jonathan Ellis
Say I have tables corresponding to users and orders from test/tables.py. I have dozens or hundreds of orders per user. I want to show a list of users with their most recent order, but because I have so many orders doing an eager load to orders is a bad solution. Having a manually defined