generateSelectRelationshipSQL method

FutureOr<SQL> generateSelectRelationshipSQL(
  1. Transaction transaction,
  2. String entityName,
  3. String table,
  4. String field,
  5. dynamic id,
  6. String otherTableName,
)

Implementation

FutureOr<SQL> generateSelectRelationshipSQL(
  Transaction transaction,
  String entityName,
  String table,
  String field,
  dynamic id,
  String otherTableName,
) {
  return _requireTableScheme(table).resolveMapped((tableScheme) {
    var relationship = _requireRelationship(
      tableScheme,
      table,
      field,
      otherTableName,
    );

    var parameters = {'source_id': id};

    var q = dialect.elementQuote;

    var conditionSQL =
        '$q${relationship.sourceRelationshipField}$q = @source_id';

    var condition = KeyConditionEQ([
      ConditionKeyField(relationship.sourceRelationshipField),
    ], id);

    return SQL(
      _selectRelationshipSQLText(relationship, conditionSQL),
      null,
      parameters,
      parameters,
      condition: condition,
      sqlCondition: conditionSQL,
      returnColumnsAliases: {
        relationship.sourceRelationshipField: 'source_id',
        relationship.targetRelationshipField: 'target_id',
      },
      mainTable: relationship.relationshipTable,
      relationship: relationship,
    );
  });
}