|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object com.vaadin.data.util.sqlcontainer.query.generator.DefaultSQLGenerator
public class DefaultSQLGenerator
Generates generic SQL that is supported by HSQLDB, MySQL and PostgreSQL.
Constructor Summary | |
---|---|
DefaultSQLGenerator()
|
|
DefaultSQLGenerator(String quoteStart,
String quoteEnd)
Construct a DefaultSQLGenerator with the specified identifiers for start and end of quoted strings. |
Method Summary | |
---|---|
protected Map<String,Object> |
generateColumnToValueMap(RowItem item)
|
StatementHelper |
generateDeleteQuery(String tableName,
List<String> primaryKeyColumns,
String versionColumn,
RowItem item)
Generates a DELETE query for deleting data related to the given RowItem from the database. |
StatementHelper |
generateInsertQuery(String tableName,
RowItem item)
Generates an INSERT query for inserting a new row with the provided values. |
protected StringBuffer |
generateLimits(StringBuffer sb,
int offset,
int pagelength)
Generates the LIMIT and OFFSET clause. |
protected StringBuffer |
generateOrderBy(StringBuffer sb,
OrderBy o,
boolean firstOrderBy)
Generates sorting rules as an ORDER BY -clause |
protected Map<String,Object> |
generateRowIdentifiers(RowItem item)
|
StatementHelper |
generateSelectQuery(String tableName,
List<Container.Filter> filters,
List<OrderBy> orderBys,
int offset,
int pagelength,
String toSelect)
Generates a SELECT query with the provided parameters. |
StatementHelper |
generateUpdateQuery(String tableName,
RowItem item)
Generates an UPDATE query with the provided parameters. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public DefaultSQLGenerator()
public DefaultSQLGenerator(String quoteStart, String quoteEnd)
quoteStart
- the identifier (character) denoting the start of a quoted
stringquoteEnd
- the identifier (character) denoting the end of a quoted stringMethod Detail |
---|
public StatementHelper generateSelectQuery(String tableName, List<Container.Filter> filters, List<OrderBy> orderBys, int offset, int pagelength, String toSelect)
SQLGenerator
generateSelectQuery
in interface SQLGenerator
tableName
- Name of the table queriedfilters
- The filters, converted into a WHERE clauseorderBys
- The the ordering conditions, converted into an ORDER BY clauseoffset
- The offset of the first row to be includedpagelength
- The number of rows to be returned when the query executestoSelect
- String containing what to select, e.g. "*", "COUNT(*)"
public StatementHelper generateUpdateQuery(String tableName, RowItem item)
SQLGenerator
generateUpdateQuery
in interface SQLGenerator
tableName
- Name of the table querieditem
- RowItem containing the updated values update.
public StatementHelper generateInsertQuery(String tableName, RowItem item)
SQLGenerator
generateInsertQuery
in interface SQLGenerator
tableName
- Name of the table querieditem
- New RowItem to be inserted into the database.
public StatementHelper generateDeleteQuery(String tableName, List<String> primaryKeyColumns, String versionColumn, RowItem item)
SQLGenerator
generateDeleteQuery
in interface SQLGenerator
tableName
- Name of the table queriedprimaryKeyColumns
- the names of the columns holding the primary key. Usually just
one column, but might be several.versionColumn
- the column containing the version number of the row, null if
versioning (optimistic locking) not enabled.item
- Item to be deleted from the database
protected StringBuffer generateOrderBy(StringBuffer sb, OrderBy o, boolean firstOrderBy)
sb
- StringBuffer to which the clause is appended.o
- OrderBy object to be added into the sb.firstOrderBy
- If true, this is the first OrderBy.
protected StringBuffer generateLimits(StringBuffer sb, int offset, int pagelength)
sb
- StringBuffer to which the clause is appended.offset
- Value for offset.pagelength
- Value for pagelength.
protected Map<String,Object> generateColumnToValueMap(RowItem item)
protected Map<String,Object> generateRowIdentifiers(RowItem item)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |