easik.sketch.util.Export
Class ExportConstants

java.lang.Object
  easik.EasikConstants
      easik.sketch.util.Export.ExportConstants

public final class ExportConstants
extends EasikConstants

A class containing constants required for SQL, and any String constants needed to access specific databases.

Since:

2006-05-16 Vera Ranieri

Version:

2006-06-29 Vera Ranieri

Author:

Vera Ranieri 2006

Field Summary

static java.lang.String	AUTO_INCREMENT The AUTO_INCREMENT statement
static java.lang.String	BEGIN The BEGIN statement
static java.lang.String	CREATE_DB The CREATE DATABASE statement
static java.lang.String	CREATE_PROC The CREATE PROCEDURE statement
static java.lang.String	CREATE_TABLE The CREATE TABLE statement
static java.lang.String	DB2 The string DB2
static java.lang.String	DB2_DRIVER_LOCATION The driver location for DB2
static java.lang.String	DB2_HOST The host location for DB2
static java.lang.String	DELIMITER The statement to change the delimiter to the original delimiter
static java.lang.String	DELIMITER$ The statement to change the delimiter to a different delimiter, so processes can be defined
static java.util.HashMap	DRIVER_LOCATIONS Hash Map of driver locations, indexed by the type of database
static java.lang.String	END The END statement
static java.lang.String	FAIL_PROC The procedure to enter an item into the fail table
static java.lang.String	FAIL_TABLE The statement creating the Fail table.
static java.lang.String	FOREIGN The FOREIGN KEY statement
static java.lang.String	ID The extension used to define the unique primary key for each table
static java.lang.String	ID_TYPE The data type of the unique key
static java.lang.String	MY_SQL The string MySQL
static java.lang.String	MySQL_DRIVER_LOCATION The driver location for MySQL
static java.lang.String	MySQL_ENGINE The MySQL engine needed for foreign key enforcement
static java.lang.String	MySQL_HOST The host location for MySQL
static java.lang.String	NOT_NULL The NOT NULL statement
static java.lang.String	ON_DELETE The ON DELETE CASCADE statement
static java.lang.String	ON_UPDATE The ON UPDATE CASCADE statement
static java.lang.String	ORACLE The string Oracle
static java.lang.String	ORACLE_DRIVER_LOCATION The driver location for Oracle
static java.lang.String	ORACLE_HOST The host location for Oracle
static java.lang.String	PRIMARY The PRIMARY KEY statement
static java.lang.String	PROC_PARAM The parameters passed to a procedure
static java.lang.String	REF The REFERENCES statement
static java.lang.String	SQL The string SQL
static java.lang.String	SQL_EXTENSION The SQL file extension
static java.util.HashMap	SQL_PLATFORM_LOCATIONS The platform locations, indexed by the type of database
static java.lang.String	UNIQUE The UNIQUE statement
static java.lang.String	USE The USE statement
static java.lang.String	USER_DEFINED The string UserDefined
static java.lang.String	XML The string XML

Fields inherited from class easik.EasikConstants

DB2_DEFAULT, DB2_TYPES, MY_SQL_DEFAULT, MY_SQL_TYPES, ORACLE_DEFAULT, ORACLE_TYPES, SQL_FILE, TEX_FILE, XML_DEFAULT, XML_FILE, XML_TYPES

Constructor Summary

ExportConstants()

Method Summary

private static java.util.HashMap<java.lang.String,java.lang.String>	setDriverHashMap() Sets the driver hash map
private static java.util.HashMap<java.lang.String,java.lang.String>	setLocationHashMap() Sets the driver location hash map

Methods inherited from class easik.EasikConstants

getDefaultDataTypes, getDefaultDataTypesOrder

Methods inherited from class java.lang.Object

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

Field Detail

DB2

public static final java.lang.String DB2

The string DB2

See Also:

Constant Field Values

MY_SQL

public static final java.lang.String MY_SQL

The string MySQL

See Also:

Constant Field Values

ORACLE

public static final java.lang.String ORACLE

The string Oracle

See Also:

Constant Field Values

XML

public static final java.lang.String XML

The string XML

See Also:

Constant Field Values

USER_DEFINED

public static final java.lang.String USER_DEFINED

The string UserDefined

See Also:

Constant Field Values

SQL

public static final java.lang.String SQL

The string SQL

See Also:

Constant Field Values

MySQL_HOST

public static final java.lang.String MySQL_HOST

The host location for MySQL

See Also:

Constant Field Values

MySQL_DRIVER_LOCATION

public static final java.lang.String MySQL_DRIVER_LOCATION

The driver location for MySQL

See Also:

Constant Field Values

ORACLE_HOST

public static final java.lang.String ORACLE_HOST

The host location for Oracle

See Also:

Constant Field Values

ORACLE_DRIVER_LOCATION

public static final java.lang.String ORACLE_DRIVER_LOCATION

The driver location for Oracle

See Also:

Constant Field Values

DB2_HOST

public static final java.lang.String DB2_HOST

The host location for DB2

See Also:

Constant Field Values

DB2_DRIVER_LOCATION

public static final java.lang.String DB2_DRIVER_LOCATION

The driver location for DB2

See Also:

Constant Field Values

DRIVER_LOCATIONS

public static final java.util.HashMap DRIVER_LOCATIONS

Hash Map of driver locations, indexed by the type of database

SQL_PLATFORM_LOCATIONS

public static final java.util.HashMap SQL_PLATFORM_LOCATIONS

The platform locations, indexed by the type of database

CREATE_DB

public static final java.lang.String CREATE_DB

The CREATE DATABASE statement

See Also:

Constant Field Values

USE

public static final java.lang.String USE

The USE statement

See Also:

Constant Field Values

MySQL_ENGINE

public static final java.lang.String MySQL_ENGINE

The MySQL engine needed for foreign key enforcement

See Also:

Constant Field Values

CREATE_TABLE

public static final java.lang.String CREATE_TABLE

The CREATE TABLE statement

See Also:

Constant Field Values

PRIMARY

public static final java.lang.String PRIMARY

The PRIMARY KEY statement

See Also:

Constant Field Values

FOREIGN

public static final java.lang.String FOREIGN

The FOREIGN KEY statement

See Also:

Constant Field Values

REF

public static final java.lang.String REF

The REFERENCES statement

See Also:

Constant Field Values

ON_UPDATE

public static final java.lang.String ON_UPDATE

The ON UPDATE CASCADE statement

See Also:

Constant Field Values

ON_DELETE

public static final java.lang.String ON_DELETE

The ON DELETE CASCADE statement

See Also:

Constant Field Values

UNIQUE

public static final java.lang.String UNIQUE

The UNIQUE statement

See Also:

Constant Field Values

ID

public static final java.lang.String ID

The extension used to define the unique primary key for each table

See Also:

Constant Field Values

NOT_NULL

public static final java.lang.String NOT_NULL

The NOT NULL statement

See Also:

Constant Field Values

AUTO_INCREMENT

public static final java.lang.String AUTO_INCREMENT

The AUTO_INCREMENT statement

See Also:

Constant Field Values

ID_TYPE

public static final java.lang.String ID_TYPE

The data type of the unique key

See Also:

Constant Field Values

SQL_EXTENSION

public static final java.lang.String SQL_EXTENSION

The SQL file extension

See Also:

Constant Field Values

DELIMITER

public static final java.lang.String DELIMITER

The statement to change the delimiter to the original delimiter

See Also:

Constant Field Values

DELIMITER$

public static final java.lang.String DELIMITER$

The statement to change the delimiter to a different delimiter, so processes can be defined

See Also:

Constant Field Values

CREATE_PROC

public static final java.lang.String CREATE_PROC

The CREATE PROCEDURE statement

See Also:

Constant Field Values

PROC_PARAM

public static final java.lang.String PROC_PARAM

The parameters passed to a procedure

See Also:

Constant Field Values

BEGIN

public static final java.lang.String BEGIN

The BEGIN statement

See Also:

Constant Field Values

END

public static final java.lang.String END

The END statement

See Also:

Constant Field Values

FAIL_TABLE

public static final java.lang.String FAIL_TABLE

The statement creating the Fail table. This table serves to record any failures caused by invalid activity where defined by a procedure

See Also:

Constant Field Values

FAIL_PROC

public static final java.lang.String FAIL_PROC

The procedure to enter an item into the fail table

See Also:

Constant Field Values

Constructor Detail

ExportConstants

public ExportConstants()

Method Detail

setDriverHashMap

private static java.util.HashMap<java.lang.String,java.lang.String> setDriverHashMap()

Sets the driver hash map

Returns:

The set driver hash map

setLocationHashMap

private static java.util.HashMap<java.lang.String,java.lang.String> setLocationHashMap()

Sets the driver location hash map

Returns:

The driver location hash map