Page History

Hidden

DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE

HTML Table

class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
JSTableObject

Table Cell (td)
#createNewTable(tableName) Creates in this server a new table with the specified name.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#dropTable(tableName) Drops the table with the specified name from this server.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
JSTableObject

Table Cell (td)
#getTable(tableName) Returns a JSTable instance corresponding to the table with the specified name from this server.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String[]

Table Cell (td)
#getTableNames() Returns an array with the names of all tables in this server.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#isValid() Get valid state for the server.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
void

Table Cell (td)
#reloadDataModel() Reloads the datamodel from the database, if changed externally or via rawSQL plugin.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#synchronizeWithDB(table) Synchronizes a JSTable instance with the database.

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	createNewTable
class	node

Table Row (tr)

id	name

Table Cell (td)
createNewTable

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

JSTableObject

Span

style	float: left; font-weight: bold;
id	iets

createNewTable

Span

style	float: left;
id	iets

(tableName)

Table Row (tr)

id	des

Table Cell (td)
Creates in this server a new table with the specified name.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {String} tableName – The name of the table to create.

Table Row (tr)

id	ret

Table Cell (td)
Returns JSTableObject – JSTableObject created table.

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.createNewTable("new_table");
	if (table) {
		table.createNewColumn("new_table_id", JSColumn.INTEGER, 0, false, true);
		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.");
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	dropTable
class	node

Table Row (tr)

id	name

Table Cell (td)
dropTable

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Boolean

Span

style	float: left; font-weight: bold;
id	iets

dropTable

Span

style	float: left;
id	iets

(tableName)

Table Row (tr)

id	des

Table Cell (td)
Drops the table with the specified name from this server.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {String} tableName – The name of the table to drop.

Table Row (tr)

id	ret

Table Cell (td)
Returns Boolean – boolean success.

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 result = server.dropTable("new_table");
	if (result)
		application.output("Table dropped.");
	else
	application.output("Table not dropped.");
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getTable
class	node

Table Row (tr)

id	name

Table Cell (td)
getTable

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

JSTableObject

Span

style	float: left; font-weight: bold;
id	iets

getTable

Span

style	float: left;
id	iets

(tableName)

Table Row (tr)

id	des

Table Cell (td)
Returns a JSTable instance corresponding to the table with the specified name from this server.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {String} tableName – The name of the table to retrieve.

Table Row (tr)

id	ret

Table Cell (td)
Returns JSTableObject – JSTableObject table.

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
class	node

Table Row (tr)

id	name

Table Cell (td)
getTableNames

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String[]

Span

style	float: left; font-weight: bold;
id	iets

getTableNames

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Returns an array with the names of all tables in this server.

Table Row (tr)

id	ret

Table Cell (td)
Returns String[] – Array of String table names.

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 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");
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	isValid
class	node

Table Row (tr)

id	name

Table Cell (td)
isValid

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Boolean

Span

style	float: left; font-weight: bold;
id	iets

isValid

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get valid state for the server.

Table Row (tr)

id	ret

Table Cell (td)
Returns 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
class	node

Table Row (tr)

id	name

Table Cell (td)
reloadDataModel

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

void

Span

style	float: left; font-weight: bold;
id	iets

reloadDataModel

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)

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 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
class	node

Table Row (tr)

id	name

Table Cell (td)
synchronizeWithDB

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Boolean

Span

style	float: left; font-weight: bold;
id	iets

synchronizeWithDB

Span

style	float: left;
id	iets

(table)

Table Row (tr)

id	des

Table Cell (td)
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 {JSTableObject} table – A JSTableObject instance that should be synchronized.

Table Row (tr)

id	ret

Table Cell (td)
Returns Boolean – boolean success.

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.createNewTable("new_table");
	if (table) {
		table.createNewColumn("new_table_id", JSColumn.INTEGER, 0, false, true);
		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.");
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 14

New Version Current

Key

createNewTable

dropTable

getTable

getTableNames

isValid

reloadDataModel

synchronizeWithDB