CreateH2DdlFromSchemaDef (Data Pipeline JavaDoc)

java.lang.Object
- com.northconcepts.datapipeline.jdbc.sql.SqlPart
- - com.northconcepts.datapipeline.sql.h2.H2SqlPart
  - - com.northconcepts.datapipeline.sql.h2.CreateH2DdlFromSchemaDef

```
public class CreateH2DdlFromSchemaDef
extends H2SqlPart
```
Generates H2 DDL from SchemaDef

Sample Generated SQL:

DROP TABLE IF EXISTS table_name; CREATE TABLE IF NOT EXISTS table_name ( user_id bigint, email text, PRIMARY KEY (user_id) ); CREATE INDEX idx_email ON table_name (email); ALTER TABLE foreign_table_name ADD CONSTRAINT fk_constraint_name FOREIGN KEY(fk_field_name) REFERENCES primary_table_name (pk_field_name) ON DELETE CASCADE ON UPDATE RESTRICT;

Constructor Summary

Constructors
Constructor and Description

CreateH2DdlFromSchemaDef(SchemaDef schemaDef)

Constructors
Constructor and Description
`CreateH2DdlFromSchemaDef(SchemaDef schemaDef)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`collectSqlFragment(CodeWriter writer)` Generates DDL from `schemaDef` and writes the output to `writer`.
`Integer`	`getDefaultBigDecimalPrecision()` Returns the default precision of `FieldType.BIG_DECIMAL` (default 20).
`Integer`	`getDefaultBigDecimalScale()` Sets the default scale of `FieldType.BIG_DECIMAL` (default 5).
`Integer`	`getDefaultBigIntegerPrecision()` Returns the default precision of `FieldType.BIG_INTEGER` (default 20).
`List<String>`	`getEntityNames()` Returns entity names that are specified by `setEntityNames(java.util.List<java.lang.String>)` to be included in the output DDL.
`SchemaDef`	`getSchemaDef()` Returns provided `schemaDef`.
`boolean`	`isCheckIfDropTableExists()` Indicates if `IF EXISTS` clause should be included in the `DROP TABLE` statement (default is true).
`boolean`	`isCheckIfTableNotExists()` Indicates if `IF NOT EXISTS` clause should be included in the `CREATE TABLE` statement (default is true).
`boolean`	`isDropTable()` Indicates if drop table statement should be included in the output DDL for each entity in the `schemaDef` (default true).
`boolean`	`isGenerateIndexes()` Indicates if DDL should be generated for indexes in the `schemaDef` (default is true).
`boolean`	`isGenerateRelationships()` Indicates if DDL should be generated for relationships in the `schemaDef` (default is true).
`CreateH2DdlFromSchemaDef`	`setCheckIfDropTableExists(boolean checkIfDropTableExists)` Indicates if `IF EXISTS` clause should be included in the `DROP TABLE` statement (default is true).
`CreateH2DdlFromSchemaDef`	`setCheckIfTableNotExists(boolean checkIfTableNotExists)` Indicates if `IF NOT EXISTS` clause should be included in the `CREATE TABLE` statement (default is true).
`CreateH2DdlFromSchemaDef`	`setDefaultBigDecimalPrecision(int defaultBigDecimalPrecision)` Sets a default precision for `FieldType.BIG_DECIMAL`. This value will be used if no precision is specified for `BIG_DECIMAL` fields (default 20).
`CreateH2DdlFromSchemaDef`	`setDefaultBigDecimalScale(Integer defaultBigDecimalScale)` Sets a default scale for `FieldType.BIG_DECIMAL` (default 5). This value will be used if no scale is specified for `BIG_DECIMAL` fields.
`CreateH2DdlFromSchemaDef`	`setDefaultBigIntegerPrecision(int defaultBigIntegerPrecision)` Sets a default precision for `FieldType.BIG_INTEGER` (default 20). This value will be used if no precision is specified for `BIG_INTEGER` fields.
`CreateH2DdlFromSchemaDef`	`setDropTable(boolean dropTable)` Indicates if drop table statement should be included in the output DDL for each entity in the `schemaDef` (default true).
`CreateH2DdlFromSchemaDef`	`setEntityNames(List<String> entityNames)` Set entity names that should be included in the output DDL (all entities will be included by default).
`CreateH2DdlFromSchemaDef`	`setEntityNames(String... entityNames)` Set entity names that should be included in the output DDL (all entities will be included by default).
`CreateH2DdlFromSchemaDef`	`setGenerateIndexes(boolean generateIndexes)` Indicates if DDL should be generated for indexes in the `schemaDef` (default is true).
`CreateH2DdlFromSchemaDef`	`setGenerateRelationships(boolean generateRelationships)` Indicates if DDL should be generated for indexes in the `schemaDef` (default is true).
`CreateH2DdlFromSchemaDef`	`setPretty(boolean pretty)` Indicates if line breaks and indentations should be added to output DDL (default false). Example output (pretty = true): `CREATE TABLE IF NOT EXISTS table_name ( id bigint, email text PRIMARY KEY (user_id) );` Example output (pretty = false): `CREATE TABLE IF NOT EXISTS table_name (id bigint, email text, PRIMARY KEY (user_id));`

Methods inherited from class com.northconcepts.datapipeline.sql.h2.H2SqlPart
escapeKeyword, placeBackTicks

Methods inherited from class com.northconcepts.datapipeline.jdbc.sql.SqlPart
collectParameterValues, getParameterValues, getSqlFragment, isPretty, printSqlParts, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - CreateH2DdlFromSchemaDef
```
public CreateH2DdlFromSchemaDef(SchemaDef schemaDef)
```
- Method Detail
  - collectSqlFragment
```
public void collectSqlFragment(CodeWriter writer)
```
    Generates DDL from schemaDef and writes the output to writer.
    
    Specified by:
    
    collectSqlFragment in class SqlPart
  - getSchemaDef
```
public SchemaDef getSchemaDef()
```
    Returns provided schemaDef.
  - isGenerateIndexes
```
public boolean isGenerateIndexes()
```
    Indicates if DDL should be generated for indexes in the schemaDef (default is true).
  - setGenerateIndexes
```
public CreateH2DdlFromSchemaDef setGenerateIndexes(boolean generateIndexes)
```
    Indicates if DDL should be generated for indexes in the schemaDef (default is true).
  - isGenerateRelationships
```
public boolean isGenerateRelationships()
```
    Indicates if DDL should be generated for relationships in the schemaDef (default is true).
  - setGenerateRelationships
```
public CreateH2DdlFromSchemaDef setGenerateRelationships(boolean generateRelationships)
```
    Indicates if DDL should be generated for indexes in the schemaDef (default is true).
  - isCheckIfTableNotExists
```
public boolean isCheckIfTableNotExists()
```
    Indicates if IF NOT EXISTS clause should be included in the CREATE TABLE statement (default is true).
  - setCheckIfTableNotExists
```
public CreateH2DdlFromSchemaDef setCheckIfTableNotExists(boolean checkIfTableNotExists)
```
    Indicates if IF NOT EXISTS clause should be included in the CREATE TABLE statement (default is true).
  - isCheckIfDropTableExists
```
public boolean isCheckIfDropTableExists()
```
    Indicates if IF EXISTS clause should be included in the DROP TABLE statement (default is true).
  - setCheckIfDropTableExists
```
public CreateH2DdlFromSchemaDef setCheckIfDropTableExists(boolean checkIfDropTableExists)
```
    Indicates if IF EXISTS clause should be included in the DROP TABLE statement (default is true).
  - getEntityNames
```
public List<String> getEntityNames()
```
    Returns entity names that are specified by setEntityNames(java.util.List<java.lang.String>) to be included in the output DDL.
  - setEntityNames
```
public CreateH2DdlFromSchemaDef setEntityNames(List<String> entityNames)
```
    Set entity names that should be included in the output DDL (all entities will be included by default).
    
    Entities that are not listed in entityNames will be excluded from the generated SQL including relationships that involve any of them.
  - setEntityNames
```
public CreateH2DdlFromSchemaDef setEntityNames(String... entityNames)
```
    Set entity names that should be included in the output DDL (all entities will be included by default).
    
    Entities that are not listed in entityNames will be excluded from the generated SQL including relationships that involve any of them.
  - setPretty
```
public CreateH2DdlFromSchemaDef setPretty(boolean pretty)
```
    Indicates if line breaks and indentations should be added to output DDL (default false).
    
    Example output (pretty = true):
    CREATE TABLE IF NOT EXISTS table_name ( id bigint, email text PRIMARY KEY (user_id) );
    Example output (pretty = false):
    CREATE TABLE IF NOT EXISTS table_name (id bigint, email text, PRIMARY KEY (user_id));
    
    Overrides:
    
    setPretty in class SqlPart
  - isDropTable
```
public boolean isDropTable()
```
    Indicates if drop table statement should be included in the output DDL for each entity in the schemaDef (default true).
  - setDropTable
```
public CreateH2DdlFromSchemaDef setDropTable(boolean dropTable)
```
    Indicates if drop table statement should be included in the output DDL for each entity in the schemaDef (default true).
  - getDefaultBigIntegerPrecision
```
public Integer getDefaultBigIntegerPrecision()
```
    Returns the default precision of FieldType.BIG_INTEGER (default 20).
  - setDefaultBigIntegerPrecision
```
public CreateH2DdlFromSchemaDef setDefaultBigIntegerPrecision(int defaultBigIntegerPrecision)
```
    Sets a default precision for FieldType.BIG_INTEGER (default 20).
    This value will be used if no precision is specified for BIG_INTEGER fields.
  - getDefaultBigDecimalPrecision
```
public Integer getDefaultBigDecimalPrecision()
```
    Returns the default precision of FieldType.BIG_DECIMAL (default 20).
  - setDefaultBigDecimalPrecision
```
public CreateH2DdlFromSchemaDef setDefaultBigDecimalPrecision(int defaultBigDecimalPrecision)
```
    Sets a default precision for FieldType.BIG_DECIMAL.
    This value will be used if no precision is specified for BIG_DECIMAL fields (default 20).
  - getDefaultBigDecimalScale
```
public Integer getDefaultBigDecimalScale()
```
    Sets the default scale of FieldType.BIG_DECIMAL (default 5).
  - setDefaultBigDecimalScale
```
public CreateH2DdlFromSchemaDef setDefaultBigDecimalScale(Integer defaultBigDecimalScale)
```
    Sets a default scale for FieldType.BIG_DECIMAL (default 5).
    This value will be used if no scale is specified for BIG_DECIMAL fields.

Class CreateH2DdlFromSchemaDef

Constructor Summary

Method Summary

Methods inherited from class com.northconcepts.datapipeline.sql.h2.H2SqlPart

Methods inherited from class com.northconcepts.datapipeline.jdbc.sql.SqlPart

Methods inherited from class java.lang.Object

Constructor Detail

CreateH2DdlFromSchemaDef

Method Detail

collectSqlFragment

getSchemaDef

isGenerateIndexes

setGenerateIndexes

isGenerateRelationships

setGenerateRelationships

isCheckIfTableNotExists

setCheckIfTableNotExists

isCheckIfDropTableExists

setCheckIfDropTableExists

getEntityNames

setEntityNames

setEntityNames

setPretty

isDropTable

setDropTable

getDefaultBigIntegerPrecision

setDefaultBigIntegerPrecision

getDefaultBigDecimalPrecision

setDefaultBigDecimalPrecision

getDefaultBigDecimalScale

setDefaultBigDecimalScale