org.mmbase.storage.implementation.database

Class Schemes

java.lang.Object

org.mmbase.storage.implementation.database.Schemes

public final class Schemes
extends Object

This class defines the scheme names and defaults used by the default database storage manager classes. Specific storage managers may add their own schemes, or not use schemes at all.

Since:

MMBase-1.7

Version:

$Id$

Author:

Pierre van Rooden

Field Summary

Fields

Modifier and Type	Field and Description
static String	CHANGE_FIELD Name of the scheme for changing a field.
static String	CHANGE_FIELD_DEFAULT The default scheme for changing a field.
static String	CREATE_CONSTRAINT Name of the scheme for creating (adding) a constraint, such as a key or index.
static String	CREATE_CONSTRAINT_DEFAULT The default scheme for creating (adding) a constraint.
static String	CREATE_DELETE_TRIGGER Name of the scheme for creating an 'delete' trigger for a view.
static String	CREATE_DELETE_TRIGGER_DEFAULT
static String	CREATE_FIELD Name of the scheme for creating (adding) a field.
static String	CREATE_FIELD_DEFAULT The default scheme for creating (adding) a field.
static String	CREATE_FOREIGN_KEY Name of the partial scheme for creating a foreign (referential) key.
static String	CREATE_FOREIGN_KEY_DEFAULT The default scheme for selecting a node type.
static String	CREATE_INDEX Name of the scheme for creating an index for a field.
static String	CREATE_INDEX_DEFAULT The default scheme for creating an index
static String	CREATE_INSERT_TRIGGER Name of the scheme for creating an 'insert' trigger for a view.
static String	CREATE_INSERT_TRIGGER_DEFAULT
static String	CREATE_OBJECT_ROW_TYPE Name of the scheme for creating a row type.
static String	CREATE_OBJECT_TABLE Name of the scheme for creating a table.
static String	CREATE_OBJECT_TABLE_DEFAULT The default scheme for creating a table.
static String	CREATE_PRIMARY_KEY Name of the partial scheme for creating a primary key.
static String	CREATE_PRIMARY_KEY_DEFAULT The default scheme for creating a prinary key.
static String	CREATE_ROW_TYPE Name of the scheme for creating a row type.
static String	CREATE_SEQUENCE Name of the scheme for creating a sequence or number table The parameters accepted are: {0} the storage manager (StorageManager), or the basename for tables (String) {1} the (suggested) field definition of the primary key field ('number') {2} the database name or catalog
static String	CREATE_SEQUENCE_DEFAULT The default scheme for creating a sequence table.
static String	CREATE_TABLE Name of the scheme for creating a table.
static String	CREATE_TABLE_DEFAULT The default scheme for creating a table.
static String	CREATE_UNIQUE_INDEX Name of the scheme for creating a unique (generally composite) index.
static String	CREATE_UNIQUE_INDEX_DEFAULT The default scheme for creating a composite key.
static String	CREATE_UNIQUE_KEY Name of the partial scheme for creating a unique key.
static String	CREATE_UNIQUE_KEY_DEFAULT The default scheme for selecting a node type.
static String	CREATE_UPDATE_TRIGGER Name of the scheme for creating an 'update' trigger for a view.
static String	CREATE_UPDATE_TRIGGER_DEFAULT
static String	CREATE_VIEW Name of the scheme for creating a view.
static String	CREATE_VIEW_DEFAULT
static String	DELETE_CONSTRAINT Name of the scheme for deleting a constraint, such as a key or index.
static String	DELETE_CONSTRAINT_DEFAULT The default scheme for deleting a constraint.
static String	DELETE_FIELD Name of the scheme for deleting a field.
static String	DELETE_FIELD_DEFAULT The default scheme for deleting a field.
static String	DELETE_INDEX Name of the scheme for deleting a index.
static String	DELETE_INDEX_DEFAULT The default scheme for deleting a constraint.
static String	DELETE_NODE Name of the scheme for selecting a node type.
static String	DELETE_NODE_DEFAULT The default scheme for selecting a node type.
static String	DELETE_UNIQUE_INDEX Name of the scheme for deleting a unique (generally composite) index.
static String	DELETE_UNIQUE_INDEX_DEFAULT The default scheme for deleting a constraint.
static String	DROP_ROW_TYPE Name of the scheme for dropping a row type.
static String	DROP_TABLE Name of the scheme for dropping a table.
static String	DROP_TABLE_DEFAULT The default scheme for reading a text field.
static String	GET_BINARY_DATA Name of the scheme for reading a binary field from a node.
static String	GET_BINARY_DATA_DEFAULT The default scheme for reading a binary field.
static String	GET_TABLE_SIZE Name of the scheme for obtaining the size of a (builder) table.
static String	GET_TABLE_SIZE_DEFAULT The default scheme for reading a text field.
static String	GET_TEXT_DATA Name of the scheme for reading a text field from a node.
static String	GET_TEXT_DATA_DEFAULT The default scheme for reading a text field.
static String	INIT_SEQUENCE Name of the scheme for initializing a sequence or number table The parameters accepted are: {0} the storage manager (StorageManager), or the basename for tables (String) {1} the (suggested) name of the primary key field ('number') {2} the value to init the sequence to {3} a default 'increment'
static String	INIT_SEQUENCE_DEFAULT The default scheme for initializing a sequence table.
static String	INSERT_NODE Name of the scheme for inserting a node.
static String	INSERT_NODE_DEFAULT The default scheme for inserting a node type.
static String	READ_SEQUENCE Name of the scheme for retrieving the key from sequence or number table The parameters accepted are: {0} the storage manager (StorageManager), or the basename for tables (String) {1} the (suggested) name of the primary key field ('number') {2} the sequence buffer size (nr of keys that MMBase caches in the storage layer).
static String	READ_SEQUENCE_DEFAULT The default scheme for retrieving the key from a sequence table.
static String	SELECT_NODE Name of the scheme for selecting a node.
static String	SELECT_NODE_DEFAULT The default scheme for selecting a node.
static String	SELECT_NODE_TYPE Name of the scheme for selecting a node type.
static String	SELECT_NODE_TYPE_DEFAULT The default scheme for selecting a node type.
static String	UPDATE_NODE Name of the scheme for updating a node type.
static String	UPDATE_NODE_DEFAULT The default scheme for updating a node type.
static String	UPDATE_SEQUENCE Name of the scheme for updating a sequence or number table The parameters accepted are: {0} the storage manager (StorageManager), or the basename for tables (String) {1} the (suggested) name of the primary key field ('number') {2} the sequence buffer size (nr of keys that MMBase caches in the storage layer).
static String	UPDATE_SEQUENCE_DEFAULT The default scheme for updating a sequence table.

Constructor Summary

Constructors

Constructor and Description
Schemes()

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

CREATE_ROW_TYPE

public static final String CREATE_ROW_TYPE

Name of the scheme for creating a row type. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String) {1} the builder to create the row type for {2} the field definitions (excluding index definitions) {3} the builder that this rowtype extends from This attribute is optional, and there is no default for this scheme. An example (for Informix):

CREATE ROW TYPE {1}_t ({2}) EXTENDS {3}_t

See Also:

Constant Field Values

CREATE_TABLE

public static final String CREATE_TABLE

Name of the scheme for creating a table. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String) {1} the table name of the builder to create the table for {2} the field definitions (excluding simple index definitions) {3} the simple index definitions. A comma-seperated list, which is preceded by a comma UNLESS there is a rowtype scheme defined {4} the field definitions, including simple index definitions {5} constraint definitions A comma-seperated list, which is preceded by a comma UNLESS there is a rowtype scheme defined, and no other field definitions. {6} the table name of the builder that this table extends from {7} the database name or catalog You can set up your scheme to create extended tables (i.e. in Postgresql). You also can define indexes or fields seperate (i.e. in HSQL or in a create table after a create row type in Informix) or in one go (as you might do with MySQL).