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


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 )


getProteu


getProteu() : org.netuno.proteu.Proteu

Return

( org.netuno.proteu.Proteu )


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


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 )


setPrimaryKey


setPrimaryKey(primaryKey: boolean) : Column

Attributes
NAMETYPEDESCRIPTION
primaryKeyboolean
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 )


toTypeDefinition


toTypeDefinition() : string

Return

( string )


unaccent


unaccent(input: string) : string

Attributes
NAMETYPEDESCRIPTION
inputstring
Return

( string )