generateSelectRelationshipsSQL method

FutureOr<SQL> generateSelectRelationshipsSQL(
  1. Transaction transaction,
  2. String entityName,
  3. String table,
  4. String field,
  5. List ids,
  6. String otherTableName,
)

Implementation

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

    var q = dialect.elementQuote;

    var conditionSQL = StringBuffer(
      '$q${relationship.sourceRelationshipField}$q IN (',
    );

    var parameters = <String, dynamic>{};
    for (var i = 0; i < ids.length; ++i) {
      var p = 'p$i';
      var id = ids[i];
      parameters[p] = id;
      if (i > 0) conditionSQL.write(', ');
      conditionSQL.write('@$p');
    }

    conditionSQL.write(') ');

    var conditionSQLStr = conditionSQL.toString();

    var condition = KeyConditionIN([
      ConditionKeyField(relationship.sourceRelationshipField),
    ], ids);

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