generateSelectRelationshipSQL method
FutureOr<SQL>
generateSelectRelationshipSQL(
- Transaction transaction,
- String entityName,
- String table,
- String field,
- dynamic id,
- 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,
);
});
}