getCountBy abstract method

  1. @Query.new('''SELECT count(*) FROM Product WHERE (0 = :catagoryId or catagory_id = :catagoryId) and (0 = :typeId or type_id = :typeId) and (0 = :measureUnitId or measure_unit_id = :measureUnitId) and status = 1''')
Future<int?> getCountBy(
  1. int catagoryId,
  2. int typeId,
  3. int measureUnitId
)

Implementation

@Query('''SELECT count(*) FROM Product WHERE
     (0 = :catagoryId or catagory_id = :catagoryId) and
     (0 = :typeId or type_id = :typeId) and
     (0 = :measureUnitId or measure_unit_id = :measureUnitId) and
     status = 1''')
Future<int?> getCountBy(int catagoryId, int typeId, int measureUnitId);