Query return type

[tajaouart]

I'm trying to return the number of rows in database but,
query method doesn't accept a String, int or Object as a return type other than my entities ??

ex:
@ Query('SELECT COUNT(id) FROM Question')
Future < String > getNumberOfQuestions();

Error:

NoSuchMethodError: The getter 'constructor' was called on null.
Receiver: null
Tried calling: constructor
[INFO] Running build completed, took 10.6s

[INFO] Caching finalized dependency graph...
[INFO] Caching finalized dependency graph completed, took 77ms

[SEVERE] Failed after 10.6s
pub finished with exit code 1

[vitusortner]

As of now, returning integers is not supported but we're working on something here #361.

[LuckyJayce]

I think the return value will be more general if it can support the definition of map，and it will deal with the situation of multiple columns

@Query('SELECT COUNT(id) FROM Question')
Future<Map<String, dynamic>> getNumberOfQuestions();

[vitusortner]

This is already possible by using your database's database property. It gives access to the underlying SQLite (sqflite) database. https://github.com/vitusortner/floor/blob/1db7738395502ca06a0adabb8943e0750c01fd4d/floor/lib/src/database.dart#L14

[alectogeek]

This is already possible by using your database's database property. It gives access to the underlying SQLite (sqflite) database.

Yes, but only as a future. Sometimes it's useful to get COUNT() as Stream

[mqus]

This is more or less the same issue as #200 so I'll close this as a duplicate of it. Please be sure to subscribe/enable notifications there to keep tabs on this feature.