org.apache.ws.jaxme.sqls
public interface SQLGenerator
An SQL generator.
Method Summary | |
---|---|
String | getConstraint(Constraint pConstraint) Generates the WHERE clause of a SELECT, UPDATE, or DELETE statement. |
Collection | getCreate(Schema pSchema) Generates a |
Collection | getCreate(Schema pSchema, boolean pAll) Generates |
Collection | getCreate(Table pTable) Generates a CREATE TABLE statement. |
Collection | getCreate(Table pTable, boolean pAll) Generates |
Collection | getCreate(Index pIndex) Generates a CREATE INDEX statement. |
Collection | getCreate(ForeignKey pKey) Generates a CREATE FOREIGN KEY statement. |
Collection | getDrop(Schema pSchema) Generates a DROP SCHEMA statement. |
Collection | getDrop(Schema pSchema, boolean pAll) Generates |
Collection | getDrop(Table pTable) Generates a DROP TABLE statement. |
Collection | getDrop(Table pTable, boolean pAll) Generates |
Collection | getDrop(Index pIndex) Generates a DROP INDEX statement. |
Collection | getDrop(ForeignKey pKey) Generates a DROP FOEIGN KEY statement. |
String | getLineTerminator() Returns the line terminator. |
String | getQuery(Statement pStatement) Generates an INSERT, UPDATE, DELETE or SELECT statement. |
String | getStatementTerminator() Returns the statement terminator. |
String | getWhereClause(SelectStatement pQuery) Returns the |
void | setLineTerminator(String pTerminator) Sets the line terminator. |
void | setStatementTerminator(String pTerminator) Sets the statement terminator. |
Generates the WHERE clause of a SELECT, UPDATE, or DELETE statement.
Generates a CREATE SCHEMA
statement. Doesn't create
CREATE TABLE
or similar statements.
Generates CREATE
statements for the schema.
Parameters: pAll If this parameter is set to true, then the method is
equivalent to getCreate. Otherwise the returned
collection will also include CREATE
statements for
all the tables and indexes in the schema. These additional statements
are created by invoking SQLGenerator for all the
tables in the schema.
Generates a CREATE TABLE statement. Doesn't create
CREATE INDEX
or similar statements.
Generates CREATE
statements for the table.
Parameters: pAll If this parameter is set to true, then the method is
equivalent to getCreate. Otherwise the returned
collection will also include CREATE
statements for
the indexes, which are defined on the table. These additional
statements are created by invoking getCreate
and getCreate for all the indexes in the
schema.
Generates a CREATE INDEX statement.
Generates a CREATE FOREIGN KEY statement.
Generates a DROP SCHEMA statement. Doesn't create
DROP TABLE
or similar statements.
Generates DROP
statements for the schema.
Parameters: pAll If this parameter is set to true, then the method is
equivalent to getDrop. Otherwise the returned
collection will also include DROP
statements for
all the tables and indexes in the schema. These additional statements
are created by invoking SQLGenerator for all the
tables in the schema.
Generates a DROP TABLE statement. Doesn't create
DROP INDEX
or similar statements.
Generates DROP
statements for the table.
Parameters: pAll If this parameter is set to true, then the method is
equivalent to getDrop. Otherwise the returned
collection will also include DROP
statements for
the indexes, which are defined on the table. These additional
statements are created by invoking getDrop
and getDrop for all the indexes in the
schema.
Generates a DROP INDEX statement.
Generates a DROP FOEIGN KEY statement.
Returns the line terminator. A non-null value indicates that the generated statements should be made human readable by splitting them over multiple lines. A null value ensures that a statement consists of a single line only. Defaults to "\n".
Generates an INSERT, UPDATE, DELETE or SELECT statement.
Returns the statement terminator. A non-null value will be appended to all generated statements. Defaults to null.
Returns the WHERE ... ORDER BY ...
part
of the SELECT statement.
Sets the line terminator. A non-null value indicates that the generated statements should be made human readable by splitting them over multiple lines. A null value ensures that a statement consists of a single line only. Defaults to "\n".
Sets the statement terminator. A non-null value will be appended to all generated statements. Defaults to null.