|
Project Wonder 5.0 | |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objecter.extensions.jdbc.ERXSQLHelper
er.extensions.jdbc.ERXSQLHelper.PostgresqlSQLHelper
public static class ERXSQLHelper.PostgresqlSQLHelper
Nested Class Summary |
---|
Nested classes/interfaces inherited from class er.extensions.jdbc.ERXSQLHelper |
---|
ERXSQLHelper.ColumnIndex, ERXSQLHelper.CustomTypes, ERXSQLHelper.DerbySQLHelper, ERXSQLHelper.EROracleSQLHelper, ERXSQLHelper.FrontBaseSQLHelper, ERXSQLHelper.H2SQLHelper, ERXSQLHelper.MicrosoftSQLHelper, ERXSQLHelper.MySQLSQLHelper, ERXSQLHelper.NoSQLHelper, ERXSQLHelper.OpenBaseSQLHelper, ERXSQLHelper.OracleSQLHelper, ERXSQLHelper.PostgresqlSQLHelper |
Field Summary |
---|
Fields inherited from class er.extensions.jdbc.ERXSQLHelper |
---|
log |
Constructor Summary | |
---|---|
ERXSQLHelper.PostgresqlSQLHelper()
|
Method Summary | |
---|---|
java.lang.String |
externalTypeForJDBCType(com.webobjects.jdbcadaptor.JDBCAdaptor adaptor,
int jdbcType)
For most types, finding the type in jdbc2Info's typeInfo will provide us with a correct type mapping. |
protected java.lang.String |
formatValueForAttribute(com.webobjects.eoaccess.EOSQLExpression expression,
java.lang.Object value,
com.webobjects.eoaccess.EOAttribute attribute,
java.lang.String key)
|
java.lang.String |
limitExpressionForSQL(com.webobjects.eoaccess.EOSQLExpression expression,
com.webobjects.eocontrol.EOFetchSpecification fetchSpecification,
java.lang.String sql,
long start,
long end)
|
java.lang.String |
sqlForCreateIndex(java.lang.String indexName,
java.lang.String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
Returns the SQL expression for creating an index on the given set of columns |
java.lang.String |
sqlForCreateUniqueIndex(java.lang.String indexName,
java.lang.String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
Creates unique index; stolen from the derby helper |
protected java.lang.String |
sqlForGetNextValFromSequencedNamed(java.lang.String sequenceName)
Returns the SQL required to select the next value from the given sequence. |
java.lang.String |
sqlForRegularExpressionQuery(java.lang.String key,
java.lang.String value)
Returns the SQL expression for a regular expression query. |
int |
varcharLargeColumnWidth()
Returns the width that should be used for a varcharLarge column in migrations. |
int |
varcharLargeJDBCType()
Returns the JDBCType that should be used for a varcharLarge column in migrations. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public ERXSQLHelper.PostgresqlSQLHelper()
Method Detail |
---|
protected java.lang.String sqlForGetNextValFromSequencedNamed(java.lang.String sequenceName)
ERXSQLHelper
sqlForGetNextValFromSequencedNamed
in class ERXSQLHelper
sequenceName
- the name of the sequence
protected java.lang.String formatValueForAttribute(com.webobjects.eoaccess.EOSQLExpression expression, java.lang.Object value, com.webobjects.eoaccess.EOAttribute attribute, java.lang.String key)
formatValueForAttribute
in class ERXSQLHelper
public java.lang.String limitExpressionForSQL(com.webobjects.eoaccess.EOSQLExpression expression, com.webobjects.eocontrol.EOFetchSpecification fetchSpecification, java.lang.String sql, long start, long end)
limitExpressionForSQL
in class ERXSQLHelper
public java.lang.String sqlForRegularExpressionQuery(java.lang.String key, java.lang.String value)
ERXSQLHelper
sqlForRegularExpressionQuery
in class ERXSQLHelper
public java.lang.String externalTypeForJDBCType(com.webobjects.jdbcadaptor.JDBCAdaptor adaptor, int jdbcType)
externalTypeForJDBCType
in class ERXSQLHelper
adaptor
- the adaptor to retrieve an external type forjdbcType
- the JDBC type number
public java.lang.String sqlForCreateUniqueIndex(java.lang.String indexName, java.lang.String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
sqlForCreateUniqueIndex
in class ERXSQLHelper
indexName
- the name of the index to createtableName
- the name of the containing tablecolumnIndexes
- the list of columns to index on
er.extensions.ERXSQLHelper#sqlForCreateUniqueIndex(java.lang.String, java.lang.String, er.extensions.ERXSQLHelper.ColumnIndex[])
public java.lang.String sqlForCreateIndex(java.lang.String indexName, java.lang.String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
ERXSQLHelper
sqlForCreateIndex
in class ERXSQLHelper
indexName
- the name of the index to createtableName
- the name of the containing tablecolumnIndexes
- the list of columns to index on
public int varcharLargeJDBCType()
ERXSQLHelper
varcharLargeJDBCType
in class ERXSQLHelper
public int varcharLargeColumnWidth()
ERXSQLHelper
varcharLargeColumnWidth
in class ERXSQLHelper
|
Last updated: Tue, Feb 21, 2017 05:45 PM CET | |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |