Skip to main content

Table

Realiza a manipulação de tabelas em base de dados.

if (_db.checkExists().table("clients")) {
    _db.table().rename(
        "clients", // Nome Antigo
        "client" // Novo Nome
    );
}

coalesce​

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

Attributes​
NAMETYPEDESCRIPTION
paramsjava.lang.String[]
Return​

( string )

columnDataType​

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

Attributes​
NAMETYPEDESCRIPTION
dataorg.netuno.tritao.com.ComponentData
Return​

( Column )

concatenation​

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

Attributes​
NAMETYPEDESCRIPTION
param1string
param2string
Return​

( string )

create​

create(name: string, columns: Column[]) : Table​

Attributes​
NAMETYPEDESCRIPTION
namestring
columnsColumn[]
Return​

( Table )

drop​

drop(name: string) : Table​

Attributes​
NAMETYPEDESCRIPTION
namestring
Return​

( Table )

getBuilder​

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

Return​

( org.netuno.tritao.db.Builder )

getDataValue​

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

Attributes​
NAMETYPEDESCRIPTION
dataorg.netuno.tritao.com.ComponentData
Return​

( string )

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

Attributes​
NAMETYPEDESCRIPTION
dataorg.netuno.tritao.com.ComponentData
valuestring
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​
NAMETYPEDESCRIPTION
tableNamestring
dataValues
Return​

( int )

isH2​

isH2() : boolean​

Return​

( boolean )

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

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

( boolean )

isId​

isId(id: string) : boolean​

Attributes​
NAMETYPEDESCRIPTION
idstring
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 )

newColumn​

newColumn() : Column​

Return​

( Column )

rename​

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

Attributes​
NAMETYPEDESCRIPTION
oldNamestring
newNamestring
Return​

( Table )

renameIfExists​

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

Attributes​
NAMETYPEDESCRIPTION
oldNamestring
newNamestring
Return​

( Table )

searchComparison​

searchComparison(param: string) : string​

Attributes​
NAMETYPEDESCRIPTION
paramstring
Return​

( string )

sequence​

sequence() : boolean​

Return​

( boolean )

unaccent​

unaccent(input: string) : string​

Attributes​
NAMETYPEDESCRIPTION
inputstring
Return​

( string )