generateSelectRelationshipsSQL method
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,
);
});
}