agrosner/DBFlow

Cast Example

apsoftware-andyp opened this issue · 0 comments

ISSUE_TEMPLATE

DBFlow Version: 3.1.1

Bug or Feature Request:

Description:
I have a fairly complex query I'm trying to port to DBFlow semantics. The biggest hurdle I've had is trying to figure out the syntax for a query piece that looks essentially like this:

SELECT Message.X, Message.Y, Message.Z, CASE WHEN CAST(Conversation.Bookmark AS LONG) <= 0 THEN false ELSE true END isBookmarkAvailable

I can get part way there with the syntax
IProperty foo = Method.cast(Conversation_Table.Bookmark).as(SQLiteType.INTEGER); but I cannot do a comparison "<= 0" on the IProperty.