Sequence

Realiza a manipulação de sequências em base de dados.

if (!_db.checkExists().sequence("client", "name")) {
    _db.index().create(
        "client", // Nome da Tabela
        "name" // Nome da Coluna
    ); // O index client_name_idx será criado criado.
}

---

coalesce

---

coalesce(params: java.lang.String[]) : string

Attributes

NAME	TYPE	DESCRIPTION
params	java.lang.String[]

Return

( string )

---

columnDataType

---

columnDataType(data: org.netuno.tritao.com.ComponentData) : Column

Attributes

NAME	TYPE	DESCRIPTION
data	org.netuno.tritao.com.ComponentData

Return

( Column )

---

commandNextValue

---

commandNextValue(sequenceName: string) : string

Attributes

NAME	TYPE	DESCRIPTION
sequenceName	string

Return

( string )

---

concatenation

---

concatenation(param1: string, param2: string) : string

Attributes

NAME	TYPE	DESCRIPTION
param1	string
param2	string

Return

( string )

---

create

---

create(name: string) : Sequence

Attributes

NAME	TYPE	DESCRIPTION
name	string

Return

( Sequence )

---

create(name: string, startWith: int) : Sequence

Attributes

NAME	TYPE	DESCRIPTION
name	string
startWith	int

Return

( Sequence )

---

drop

---

drop(name: string) : Sequence

Attributes

NAME	TYPE	DESCRIPTION
name	string

Return

( Sequence )

---

getBuilder

---

getBuilder() : org.netuno.tritao.db.Builder

Return

( org.netuno.tritao.db.Builder )

---

getCurrentValue

---

getCurrentValue(sequenceName: string) : int

Attributes

NAME	TYPE	DESCRIPTION
sequenceName	string

Return

( int )

---

getDataValue

---

getDataValue(data: org.netuno.tritao.com.ComponentData) : string

Attributes

NAME	TYPE	DESCRIPTION
data	org.netuno.tritao.com.ComponentData

Return

( string )

---

getDataValue(data: org.netuno.tritao.com.ComponentData, value: string) : string

Attributes

NAME	TYPE	DESCRIPTION
data	org.netuno.tritao.com.ComponentData
value	string

Return

( string )

---

getExecutor

---

getExecutor() : org.netuno.tritao.db.DBExecutor

Return

( org.netuno.tritao.db.DBExecutor )

---

getHili

---

getHili() : org.netuno.tritao.hili.Hili

Return

( org.netuno.tritao.hili.Hili )

---

getKey

---

getKey() : string

Return

( string )

---

getManager

---

getManager() : org.netuno.tritao.db.manager.ManagerBase

Return

( org.netuno.tritao.db.manager.ManagerBase )

---

getProteu

---

getProteu() : org.netuno.proteu.Proteu

Return

( org.netuno.proteu.Proteu )

---

insertInto

---

insertInto(tableName: string, data: Values) : int

Attributes

NAME	TYPE	DESCRIPTION
tableName	string
data	Values

Return

( int )

---

isH2

---

isH2() : boolean

Return

( boolean )

---

isH2(builder: org.netuno.tritao.db.Builder) : boolean

Attributes

NAME	TYPE	DESCRIPTION
builder	org.netuno.tritao.db.Builder

Return

( boolean )

---

isId

---

isId(id: string) : boolean

Attributes

NAME	TYPE	DESCRIPTION
id	string

Return

( boolean )

---

isMSSQL

---

isMSSQL() : boolean

Return

( boolean )

---

isMSSQL(builder: org.netuno.tritao.db.Builder) : boolean

Attributes

NAME	TYPE	DESCRIPTION
builder	org.netuno.tritao.db.Builder

Return

( boolean )

---

isMariaDB

---

isMariaDB() : boolean

Return

( boolean )

---

isMariaDB(builder: org.netuno.tritao.db.Builder) : boolean

Attributes

NAME	TYPE	DESCRIPTION
builder	org.netuno.tritao.db.Builder

Return

( boolean )

---

isPostgreSQL

---

isPostgreSQL() : boolean

Return

( boolean )

---

isPostgreSQL(builder: org.netuno.tritao.db.Builder) : boolean

Attributes

NAME	TYPE	DESCRIPTION
builder	org.netuno.tritao.db.Builder

Return

( boolean )

---

rename

---

rename(oldName: string, newName: string) : Sequence

Attributes

NAME	TYPE	DESCRIPTION
oldName	string
newName	string

Return

( Sequence )

---

renameIfExists

---

renameIfExists(oldName: string, newName: string) : Sequence

Attributes

NAME	TYPE	DESCRIPTION
oldName	string
newName	string

Return

( Sequence )

---

restart

---

restart(sequenceName: string, nextValue: int) : Sequence

Attributes

NAME	TYPE	DESCRIPTION
sequenceName	string
nextValue	int

Return

( Sequence )

---

restart(sequenceName: string, tableName: string, column: string) : Sequence

Attributes

NAME	TYPE	DESCRIPTION
sequenceName	string
tableName	string
column	string

Return

( Sequence )

---

searchComparison

---

searchComparison(param: string) : string

Attributes

NAME	TYPE	DESCRIPTION
param	string

Return

( string )

---

sequence

---

sequence() : boolean

Return

( boolean )

---

supported

---

supported() : boolean

Return

( boolean )

---

unaccent

---

unaccent(input: string) : string

Attributes

NAME	TYPE	DESCRIPTION
input	string

Return

( string )

---