Constant Field Values

Contents

• org.kuali.*

org.kuali.*

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	STATEMENT_SEPARATOR	"/"
public static final String	TYPE_SIZE_PREFIX	"("
public static final String	TYPE_SIZE_SUFFIX	")"

org.kuali.common.impex.data.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.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.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.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_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_PAREN	"("
public static final String	SPACE	" "

org.kuali.common.impex.schema.ExportSchemaExecutable

public static final boolean

DEFAULT_SKIP_EXECUTION

false

org.kuali.common.impex.schema.MySqlSequenceFinder

public static final String

SUPPORTED_VENDOR

"mysql"

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.ProduceSchemaExecutable

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

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.MySqlSchemaProducer

public static final String

SUPPORTED_VENDOR

"mysql"

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.OracleSchemaProducer

public static final String

SUPPORTED_VENDOR

"oracle"

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.spring.DataTypeMappingProviderConfig

protected static final String

DB_VENDOR_KEY

"db.vendor"

org.kuali.common.impex.spring.ExportDataConfig

protected static final String	DATA_INTERVAL_KEY	"impex.export.data.dataInterval"
protected static final String	DATA_THREADS_KEY	"impex.export.data.threads"
protected static final String	PROJECT_PREFIX	"impex."
protected static final String	ROW_INTERVAL_KEY	"impex.export.data.rowInterval"
protected static final String	SKIP_EXECUTE_KEY	"impex.export.skip"
protected static final String	STATISTICS_LOCATION_KEY	"impex.export.data.statistics.location"
protected static final String	TABLE_NAME_EXCLUDE_KEY	"impex.export.data.exclude"
protected static final String	TABLE_NAME_INCLUDE_KEY	"impex.export.data.include"
protected static final String	WORKING_DIR_KEY	"impex.export.data.workingDir"

org.kuali.common.impex.spring.ExportSchemaConfig

protected static final String	EXPORT_SCHEMA_SERVICE_KEY	"impex.export.schema.service"
protected static final String	FOREIGNKEY_LOCATION_KEY	"impex.export.schema.foreignkeys.location"
protected static final String	FOREIGNKEYS_EXCLUDE_KEY	"impex.export.schema.foreignkeys.exclude"
protected static final String	FOREIGNKEYS_INCLUDE_KEY	"impex.export.schema.foreignkeys.include"
protected static final String	PROJECT_PREFIX	"impex."
protected static final String	SCHEMA_LOCATION_KEY	"impex.export.schema.location"
protected static final String	SEQUENCES_EXCLUDE_KEY	"impex.export.schema.sequences.exclude"
protected static final String	SEQUENCES_INCLUDE_KEY	"impex.export.schema.sequences.include"
protected static final String	SEQUENCES_LOCATION_KEY	"impex.export.schema.sequences.location"
protected static final String	SKIP_EXECUTION_KEY	"impex.export.skip"
protected static final String	TABLES_EXCLUDE_KEY	"impex.export.schema.tables.exclude"
protected static final String	TABLES_INCLUDE_KEY	"impex.export.schema.tables.include"
protected static final String	TABLES_LOCATION_KEY	"impex.export.schema.tables.location"
protected static final String	VIEWS_EXCLUDE_KEY	"impex.export.schema.views.exclude"
protected static final String	VIEWS_INCLUDE_KEY	"impex.export.schema.views.include"
protected static final String	VIEWS_LOCATION_KEY	"impex.export.schema.views.location"

org.kuali.common.impex.spring.LiquibaseSchemaConfig

protected static final String

DB_VENDOR_KEY

"db.vendor"

org.kuali.common.impex.spring.ModularDataExportConfig

public static final String	DATA_INTERVAL_KEY	"data.dataInterval"
public static final String	DATA_THREADS_KEY	"data.threads"
public static final String	NAME_EXCLUDE_KEY	"data.exclude"
public static final String	NAME_INCLUDE_KEY	"data.include"
public static final String	OUTPUT_LOCATION_KEY	"data.output"
public static final String	PROPERTY_PREFIXES_KEY	"impex.export.data.modular.prefixes"
public static final String	ROW_INTERVAL_KEY	"data.rowInterval"
public static final String	SKIP_EXECUTION_KEY	"data.skip"
public static final String	STATISTICS_LOCATION_KEY	"impex.export.data.statistics.location"

org.kuali.common.impex.spring.ModularSchemaExportConfig

public static final boolean	DEFAULT_SEPARATE_FOREIGN_KEYS	true
public static final String	EXECUTION_SKIP_KEY	"schema.skip"
public static final String	FOREIGN_KEY_OUTPUT_LOCATION_KEY	"schema.foreignKeys.output"
public static final String	NAME_EXCLUDE_KEY	"schema.exclude"
public static final String	NAME_INCLUDE_KEY	"schema.include"
public static final String	OUTPUT_LOCATION_KEY	"schema.output"
public static final String	PROPERTY_PREFIXES_KEY	"impex.export.schema.modular.prefixes"
public static final String	SEPARATE_FOREIGN_KEYS_KEY	"schema.foreignKeys.separate"

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.SchemaSqlProducerConfig

protected static final String

DB_VENDOR_KEY

"db.vendor"

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.ExportConstants

public static final String	DEFAULT_EXCLUDE	""
public static final String	DEFAULT_INCLUDE	".*"

org.kuali.common.impex.util.ExportSchemaUtility

protected static final String	CUSTOM_KEY	"custom="
protected static final String	LIQUIBASE_KEY	"lb"
protected static final String	XML_KEY	"xml"

org.kuali.common.impex.util.ExportUtils

protected static final String	ROWS_PROPERTY_SUFFIX	".rows"
protected static final String	SIZE_PROPERTY_SUFFIX	".size"