com.vp.plugin

Interface DatabaseManager

public interface DatabaseManager

Manage Database related functions. Provides a set of functions to generate SQL statements for Entities, Columns, Procedures, Triggers, etc...

Method Summary

Modifier and Type	Method and Description
java.lang.String	generateCreateSQL(DatabaseType aDatabaseType, IModelElement[] aModelElements) Generate create table statement for the selected entities.
java.lang.String	generateDeleteSQL(DatabaseType aDatabaseType, IModelElement[] aModelElements) Generate SQL statement for deleting records from selected entities.
java.lang.String	generateDropSQL(DatabaseType aDatabaseType, IModelElement[] aModelElements) Generate drop statement for the selected entities.
java.lang.String	generateInsertSQL(DatabaseType aDatabaseType, IModelElement[] aModelElements) Generate insert data statement for selected entities.
java.lang.String	generateInsertSQLForCustomSQL(DatabaseType aDatabaseType, IModelElement[] aModelElements) Generate insert data SQL statement for override default insert statement used in Hiberante.
java.lang.String	generateSelectSQL(DatabaseType aDatabaseType, IModelElement[] aModelElements) Generate select data statement for selected entities.
java.lang.String	generateUpdateSQL(DatabaseType aDatabaseType, IModelElement[] aModelElements) Generate alter statements for the selected entities.

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.