simpleorm.drivers

Class SDriverPostgres

java.lang.Object

simpleorm.sessionjdbc.SDriver

simpleorm.drivers.SDriverPostgres

public class SDriverPostgres
extends SDriver

This contains PostgreSQL specific code.

VARCHAR without size means unlimited. No artificial upper size? TEXT has the same behaviour as VARCHAR, apparently.

Nested Class Summary

Nested classes/interfaces inherited from class simpleorm.sessionjdbc.SDriver

SDriver.OffsetStrategy

Constructor Summary

Constructors

Constructor and Description
SDriverPostgres()

Method Summary

Modifier and Type	Method and Description
protected java.lang.String	columnTypeSQL(SFieldScalar field, java.lang.String defalt) Never need to specify byteSize for varchar
protected java.lang.String	createSequenceDDL(java.lang.String name)
protected java.lang.String	driverName() The driver name to be compared to getMetaData().getDriverName()
protected java.lang.String	dropSequenceDDL(java.lang.String name)
protected long	generateKeySequence(SRecordMeta<?> rec, SFieldScalar keyFld) Specializes SDriver.generateKeySequence using the Postgres SEQUENCEs.
protected SDriver.OffsetStrategy	getOffsetStrategy() JDBC prefered, if jdbc driver has a sensible scrollable resultset implemntation QUERY if database would handle it better via some proprietary sql extension (eg.
protected java.lang.String	limitSQL(long offset, long limit) Drivers that choose to implement a QUERY offset strategy should return the limit statment here
int	maxIdentNameLength() The maximum size for table names and foreign key constraint names.
boolean	supportsKeySequences()

Methods inherited from class simpleorm.sessionjdbc.SDriver

addNull, alterTableAddColumnSQL, alterTableDropColumnSQL, appendColumnName, appendQuotedIdentifier, appendQuotedIdentifier, appendTableName, clauseSeparator, createTableSQL, deleteSQL, dropTableNoError, foreignKeysSQL, forUpdateSQL, fromSQL, generateKeySelectMax, getLogger, getSession, indexKeySQL, insertSQL, joinSQL, makeForeignKeyIndexSQL, mapForeignKeys, postColumnSQL, postFromSQL, postTablePostParenSQL, postTablePreParenSQL, primaryKeySQL, queryExecuteFactory, registerDriver, selectSQL, selectSQL, supportsLocking, updateSQL, whereSQL, wholeColumnSQL

Methods inherited from class java.lang.Object

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

Constructor Detail

SDriverPostgres

public SDriverPostgres()

Method Detail

driverName

protected java.lang.String driverName()

Description copied from class: SDriver

The driver name to be compared to getMetaData().getDriverName()

Overrides:

driverName in class SDriver

maxIdentNameLength

public int maxIdentNameLength()

Description copied from class: SDriver

The maximum size for table names and foreign key constraint names.

Overrides:

maxIdentNameLength in class SDriver

columnTypeSQL

protected java.lang.String columnTypeSQL(SFieldScalar field,
                                         java.lang.String defalt)

Never need to specify byteSize for varchar

Overrides:

columnTypeSQL in class SDriver

generateKeySequence

protected long generateKeySequence(SRecordMeta<?> rec,
                                   SFieldScalar keyFld)

Specializes SDriver.generateKeySequence using the Postgres SEQUENCEs.

Overrides:

generateKeySequence in class SDriver

supportsKeySequences

public boolean supportsKeySequences()

Overrides:

supportsKeySequences in class SDriver

createSequenceDDL

protected java.lang.String createSequenceDDL(java.lang.String name)

Overrides:

createSequenceDDL in class SDriver

dropSequenceDDL

protected java.lang.String dropSequenceDDL(java.lang.String name)

Overrides:

dropSequenceDDL in class SDriver

getOffsetStrategy

protected SDriver.OffsetStrategy getOffsetStrategy()

Description copied from class: SDriver

JDBC prefered, if jdbc driver has a sensible scrollable resultset implemntation QUERY if database would handle it better via some proprietary sql extension (eg. LIMIT) BULK Simpleorm will get the whole resultset and skip de first row. Worst case scenario :(

Defaults to BULK

Overrides:

getOffsetStrategy in class SDriver

limitSQL

protected java.lang.String limitSQL(long offset,
                                    long limit)

Description copied from class: SDriver

Drivers that choose to implement a QUERY offset strategy should return the limit statment here

Overrides:

limitSQL in class SDriver

Parameters:

offset - number of rows to skip

limit - number of rows to retrieve

Returns:

LIMIT + OFFSET string statment