buildSelectStatement method

JoinedSelectStatement<$Table, $Dataclass> buildSelectStatement({ Iterable<Expression<Object>>? targetColumns, })

Builds a select statement with the given target columns, or all columns if none are provided

Implementation

JoinedSelectStatement<$Table, $Dataclass> buildSelectStatement({
  Iterable<Expression>? targetColumns,
}) {
  final joins = joinBuilders.map((e) => e.buildJoin()).toList();

  JoinedSelectStatement<$Table, $Dataclass> joinedStatement;
  // If we are only selecting specific columns, we can use a selectOnly statement
  if (targetColumns != null) {
    joinedStatement = (db.selectOnly(
      _tableAsTableInfo,
      distinct: distinct ?? false,
    )..addColumns(targetColumns));
    // Add the joins to the statement
    joinedStatement =
        joinedStatement.join(joins)
            as JoinedSelectStatement<$Table, $Dataclass>;
  } else {
    joinedStatement =
        db.select(_tableAsTableInfo, distinct: distinct ?? false).join(joins)
            as JoinedSelectStatement<$Table, $Dataclass>;
  }

  // Add any additional columns/expression that were added
  joinedStatement.addColumns(addedColumns);

  // If there are any added column, then group by primary key and apply filter to it
  // other wise add the filter to the select directly
  if (addedColumns.isNotEmpty) {
    // ignore: invalid_use_of_visible_for_overriding_member
    joinedStatement.groupBy(table.primaryKey!, having: filter);
  } else if (filter != null) {
    joinedStatement.where(filter!);
  }

  // Apply orderings and limits
  joinedStatement.orderBy(
    orderingBuilders.map((e) => e.buildTerm()).toList(),
  );
  if (limit != null) {
    joinedStatement.limit(limit!, offset: offset);
  }

  return joinedStatement;
}