Relation
Definição da configuração do objeto Relation para configurar relacionamentos entre tabelas com Join.
getColumn
getColumn() : string
Description
Returns the name of the column that will be used in the relationship.
Return
( string )
The name of the column.
getSubRelations
getSubRelations() : Config | Exec | Header | Req | Res | Values | DataSchema
Description
Returns the sub relationships of the current object.
Return
( Config | Exec | Header | Req | Res | Values | DataSchema )
The sub relationships
getTableName
getTableName() : string
Description
Returns the name of the table to be related.
Return
( string )
The name of the table.
getType
getType() : org.netuno.tritao.query.join.RelationType
Description
Returns the type of the relationship.
Return
( org.netuno.tritao.query.join.RelationType )
The type of the relationship.
getWhere
getWhere() : Where
Description
Returns the filter settings.
Return
( Where )
The filter settings.
join
join(relation: Relation) : Relation
Description
Defines a second level of INNER JOIN relationship on the current object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| relation | Relation | Second level INNER JOIN relationship. |
Return
( Relation )
Current Relation object.
leftJoin
leftJoin(relation: Relation) : Relation
Description
Defines a second level of LEFT JOIN relationship on the current object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| relation | Relation | Second level LEFT JOIN relationship. |
Return
( Relation )
Current Relation object.
rightJoin
rightJoin(relation: Relation) : Relation
Description
Defines a second level of RIGHT JOIN relationship on the current object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| relation | Relation | Second level RIGHT JOIN relationship. |
Return
( Relation )
Current Relation object.
setColumn
setColumn(column: string) : Relation
Description
Defines the name of the column that will be used in the relationship.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| column | string | The name of the column |
Return
( Relation )
Current Relation object.
setSubRelations
setSubRelations(subRelations: Config | Exec | Header | Req | Res | Values | DataSchema) : Relation
Description
Defines the sub relationships of the current object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| subRelations | Config | Exec | Header | Req | Res | Values | DataSchema | the sub relationships. |
Return
( Relation )
Current Relation object.
setTableName
setTableName(tableName: string) : Relation
Description
Defines the name of the table to be related.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| tableName | string | The name of the table |
Return
( Relation )
Current Relation object.
setType
setType(type: org.netuno.tritao.query.join.RelationType) : Relation
Description
Defines the type of the relationship.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| type | org.netuno.tritao.query.join.RelationType | The type of the relationship. |
Return
( Relation )
Current Relation object.
setWhere
setWhere(where: Where) : Relation
Description
Defines the filter settings.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| where | Where | The filter settings. |
Return
( Relation )
Current Relation object.