toList method

Future<List> toList(QueryParams params)

Implementation

Future<List> toList(QueryParams params) async {
  final Database db = (await this.db)!;
  final result = await db.query(_tableName!,
      columns: params.selectColumns,
      where: params.whereString,
      whereArgs: params.whereArguments,
      orderBy: params.orderBy == '' ? null : params.orderBy,
      groupBy: params.groupBy == '' ? null : params.groupBy,
      having: params.having == '' ? null : params.having,
      limit: params.limit == 0 ? null : params.limit,
      offset: params.offset == 0 ? null : params.offset,
      distinct: params.distinct);
  // print('\r\n');
  // print('\r\n');

  // You can uncomment following print command for print when called db query with parameters automatically
  /*
  print('********** SqfEntityProvider.toList(QueryParams=> columns:' +
      (params.selectColumns != null ? params.selectColumns.toString() : '*') +
      ', whereString: ' +
      (params.whereString != null ? params.whereString : 'null') +
      ', whereArgs:' +
      (params.whereArguments != null
          ? params.whereArguments.toString()
          : 'null') +
      ', orderBy:' +
      (params.orderBy != '' ? params.orderBy : 'null') +
      ', groupBy:' +
      (params.groupBy != '' ? params.groupBy : 'null') +
      ')');
      */

  return result;
}