generateSelectSQL method

FutureOr<SQL> generateSelectSQL(
  1. Transaction transaction,
  2. String entityName,
  3. String table,
  4. EntityMatcher matcher, {
  5. Object? parameters,
  6. List? positionalParameters,
  7. Map<String, Object?>? namedParameters,
  8. int? limit,
  9. int? offset,
  10. bool? orderByID,
  11. OrderDirection? orderDirection,
})

Implementation

FutureOr<SQL> generateSelectSQL(
  Transaction transaction,
  String entityName,
  String table,
  EntityMatcher matcher, {
  Object? parameters,
  List? positionalParameters,
  Map<String, Object?>? namedParameters,
  int? limit,
  int? offset,
  bool? orderByID,
  OrderDirection? orderDirection,
}) {
  return _generateSQLFrom(
    transaction,
    entityName,
    table,
    matcher,
    parameters: parameters,
    positionalParameters: positionalParameters,
    namedParameters: namedParameters,
    limit: limit,
    offset: offset,
    orderByID: orderByID,
    orderDirection: orderDirection,
    sqlBuilder: (String from, EncodingContext context) {
      var tableAlias = context.resolveEntityAlias(table);
      var q = dialect.elementQuote;
      var tail = _generateSelectTailSQL(
        context,
        tableAlias,
        limit: limit,
        offset: offset,
        orderByID: orderByID,
        orderDirection: orderDirection,
      );
      var sql = 'SELECT $q$tableAlias$q.* $from$tail';
      return sql;
    },
  );
}