Page History

Divcache

Div

id	description

HTML Table

id

class

servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
JSTableObject

Table Cell (td)createNewTable(tableName)

styleindex	display:none

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.

true
refresh	100d
showRefresh	true
id	doc
title	Refresh page
showDate	true
retry	Enable

id

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Methods SummaryCreates in this server a new table with the specified name. Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)dropTable(tableName)

Table Cell (td)getTable(tableName)

Drops the table with the specified name from this server.

Table Row (tr)

Table Cell (td)
JSTableObject

Returns a JSTable instance corresponding to the table with the specified name from this server.

Table Row (tr)

Table Cell (td)
String[]

Table Cell (td)getTableNames()

Returns an array with the names of all tables in this server.

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)isValid()

Get valid state for the server.

Table Row (tr) Table Cell (td) Table Cell (td)reloadDataModel()

void

Reloads the datamodel from the database, if changed externally or via rawSQL plugin.

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)synchronizeWithDB(table)

Synchronizes a JSTable instance with the database.

HTML Table

functionclass Colgroup Tag Colcolspanservoy sDetail2width100%

Col

Table Head (thead) Table Row (tr)style

Table Row (tr)

id	name

Table Cell (td)
createNewTable

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSTableObject

Span

style	font-weight: bold;

createNewTable

Span

height:30px

;

Table Head (th)

colspan	2

Method Details

Table Body (tbody)

id	createNewTable-String

id

2

Methods Details

createNewTable

name

createNewTable(tableName)

Table Row (tr)

des

Table Cell (td) Divclass

sIndent

Creates in this server a new table with the specified name.

tr

idprs Table Cell (td)
Parameters DivclasssIndent{String} tableName - The name of the table to create. Table Row (tr)idret
 Table Cell (td)class
Returns DivsIndent JSTableObject  - JSTableObject id created table.clients Table Row (tr)
Supported Clients
sIndentSmartClient,WebClient,NGClientsam Table Cell (td)
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)id dropTable-String
 Table Row (tr)
id name
 Table Cell (td)
dropTable
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
Boolean
 Span
style font-weight: bold;
dropTable
 Span
(tableName)
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Drops the table with the specified name from this server.
 Table Row (tr)id prs
 Table Cell (td)Parameters
 Divclass sIndent
{String} tableName - Sample Div
class sIndent
 Code Block
language javascript
var server = plugins.maintenance.getServer("example_data");
if (server)
{
	var table = server.createNewTable("new_table");
	if (table) {
		var pk = table.createNewColumn("new_table_id", JSColumn.INTEGER, 0);
		pk.rowIdentifierType = JSColumn.PK_COLUMN;
		if (server.synchronizeWithDB(table))
			application.output("New table created in the database.");
		else
			application.output("New table not created in database.");
	}
	else application.output("New table not created at all.");
}
sIdentjavascriptlastDetailRowdropTablenamedropTable(tableName)dessIndentDrops the table with the specified name from this server.prsParameters
sIndenttableNameThe name of the table to drop. Table Row (tr)idret Table Cell (td)
Returns DivclassBoolean - sIndentid boolean success.clients Table Row (tr)
Supported Clients
sIndentSmartClient,WebClient,NGClientsam Table Cell (td)
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)id getTable-String
 Table Row (tr)
id name
 Table Cell (td)
getTable
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
JSTableObject
 Span
style font-weight: bold;
getTable
 Span
(tableName)
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Returns a JSTable instance corresponding to the table with the specified name from this server.
 Table Row (tr)id prs
 Table Cell (td)Parameters
 Divclass sIndent
{String} tableName - Sample Div
class sIndent
 Code Block
language javascript
var server = plugins.maintenance.getServer("example_data");
if (server) {
	var result = server.dropTable("new_table");
	if (result)
		application.output("Table dropped.");
	else
		application.output("Table not dropped.");
}
sIdentjavascriptlastDetailRowgetTablenamegetTable(tableName)dessIndentReturns a JSTable instance corresponding to the table with the specified name from this server.prsParameters
sIndenttableNameThe name of the table to retrieve. Table Row (tr)idret Table Cell (td)
Returns DivclassJSTableObject - sIndent Divclass sIndent
String[] -  JSTableObject table.clients
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
var server = plugins.maintenance.getServer("example_data");
if (server) {
	var table = server.getTable("employees");
	if (table) {
		var colNames = table.getColumnNames()
		application.output("Table has " + colNames.length + " columns.");
		for (var i=0; i<colNames.length; i++)
			application.output("Column " + i + ": " + colNames[i]);
	}
}
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)id getTableNames
 Table Row (tr)
id name
 Table Cell (td)
getTableNames
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
String[]
 Span
style font-weight: bold;
getTableNames
 Span
()
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Returns an array with the names of all tables in this server.
 Table Row (tr)id ret
 Table Cell (td)Returns
idSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetTableNamesnamegetTableNames()dessIndentReturns an array with the names of all tables in this server.retReturns
sIndent Array of String table names.clients Table Row (tr)
Supported Clients
sIndentSmartClient,WebClient,NGClientsam Table Cell (td)
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)
id isValid
 Table Row (tr)
id name
 Table Cell (td)
isValid
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
Boolean
 Span
style font-weight: bold;
isValid
 Span
()
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Get valid state for the server.
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
Boolean - boolean valid state.
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
var server = plugins.maintenance.getServer("example_data");
if (!server.isValid()) {
	application.output("Server not valid!");
}
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)
id reloadDataModel
 Table Row (tr)
id name
 Table Cell (td)
reloadDataModel
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
void
 Span
style font-weight: bold;
reloadDataModel
 Span
()
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Reloads the datamodel from the database, if changed externally or via rawSQL plugin.
This call is not needed after a call to synchronizeWithDB().
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
void
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript
var server = plugins.maintenance.getServer("example_data");
var result = plugins.rawSQL.executeSQL("example_data", null, 'CREATE TABLE raw_table (raw_table_id INTEGER)');
if (result) {
	application.output("Table created through rawSQL plugin.");
	if (server) {
		server.reloadDataModel();
		// All existing JSTableObject/JSColumn object references are invalid now! Use getTable to get new ones.
		var table = server.getTable("raw_table");
		if (table) {
			var colNames = table.getColumnNames()
			application.output("Table has " + colNames.length + " columns.");
			for (var i=0; i<colNames.length; i++)
				application.output("Column " + i + ": " + colNames[i]);
		}
	}
}
else {
	application.output("Raw table creation failed: " + plugins.rawSQL.getException());
}
 Table Row (tr)
class lastDetailRow
 Table Cell (td)
 
 Table Body (tbody)id synchronizeWithDB-JSTableObject
 Table Row (tr)
id name
 Table Cell (td)
synchronizeWithDB
 Table Row (tr)
id sig
 Table Cell (td)
 Span
style margin-right: 5px;
Boolean
 Span
style font-weight: bold;
synchronizeWithDB
 Span
(table)
 Table Row (tr)
id des
 Table Cell (td)
 Div
class sIndent
Synchronizes a JSTable instance with the database. If columns were added to or removed from the JSTable instance, all these changes will now be persisted to the database.
 Table Row (tr)id prs
 Table Cell (td)Parameters
 Divclass sIndent
{JSTableObject} table - Sample Div
class sIndent
 Code Block
language javascript
var server = plugins.maintenance.getServer("example_data");
if (server) {
	var tableNames = server.getTableNames();
	application.output("There are " + tableNames.length + " tables.");
	for (var i=0; i<tableNames.length; i++)
		application.output("Table " + i + ": " + tableNames[i]);
}
else {
	plugins.dialogs.showInfoDialog("Attention","Server 'example_data' cannot be found.","OK");
}
idsIdentjavascriptlastDetailRowisValidnameisValid()dessIndentGet valid state for the server.retReturns
sIndent boolean valid state.clientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowreloadDataModelnamereloadDataModel()dessIndentReloads the datamodel from the database, if changed externally or via rawSQL plugin.

This call is not needed after a call to synchronizeWithDB().clientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowsynchronizeWithDBnamesynchronizeWithDB(table)dessIndentSynchronizes a JSTable instance with the database. If columns were added to or removed from the JSTable instance, all these changes will now be persisted to the database.prsParameters
sIndenttableA JSTableObject instance that should be synchronized. Table Row (tr)ret Table Cell (td)class
Returns DivBoolean - sIndentid boolean success.clients Table Row (tr)
Supported Clients
sIndentSmartClient,WebClient,NGClientsam Table Cell (td) Table Row (tr)
class lastDetailRow
 Table Cell (td) Sample Div
class sIndent
 Code Block
language javascript
var server = plugins.maintenance.getServer("example_data");
if (server)
{
	var table = server.createNewTable("new_table");
	if (table) {
		var pk = table.createNewColumn("new_table_id", JSColumn.INTEGER, 0);
		pk.rowIdentifierType = JSColumn.PK_COLUMN;
		if (server.synchronizeWithDB(table))
			application.output("New table created in the database.");
		else
			application.output("New table not created in database.");
	}
	else application.output("New table not created at all.");
}
sIdentjavascriptlastDetailRow

Child pages

Versions Compared

Old Version 27

New Version Current

Key

createNewTable

createNewTable(tableName)

dropTable

dropTable(tableName)

getTable

getTable(tableName)

getTableNames

getTableNames()

isValid

reloadDataModel

synchronizeWithDB

isValid()

reloadDataModel()

synchronizeWithDB(table)