[sqlalchemy] Re: How to define a column as read-only (e.g. computed by column in Firebird)

2007-11-08 Thread Werner F. Bruhin
Mike, Michael Bayer wrote: > ... > oh sorry, I misread the source code in SA earlier...for an INSERT, we > are going to insert "None" for all columns that are blank but dont > have a default. so your two options here are to put another > PassiveDefault on the column: > > Column(u'consu

[sqlalchemy] Re: How to define a column as read-only (e.g. computed by column in Firebird)

2007-11-07 Thread Michael Bayer
On Nov 7, 2007, at 12:58 PM, Werner F. Bruhin wrote: > > Mike, > > Michael Bayer wrote: >> On Nov 7, 2007, at 12:32 PM, Werner F. Bruhin wrote: >> >> >>> Can you point out what I did wrong, please. >>> >>> >> >> id have to see a larger example, seems like something is marking the >> column as mo

[sqlalchemy] Re: How to define a column as read-only (e.g. computed by column in Firebird)

2007-11-07 Thread Werner F. Bruhin
Mike, Michael Bayer wrote: > On Nov 7, 2007, at 12:32 PM, Werner F. Bruhin wrote: > > >> Can you point out what I did wrong, please. >> >> > > id have to see a larger example, seems like something is marking the > column as modified when it should not be. > I put a little test case t

[sqlalchemy] Re: How to define a column as read-only (e.g. computed by column in Firebird)

2007-11-07 Thread Michael Bayer
On Nov 7, 2007, at 12:32 PM, Werner F. Bruhin wrote: > > > Can you point out what I did wrong, please. > id have to see a larger example, seems like something is marking the column as modified when it should not be. --~--~-~--~~~---~--~~ You received this mess

[sqlalchemy] Re: How to define a column as read-only (e.g. computed by column in Firebird)

2007-11-07 Thread Werner F. Bruhin
Mike, Michael Bayer wrote: > On Nov 7, 2007, at 10:23 AM, Werner F. Bruhin wrote: > > >> How can I define a column in the table as read-only? >> >> I have some "computed by" columns, e.g.: >> consumedvalue computed by (quantity*unitprice) >> >> These columns can not be updated, otherwise I ge

[sqlalchemy] Re: How to define a column as read-only (e.g. computed by column in Firebird)

2007-11-07 Thread Michael Bayer
On Nov 7, 2007, at 10:23 AM, Werner F. Bruhin wrote: > > How can I define a column in the table as read-only? > > I have some "computed by" columns, e.g.: > consumedvalue computed by (quantity*unitprice) > > These columns can not be updated, otherwise I get the following > exception: > Progra