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 {@link #getCreate(Schema)}. 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 {@link #getCreate(Table,boolean)} 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 {@link #getCreate(Table)}. 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 {@link #getCreate(Index)}
and {@link #getCreate(ForeignKey)} 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 {@link #getDrop(Schema)}. 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 {@link #getDrop(Table,boolean)} 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 {@link #getDrop(Table)}. 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 {@link #getDrop(Index)}
and {@link #getDrop(ForeignKey)} 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.