Changing the ActiveRecord mapping of boolean values in the DB?


#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


#2

Thomas Waswasi wrote:

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 ?

Not on the model level, but you could monkey-patch the AR quoting
function.


Roderick van Domburg
http://www.nedforce.nl