Method Summary | |
---|---|
JSColumn | #getColumn(name) Returns a JSColumn for the named column (or column dataproviderID). |
String[] | #getColumnNames() Returns an array containing the names of all table columns. |
String | #getDataSource() Returns the table data source uri. |
String | #getQuotedSQLName() Returns a quoted version of the table name, if necessary, as defined by the actual database used. |
String[] | #getRowIdentifierColumnNames() Returns an array containing the names of the identifier (PK) column(s). |
String | #getSQLName() Returns the table name. |
String | #getServerName() Returns the Servoy server name. |
Boolean | #isMetadataTable() Returns whether table was flagged as metadata table. |
Method Details |
---|
getColumn |
JSColumn getColumn (name) |
Returns a JSColumn for the named column (or column dataproviderID).
|
Parameters {String} name – The name of the column to return the value from.
|
Returns JSColumn – JSColumn column.
|
Samplevar jsTable = databaseManager.getTable('udm', 'campaigns') var jsColumn = jsTable.getColumn('campaign_name') |
getColumnNames |
String[] getColumnNames () |
Returns an array containing the names of all table columns.
|
Returns String[] – String array of column names.
|
Samplevar jsTable = databaseManager.getTable('udm', 'campaigns') var columnNames = jsTable.getColumnNames() |
getDataSource |
String getDataSource () |
Returns the table data source uri.
|
Returns String – String datasource uri.
|
Samplevar jsTable = databaseManager.getTable('udm', 'campaigns') var dataSource = jsTable.getDataSource() |
getQuotedSQLName |
String getQuotedSQLName () |
Returns a quoted version of the table name, if necessary, as defined by the actual database used.
|
Returns String – String table name, quoted if needed.
|
Sample//use with the raw SQL plugin: //if the table name contains characters that are illegal in sql, the table name will be quoted var jsTable = databaseManager.getTable('udm', 'campaigns') var quotedTableName = jsTable.getQuotedSQLName() plugins.rawSQL.executeSQL('udm', quotedTableName, 'select * from ' + quotedTableName + ' where is_active = ?', [1]) |
getRowIdentifierColumnNames |
String[] getRowIdentifierColumnNames () |
Returns an array containing the names of the identifier (PK) column(s).
|
Returns String[] – String array of row identifier column names.
|
Samplevar jsTable = databaseManager.getTable('udm', 'campaigns') var identifierColumnNames = jsTable.getRowIdentifierColumnNames() |
getSQLName |
String getSQLName () |
Returns the table name.
|
Returns String – String table name.
|
Samplevar jsTable = databaseManager.getTable('udm', 'campaigns') var tableNameForDisplay = jsTable.getSQLName() |
getServerName |
String getServerName () |
Returns the Servoy server name.
|
Returns String – String server name.
|
Samplevar jsTable = databaseManager.getTable('udm', 'campaigns') var serverName = jsTable.getServerName() |
isMetadataTable |
Boolean isMetadataTable () |
Returns whether table was flagged as metadata table.
|
Returns Boolean – boolean is metadata
|
Samplevar jsTable = databaseManager.getTable('udm', 'campaigns') var isMetaDataTable = jsTable.isMetadataTable() |