Skip to main content

CheckExists

Verifica se sequências, tabelas, colunas e indexes existem na base de dados.

if (!_db.checkExists().table("client")) {
    _db.table().create(
        "client",
        _db.column().setName("id").setType("int").setPrimaryKey(true),
        _db.column().setName("name").setType("varchar").setNotNull(true).setDefault()
    );
}

coalesce​

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

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

( string )

column​

column(table: string, column: string) : boolean​

Attributes​
NAMETYPEDESCRIPTION
tablestring
columnstring
Return​

( boolean )

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 )

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 )

index​

index(index: string) : boolean​

Attributes​
NAMETYPEDESCRIPTION
indexstring
Return​

( boolean )

index(tableName: string, columnName: string) : boolean​

Attributes​
NAMETYPEDESCRIPTION
tableNamestring
columnNamestring
Return​

( boolean )

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 )

searchComparison​

searchComparison(param: string) : string​

Attributes​
NAMETYPEDESCRIPTION
paramstring
Return​

( string )

sequence​

sequence() : boolean​

Return​

( boolean )

sequence(name: string) : boolean​

Attributes​
NAMETYPEDESCRIPTION
namestring
Return​

( boolean )

sequence(tableName: string, columnName: string) : boolean​

Attributes​
NAMETYPEDESCRIPTION
tableNamestring
columnNamestring
Return​

( boolean )

table​

table(table: string) : boolean​

Attributes​
NAMETYPEDESCRIPTION
tablestring
Return​

( boolean )

unaccent​

unaccent(input: string) : string​

Attributes​
NAMETYPEDESCRIPTION
inputstring
Return​

( string )