var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')switch (column.getSequenceType()){caseJSColumn.NONE:// handle column with no sequencebreak;caseJSColumn.UUID_GENERATOR:// handle uuid generated columnbreak;}
DATABASE_SEQUENCE
Constant used when setting or getting the sequence type of columns.
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')switch (column.getSequenceType()){caseJSColumn.NONE:// handle column with no sequencebreak;caseJSColumn.UUID_GENERATOR:// handle uuid generated columnbreak;}
DATETIME
Constant used when setting or getting the type of columns.
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')switch (column.getType()){caseJSColumn.TEXT:// handle text columnbreak;caseJSColumn.NUMBER:caseJSColumn.INTEGER:// handle numerical columnbreak;}
NATIVE_COLUMN
Constant used when setting or getting the flags of columns.
This flag identifies columns that are marked as a native type column (for example uniqueidentifier).
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')switch (column.getSequenceType()){caseJSColumn.NONE:// handle column with no sequencebreak;caseJSColumn.UUID_GENERATOR:// handle uuid generated columnbreak;}
NUMBER
Constant used when setting or getting the type of columns.
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')switch (column.getType()){caseJSColumn.TEXT:// handle text columnbreak;caseJSColumn.NUMBER:caseJSColumn.INTEGER:// handle numerical columnbreak;}
PK_COLUMN
Constant used when setting or getting the row identifier type of columns.
This value identifies columns that are defined as primary key in the database.
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')switch (column.getRowIdentifierType()){caseJSColumn.NONE:// handle normal columnbreak;caseJSColumn.PK_COLUMN:// handle database pk columnbreak;caseJSColumn.ROWID_COLUMN:// handle developer defined pk columnbreak;}
ROWID_COLUMN
Constant used when setting or getting the row identifier type of columns.
This value identifies columns that are defined as primary key by the developer (but not in the database).
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')switch (column.getSequenceType()){caseJSColumn.NONE:// handle column with no sequencebreak;caseJSColumn.UUID_GENERATOR:// handle uuid generated columnbreak;}
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')if (!column.getAllowNull()){// column cannot be null}
getDataProviderID()
Get the data provider id for this column (which is the same as name if not explicitly defined otherwise).
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customername')if (column.getLength() <10){// handle short column}
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')var colName =column.getName()
getQualifiedName()
Get the qualified name (including table name) of the column as known by the database.
The name is quoted, if necessary, as defined by the actual database used.
//use with the raw SQL plugin://if the table name contains characters that are illegal in sql, the table name will be quotedvar jsTable =databaseManager.getTable('udm','campaigns')var quotedTableName =jsTable.getQuotedSQLName()var jsColumn =jsTable.getColumn('active')var quotedColumnName =jsColumn.getQuotedSQLName()plugins.rawSQL.executeSQL('udm', quotedTableName, 'select * from ' + quotedTableName + ' where ' + quotedColumnName + ' = ?', [1])
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customername')var scale =column.getScale()
getSequenceType()
Get the sequence type of the column.
The sequence type is one of:
- JSColumn.NONE
- JSColumn.SERVOY_SEQUENCE
- JSColumn.DATABASE_SEQUENCE
- JSColumn.DATABASE_IDENTITY
- JSColumn.UUID_GENERATOR;
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')switch (column.getSequenceType()){caseJSColumn.NONE:// handle column with no sequencebreak;caseJSColumn.UUID_GENERATOR:// handle uuid generated columnbreak;}
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customername')var title =column.getTitle()
getType()
Get the JDBC type of the column.
The type reported by the JDBC driver will be mapped to one of:
- JSColumn.DATETIME
- JSColumn.TEXT
- JSColumn.NUMBER
- JSColumn.INTEGER
- JSColumn.MEDIA
var table =databaseManager.getTable('db:/example_data/orders')var column =table.getColumn('customerid')var typeName =column.getTypeAsString()
hasFlag(flag)
Check a flag of the column.
The flags are a bit pattern consisting of 1 or more of the following bits:
- JSColumn.UUID_COLUMN
- JSColumn.EXCLUDED_COLUMN
- JSColumn.TENANT_COLUMN
- JSColumn.NATIVE_COLUMN