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.
}
commandNextValue
commandNextValue(sequenceName: string) : string
Attributes
NAME | TYPE | DESCRIPTION |
---|---|---|
sequenceName | 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 )
getCurrentValue
getCurrentValue(sequenceName: string) : int
Attributes
NAME | TYPE | DESCRIPTION |
---|---|---|
sequenceName | string |
Return
( int )
getKey
getKey() : string
Return
( string )
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 )
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 )
sequence
sequence() : boolean
Return
( boolean )
supported
supported() : boolean
Return
( boolean )