Constant Field Values

Contents

• org.kuali.*

org.kuali.*

org.kuali.common.impex.KualiImpexProducerConfig

public static final String

ARTIFACT_ID

"kuali-impex-producer"

org.kuali.common.impex.ProducerUtils

public static final String	COMMA	","
public static final String	DOT	"."
public static final String	NEWLINE	"\n"
public static final String	NEWLINE_TAB	"\n\t"
public static final String	NOT_NULL	"NOT NULL"
public static final char	SINGLE_QUOTE	39
public static final String	SPACE	" "
public static final String	TYPE_SIZE_PREFIX	"("
public static final String	TYPE_SIZE_SUFFIX	")"

org.kuali.common.impex.config.ExportProjectConstants

public static final String	ARTIFACT_ID	"kuali-impex-export"
public static final String	GROUP_ID	"org.kuali.common"
public static final String	PROJECT_ID	"org.kuali.common:kuali-impex-export"

org.kuali.common.impex.data.DumpDataExecutable

public static final boolean

DEFAULT_SKIP_EXECUTION

false

org.kuali.common.impex.data.impl.AbstractSqlProducer

public static final int	DEFAULT_BATCH_ROW_COUNT_LIMIT	50
public static final int	DEFAULT_DATA_SIZE_LIMIT	51200
protected static final String	OUTPUT_DATE_FORMAT	"yyyyMMddHHmmss"

org.kuali.common.impex.data.impl.MpxLocationSupplier

public static final String	DEFAULT_MPX_EXTENSION	".mpx"
public static final String	UTF8	"UTF-8"

org.kuali.common.impex.data.impl.ParseUtils

public static final String

MPX_DATE_FORMAT

"yyyy-MM-dd\'T\'HH:mm:ss.SSSZZZZZ"

org.kuali.common.impex.data.impl.mysql.MySqlProducer

public static final String	DATE_VALUE_SUFFIX	"\',\'%Y%m%d%H%i%s\')"
public static final String	SUPPORTED_VENDOR	"mysql"

org.kuali.common.impex.data.impl.oracle.OracleProducer

public static final String

SUPPORTED_VENDOR

"oracle"

org.kuali.common.impex.data.service.impl.DataHandler

public static final String	CARRIAGE_RETURN	"\r"
protected static final String	COMMA	","
protected static final String	DOUBLE_QUOTE	"\""
protected static final String	LF	"\n"
public static final String	MPX_CARRIAGE_RETURN	"${mpx.cr}"
public static final String	MPX_DATE_FORMAT	"yyyy-MM-dd\'T\'HH:mm:ss.SSSZZZZZ"
public static final String	MPX_EXTENSION	".mpx"
public static final String	MPX_LINEFEED	"${mpx.lf}"
public static final String	MPX_NULL	"${mpx.null}"
public static final String	MPX_QUOTE	"${mpx.quote}"

org.kuali.common.impex.data.service.impl.DefaultDumpDataService

protected static final int

DEFAULT_DATABASE_ROW_COUNT

500000

org.kuali.common.impex.model.spring.SchemaCompareConfig

protected static final String	EXECUTION_SKIP_KEY	"impex.compare.skip"
protected static final String	SCHEMA_1_DEFAULT_LABEL	"schema1"
protected static final String	SCHEMA_1_LABEL_KEY	"impex.compare.schema1.label"
protected static final String	SCHEMA_2_DEFAULT_LABEL	"schema2"
protected static final String	SCHEMA_2_LABEL_KEY	"impex.compare.schema2.label"

org.kuali.common.impex.model.util.CompareUtils

public static final int

EXPECTED_MISSING_ELEMENTS_SET_COUNT

2

org.kuali.common.impex.model.util.DifferenceUtils

public static final String	CLOSE_PAD_PAREN	" ) "
public static final String	COMMA	"."
public static final String	DOT	"."
public static final String	FOUND_IN_LABEL	"FOUND IN: "
public static final String	LABEL_SEPARATOR	": "
public static final String	NOT_EQUAL_SEPARATOR	" != "
public static final String	NOT_FOUND_IN_LABEL	"NOT FOUND IN: "
public static final String	OPEN_PAD_PAREN	" ( "
public static final String	SPACE	" "

org.kuali.common.impex.schema.MySqlSequenceFinder

public static final String

SUPPORTED_VENDOR

"mysql"

org.kuali.common.impex.schema.MySqlViewFinder

protected static final String	MYSQL_FIND_VIEWS_STATEMENT	"SELECT table_name, view_definition FROM information_schema.views WHERE table_schema = ?"
public static final String	SUPPORTED_VENDOR	"mysql"
protected static final int	VIEW_NAME_INDEX	1
protected static final int	VIEW_TEXT_INDEX	2

org.kuali.common.impex.schema.OracleSequenceFinder

protected static final String	SEQUENCE_NAME_KEY	"name"
protected static final String	SEQUENCE_QUERY_PREFIX	"SELECT SEQUENCE_NAME as name, LAST_NUMBER as value FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = \'"
protected static final String	SEQUENCE_QUERY_SUFFIX	"\'"
protected static final String	SEQUENCE_VALUE_KEY	"value"
public static final String	SUPPORTED_VENDOR	"oracle"

org.kuali.common.impex.schema.OracleViewFinder

protected static final String	ORACLE_FIND_VIEWS_STATEMENT	"SELECT view_name, text FROM all_views WHERE owner = ?"
public static final String	SUPPORTED_VENDOR	"oracle"
protected static final int	VIEW_NAME_INDEX	1
protected static final int	VIEW_TEXT_INDEX	2

org.kuali.common.impex.schema.ProduceSchemaExecutable

public static final boolean	DEFAULT_SKIP_EXECUTION	false
protected static final String	LF	"\n"

org.kuali.common.impex.schema.execute.DumpSchemaRequest

public static final boolean

DEFAULT_LOG_EXCLUDED_SCHEMA_OBJECTS

false

org.kuali.common.impex.schema.execute.DumpSchemasExecutable

public static final boolean

DEFAULT_SKIP_VALUE

false

org.kuali.common.impex.schema.execute.ProjectSchemaExportExecutable

public static final boolean	DEFAULT_EXECUTION_SKIP	false
public static final String	DEFAULT_SCHEMA_FILENAME	"schema.xml"

org.kuali.common.impex.schema.impl.AbstractForeignKeySqlProducer

protected static final String	CASCADE_CONSTRAINT	"CASCADE"
protected static final String	NO_ACTION_CONSTRAINT	"NO ACTION"
protected static final String	RESTRICT_CONSTRAINT	"RESTRICT"
protected static final String	SET_DEFAULT_CONSTRAINT	"SET DEFAULT"
protected static final String	SET_NULL_CONSTRAINT	"SET NULL"

org.kuali.common.impex.schema.impl.mysql.MySqlForeignKeySqlProducer

protected static final String	FOREIGN_COLUMNS_PREFIX	" ("
protected static final String	FOREIGN_COLUMNS_SUFFIX	")"
protected static final String	FOREIGN_TABLE_PREFIX	")\n\tREFERENCES "
protected static final String	LOCAL_COLUMNS_PREFIX	" FOREIGN KEY ("
protected static final String	NAME_PREFIX	"\n\tADD CONSTRAINT "
protected static final String	ON_DELETE_PREFIX	"\tON DELETE "
protected static final String	ON_UPDATE_PREFIX	"\tON UPDATE "
protected static final String	PREFIX	"ALTER TABLE "

org.kuali.common.impex.schema.impl.mysql.MySqlSequenceSqlProducer

protected static final String	ALTER_INCREMENT_START	" AUTO_INCREMENT = "
protected static final String	ALTER_PREFIX	"ALTER TABLE "
protected static final String	CREATE_PREFIX	"CREATE TABLE "
protected static final String	CREATE_SUFFIX	"\n(\n\tID BIGINT(19) NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID)\n) ENGINE MyISAM\n"
protected static final String	DROP_PREFIX	"DROP TABLE IF EXISTS "

org.kuali.common.impex.schema.impl.mysql.MySqlTableSqlProducer

protected static final String	COMMENT_PREFIX	"COMMENT = \'"
protected static final String	CONSTRAINT_PREFIX	"CONSTRAINT "
protected static final String	CONSTRAINT_SUFFIX	")"
protected static final String	CREATE_TABLE_FOOTER	" ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_bin\n"
protected static final String	CREATE_TABLE_HEADER	"CREATE TABLE "
protected static final String	DEFAULT_PREFIX	" DEFAULT "
protected static final String	DROP_TABLE_FOOTER	"\n"
protected static final String	DROP_TABLE_HEADER	"DROP TABLE IF EXISTS "
protected static final String	INDEX_COLUMNS_PREFIX	" ("
protected static final String	INDEX_PREFIX	"INDEX "
protected static final String	INDEX_SUFFIX	")"
protected static final String	PRIMARY_KEY_CONSTRAINT	" PRIMARY KEY("
protected static final String	TABLE_DETAILS_PREFIX	"\n("
protected static final String	TABLE_DETAILS_SUFFIX	"\n)"
protected static final String	UNIQUE_CONSTRAINT	" UNIQUE ("

org.kuali.common.impex.schema.impl.mysql.MySqlViewSqlProducer

protected static final String	CREATE_AS_KEYWORD	" AS\n"
protected static final String	CREATE_PREFIX	"CREATE VIEW "
protected static final String	DROP_PREFIX	"DROP VIEW IF EXISTS "

org.kuali.common.impex.schema.impl.oracle.OracleForeignKeySqlProducer

protected static final String	FOREIGN_COLUMNS_PREFIX	" ("
protected static final String	FOREIGN_COLUMNS_SUFFIX	")\n"
protected static final String	FOREIGN_TABLE_PREFIX	")\n\tREFERENCES "
protected static final String	LOCAL_COLUMNS_PREFIX	"\n\tFOREIGN KEY ("
protected static final String	NAME_PREFIX	"\n\tADD CONSTRAINT "
protected static final String	ON_DELETE_PREFIX	"\tON DELETE "
protected static final String	ON_UPDATE_PREFIX	"\tON UPDATE "
protected static final String	PREFIX	"ALTER TABLE "

org.kuali.common.impex.schema.impl.oracle.OracleSequenceSqlProducer

protected static final String	CREATE_INCREMENT_START	" INCREMENT BY 1 START WITH "
protected static final String	CREATE_PREFIX	"CREATE SEQUENCE "
protected static final String	CREATE_SUFFIX	" NOMAXVALUE NOCYCLE NOCACHE ORDER\n"
protected static final String	DROP_MIDDLE	"\';\n\tIF temp > 0 THEN EXECUTE IMMEDIATE \'DROP SEQUENCE "
protected static final String	DROP_PREFIX	"DECLARE temp NUMBER;\nBEGIN\n\tSELECT COUNT(*) INTO temp FROM user_sequences WHERE sequence_name = \'"
protected static final String	DROP_SUFFIX	"\'; END IF;\nEND;\n"

org.kuali.common.impex.schema.impl.oracle.OracleTableSqlProducer

protected static final String	COLUMN_DESCRIPTION_PREFIX	"\n\nCOMMENT ON COLUMN "
protected static final String	COLUMN_DESCRIPTION_SUFFIX	"\'\n"
protected static final String	COLUMN_SECTION_PREFIX	"\n("
protected static final String	COLUMN_SECTION_SUFFIX	"\n"
protected static final String	CREATE_TABLE_FOOTER	")\n"
protected static final String	CREATE_TABLE_HEADER	"CREATE TABLE "
protected static final String	DEFAULT_PREFIX	" DEFAULT "
protected static final String	DESCRIPTION_IS_KEYWORD	" IS \'"
protected static final String	DROP_TABLE_FOOTER	" CASCADE CONSTRAINTS PURGE\'; END IF;\nEND;\n"
protected static final String	DROP_TABLE_HEADER	"DECLARE temp NUMBER;\nBEGIN\n\tSELECT COUNT(*) INTO temp FROM user_tables WHERE table_name = \'"
protected static final String	DROP_TABLE_MIDDLE	"\';\n\tIF temp > 0 THEN EXECUTE IMMEDIATE \'DROP TABLE "
protected static final String	INDEX_COLUMN_LIST_PREFIX	"\n\t("
protected static final String	INDEX_FOOTER	")\n"
protected static final String	INDEX_HEADER	"CREATE INDEX "
protected static final String	INDEX_TABLE_NAME_PREFIX	"\n\tON "
protected static final String	INDEX_UNIQUE_HEADER	"CREATE UNIQUE INDEX "
protected static final String	PRIMARY_KEY_ADD_CONSTRAINT	"\n\tADD CONSTRAINT "
protected static final String	PRIMARY_KEY_FOOTER	")\n"
protected static final String	PRIMARY_KEY_HEADER	"ALTER TABLE "
protected static final String	PRIMARY_KEY_LISTING_PREFIX	"\nPRIMARY KEY ("
protected static final String	TABLE_DESCRIPTION_PREFIX	"\n\nCOMMENT ON TABLE "
protected static final String	TABLE_DESCRIPTION_SUFFIX	"\'\n"
protected static final String	UNIQUE_MIDDLE	" UNIQUE ("
protected static final String	UNIQUE_PREFIX	"CONSTRAINT "
protected static final String	UNIQUE_SUFFIX	")"

org.kuali.common.impex.schema.impl.oracle.OracleViewSqlProducer

protected static final String	CREATE_VIEW_AS_KEYWORD	" AS \n"
protected static final String	CREATE_VIEW_FOOTER	"\n"
protected static final String	CREATE_VIEW_HEADER	"CREATE OR REPLACE FORCE VIEW "

org.kuali.common.impex.schema.service.ExtractSchemaExecutable

public static final boolean

DEFAULT_SKIP

false

org.kuali.common.impex.schema.service.impl.DefaultExtractSchemaService

protected static final int

SINGLE_THREAD_COUNT

1

org.kuali.common.impex.schema.service.impl.liquibase.LiquibaseSchemaProvider

protected static final String	METADATA_FK_COLUMN_NAME	"FKCOLUMN_NAME"
protected static final String	METADATA_FK_NAME	"FK_NAME"
protected static final String	METADATA_INDEX_COLUMN_NAME	"COLUMN_NAME"
protected static final String	METADATA_INDEX_NAME	"INDEX_NAME"
protected static final String	METADATA_PK_COLUMN_NAME	"PKCOLUMN_NAME"
protected static final String	SINGLE_QUOTE	"\'"
protected static final String	SYSDATE_KEYWORD_DEFAULT	"SYSDATE"
protected static final String	SYSGUID_KEYWORD_DEFAULT	"SYS_GUID()"
protected static final String	USERSESSION_KEYWORD_DEFAULT	"USERENV(\'SESSIONID\')"

org.kuali.common.impex.spring.DataTypeMappingProviderConfig

protected static final String	DATATYPE_SIZE_OVERRIDES_KEY	"producer.sql.schema.datatype.size.overrides"
protected static final String	DEFAULT_DATATYPE_SIZE_OVERRIDES	""

org.kuali.common.impex.spring.MpxSupplierConfig

protected static final String

PRODUCER_IMPL_KEY

"producer.sql.mpx.impl"

org.kuali.common.impex.spring.ParserProjectConfig

public static final String	ARTIFACT_ID	"torque-parser"
public static final String	GROUP_ID	"org.kuali.common"

org.kuali.common.impex.spring.ProduceSchemaConfig

protected static final String	DEFAULT_FILENAME_PREFIX	"dump-"
protected static final String	DUMP_FOLDER_KEY	"impex.schemadump.folder"
protected static final String	FILENAME_PREFIX_KEY	"impex.schemadump.prefix"
protected static final String	FOREIGN_KEY_FILE	"foreignKeys.sql"
protected static final String	SEQUENCE_FILE	"sequences.sql"
protected static final String	SKIP_EXECUTION_KEY	"impex.schemadump.skip"
protected static final String	TABLE_FILE	"tables.sql"
protected static final String	VIEW_FILE	"views.sql"

org.kuali.common.impex.spring.ProjectSchemaExportConfig

public static final String	PROJECTS_KEY	"impex.export.schema.projects"
public static final String	STAGING_DIR_KEY	"impex.export.schema.stagingDir"

org.kuali.common.impex.spring.SchemaSqlProducerConfig

protected static final String

PRODUCER_IMPL_KEY

"producer.sql.schema.impl"

org.kuali.common.impex.spring.SchemaXmlSupplierConfig

protected static final String

SCHEMA_SUFFIX

"schema.xml"

org.kuali.common.impex.spring.XmlSchemaCompareConfig

protected static final String	SCHEMA_1_LOCATION_KEY	"impex.compare.schema1.location"
protected static final String	SCHEMA_2_LOCATION_KEY	"impex.compare.schema2.location"

org.kuali.common.impex.spring.XmlSchemaConfig

protected static final String

XML_LOCATION_KEY

"impex.schema.location"

org.kuali.common.impex.util.DumpConstants

public static final String	DEFAULT_FILE_EXCLUDE	""
public static final String	DEFAULT_FILE_INCLUDE	"**/**"
public static final String	DEFAULT_REGEX_EXCLUDE	""
public static final String	DEFAULT_REGEX_INCLUDE	".*"

org.kuali.common.impex.util.DumpUtils

public static final String	DEFAULT_DATA_INTERVAL	"50k"
public static final int	DEFAULT_DATA_THREADS	15
public static final int	DEFAULT_ROW_INTERVAL	50
protected static final String	ROWS_PROPERTY_SUFFIX	".rows"
protected static final String	SIZE_PROPERTY_SUFFIX	".size"

org.kuali.common.impex.util.ExtractionUtils

protected static final int	COLUMN_DEFAULT_INDEX	13
protected static final int	COLUMN_NAME_INDEX	4
protected static final int	COLUMN_NULLABLE_INDEX	18
protected static final int	COLUMN_REMARKS_INDEX	12
protected static final String	COLUMN_RESULT_SET_NULLABLE_VALUE	"YES"
protected static final int	COLUMN_TYPE_INDEX	5
protected static final int	COLUMN_TYPE_SCALE_INDEX	9
protected static final int	COLUMN_TYPE_SIZE_INDEX	7
protected static final boolean	DEFAULT_NULLABLE	true
protected static final int	FOREIGN_KEY_IMPORTED_COLUMN_NAME_INDEX	4
protected static final int	FOREIGN_KEY_IMPORTED_TABLE_NAME_INDEX	3
protected static final int	FOREIGN_KEY_LOCAL_COLUMN_NAME_INDEX	8
protected static final int	FOREIGN_KEY_NAME_INDEX	12
protected static final int	FOREIGN_KEY_ON_DELETE_INDEX	11
protected static final int	FOREIGN_KEY_ON_UPDATE_INDEX	10
protected static final int	INDEX_COLUMN_NAME_INDEX	9
protected static final int	INDEX_NAME_INDEX	6
protected static final int	INDEX_NON_UNIQUE_INDEX	4
protected static final String	ORACLE_RECYCLE_BIN_TABLE_NAME_PREFIX	"BIN$"
protected static final int	PRIMARY_KEY_COLUMN_NAME_INDEX	4
protected static final int	PRIMARY_KEY_NAME_INDEX	6
protected static final String	PRIMARY_KEY_UNNAMED_KEY	"UNNAMED"
protected static final String	SINGLE_QUOTE	"\'"
protected static final int	TABLE_COMMENT_INDEX	5
protected static final String	TABLE_META_DATA_TYPE	"TABLE"
protected static final int	TABLE_NAME_INDEX	3