Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 18
Next »
Unknown macro: {div}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR
Unknown macro: {div}
Unknown macro: {table}
{column:width=80px|padding=0px}{column}{column}{column}
Unknown macro: {tr} Unknown macro: {th} Method Summary
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} createNewColumn(columnName, type, length)
Creates a new column in this table.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} createNewColumn(columnName, type, length, allowNull)
Creates a new column in this table.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} createNewColumn(columnName, type, length, allowNull, pkColumn)
Creates a new column in this table.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} deleteColumn(columnName)
Deletes the column with the specified name from this table.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getColumn(name)
Returns a JSColumn for the named column (or column dataproviderID).
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getColumnNames()
Returns an array containing the names of all table columns.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getDataSource()
Returns the table data source uri.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getQuotedSQLName()
Returns a quoted version of the table name, if necessary, as defined by the actual database used.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getSQLName()
Returns the table name.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getServerName()
Returns the Servoy server name.
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} isMetadataTable()
Returns whether table was flagged as metadata table.
Unknown macro: {table}
{column:width=100%|padding=0px}{column}
Unknown macro: {tr} Unknown macro: {th} Method Details
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} createNewColumn
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} createNewColumn
Unknown macro: {span} (columnName, type, length)
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var server = plugins.maintenance.getServer("example_data");
if (server)
{
var table = server.createNewTable("users");
if (table)
{
var pk = table.createNewColumn("id", JSColumn.MEDIA, 16); // can also use (JSColumn.TEXT, 36) for UUIDs
pk.rowIdentifierType = JSColumn.PK_COLUMN;
pk.setFlag(JSColumn.UUID_COLUMN, true)
pk.sequenceType = JSColumn.UUID_GENERATOR
var c = table.createNewColumn("name", JSColumn.TEXT, 100);
c.allowNull = false
table.createNewColumn("age", JSColumn.INTEGER, 0);
table.createNewColumn("last_login", JSColumn.DATETIME, 0);
var result = server.synchronizeWithDB(table);
if (result) application.output("Table successfully created.");
else application.output("Table not created.");
}
}
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} createNewColumn
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} createNewColumn
Unknown macro: {span} (columnName, type, length, allowNull)
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var server = plugins.maintenance.getServer("example_data");
if (server)
{
var table = server.createNewTable("users");
if (table)
{
var pk = table.createNewColumn("id", JSColumn.MEDIA, 16); // can also use (JSColumn.TEXT, 36) for UUIDs
pk.rowIdentifierType = JSColumn.PK_COLUMN;
pk.setFlag(JSColumn.UUID_COLUMN, true)
pk.sequenceType = JSColumn.UUID_GENERATOR
var c = table.createNewColumn("name", JSColumn.TEXT, 100);
c.allowNull = false
table.createNewColumn("age", JSColumn.INTEGER, 0);
table.createNewColumn("last_login", JSColumn.DATETIME, 0);
var result = server.synchronizeWithDB(table);
if (result) application.output("Table successfully created.");
else application.output("Table not created.");
}
}
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} createNewColumn
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} createNewColumn
Unknown macro: {span} (columnName, type, length, allowNull, pkColumn)
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var server = plugins.maintenance.getServer("example_data");
if (server)
{
var table = server.createNewTable("users");
if (table)
{
var pk = table.createNewColumn("id", JSColumn.MEDIA, 16); // can also use (JSColumn.TEXT, 36) for UUIDs
pk.rowIdentifierType = JSColumn.PK_COLUMN;
pk.setFlag(JSColumn.UUID_COLUMN, true)
pk.sequenceType = JSColumn.UUID_GENERATOR
var c = table.createNewColumn("name", JSColumn.TEXT, 100);
c.allowNull = false
table.createNewColumn("age", JSColumn.INTEGER, 0);
table.createNewColumn("last_login", JSColumn.DATETIME, 0);
var result = server.synchronizeWithDB(table);
if (result) application.output("Table successfully created.");
else application.output("Table not created.");
}
}
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} deleteColumn
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} void
Unknown macro: {span} deleteColumn
Unknown macro: {span} (columnName)
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {String} columnName
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {div} void
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var server = plugins.maintenance.getServer("example_data");
if (server) {
var table = server.getTable("users");
if (table) {
table.deleteColumn("last_login");
server.synchronizeWithDB(table);
}
}
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getColumn
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} getColumn
Unknown macro: {span} (name)
Unknown macro: {tr} Unknown macro: {td} Parameters
Unknown macro: {div} {String} name – The name of the column to return the value from.
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {div} JSColumn – JSColumn column.
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var jsTable = databaseManager.getTable('udm', 'campaigns')
var jsColumn = jsTable.getColumn('campaign_name')
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getColumnNames
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} String[]
Unknown macro: {span} getColumnNames
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {div} String[] – String array of column names.
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var jsTable = databaseManager.getTable('udm', 'campaigns')
var columnNames = jsTable.getColumnNames()
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getDataSource
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} getDataSource
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {div} String – String datasource uri.
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var jsTable = databaseManager.getTable('udm', 'campaigns')
var dataSource = jsTable.getDataSource()
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getQuotedSQLName
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} getQuotedSQLName
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {div} String – String table name, quoted if needed.
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
//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])
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getRowIdentifierColumnNames
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} String[]
Unknown macro: {span} getRowIdentifierColumnNames
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {div} String[] – String array of row identifier column names.
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var jsTable = databaseManager.getTable('udm', 'campaigns')
var identifierColumnNames = jsTable.getRowIdentifierColumnNames()
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getSQLName
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} getSQLName
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {div} String – String table name.
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var jsTable = databaseManager.getTable('udm', 'campaigns')
var tableNameForDisplay = jsTable.getSQLName()
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} getServerName
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} getServerName
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {div} String – String server name.
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var jsTable = databaseManager.getTable('udm', 'campaigns')
var serverName = jsTable.getServerName()
Unknown macro: {tr} Unknown macro: {td}
Unknown macro: {tbody} Unknown macro: {tr} Unknown macro: {td} isMetadataTable
Unknown macro: {tr} Unknown macro: {td} Unknown macro: {span} isMetadataTable
Unknown macro: {tr} Unknown macro: {td} Returns
Unknown macro: {div} Boolean – boolean is metadata
Unknown macro: {tr} Unknown macro: {td} Sample
Unknown macro: {div}
var jsTable = databaseManager.getTable('udm', 'campaigns')
var isMetaDataTable = jsTable.isMetadataTable()
Unknown macro: {tr} Unknown macro: {td}