Querying boolean property returns as int about couchbase_lite HOT 7 CLOSED

I found this, is it related?

from couchbase_lite.

I'm not sure on how everything is done behind the scenes but I do know that SQLite is used to store information and SQLite does not have boolean types instead it uses 0's and 1's.

from couchbase_lite.

So you're saying this is expected behavior? so why is there setBoolean on MutableDocument if it doesn't support boolean data type

from couchbase_lite.

I'm sure its mostly because there is not an easy solution to differentiate between boolean and int values in SQLite / maybe C or C# depending on where the value is being stored. Refer to this documentation on the method getBoolean for a way to parse the value https://pub.dev/documentation/couchbase_lite/latest/couchbase_lite/Document-class.html

from couchbase_lite.

@bawelter how do I cast a Result to Document? since QueryBuilder.execute() results ResultSet

from couchbase_lite.

@bawelter how do I cast a Result to Document? since QueryBuilder.execute() results ResultSet

Please reference the documentation https://pub.dev/documentation/couchbase_lite/latest/couchbase_lite/Database-class.html for retrieving a Document object and https://pub.dev/documentation/couchbase_lite/latest/couchbase_lite/Result-class.html for using the getBoolean function on a result set. Please refer to the documentation before posting questions here.

from couchbase_lite.

I use https://pub.dev/packages/built_value to model the data. Hopefully this helps.

from couchbase_lite.