Skip to main content

Column

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

if (!_db.checkExists().column("client", "description")) {
    _db.column().rename(
        "client", // Tabela
        "description", // Nome Antigo
        "name" // Novo Nome
    );
}

changeType​

changeType(table: string) : Column​

Attributes​
NAMETYPEDESCRIPTION
tablestring
Return​

( Column )

coalesce​

coalesce(params: string[]) : string​

Attributes​
NAMETYPEDESCRIPTION
paramsstring[]
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 )

drop​

drop(table: string, column: string) : Column​

Attributes​
NAMETYPEDESCRIPTION
tablestring
columnstring
Return​

( Column )

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 )

getDefault​

getDefault() : 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 )

getMaxLength​

getMaxLength() : int​

Return​

( int )

getName​

getName() : string​

Return​

( string )

getPrecision​

getPrecision() : int​

Return​

( int )

getProteu​

getProteu() : org.netuno.proteu.Proteu​

Return​

( org.netuno.proteu.Proteu )

getScale​

getScale() : int​

Return​

( int )

getType​

getType() : org.netuno.tritao.db.manager.Column$Type​

Return​

( org.netuno.tritao.db.manager.Column$Type )

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 )

isNotNull​

isNotNull() : boolean​

Return​

( boolean )

isPostgreSQL​

isPostgreSQL() : boolean​

Return​

( boolean )

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

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

( boolean )

isPrimaryKey​

isPrimaryKey() : boolean​

Return​

( boolean )

rename​

rename(table: string, oldName: string, newName: string) : Column​

Attributes​
NAMETYPEDESCRIPTION
tablestring
oldNamestring
newNamestring
Return​

( Column )

renameIfExists​

renameIfExists(table: string, oldName: string, newName: string) : Column​

Attributes​
NAMETYPEDESCRIPTION
tablestring
oldNamestring
newNamestring
Return​

( Column )

searchComparison​

searchComparison(param: string) : string​

Attributes​
NAMETYPEDESCRIPTION
paramstring
Return​

( string )

sequence​

sequence() : boolean​

Return​

( boolean )

setDefault​

setDefault() : Column​

Return​

( Column )

setDefault(_default: boolean) : Column​

Attributes​
NAMETYPEDESCRIPTION
_defaultboolean
Return​

( Column )

setDefault(_default: double) : Column​

Attributes​
NAMETYPEDESCRIPTION
_defaultdouble
Return​

( Column )

setDefault(_default: float) : Column​

Attributes​
NAMETYPEDESCRIPTION
_defaultfloat
Return​

( Column )

setDefault(_default: int) : Column​

Attributes​
NAMETYPEDESCRIPTION
_defaultint
Return​

( Column )

setDefault(_default: string) : Column​

Attributes​
NAMETYPEDESCRIPTION
_defaultstring
Return​

( Column )

setDefault(_default: long) : Column​

Attributes​
NAMETYPEDESCRIPTION
_defaultlong
Return​

( Column )

setDefaultAsCurrentDate​

setDefaultAsCurrentDate() : Column​

Return​

( Column )

setDefaultAsCurrentTime​

setDefaultAsCurrentTime() : Column​

Return​

( Column )

setDefaultAsCurrentTimeStamp​

setDefaultAsCurrentTimeStamp() : Column​

Return​

( Column )

setDefaultAsNewUUID​

setDefaultAsNewUUID() : Column​

Return​

( Column )

setMaxLength​

setMaxLength(maxLength: int) : Column​

Attributes​
NAMETYPEDESCRIPTION
maxLengthint
Return​

( Column )

setName​

setName(name: string) : Column​

Attributes​
NAMETYPEDESCRIPTION
namestring
Return​

( Column )

setNotNull​

setNotNull(notNull: boolean) : Column​

Attributes​
NAMETYPEDESCRIPTION
notNullboolean
Return​

( Column )

setPrecision​

setPrecision(precision: int) : Column​

Attributes​
NAMETYPEDESCRIPTION
precisionint
Return​

( Column )

setPrimaryKey​

setPrimaryKey(primaryKey: boolean) : Column​

Attributes​
NAMETYPEDESCRIPTION
primaryKeyboolean
Return​

( Column )

setScale​

setScale(scale: int) : Column​

Attributes​
NAMETYPEDESCRIPTION
scaleint
Return​

( Column )

setType​

setType(typeName: string) : Column​

Attributes​
NAMETYPEDESCRIPTION
typeNamestring
Return​

( Column )

setType(type: org.netuno.tritao.db.manager.Column$Type) : Column​

Attributes​
NAMETYPEDESCRIPTION
typeorg.netuno.tritao.db.manager.Column$Type
Return​

( Column )

toDefaultDefinition​

toDefaultDefinition() : string​

Return​

( string )

toPrimaryKeyDefinition​

toPrimaryKeyDefinition() : string​

Return​

( string )

toTypeDefinition​

toTypeDefinition() : string​

Return​

( string )

unaccent​

unaccent(input: string) : string​

Attributes​
NAMETYPEDESCRIPTION
inputstring
Return​

( string )