Skip to main content

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​
NAMETYPEDESCRIPTION
sequenceNamestring
Return​

( string )

create​

create(name: string) : Sequence​

Attributes​
NAMETYPEDESCRIPTION
namestring
Return​

( Sequence )

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

Attributes​
NAMETYPEDESCRIPTION
namestring
startWithint
Return​

( Sequence )

drop​

drop(name: string) : Sequence​

Attributes​
NAMETYPEDESCRIPTION
namestring
Return​

( Sequence )

getCurrentValue​

getCurrentValue(sequenceName: string) : int​

Attributes​
NAMETYPEDESCRIPTION
sequenceNamestring
Return​

( int )

getKey​

getKey() : string​

Return​

( string )

isH2​

isH2() : boolean​

Return​

( boolean )

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

Attributes​
NAMETYPEDESCRIPTION
builderorg.netuno.tritao.db.Builder
Return​

( boolean )

isMSSQL​

isMSSQL() : boolean​

Return​

( boolean )

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

Attributes​
NAMETYPEDESCRIPTION
builderorg.netuno.tritao.db.Builder
Return​

( boolean )

isMariaDB​

isMariaDB() : boolean​

Return​

( boolean )

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

Attributes​
NAMETYPEDESCRIPTION
builderorg.netuno.tritao.db.Builder
Return​

( boolean )

isPostgreSQL​

isPostgreSQL() : boolean​

Return​

( boolean )

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

Attributes​
NAMETYPEDESCRIPTION
builderorg.netuno.tritao.db.Builder
Return​

( boolean )

rename​

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

Attributes​
NAMETYPEDESCRIPTION
oldNamestring
newNamestring
Return​

( Sequence )

renameIfExists​

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

Attributes​
NAMETYPEDESCRIPTION
oldNamestring
newNamestring
Return​

( Sequence )

restart​

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

Attributes​
NAMETYPEDESCRIPTION
sequenceNamestring
nextValueint
Return​

( Sequence )

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

Attributes​
NAMETYPEDESCRIPTION
sequenceNamestring
tableNamestring
columnstring
Return​

( Sequence )

sequence​

sequence() : boolean​

Return​

( boolean )

supported​

supported() : boolean​

Return​

( boolean )