Changing the ActiveRecord mapping of boolean values in the DB ?

rubyonrails-talk
1

Hi,

I want to insert some rows into a sqlite3 database where some tables contain BOOLEAN columns.

Some older applications accessing the same DB require boolean columns to be 0 and 1, whereas the default behaviour of the sqlite Adapter is a mapping of true/false values to 't' and 'f' in the database.

My current workaround is a row insert trigger in the database, but I'd rather have this logic in the AR model class.

Is there some way to change the type mapping on model level ?

Thanks and kind regards, Thomas