tudresden.ocl.sql
Class SybaseSQLBuilder

java.lang.Object
  tudresden.ocl.sql.SybaseSQLBuilder

All Implemented Interfaces:

SQLBuilder

public class SybaseSQLBuilder

extends Object

implements SQLBuilder

implementation of the SQLBuilder for Sybase DBMS

Author:

Andrea Kling

Field Summary

private int	aliasCount
private Hashtable	datatypes
private int	nextAliasPos
private String	pks
private HashSet	reserved
private StringBuffer	theCode

Constructor Summary

SybaseSQLBuilder()

Method Summary

void	addAlias(String name)
void	addAnd()
void	addColumn(String name)
void	addColumn(String colName, boolean optional, String colType)
void	addColumn(String colName, String type, 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 constrName, String tableName, String colName, String fkTable, String fkColName)
void	addTable(String name)
void	beginTable(String tableName)
private String	check(String word)
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()
private String	indent(int length)
void	reset() Resets the Builder to an empty product.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

datatypes

private Hashtable datatypes

theCode

private StringBuffer theCode

nextAliasPos

private int nextAliasPos

aliasCount

private int aliasCount

pks

private String pks

reserved

private HashSet reserved

Constructor Detail

SybaseSQLBuilder

public SybaseSQLBuilder()

Method Detail

addAlias

public void addAlias(String name)

Specified by:

addAlias in interface SQLBuilder

addAnd

public void addAnd()

Specified by:

addAnd in interface SQLBuilder

addColumn

public void addColumn(String name)

Specified by:

addColumn in interface SQLBuilder

indent

private String indent(int length)

check

private String check(String word)

addColumn

public void addColumn(String colName,
                      String type,
                      boolean pk)

Specified by:

addColumn in interface SQLBuilder

addColumn

public void addColumn(String colName,
                      boolean optional,
                      String colType)

Specified by:

addColumn in interface SQLBuilder

addColumnSeparator

public void addColumnSeparator()

Specified by:

addColumnSeparator in interface SQLBuilder

addEquation

public void addEquation(String op1,
                        String op2)

Specified by:

addEquation in interface SQLBuilder

addFKConstraint

public void addFKConstraint(String constrName,
                            String tableName,
                            String colName,
                            String fkTable,
                            String fkColName)

Specified by:

addFKConstraint in interface SQLBuilder

addFKConstraint

public void addFKConstraint(String conName,
                            String tableName,
                            String[] colName,
                            String fkTable,
                            String[] fkColName)

Specified by:

addFKConstraint in interface SQLBuilder

addTable

public void addTable(String name)

Specified by:

addTable in interface SQLBuilder

beginTable

public void beginTable(String tableName)

Specified by:

beginTable in interface SQLBuilder

createAssertionReplacement

public void createAssertionReplacement(String triggerName,
                                       String tableName,
                                       String viewName,
                                       String errMsg)

Specified by:

createAssertionReplacement in interface SQLBuilder

createECATriggerTemplate

public void createECATriggerTemplate(String triggerName,
                                     String tableName,
                                     String viewName)

Specified by:

createECATriggerTemplate in interface SQLBuilder

createSelect

public void createSelect()

Specified by:

createSelect in interface SQLBuilder

createFrom

public void createFrom()

Specified by:

createFrom in interface SQLBuilder

createWhere

public void createWhere()

Specified by:

createWhere in interface SQLBuilder

createUnion

public void createUnion()

Specified by:

createUnion in interface SQLBuilder

createView

public void createView(String name,
                       boolean alias)

Specified by:

createView in interface SQLBuilder

endTable

public void endTable()

Specified by:

endTable in interface SQLBuilder

endView

public void endView()

Specified by:

endView in interface SQLBuilder

endStatement

public void endStatement()

Description copied from interface: SQLBuilder

adds a statement seperator for sql-scripts

Specified by:

endStatement in interface SQLBuilder

getCode

public String getCode()

Specified by:

getCode in interface SQLBuilder

Returns:

the product that was build (database specific DDL)

reset

public void reset()

Description copied from interface: SQLBuilder

Resets the Builder to an empty product.

Specified by:

reset in interface SQLBuilder

getDescription

public String getDescription()

Specified by:

getDescription in interface SQLBuilder

Returns:

a description of the database system(s) the builder is for