Hi!
I have reflected my table from the db (Postgresql 8.4.2, tried psyco
2.0.12 and 2.0.14) using
Table(name, metadata, autoload=True, autoload_with=engine)
After that I map the table.
When later in my app, I try to access the default values from the DB,
I use
the columnproperty:
from owconf.model import Participation
from rumalchemy.util import get_mapper
prop = get_mapper(Participation).get_property('remark')
prop
<sqlalchemy.orm.properties.ColumnProperty object at 0xac5dcec>
c=prop.columns[0]
repr(c.default)
repr(c.server_default)
prop = get_mapper(Participation).get_property('number_of_companions')
This is the reflection of a simple text field:
remark | text | not null default ''::text
In former times, I used
prop.server_default to find out, that there is an default of ''.
This does not exist any more at that place, so I have inspected the
property:
c=prop.columns[0]
repr(c.default)
-> None
repr(c.server_default)
-> None
The same occurs with integer fields like that:
number_of_companions | integer | not null default 0
Which is now the proper way to find out the right default for the
column?
The functionality is very useful for the RUM CRUD application.
http://python-rum.org/
Cheers,
Michael
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
