Method Detail

• generateInsertSQL

  java.lang.String generateInsertSQL(DatabaseType aDatabaseType,
                                     IModelElement[] aModelElements)

  Generate insert data statement for selected entities. The values for the column will shown as "?". User can replace "?" with proper value to execute the insert statement to database.

  e.g.: INSERT INTO Entity(ID, `Column`, Column2, Column3) VALUES (?, ?, ?, ?);

  Parameters:

  aDatabaseType - - the target database type.

  aModelElements - - the model elements for generate SQL statements.

  Returns:

  the insert data SQL statement for the selected entities.

• generateUpdateSQL

  java.lang.String generateUpdateSQL(DatabaseType aDatabaseType,
                                     IModelElement[] aModelElements)

  Generate alter statements for the selected entities. The values to be updated will shown as "?". User can replace "?" with proper value to execute the statement to database.

  e.g.: UPDATE Entity SET `Column` = ?, Column2 = ?, Column3 = ? WHERE ID = ?;

  Parameters:

  aDatabaseType - - the target database type.

  aModelElements - - the model elements for generate SQL statements.

  Returns:

  the alter table SQL statement for the selected entities.

• generateCreateSQL

  java.lang.String generateCreateSQL(DatabaseType aDatabaseType,
                                     IModelElement[] aModelElements)

  Generate create table statement for the selected entities.

  Parameters:

  aDatabaseType - - the target database type.

  aModelElements - - the model elements for generate SQL statements.

  Returns:

  the create table statement for the selected entities.

• generateDeleteSQL

  java.lang.String generateDeleteSQL(DatabaseType aDatabaseType,
                                     IModelElement[] aModelElements)

  Generate SQL statement for deleting records from selected entities. The record to be delete is identified by the primary key value which present as "?" in generated statement. User can replace "?" with proper value to execute the statement to database.

  e.g.: DELETE FROM Entity WHERE ID = ?;

  Parameters:

  aDatabaseType - - the target database type.

  aModelElements - - the model elements for generate SQL statements.

  Returns:

  the delete statement SQL statement for deleting records from the selected entities

• generateSelectSQL

  java.lang.String generateSelectSQL(DatabaseType aDatabaseType,
                                     IModelElement[] aModelElements)

  Generate select data statement for selected entities.

  e.g.: SELECT ID, `Column`, Column2, Column3 FROM Entity;

  Parameters:

  aDatabaseType - - the target database type.

  aModelElements - - the model elements for generate SQL statements.

  Returns:

  the select statement for the selected entities.

• generateDropSQL

  java.lang.String generateDropSQL(DatabaseType aDatabaseType,
                                   IModelElement[] aModelElements)

  Generate drop statement for the selected entities.

  Parameters:

  aDatabaseType - - the target database type.

  aModelElements - - the model elements for generate SQL statements.

  Returns:

  the drop table statement for the selected entities.

• generateInsertSQLForCustomSQL

  java.lang.String generateInsertSQLForCustomSQL(DatabaseType aDatabaseType,
                                                 IModelElement[] aModelElements)

  Generate insert data SQL statement for override default insert statement used in Hiberante. The values for the column will shown as "?". User can replace "?" with proper value to execute the insert statement to database.

  e.g.: INSERT INTO Entity(Attribute, Attribute2, ID) VALUES (?, ?, ?);

  Parameters:

  aDatabaseType - - the target database type.

  aModelElements - - the model elements for generate SQL statements.

  Returns:

  the insert data statement for override default insert statement used in Hibernate.