Package ru.curs.celesta.dbutils.adaptors

Class FirebirdAdaptor

java.lang.Object

ru.curs.celesta.dbutils.adaptors.DBAdaptor

ru.curs.celesta.dbutils.adaptors.FirebirdAdaptor

All Implemented Interfaces:

StaticDataAdaptor, QueryBuildingHelper

public final class FirebirdAdaptor
extends DBAdaptor

FirebirdAdaptor.

Author:

ioanngolovko

Constructor Summary

Constructors

Constructor	Description
FirebirdAdaptor(ConnectionPool connectionPool, DdlConsumer ddlConsumer)

Method Summary

Modifier and Type	Method	Description
void	createSysObjects(Connection conn, String sysSchemaName)	Creates or recreates other system objects (stored procedures, functions) needed for Celesta functioning on current RDBMS.
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.
void	dropSequence(Connection conn, SequenceElement s)	Drops sequence from the database.
DbColumnInfo	getColumnInfo(Connection conn, Column<?> c)	Returns information on a column.
Set<String>	getColumns(Connection conn, TableElement t)	Returns a set of column names for a specific table.
int	getCurrentIdent(Connection conn, BasicTable t)	Returns current identity value for the table.
int	getDBPid(Connection conn)	Returns process id of current database connection.
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.
List<DbFkInfo>	getFKInfo(Connection conn, Grain g)	Returns information on the foreign keys from grain.
Map<String,DbIndexInfo>	getIndices(Connection conn, Grain g)	Returns a set of indices referring to tables specified in the indicated grain.
String	getInFilterClause(DataGrainElement dge, DataGrainElement otherDge, List<String> fields, List<String> otherFields, String whereForOtherTable)
PreparedStatement	getInsertRecordStatement(Connection conn, BasicTable t, boolean[] nullsMask, List<ParameterSetter> program)	Creates a PreparedStatement object for an INSERT statement to insert a record into a table.
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.
List<String>	getParameterizedViewList(Connection conn, Grain g)	Get names of existing parameterized views.
DbPkInfo	getPKInfo(Connection conn, TableElement t)	Returns information on the primary key of a table.
DbSequenceInfo	getSequenceInfo(Connection conn, SequenceElement s)	Returns information on a sequence.
DBType	getType()	Returns current database type.
List<String>	getViewList(Connection conn, Grain g)	Returns list of view names in the grain.
long	nextSequenceValue(Connection conn, SequenceElement s)	Retrieves next value from the sequence.
boolean	nullsFirst()	Tells whether RDBMS sorts nulls first.
String	pkConstraintString(TableElement tableElement)	Returns DB specific PK constraint name for a table element.
ZonedDateTime	prepareZonedDateTimeForParameterSetter(Connection conn, ZonedDateTime z)
static String	sequenceCurValueProcString(String schemaName, String sequenceName)
boolean	sequenceExists(Connection conn, String schema, String name)	Checks if sequence exists in the DB.
static String	sequenceNextValueProcString(String schemaName, String sequenceName)
String	sequenceString(String schemaName, String sequenceName)	Returns template by sequence name.
boolean	tableExists(Connection conn, String schema, String name)	Checks if table exists in the DB.
String	tableString(String schemaName, String tableName)	Returns template by table name.
boolean	triggerExists(Connection conn, TriggerQuery query)	Checks if trigger exists in the DB.

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

alterSequence, compareStrings, createColumn, createFK, createIndex, createParameterizedView, createPK, createSchemaIfNotExists, createSequence, createTable, createTableTriggersForMaterializedViews, createView, dropFK, dropIndex, dropParameterizedView, dropPk, dropTable, dropTableTriggersForMaterializedViews, dropTrigger, dropView, executeNative, getCallFunctionSql, getRecordSetStatement, getSetCountStatement, getTriggerBody, getUpdateRecordStatement, getViewSQLGenerator, initDataForMaterializedView, isValidConnection, selectStaticStrings, supportsCortegeComparing, translateDate, updateColumn, updateVersioningTrigger, userTablesExist

Methods inherited from class java.lang.Object

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

Constructor Details

FirebirdAdaptor

public FirebirdAdaptor(ConnectionPool connectionPool,
 DdlConsumer ddlConsumer)

Method Details

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

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

triggerExists

public boolean triggerExists(Connection conn,
 TriggerQuery query)
                      throws SQLException

Description copied from class: DBAdaptor

Checks if trigger exists in the DB.

Specified by:

triggerExists in class DBAdaptor

Parameters:

conn - DB connection.

query - trigger query parameters

Throws:

SQLException - thrown if resulting query fails

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.

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

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

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

getInsertRecordStatement

public PreparedStatement getInsertRecordStatement(Connection conn,
 BasicTable t,
 boolean[] nullsMask,
 List<ParameterSetter> program)

Description copied from class: DBAdaptor

Creates a PreparedStatement object for an INSERT statement to insert a record into a table.

Specified by:

getInsertRecordStatement in class DBAdaptor

Parameters:

conn - DB connection

t - table

nullsMask - null-flags (if set the corresponding field at n-th position becomes null)

program - collects parameters that can be set with the query

getCurrentIdent

public int getCurrentIdent(Connection conn,
 BasicTable t)

Description copied from class: DBAdaptor

Returns current identity value for the table.

Specified by:

getCurrentIdent in class DBAdaptor

Parameters:

conn - DB connection

t - table

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)

getColumnInfo

public DbColumnInfo getColumnInfo(Connection conn,
 Column<?> c)

Description copied from class: DBAdaptor

Returns information on a column.

Specified by:

getColumnInfo in class DBAdaptor

Parameters:

conn - DB connection

c - column

getPKInfo

public DbPkInfo getPKInfo(Connection conn,
 TableElement t)

Description copied from class: DBAdaptor

Returns information on the primary key of a table.

Specified by:

getPKInfo in class DBAdaptor

Parameters:

conn - DB connection

t - Table that the information on the primary key has to be returned from

getFKInfo

public List<DbFkInfo> getFKInfo(Connection conn,
 Grain g)

Description copied from class: DBAdaptor

Returns information on the foreign keys from grain.

Specified by:

getFKInfo in class DBAdaptor

Parameters:

conn - DB connection

g - grain name

Returns:

list where each item contain information on a separate foreign key

getIndices

public Map<String,DbIndexInfo> getIndices(Connection conn,
 Grain g)

Description copied from class: DBAdaptor

Returns a set of indices referring to tables specified in the indicated grain.

Specified by:

getIndices in class DBAdaptor

Parameters:

conn - DB connection

g - Grain the tables of which have to be traversed for the indices.

getParameterizedViewList

public List<String> getParameterizedViewList(Connection conn,
 Grain g)

Description copied from class: DBAdaptor

Get names of existing parameterized views.

Specified by:

getParameterizedViewList in class DBAdaptor

Parameters:

conn - connection

g - current grain

getDBPid

public int getDBPid(Connection conn)

Description copied from class: DBAdaptor

Returns process id of current database connection.

Specified by:

getDBPid in class DBAdaptor

Parameters:

conn - DB connection

getType

public DBType getType()

Description copied from class: DBAdaptor

Returns current database type. E.g. H2, POSTGRESQL etc.

Specified by:

getType in class DBAdaptor

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

prepareZonedDateTimeForParameterSetter

public ZonedDateTime prepareZonedDateTimeForParameterSetter(Connection conn,
 ZonedDateTime z)

Specified by:

prepareZonedDateTimeForParameterSetter in interface QueryBuildingHelper

Overrides:

prepareZonedDateTimeForParameterSetter in class DBAdaptor

dropSequence

public void dropSequence(Connection conn,
 SequenceElement s)

Description copied from class: DBAdaptor

Drops sequence from the database.

Overrides:

dropSequence in class DBAdaptor

Parameters:

conn - DB connection

s - sequence element

sequenceCurValueProcString

public static String sequenceCurValueProcString(String schemaName,
 String sequenceName)

sequenceNextValueProcString

public static String sequenceNextValueProcString(String schemaName,
 String sequenceName)

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

getSequenceInfo

public DbSequenceInfo getSequenceInfo(Connection conn,
 SequenceElement s)

Description copied from class: DBAdaptor

Returns information on a sequence.

Specified by:

getSequenceInfo in class DBAdaptor

Parameters:

conn - DB connection

s - sequence

nullsFirst

public boolean nullsFirst()

Description copied from interface: QueryBuildingHelper

Tells whether RDBMS sorts nulls first.

getInFilterClause

public String getInFilterClause(DataGrainElement dge,
 DataGrainElement otherDge,
 List<String> fields,
 List<String> otherFields,
 String whereForOtherTable)

createSysObjects

public void createSysObjects(Connection conn,
 String sysSchemaName)

Description copied from class: DBAdaptor

Creates or recreates other system objects (stored procedures, functions) needed for Celesta functioning on current RDBMS.

Overrides:

createSysObjects in class DBAdaptor

Parameters:

conn - DB connection

sysSchemaName - system schema name

getViewList

public List<String> getViewList(Connection conn,
 Grain g)

Description copied from class: DBAdaptor

Returns list of view names in the grain.

Overrides:

getViewList in class DBAdaptor

Parameters:

conn - DB connection

g - Grain for which the list of view names have to be returned.

tableString

public String tableString(String schemaName,
 String tableName)

Description copied from class: DBAdaptor

Returns template by table name.

Overrides:

tableString in class DBAdaptor

Parameters:

schemaName - schema name

tableName - table name

pkConstraintString

public String pkConstraintString(TableElement tableElement)

Description copied from class: DBAdaptor

Returns DB specific PK constraint name for a table element.

Overrides:

pkConstraintString in class DBAdaptor

Parameters:

tableElement - table element

sequenceString

public String sequenceString(String schemaName,
 String sequenceName)

Description copied from class: DBAdaptor

Returns template by sequence name.

Overrides:

sequenceString in class DBAdaptor

Parameters:

schemaName - schema name

sequenceName - sequence name