Impossible to return int value from COUNT(*) #200

alectogeek · 2019-10-01T15:50:34Z

`[INFO] Generating build script...
[INFO] Generating build script completed, took 409ms

[INFO] Initializing inputs
[INFO] Reading cached asset graph...
[INFO] Reading cached asset graph completed, took 151ms

[INFO] Checking for updates since last build...
[INFO] Checking for updates since last build completed, took 1.1s

[INFO] Running build...
[INFO] 1.1s elapsed, 0/16 actions completed.
[INFO] 2.1s elapsed, 0/16 actions completed.
[INFO] 3.2s elapsed, 0/16 actions completed.
[INFO] 4.3s elapsed, 0/16 actions completed.
[INFO] 12.5s elapsed, 1/16 actions completed.
[SEVERE] floor_generator:floor_generator on lib/data/db_configs/AppDatabase.dart:
Error running FloorGenerator
NoSuchMethodError: The getter 'name' was called on null.
Receiver: null
Tried calling: name
[INFO] Running build completed, took 13.6s

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

[SEVERE] Failed after 13.8s
pub finished with exit code 1
iMac-Tim:learnlanguage-mobile alectogeek$ flutter packages pub run build_runner build --delete-conflicting-outputs
[INFO] Generating build script...
[INFO] Generating build script completed, took 408ms

[INFO] Initializing inputs
[INFO] Reading cached asset graph...
[INFO] Reading cached asset graph completed, took 125ms

[INFO] Checking for updates since last build...
[INFO] Checking for updates since last build completed, took 1.1s

[INFO] Running build...
[INFO] 1.1s elapsed, 0/16 actions completed.
[INFO] 2.1s elapsed, 0/16 actions completed.
[INFO] 3.2s elapsed, 0/16 actions completed.
[INFO] 4.3s elapsed, 0/16 actions completed.
[INFO] 12.2s elapsed, 1/16 actions completed.
[SEVERE] floor_generator:floor_generator on lib/data/db_configs/AppDatabase.dart:
Error running FloorGenerator
NoSuchMethodError: The getter 'name' was called on null.
Receiver: null
Tried calling: name
[INFO] Running build completed, took 13.4s

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

[SEVERE] Failed after 13.5s
pub finished with exit code 1
iMac-Tim:learnlanguage-mobile alectogeek$ flutter packages pub run build_runner build --delete-conflicting-outputs --help
[INFO] Generating build script...
[INFO] Generating build script completed, took 419ms

Performs a single build on the specified targets and then exits.

Usage: build_runner build [arguments] [directories]
-h, --help Print this usage information.
--delete-conflicting-outputs By default, the user will be prompted to
delete any files which already exist but
were not known to be generated by this
specific build script.

                                Enabling this option skips the prompt and
                                deletes the files. This should typically be
                                used in continues integration servers and
                                tests, but not otherwise.

--low-resources-mode            Reduce the amount of memory consumed by the
                                build process. This will slow down builds
                                but allow them to progress in resource
                                constrained environments.

-c, --config Read build.<name>.yaml instead of the
default build.yaml

--[no-]track-performance        Enables performance tracking and the /$perf
                                page.

--log-performance               A directory to write performance logs to,
                                must be in the current package. Implies
                                `--track-performance`.

-o, --output A directory to copy the fully built package
to. Or a mapping from a top-level directory
in the package to the directory to write a
filtered build output to. For example
"web:deploy".

-v, --verbose Enables verbose logging.
-r, --[no-]release Build with release mode defaults for
builders.

--define                        Sets the global `options` config for a
                                builder by key.

--[no-]symlink                  Symlink files in the output directories,
                                instead of copying.

--build-filter                  An explicit filter of files to build.
                                Relative paths and `package:` uris are
                                supported, including glob syntax for paths
                                portions (but not package names).
                                
                                If multiple filters are applied then outputs
                                matching any filter will be built (they do
                                not need to match all filters).

Run "build_runner help" to see global options.
iMac-Tim:learnlanguage-mobile alectogeek$ flutter packages pub run build_runner build --delete-conflicting-outputs --verbose
[INFO] Generating build script...
[INFO] Generating build script completed, took 411ms

[INFO] BuildDefinition:Initializing inputs
[INFO] BuildDefinition:Reading cached asset graph...
[INFO] BuildDefinition:Reading cached asset graph completed, took 129ms

[INFO] BuildDefinition:Checking for updates since last build...
[INFO] BuildDefinition:Checking for updates since last build completed, took 1.1s

[INFO] Build:Running build...
[INFO] Heartbeat:1.1s elapsed, 0/16 actions completed.
[INFO] Heartbeat:2.2s elapsed, 0/16 actions completed.
[INFO] Heartbeat:3.2s elapsed, 0/16 actions completed.
[INFO] Heartbeat:4.3s elapsed, 0/16 actions completed.
[FINE] floor_generator:floor_generator on test/widget_test.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/subcategory_page/subcategory_page_bloc.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/subcategory_page/subcateegory_page_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/section_description_page/categories_grid_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/section_description_page/section_description_page_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/home_page/home_page_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/home_page/home_page_bloc.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/home_page/categories_footer.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/home_page/alphabet_footer.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_testing_page/alphabet_testing_page_bloc.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_testing_page/task_views/draw_letter_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_testing_page/task_views/testing_letter_result_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_testing_page/alphabet_testing_page_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_description_page/alphabet_description_page_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_description_page/alphabet_description_page_bloc.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/section_description_page/section_description_page_bloc.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/words_learning_page/task_views/picture_choice_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/words_learning_page/task_views/acquaintance_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/words_learning_page/task_views/build_word_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/words_learning_page/task_views/word_memorized_confirmation.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/words_learning_page/task_views/translation_choice_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/words_learning_page/words_learning_page_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/words_learning_page/words_learning_page_bloc.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_learning_page/task_views/letter_acquaintance_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_learning_page/task_views/draw_letter_task_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_learning_page/task_views/letter_memorized_confirmation.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_learning_page/alphabet_learning_page_bloc.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/alphabet_learning_page/alphabet_learning_page_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/testing_page/testing_result_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/testing_page/testing_page_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/testing_page/testing_page_bloc.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/ui/testing_page/testing_translation_choice_view.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/main.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/injection/injector.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/data/repository/study_data_repository.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/data/dao/study/section_dao.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/data/db_configs/AppDatabase.dart:Running FloorGenerator
[SEVERE] floor_generator:floor_generator on lib/data/db_configs/AppDatabase.dart:
Error running FloorGenerator
NoSuchMethodError: The getter 'name' was called on null.
Receiver: null
Tried calling: name
dart:core Object.noSuchMethod
package:floor_generator/writer/query_method_writer.dart 66:57 QueryMethodWriter._generateMethodBody
package:floor_generator/writer/query_method_writer.dart 28:21 QueryMethodWriter._generateQueryMethod
package:floor_generator/writer/query_method_writer.dart 19:12 QueryMethodWriter.write
package:floor_generator/writer/dao_writer.dart 217:52 DaoWriter._generateQueryMethods.
dart:_internal ListIterable.toList
package:floor_generator/writer/dao_writer.dart 218:10 DaoWriter._generateQueryMethods
package:floor_generator/writer/dao_writer.dart 165:24 DaoWriter.write
package:floor_generator/generator.dart 30:64 FloorGenerator.generateForAnnotatedElement.
dart:core List.addAll
package:built_collection/src/list/list_builder.dart 106:14 ListBuilder.addAll
package:floor_generator/generator.dart 36:14 FloorGenerator.generateForAnnotatedElement.
package:code_builder/src/specs/library.g.dart 108:33 _$LibraryBuilder.update
package:code_builder/src/specs/library.g.dart 26:30 new _$Library
package:floor_generator/generator.dart 32:21 FloorGenerator.generateForAnnotatedElement
package:source_gen/src/generator_for_annotation.dart 47:30 GeneratorForAnnotation.generate
package:source_gen/src/builder.dart 280:35 _generate
package:source_gen/src/builder.dart 73:15 _Builder._generateForLibrary
package:source_gen/src/builder.dart 67:11 _Builder.build
package:build runBuilder
package:build_runner_core/src/generate/build_impl.dart 478:19 _SingleBuild._runForInput...
package:build_runner_core/src/generate/performance_tracker.dart 300:15 _NoOpBuilderActionTracker.trackStage
package:build_runner_core/src/generate/build_impl.dart 476:23 _SingleBuild._runForInput..
package:timing/src/timing.dart 222:44 NoOpTimeTracker.track
package:build_runner_core/src/generate/build_impl.dart 434:22 _SingleBuild._runForInput.
package:pool/pool.dart 127:28 Pool.withResource
package:build_runner_core/src/generate/build_impl.dart 430:17 _SingleBuild._runForInput
package:build_runner_core/src/generate/build_impl.dart 378:38 _SingleBuild._runBuilder.
dart:async Future.wait
package:build_runner_core/src/generate/build_impl.dart 377:36 _SingleBuild._runBuilder
dart:async _AsyncAwaitCompleter.start
package:build_runner_core/src/generate/build_impl.dart 375:40 _SingleBuild._runBuilder
package:build_runner_core/src/generate/build_impl.dart 323:20 _SingleBuild._runPhases..
dart:async _completeOnAsyncReturn
package:build_runner_core/src/generate/build_impl.dart _SingleBuild._matchingPrimaryInputs

[FINE] floor_generator:floor_generator on lib/data/service/dictionary_data_service.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/data/service/letters_service.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/data/service/testing_service.dart:Running FloorGenerator
[FINE] floor_generator:floor_generator on lib/data/service/words_learning_service.dart:Running FloorGenerator
[INFO] Build:Running build completed, took 13.6s

[INFO] Build:Caching finalized dependency graph...
[INFO] Build:Caching finalized dependency graph completed, took 113ms

[SEVERE] Build:
Failed after 13.7s
pub finished with exit code 1

#0 throwToolExit (package:flutter_tools/src/base/common.dart:28:3)
#1
#2
#3 #4 #5 #6 #7 #8 #9 #10 #11 #12 #13 #14 #15 #16 #17 #18 #19 pubInteractively (package:flutter_tools/src/dart/pub.dart:191:5)
PackagesPassthroughCommand.runCommand (package:flutter_tools/src/commands/packages.dart:227:11)
FlutterCommand.verifyThenRunCommand (package:flutter_tools/src/runner/flutter_command.dart:490:18)
_asyncThenWrapperHelper. (dart:async-patch/async_patch.dart:71:64)
_rootRunUnary (dart:async/zone.dart:1132:38)
_CustomZone.runUnary (dart:async/zone.dart:1029:19)
_FutureListener.handleValue (dart:async/future_impl.dart:137:18)
Future._propagateToListeners.handleValueCallback (dart:async/future_impl.dart:678:45)
Future._propagateToListeners (dart:async/future_impl.dart:707:32)
Future._completeWithValue (dart:async/future_impl.dart:522:5)
Future._asyncComplete. (dart:async/future_impl.dart:552:7)
_rootRun (dart:async/zone.dart:1124:13)
_CustomZone.run (dart:async/zone.dart:1021:19)
_CustomZone.runGuarded (dart:async/zone.dart:923:7)
_CustomZone.bindCallbackGuarded. (dart:async/zone.dart:963:23)
_microtaskLoop (dart:async/schedule_microtask.dart:41:21)
_startMicrotaskLoop (dart:async/schedule_microtask.dart:50:5)
_runPendingImmediateCallback (dart:isolate-patch/isolate_patch.dart:116:13)
_RawReceivePortImpl._handleMessage (dart:isolate-patch/isolate_patch.dart:173:5)`

The code fails on this part:
`String _generateMethodBody() {
final _methodBody = StringBuffer();

final valueLists = _generateInClauseValueLists();
if (valueLists.isNotEmpty) {
  _methodBody.write(valueLists.join(''));
}

final arguments = _generateArguments();
if (_queryMethod.returnsVoid) {
  _methodBody.write(_generateNoReturnQuery(arguments));
  return _methodBody.toString();
}

final mapper = '_${decapitalize(_queryMethod.entity.name)}Mapper';
if (_queryMethod.returnsStream) {
  _methodBody.write(_generateStreamQuery(arguments, mapper));
} else {
  _methodBody.write(_generateQuery(arguments, mapper));
}

return _methodBody.toString();

}`

My queries:
`@Query('SELECT COUNT(*) FROM word '
'INNER JOIN word_category_join'
'ON word.id=word_category_join.word_id '
'WHERE word_category_join.category_id=('
'SELECT id FROM category '
'WHERE section_id=:sectionId LIMIT 1'
')'
'AND word.status=:status')
Future getSectionWordsCountByStatus(int sectionId, String status);

@query('SELECT COUNT(*) FROM word '
'INNER JOIN word_category_join'
'ON word.id=word_category_join.word_id '
'WHERE word_category_join.category_id=('
'SELECT id FROM category'
'WHERE section_id=:sectionId LIMIT 1'
')')
Future getAllSectionWordsCount(int sectionId);

`

The text was updated successfully, but these errors were encountered:

vitusortner · 2019-10-04T07:12:58Z

You need to define the return type of each DAO functions explicitly.Future is not enough. The fixed version of your query methods can be seen in the following.

@query('SELECT COUNT(*) FROM word '
  'INNER JOIN word_category_join'
  'ON word.id=word_category_join.word_id '
  'WHERE word_category_join.category_id=('
  'SELECT id FROM category '
  'WHERE section_id=:sectionId LIMIT 1'
  ')'
  'AND word.status=:status')
-Future getSectionWordsCountByStatus(int sectionId, String status);
+Future<int> getSectionWordsCountByStatus(int sectionId, String status);

@query('SELECT COUNT(*) FROM word '
  'INNER JOIN word_category_join'
  'ON word.id=word_category_join.word_id '
  'WHERE word_category_join.category_id=('
  'SELECT id FROM category'
  'WHERE section_id=:sectionId LIMIT 1'
  ')')
-Future getAllSectionWordsCount(int sectionId);
+Future<int> getAllSectionWordsCount(int sectionId);

Please report back if that has fixed the problems.

alectogeek · 2019-10-04T10:07:17Z

Oh, excuse me, it was just a typo. I always define types and I have also tried with Future, but always see the following:
[SEVERE] floor_generator:floor_generator on lib/data/db_configs/AppDatabase.dart: Error running FloorGenerator NoSuchMethodError: The getter 'name' was called on null. Receiver: null Tried calling: name
There is a method in the package's source code that tries to get a class name for a mapper and code fails there.
final mapper = '_${decapitalize(_queryMethod.entity.name)}Mapper';

alectogeek · 2019-10-08T16:25:08Z

I guess I've found the cause! I've been trying to execute the raw query exactly in entityDao instead of calling appDatabase.query('sql'). It wasn't obvious to me :)

SergeiMikhailovskii · 2019-10-17T13:38:22Z

I guess I've found the cause! I've been trying to execute the raw query exactly in entityDao instead of calling appDatabase.query('sql'). It wasn't obvious to me :)

Faced with the same situation. Where did you place this line? appDatabase.query('sql'). Thanks in advance!

alectogeek · 2019-10-17T14:22:01Z

I guess I've found the cause! I've been trying to execute the raw query exactly in entityDao instead of calling appDatabase.query('sql'). It wasn't obvious to me :)

Faced with the same situation. Where did you place this line? appDatabase.query('sql'). Thanks in advance!

AppDatabase _appDatabase = await $FloorAppDatabase.databaseBuilder('app_database.db').build(); Map<String, dynamic> anyQuery = await _database.database.rawQuery('your sql', [arguments]);

Hope, it's clear now. If you have any difficulties, feel free to ask!

SergeiMikhailovskii · 2019-10-17T14:31:03Z

@alectogeek , so, I can't create a query with SUM in annotation, as I understand?

alectogeek · 2019-10-17T14:48:56Z

@SergeiMikhailovskii Why not?
let's assume we have a table called 'bill' with fields [id, amount], then:
final int numbersSum = await _database.database.rawQuery('SELECT SUM(amount) FROM bill')['SUM(amount)'];
You just receive a map with needed fields. If you provide an alias in your sql query, you can use that as the key of map instead of 'SUM(amount)'.

Highly recommend you to take a look to autogenerated by floor files in order to understand how it works under the hood

SergeiMikhailovskii · 2019-10-17T15:55:16Z

@alectogeek I understand it. I thought that I can do like @query("SELECT SUM(amount) FROM Steps"
" WHERE date=:_date")

alectogeek · 2019-10-17T16:08:46Z

@SergeiMikhailovskii No, from DAO you can return only that data type, for which dao was created.
But you still can do that by the direct raw query (including using WHERE clause and ":_date" as an argument)

SergeiMikhailovskii · 2019-10-17T16:10:41Z

@alectogeek yes, got it, thanks a lot!

JAICHANGPARK · 2020-03-05T01:55:07Z

I Have some same problem about return value

@Query('SELECT Count(*) FROM User WHERE id = :id')
Future<int> checkDuplicateId(String id);

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

alectogeek · 2020-03-05T08:42:25Z

@JAICHANGPARK Try to implement it using rawQuery, works fine.

AppDatabase _database = await $FloorAppDatabase.databaseBuilder('myDb.db').build();
print(
await _database.database.rawQuery(
'SELECT Count(*) FROM User WHERE id = :id',
<dynamic>[id])).elementAt(0)['COUNT(*)']
)
);

JAICHANGPARK · 2020-03-05T08:45:45Z

@alectogeek Awesome ! Thank you

jaumzera · 2020-03-17T22:14:33Z

I Have some same problem about return value

@Query('SELECT Count(*) FROM User WHERE id = :id')
Future<int> checkDuplicateId(String id);

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

Same issue here. I'm trying to do a simple count as select count(1) from MyTable:

@Query('select count(*) from Product where enabled = 1')
Future<int> count();

``

mqus · 2020-05-05T12:41:58Z

This is not possible right now because floor does not look at the queries to derive the type and also can't output arbitrary types. This will be adressed in #94 and #321 .

cassioseffrin · 2020-08-03T20:33:57Z

It would be nice if the DAO could parse the generic results into primitive types. I understand the current limitations.

As an alternative I think it's possible to create a custom model with primitive type int and parse the result into it instead using raw queries. However it's just a hack!

lavahasif · 2021-09-19T22:46:04Z

@alectogeek

@dao
abstract class Notesdao {
  @Query('SELECT * FROM Notes WHERE id = :id')
  Future<Notes?> findNotesById(int id);

  @Query('SELECT MAX(id) FROM Notes')
  Future<int?> getMaxCount();}

after code generation you can edit like this

 @override
  Future<int?> getMaxCount() async {
//_queryAdapter.queryNoReturn(sql) ====instedad of this
    var list = await database.rawQuery("SELECT max(id) as id FROM Notes");
    return int.parse(list.first["id"].toString());
  }

MrCsabaToth · 2021-12-24T21:55:02Z

Oh boy, I see #361 is abandoned?

liaoxuewei · 2022-04-02T03:44:31Z

I finally took a compromise and now I'm working well with generator:
1. Define an auxiliary entity:
@entity(tableName: "CountVO")
class CountVO {
@PrimaryKey(autoGenerate: true)
int cnt;

CountVO({required this.cnt});
}

2. Define dao function
@query("SELECT COUNT(*) cnt FROM Task WHERE pid=:pid")
Future<CountVO?> countByPid(int pid);

3. Use
CountVO? countVO = await db.taskDao.countByPid(id);
if (countVO != null && countVO.cnt > 0) {
int cnt = countVO.cnt;
return;
}

liaoxuewei · 2022-04-02T03:46:11Z

To add: an auxiliary table CountVO is created, too.

dkaera · 2022-08-10T12:57:04Z

Opened a discussion about the feature that should solve issues like it.

tulioccalazans · 2022-08-10T13:34:21Z

Opened a discussion about the feature that should solve issues like it.

Unfortunately floor doesn't support this yet.

You can do something like what @alectogeek said for count field.

Future<int?> count() async {
    final floor = await AppDatabase.getInstance();
    var result = await floor!.database.rawQuery('SELECT COUNT(*) FROM GameResult');
    return result.first['COUNT(*)'] as int;
  }

dkaera · 2022-08-10T16:31:53Z

Unfortunately floor doesn't support this yet.

Yeah, that's true. My suggestion is to implement that 😁
I can do this after I've finished working on the RawQuery feature.
The example I added in the discussion above demonstrates what the generated code should look like (in the future).

MrCsabaToth · 2023-01-01T05:05:01Z

Version 1.4.0 and 1.4.1 support DAO functions with COUNT queries, such as the one in the DAO docs https://github.com/pinchbv/floor/blob/develop/docs/daos.md#queries:

@Query('SELECT COUNT(id) FROM Person')
Future<int?> getPeopleCount(); // fetch records count
@Query('SELECT name FROM Person')
Future<List<String>> getAllPeopleNames(); // fetch all records from one column

So actually it's possible to return now int?.

dkaera · 2023-01-03T23:40:46Z

@MrCsabaToth yes, that's true
The example project contains a sample for counting the number of records.

dkaera · 2023-01-04T10:28:38Z

Closed since the feature was added in version 1.4.0.

mqus added the feature Request and implementation of a feature (release drafter) label May 5, 2020

mqus mentioned this issue May 5, 2020

Add a query parser #321

Open

9 tasks

mqus mentioned this issue Jun 15, 2020

Integrate sqlparser #361

Closed

23 tasks

mqus linked a pull request Jun 15, 2020 that will close this issue

Integrate sqlparser #361

Closed

23 tasks

mqus mentioned this issue Jul 15, 2020

NoSuchMethodError: The getter 'name' was called on null. Receiver: null Tried calling: name #374

Open

mqus mentioned this issue Jul 23, 2020

can @Query support part attributs? #378

Closed

This was referenced Apr 23, 2021

Query return type #426

Closed

There is support for query only entity id from table? #528

Closed

MrCsabaToth mentioned this issue Nov 10, 2021

Return null on scalar queries such as "Select count(*) from ..." #576

Open

MrCsabaToth mentioned this issue Dec 24, 2021

count statement should return number but it got NULL #625

Closed

MrCsabaToth mentioned this issue Aug 10, 2022

Feature/raw query #517

Draft

dkaera closed this as completed Jan 4, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Impossible to return int value from COUNT(*) #200

Impossible to return int value from COUNT(*) #200

alectogeek commented Oct 1, 2019

vitusortner commented Oct 4, 2019

alectogeek commented Oct 4, 2019

alectogeek commented Oct 8, 2019

SergeiMikhailovskii commented Oct 17, 2019

alectogeek commented Oct 17, 2019

SergeiMikhailovskii commented Oct 17, 2019

alectogeek commented Oct 17, 2019

SergeiMikhailovskii commented Oct 17, 2019

alectogeek commented Oct 17, 2019

SergeiMikhailovskii commented Oct 17, 2019

JAICHANGPARK commented Mar 5, 2020 •

edited

Loading

alectogeek commented Mar 5, 2020

JAICHANGPARK commented Mar 5, 2020

jaumzera commented Mar 17, 2020

mqus commented May 5, 2020

cassioseffrin commented Aug 3, 2020

lavahasif commented Sep 19, 2021 •

edited

Loading

MrCsabaToth commented Dec 24, 2021

liaoxuewei commented Apr 2, 2022

liaoxuewei commented Apr 2, 2022 •

edited

Loading

dkaera commented Aug 10, 2022

tulioccalazans commented Aug 10, 2022

dkaera commented Aug 10, 2022 •

edited

Loading

MrCsabaToth commented Jan 1, 2023

dkaera commented Jan 3, 2023

dkaera commented Jan 4, 2023

Impossible to return int value from COUNT(*) #200

Impossible to return int value from COUNT(*) #200

Comments

alectogeek commented Oct 1, 2019

vitusortner commented Oct 4, 2019

alectogeek commented Oct 4, 2019

alectogeek commented Oct 8, 2019

SergeiMikhailovskii commented Oct 17, 2019

alectogeek commented Oct 17, 2019

SergeiMikhailovskii commented Oct 17, 2019

alectogeek commented Oct 17, 2019

SergeiMikhailovskii commented Oct 17, 2019

alectogeek commented Oct 17, 2019

SergeiMikhailovskii commented Oct 17, 2019

JAICHANGPARK commented Mar 5, 2020 • edited Loading

alectogeek commented Mar 5, 2020

JAICHANGPARK commented Mar 5, 2020

jaumzera commented Mar 17, 2020

mqus commented May 5, 2020

cassioseffrin commented Aug 3, 2020

lavahasif commented Sep 19, 2021 • edited Loading

MrCsabaToth commented Dec 24, 2021

liaoxuewei commented Apr 2, 2022

liaoxuewei commented Apr 2, 2022 • edited Loading

dkaera commented Aug 10, 2022

tulioccalazans commented Aug 10, 2022

dkaera commented Aug 10, 2022 • edited Loading

MrCsabaToth commented Jan 1, 2023

dkaera commented Jan 3, 2023

dkaera commented Jan 4, 2023

JAICHANGPARK commented Mar 5, 2020 •

edited

Loading

lavahasif commented Sep 19, 2021 •

edited

Loading

liaoxuewei commented Apr 2, 2022 •

edited

Loading

dkaera commented Aug 10, 2022 •

edited

Loading