|
Dresden OCL Toolkit | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
This interface specifies methodes to build SQL code. It should be implemented by classes to build database specific statements. This interface realizes the builder interface of the Builder pattern from Gamma. The director part is realized by implementations of the SQLDirector interface. The product is a String. See the OracleSQLBuilder for an example how to implement a SQLBuilder. Basically, the product should be build by concatenating single parts.
SQLDirector
Method Summary | |
void |
addAlias(String name)
|
void |
addAnd()
|
void |
addColumn(String name)
|
void |
addColumn(String colName,
boolean isOptional,
String colType)
|
void |
addColumn(String colName,
String colType,
boolean pk)
|
void |
addColumnSeparator()
|
void |
addEquation(String op1,
String op2)
|
void |
addFKConstraint(String conName,
String tableName,
String[] colName,
String fkTable,
String[] fkColName)
|
void |
addFKConstraint(String conName,
String tableName,
String colName,
String fkTable,
String fkColName)
|
void |
addTable(String name)
|
void |
beginTable(String tableName)
|
void |
createAssertionReplacement(String triggerName,
String tableName,
String viewName,
String errMsg)
|
void |
createECATriggerTemplate(String triggerName,
String tableName,
String viewName)
|
void |
createFrom()
|
void |
createSelect()
|
void |
createUnion()
|
void |
createView(String name,
boolean alias)
|
void |
createWhere()
|
void |
endStatement()
adds a statement seperator for sql-scripts |
void |
endTable()
|
void |
endView()
|
String |
getCode()
|
String |
getDescription()
|
void |
reset()
Resets the Builder to an empty product. |
Method Detail |
public String getCode()
public void reset()
public void beginTable(String tableName)
public void addColumn(String colName, String colType, boolean pk)
public void addColumn(String colName, boolean isOptional, String colType)
public void addColumnSeparator()
public void endTable()
public void addFKConstraint(String conName, String tableName, String colName, String fkTable, String fkColName)
public void addFKConstraint(String conName, String tableName, String[] colName, String fkTable, String[] fkColName)
public void createView(String name, boolean alias)
public void addAlias(String name)
public void endView()
public void createAssertionReplacement(String triggerName, String tableName, String viewName, String errMsg)
public void createECATriggerTemplate(String triggerName, String tableName, String viewName)
public void createSelect()
public void addColumn(String name)
public void createFrom()
public void addTable(String name)
public void createWhere()
public void createUnion()
public void addEquation(String op1, String op2)
public void addAnd()
public String getDescription()
public void endStatement()
|
Dresden OCL Toolkit | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |