SQLEP Control directives old

###POJO directives

• resolve-pojo-off;
  • POJO validation inactive
• resolve-pojo-on;
  • POJO validation active

###Database directives

• database-active-schema SCHEMA_NAME;
  • Database active schema
• database-ddl-create DDL_SCRIPT_NAME;
  • DDL for on the fly database
• database-ddl-drop DDL_SCRIPT_NAME;
  • DDL for on the fly database
• database-debug-level [OFF | FATAL | ERROR | WANR | INFO | DEBUG | TRACE];
  • SQLEP can produce debug info on the console
• database-has-url URL_STRING;
  • Database URL to establish connection
• database-in-catalog CATALOG_NAME;
  • Database avtive catalog
• database-index-types INDEX_TYPE_NUMBER+;
  • For DatabaseMetaData getIndexInfo method usage
• database-is-offline;
  • Tables / columns validation inactive
• database-is-of-type [ORACLE | MY_SQL | HSQLDB | POSTGRESQL | INFORMIX | DB2 | MS_SQL];
  • One of supported database types, a generated info
• database-is-online;
  • Tables / columns validation active
• database-jdbc-driver [:JAVA_TYPE | DRIVER_STRING];
  • Database JDBC Driver to establish connection
• database-login-password PASSWORD_STRING;
  • Database user password to establish connection
• database-login-username USERNAME_STRING;
  • Database user login to establish connection
• database-show-database-info GENERATED_STRING;
  • Database meta info, generated value
• database-show-driver-info GENERATED_STRING;
  • JDBC Driver info, generated value
• database-show-driver-output [METHOD_NAME GENERATED_STRING]+;
  • DatabaseMetaData methods invocation output, generated values
• database-skip-check-constraints;
  • Skip columns check constraints in the generated artefacts (no enumerations)
• database-skip-functions-procedures;
  • Skip functions and procedures in the generated artefacts
• database-skip-indexes;
  • Skip indexes in the generated POJOs and META SQL statements

###POJO generation directives

• pojogen-create-columns TABLE_NAME [COLUMN_NAME->TYPE_NAME]+;
  • Columns positive selection
• pojogen-create-many-to-one TABLE_NAME [COLUMN_NAME->PRIMARY_TABLE_NAME->PRIMARY_COLUMN_NAME]+;
  • Handling many-to-one association
• pojogen-create-one-to-many TABLE_NAME [COLUMN_NAME->FOREIGN_TABLE_NAME->FOREIGN_COLUMN_NAME]+;
  • Handling one-to-many association
• pojogen-debug-level [OFF | FATAL | ERROR | WANR | INFO | DEBUG | TRACE];
  • SQLEP can produce debug info on the console
• pojogen-extends-class JAVA_TYPE;
  • Parent POJO
• pojogen-generate-methods [toString | hashCode | equals | isDef | enumDef | toInit | index= | enumInit]+;
  • POJO basic methods
  • POJO methods for associations
  • POJO methods for null handling
  • POJO methods overview
  • POJO methods for indexes
• pojogen-generate-operators [OPERATOR_NAME]?;
  • Dynamic/Static SQL operators
• pojogen-generate-wrappers;
  • Generate wrapper atrtributes in POJO
• pojogen-ignore-columns TABLE_NAME [COLUMN_NAME]+;
  • Columns negative selection
• pojogen-ignore-many-to-one TABLE_NAME [COLUMN_NAME->PRIMARY_TABLE_NAME-?PRIMARY_COLUMN_NAME]+;
  • Handling many-to-one association
• pojogen-ignore-one-to-many TABLE_NAME [COLUMN_NAME->FOREIGN_TABLE_NAME->FOREIGN_COLUMN_NAME]+;
  • Handling one-to-many association
• pojogen-ignore-tables [TABLE_NAME]+;
  • Tables negative selection
• pojogen-implementation-package PACKAGE;
  • Not used
• pojogen-implements-interfaces [JAVA_TYPE]+;
  • POJO interfaces
• pojogen-inherit-discriminator TABLE_NAME COLUMN_NAME [DISCRIMINATOR->TABLE_NAME[->COLUMN_NAME]+]+;
  • Handling inheritance
• pojogen-inherit-many-to-one TABLE_NAME [COLUMN_NAME->PRIMARY_TABLE_NAME->PRIMARY_COLUMN_NAME]+;
  • Handling inheritance
• pojogen-join-tables [TABLE_NAME[->TABLE_NAME]+]+;
  • Handling SELECT join
• pojogen-make-it-final;
  • Do not overwritte in generation
• pojogen-not-abstract-tables [TABLE_NAME]+;
  • Suppress POJO to be abstract
• pojogen-not-required-columns TABLE_NAME [COLUMN_NAME]+;
  • Requirements modification
• pojogen-only-tables [TABLE_NAME]+;
  • Tables positive selection
• pojogen-pojos-for-procedures [PROCEDURE_NAME POJO_NAME]+
• pojogen-pojos-for-functions [FUNCTION_NAME POJO_NAME]+
• pojogen-preserve-foreign-keys [TABLE_NAME]*;
  • The foreign keys in POJO
• pojogen-rename-columns TABLE_NAME [COLUMN_NAME->NEW_COLUMN_NAME]+;
  • Columns name modification
• pojogen-rename-tables [TABLE_NAME->NEW_ TABLE_NAME]+;
  • Tables name modification
• pojogen-required-columns TABLE_NAME [COLUMN_NAME]+;
  • Requirements modification
• pojogen-show-type-for-column TABLE_NAME COLUMN_NAME->GENERATED_JAVA_TYPE;
  • Asking for database column type, generated value
• pojogen-table-many-to-many TABLE_NAME [PRIMARY_COLUMN_NAME->PRIMARY_ TABLE_NAME[->FOREIGN_COLUMN_NAME]?]+;
  • Handling many-to-many association
• pojogen-types-for-columns TABLE_NAME [COLUMN_NAME->TYPE]+;
  • Columns global type modification
• pojogen-types-in-table TABLE_NAME [TYPE[(SIZE)]?->JAVA_TYPE]+;
  • Columns type modification in table
• pojogen-types-for-procedure [PROCEDURE_NAME PARAMETER_NAME->TYPE]+
• pojogen-types-for-function [FUNCTION_NAME PARAMETER_NAME->TYPE]+
• pojogen-types-sqltypes [TYPE_NAME[(SIZE)]?->JAVA_TYPE]+;
  • Types modification
• pojogen-version-column VERSION_COLUMN_NAME [TABLE_NAME]*;
  • Optimistic locking

###META SQL generation directives

• metagen-column-meta-type TABLE_NAME [COLUMN_NAME->META_TYPE_NAME[->EXTENSION_VALUE)+;
  • Meta types
• metagen-debug-level [OFF | FATAL | ERROR | WANR | INFO | DEBUG | TRACE];
  • SQLEP can produce debug info on the console
• metagen-function-result-set FUNCTION_NAME TABLE_NAME;
  • Procedures and functions handling
• metagen-function-result FUNCTION_NAME TYPE_NAME;
  • Procedures and functions handling
• metagen-generate-identities;
  • Improved identities statements generation
• metagen-generate-operators;
  • Dynamic/Static SQL operators
• metagen-generate-sequences;
  • Improved sequences statements generation
• metagen-global-identity IDENTITY_NAME [TYPE_NAME]?;
  • Identities
• metagen-global-sequence SEQUENCE_NAME [TYPE_NAME]?;
  • Sequences
• metagen-like-columns TABLE_NAME [COLUMN_NAME]+;
  • SELECT like handling
• metagen-make-it-final;
  • Do not overwritte in generation
• metagen-not-like-columns TABLE_NAME [COLUMN_NAME]+;
  • SELECT like handling
• metagen-optimize-insert [TABLE_NAME]*;
  • Not yet implemented
• metagen-optional-features STATEMENT_NAME [OPTIONAL_FEATURE]+;
  • Put optional features into generated META SQL
• metagen-procedure-result-set PROCEDURE_NAME TABLE_NAME;
  • Procedures and functions
• metagen-statement-meta-type STATEMENT_NAME [COLUMN_NAME->META_TYPE_NAME[->EXTENSION_VALUE)+;
  • META types
• metagen-table-identity TABLE_NAME IDENTITY_NAME [TYPE_NAME]?;
  • Table identities
• metagen-table-sequence TABLE_NAME SEQUENCE_NAME [TYPE_NAME]?;
  • Table sequences

###DAO generation directives

• daogen-debug-level [OFF | FATAL | ERROR | WANR | INFO | DEBUG | TRACE];
  • SQLEP can produce debug info on the console
• daogen-extends-class JAVA_TYPE;
  • Parent DAO
• daogen-function-result FUNCTION_NAME JAVA_TYPE;
  • Not used
• daogen-ignore-tables [TABLE_NAME]+;
  • Tables/POJOs negative selection
• daogen-implementation-package PACKAGE;
  • Implementation separated from interface
• daogen-implements-interfaces [JAVA_TYPE]+;
  • DAO interfaces
• daogen-make-it-final;
  • Do not overwritte in generation
• daogen-only-tables [TABLE_NAME]*;
  • Tables/POJOs positive selection

###General directives

• replace-all-regex ID_REL SUBSTITUTED_STRING;
• eplace-all-replacement ID_REL SUBSTITUTION_STRING;