Search code examples
perlormperl-moduledbix-class

How does DBIx::Class handle boolean values?


I'm using DBIx::Class in my perl script to interact with a sqlite database.

When doing inserts/searches, what will DBIx::Class consider 'true' and 'false'?

eg:

$schema->resultset('SomeObject')->create({ some_boolean => 1, primary_key => 1 });

$schema->resultset('SomeObject')->search({ some_boolean => 'true' });

Any help or documentation is appreciated (I haven't been able to find it in the DBIx::Class docs, but maybe I'm missing something.

Thanks in advance.


Solution

  • http://sqlite.org/datatype3.html says that SQLite doesn't have a boolean datatype but false is stored as integer 0 and true as integer 1.