Package ru.curs.celesta.dbutils.adaptors

Class OpenSourceDbAdaptor

java.lang.Object

ru.curs.celesta.dbutils.adaptors.DBAdaptor

ru.curs.celesta.dbutils.adaptors.OpenSourceDbAdaptor

All Implemented Interfaces:

StaticDataAdaptor, QueryBuildingHelper

Direct Known Subclasses:

H2Adaptor, PostgresAdaptor

public abstract class OpenSourceDbAdaptor
extends DBAdaptor

Created by ioann on 02.05.2017.

Constructor Summary

Constructors

Constructor	Description
OpenSourceDbAdaptor(ConnectionPool connectionPool, DdlConsumer ddlConsumer)

Method Summary

Modifier and Type	Method	Description
PreparedStatement	deleteRecordSetStatement(Connection conn, TableElement t, String where)	Creates a PreparedStatement object for a DELETE statement for deleting a set of records that satisfy a condition.
Set<String>	getColumns(Connection conn, TableElement t)	Returns a set of column names for a specific table.
PreparedStatement	getDeleteRecordStatement(Connection conn, TableElement t, String where)	Creates a PreparedStatement object for a DELETE statement for deleting a set of records that satisfy a condition.
PreparedStatement	getNavigationStatement(Connection conn, FromClause from, String orderBy, String navigationWhereClause, Set<String> fields, long offset)	Returns navigable PreparedStatement by a filtered set of records.
PreparedStatement	getOneFieldStatement(Connection conn, Column<?> c, String where)	Creates a PreparedStatement object for a SELECT statement of a single column containing at most one record.
PreparedStatement	getOneRecordStatement(Connection conn, TableElement t, String where, Set<String> fields)	Creates a PreparedStatement object for a SELECT statement containing at most one record.
long	nextSequenceValue(Connection conn, SequenceElement s)	Retrieves next value from the sequence.
boolean	nullsFirst()	Tells whether RDBMS sorts nulls first.
boolean	sequenceExists(Connection conn, String schema, String name)	Checks if sequence exists in the DB.
boolean	tableExists(Connection conn, String schema, String name)	Checks if table exists in the DB.

Methods inherited from class ru.curs.celesta.dbutils.adaptors.DBAdaptor

alterSequence, compareStrings, createColumn, createFK, createIndex, createParameterizedView, createPK, createSchemaIfNotExists, createSequence, createSysObjects, createTable, createTableTriggersForMaterializedViews, createView, dropFK, dropIndex, dropParameterizedView, dropPk, dropSequence, dropTable, dropTableTriggersForMaterializedViews, dropTrigger, dropView, executeNative, getCallFunctionSql, getColumnInfo, getCurrentIdent, getDBPid, getFKInfo, getIndices, getInsertRecordStatement, getParameterizedViewList, getPKInfo, getRecordSetStatement, getSequenceInfo, getSetCountStatement, getTriggerBody, getType, getUpdateRecordStatement, getViewList, getViewSQLGenerator, initDataForMaterializedView, isValidConnection, pkConstraintString, prepareZonedDateTimeForParameterSetter, selectStaticStrings, sequenceString, supportsCortegeComparing, tableString, translateDate, triggerExists, updateColumn, updateVersioningTrigger, userTablesExist

Methods inherited from class java.lang.Object

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

Methods inherited from interface ru.curs.celesta.dbutils.QueryBuildingHelper

getInFilterClause

Constructor Details

OpenSourceDbAdaptor

public OpenSourceDbAdaptor(ConnectionPool connectionPool,
 DdlConsumer ddlConsumer)

Method Details

tableExists

public boolean tableExists(Connection conn,
 String schema,
 String name)

Description copied from class: DBAdaptor

Checks if table exists in the DB.

Specified by:

tableExists in class DBAdaptor

Parameters:

conn - DB connection

schema - schema name

name - table name

getOneFieldStatement

public PreparedStatement getOneFieldStatement(Connection conn,
 Column<?> c,
 String where)

Description copied from class: DBAdaptor

Creates a PreparedStatement object for a SELECT statement of a single column containing at most one record.

Specified by:

getOneFieldStatement in class DBAdaptor

Parameters:

conn - DB connection

c - column to select

where - WHERE condition

getOneRecordStatement

public PreparedStatement getOneRecordStatement(Connection conn,
 TableElement t,
 String where,
 Set<String> fields)

Description copied from class: DBAdaptor

Creates a PreparedStatement object for a SELECT statement containing at most one record.

Specified by:

getOneRecordStatement in class DBAdaptor

Parameters:

conn - DB connection

t - table

where - WHERE condition

fields - fields of selection

getDeleteRecordStatement

public PreparedStatement getDeleteRecordStatement(Connection conn,
 TableElement t,
 String where)

Description copied from class: DBAdaptor

Creates a PreparedStatement object for a DELETE statement for deleting a set of records that satisfy a condition.

Specified by:

getDeleteRecordStatement in class DBAdaptor

Parameters:

conn - DB connection

t - table

where - condition (can be null)

getColumns

public Set<String> getColumns(Connection conn,
 TableElement t)

Description copied from class: DBAdaptor

Returns a set of column names for a specific table.

Overrides:

getColumns in class DBAdaptor

Parameters:

conn - DB connection

t - Table to look the columns in.

deleteRecordSetStatement

public PreparedStatement deleteRecordSetStatement(Connection conn,
 TableElement t,
 String where)

Description copied from class: DBAdaptor

Creates a PreparedStatement object for a DELETE statement for deleting a set of records that satisfy a condition.

Specified by:

deleteRecordSetStatement in class DBAdaptor

Parameters:

conn - DB connection

t - table

where - condition

getNavigationStatement

public PreparedStatement getNavigationStatement(Connection conn,
 FromClause from,
 String orderBy,
 String navigationWhereClause,
 Set<String> fields,
 long offset)

Description copied from class: DBAdaptor

Returns navigable PreparedStatement by a filtered set of records.

Specified by:

getNavigationStatement in class DBAdaptor

Parameters:

conn - Connection

from - From clause

orderBy - Sorting order (ascending or descending)

navigationWhereClause - Navigable set condition (from current record)

fields - Fields of selection

offset - First record offset

nullsFirst

public boolean nullsFirst()

Description copied from interface: QueryBuildingHelper

Tells whether RDBMS sorts nulls first.

nextSequenceValue

public long nextSequenceValue(Connection conn,
 SequenceElement s)

Description copied from class: DBAdaptor

Retrieves next value from the sequence.

Specified by:

nextSequenceValue in class DBAdaptor

Parameters:

conn - DB connection

s - sequence

sequenceExists

public boolean sequenceExists(Connection conn,
 String schema,
 String name)

Description copied from class: DBAdaptor

Checks if sequence exists in the DB.

Specified by:

sequenceExists in class DBAdaptor

Parameters:

conn - DB connection

schema - schema name

name - sequence name