Hi folks,

I have several tables with string columns (actually they are char[1]
columns) which represent boolean values:

  'S'  means True
  'N'  means False

So, when I do :

>>> customer_table = Table('customer', metadata, autoload=True)
>>> class Cliente(object): pass
>>> c = session.query(Customer).get(999)
>>> c.active
'S'

Where I wished the last sentence has returned True.

Is it possible to change columns type (and representation values) when
mapping my classes ?

I have already tried to do something like:

>>> customer_table = Table('customer', metadata,
>>>     Column('active', Boolean),
>>>     autoload=True)

but have no sucess...  :(


Thanks

Roger

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to