Operation
Definição da configuração do objeto Operation para operações em base de dados.
all
all() : java.util.List<Values>
Description
Returns all records resulting from query execution, if none, returns an empty list.
Return
( java.util.List )
List of records.
count
count() : int
Return
( int )
debug
debug(enabled: boolean) : Operation
Description
Defines whether debug is active or not in the query.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| enabled | boolean | Whether the debug is active or not. |
Return
( Operation )
Current Query object.
delete
delete() : Values
Return
( Values )
delete(forms: string[]) : Values
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| forms | string[] |
Return
( Values )
distinct
distinct(enabled: boolean) : Operation
Description
Defines whether the DISTINCT command will be applied to the query.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| enabled | boolean | Whether it will be applied or not. |
Return
( Operation )
Current Query object.
first
first() : Values
Description
Returns the first record resulting from the query execution, if none, returns null.
Return
( Values )
First record of the result.
get
get(column: string) : Operation
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| column | string |
Return
( Operation )
get(column: string, alias: string) : Operation
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| column | string | |
| alias | string |
Return
( Operation )
getFieldsToGet
getFieldsToGet() : java.util.List<org.netuno.tritao.db.form.Field>
Description
Returns the fields that will be obtained in the query
Return
( java.util.List )
The fields that will be obtained in the query
getFieldsToSet
getFieldsToSet() : java.util.List<org.netuno.tritao.db.form.Field>
Return
( java.util.List )
getFormName
getFormName() : string
Description
Returns the name of the query's main table.
Return
( string )
The name of the query's main table.
getGroup
getGroup() : Group
Description
Returns the query grouping object.
Return
( Group )
The query grouping object.
getJoin
getJoin() : Values | DataSchema | java.util.Map
Description
Returns the Join objects (related tables) referring to the main table of the query.
Return
( java.util.Map )
The Join objects (related tables) referring to the main table of the query.
getLimit
getLimit() : int
Return
( int )
getOrder
getOrder() : Order
Description
Returns the query ordering object.
Return
( Order )
The query ordering object.
getPagination
getPagination() : org.netuno.tritao.db.form.pagination.Pagination
Description
Returns the pagination configuration object (if any) of the query.
Return
( org.netuno.tritao.db.form.pagination.Pagination )
The pagination configuration object (if any) of the query.
getTablesToPopulate
getTablesToPopulate() : java.util.List<org.netuno.tritao.db.form.populate.Populate>
Return
( java.util.List )
getWhere
getWhere() : Where
Description
Returns the Where object referring to the main table of the query.
Return
( Where )
Where object of the query's main table.
group
group(order: string[]) : Operation
Description
Defines the query grouping object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| order | string[] | The query grouping object. |
Return
( Operation )
Current Query object.
group(order: string) : Operation
Description
Defines the query grouping object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| order | string | The query grouping object. |
Return
( Operation )
Current Query object.
insert
insert() : Values
Return
( Values )
insertAndReturn
insertAndReturn() : Values
Return
( Values )
isDebug
isDebug() : boolean
Description
Returns whether debug is active or not in the query.
Return
( boolean )
Whether debug is active or not in the query.
isDistinct
isDistinct() : boolean
Description
Returns whether the DISTINCT command will be applied to the query.
Return
( boolean )
Whether it will be applied or not.
join
join(relation: Relationship) : Operation
Description
Defines an INNER JOIN relationship with a table.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| relation | Relationship | INNER JOIN type relationship. |
Return
( Operation )
Current Query object.
leftJoin
leftJoin(relation: Relationship) : Operation
Description
Defines an LEFT JOIN relationship with a table.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| relation | Relationship | LEFT JOIN type relationship. |
Return
( Operation )
Current Query object.
limit
limit(limit: int) : Operation
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| limit | int |
Return
( Operation )
link
link(formLink: string) : Operation
Description
Defines a form to be related to the main table of the query using the Link criteria.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| formLink | string | Form to be related. |
Return
( Operation )
Current Query object.
link(formLink: string, link: Link) : Operation
Description
Defines a form to be related to the main table of the query using the Link criteria.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| formLink | string | Form to be related. |
| link | Link | Link object with a subrelation. |
Return
( Operation )
Current Query object.
link(formLink: string, where: Where) : Operation
Description
Defines a form to be related to the main table of the query using the Link criteria.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| formLink | string | Form to be related. |
| where | Where | Where object with the conditions referring to the form you want to relate. |
Return
( Operation )
Current Query object.
link(formLink: string, where: Where, link: Link) : Operation
Description
Defines a form to be related to the main table of the query using the Link criteria.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| formLink | string | Form to be related. |
| where | Where | Where object with the conditions referring to the form you want to relate. |
| link | Link | Link object with a subrelation. |
Return
( Operation )
Current Query object.
link(formLink: Link) : Operation
Description
Defines a form to be related to the main table of the query using the Link criteria.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| formLink | Link | Form to be related. |
Return
( Operation )
Current Query object.
order
order(column: string, order: string) : Operation
Description
Defines the ordering of the query.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| column | string | Column for sorting. |
| order | string | Meaning of ordering. |
Return
( Operation )
Current Query object.
page
page(page: int, size: int) : Values
Description
Returns Page with the items resulting from executing the query in a paged form and other pagination data.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| page | int | Records page number. |
| size | int | Number of records per page. |
Return
( Values )
Page with items and other pagination data.
page(pagination: org.netuno.tritao.db.form.pagination.Pagination) : Values
Description
Returns Page with the items resulting from executing the query in a paged form and other pagination data.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| pagination | org.netuno.tritao.db.form.pagination.Pagination | Pagination object with pagination settings. |
Return
( Values )
Page with items and other pagination data.
populate
populate(table: string, filter: org.netuno.tritao.db.form.Field) : Operation
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| table | string | |
| filter | org.netuno.tritao.db.form.Field |
Return
( Operation )
populate(table: string, filter: org.netuno.tritao.db.form.Field, fields: java.util.List<org.netuno.tritao.db.form.Field>) : Operation
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| table | string | |
| filter | org.netuno.tritao.db.form.Field | |
| fields | java.util.List |
Return
( Operation )
rightJoin
rightJoin(relation: Relationship) : Operation
Description
Defines an RIGHT JOIN relationship with a table.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| relation | Relationship | RIGHT JOIN type relationship. |
Return
( Operation )
Current Query object.
set
set(column: string, value: java.lang.Object) : Operation
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| column | string | |
| value | java.lang.Object |
Return
( Operation )
setDebug
setDebug(enabled: boolean) : Operation
Description
Defines whether debug is active or not in the query.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| enabled | boolean | Whether the debug is active or not. |
Return
( Operation )
Current Query object.
setDistinct
setDistinct(enabled: boolean) : Operation
Description
Defines whether the DISTINCT command will be applied to the query.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| enabled | boolean | Whether it will be applied or not. |
Return
( Operation )
Current Query object.
setFieldsToGet
setFieldsToGet(fields: java.util.List<org.netuno.tritao.db.form.Field>) : Operation
Description
Defines the fields that will be obtained in the query
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| fields | java.util.List | The fields that will be obtained in the query. |
Return
( Operation )
Current Query object.
setFieldsToSet
setFieldsToSet(fieldsToSet: java.util.List<org.netuno.tritao.db.form.Field>) : Operation
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| fieldsToSet | java.util.List |
Return
( Operation )
setFormName
setFormName(tableName: string) : Operation
Description
Defines the name of the query's main table.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| tableName | string | The name of the query's main table. |
Return
( Operation )
Current Query object.
setGroup
setGroup(order: Group) : Operation
Description
Defines the query grouping object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| order | Group | The query grouping object. |
Return
( Operation )
Current Query object.
setJoin
setJoin(join: Values | DataSchema | java.util.Map) : Operation
Description
Defines the Join objects (related tables) referring to the main table of the query.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| join | java.util.Map | The Join objects (related tables) referring to the main table of the query. |
Return
( Operation )
Current Query object.
setLimit
setLimit(limit: int) : Operation
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| limit | int |
Return
( Operation )
setOrder
setOrder(order: Order) : Operation
Description
Defines the query ordering object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| order | Order | The query ordering object. |
Return
( Operation )
Current Query object.
setPagination
setPagination(pagination: org.netuno.tritao.db.form.pagination.Pagination) : Operation
Description
Defines the pagination configuration object (if any) of the query.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| pagination | org.netuno.tritao.db.form.pagination.Pagination | the pagination configuration object of the query. |
Return
( Operation )
Current Query object.
setTablesToPopulate
setTablesToPopulate(tablesToPopulate: java.util.List<org.netuno.tritao.db.form.populate.Populate>) : Operation
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| tablesToPopulate | java.util.List |
Return
( Operation )
setWhere
setWhere(where: Where) : Operation
Description
Defines the Where object referring to the main table of the query.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| where | Where | Where object of the query's main table. |
Return
( Operation )
Current Query object.
update
update() : Values
Return
( Values )
where
where(where: Where) : Operation
Description
Defines the Where object referring to the main table of the query.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| where | Where | Where object of the query's main table. |
Return
( Operation )
Current Query object.