easik.sketch.util.Export
Class ExportConstants

java.lang.Object
  extended by easik.EasikConstants
      extended by 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