public class PostgreSQLSpecifics extends DBSpecifics
PostgreSQL does not support the CLOB datatype but instead provides a "text" data type. See http://www.postgresql.org/docs/current/static/datatype-character.html.
Constructor and Description |
---|
PostgreSQLSpecifics() |
Modifier and Type | Method and Description |
---|---|
void |
createEavAttributeTable(int toVersion)
Create the EavAttributeTable table in the database.
|
void |
createEavTypeAttributeTable(int toVersion)
Create the EavTypeAttribute table in the database.
|
protected void |
createExtendedFieldTable()
Create the extendedfield table in the database.
|
protected void |
createExtendedFieldTypeTable()
Create the extendedfieldtype table in the database.
|
protected void |
createExtendedFieldValueTable()
Create the extendedfieldvalue table in the database.
|
void |
createFrontierReportMonitorTable()
Create the frontierReportMonitor table in the database.
|
protected void |
createGlobalCrawlerTrapExpressions()
Creates the initial (version 1) of table 'global_crawler_trap_expressions'.
|
protected void |
createGlobalCrawlerTrapLists()
Creates the initial (version 1) of table 'global_crawler_trap_lists'.
|
protected void |
createHarvestChannelTable() |
void |
createRunningJobsHistoryTable()
Create the frontierReportMonitor table in the database.
|
void |
createRunningJobsMonitorTable()
Create the frontierReportMonitor table in the database.
|
void |
dropJobConfigsTmpTable(Connection c,
String tableName)
Dispose of a temporary table created with getTemporaryTable.
|
String |
getDriverClassName()
Get the name of the JDBC driver class that handles interfacing to this server.
|
static DBSpecifics |
getInstance()
Get an instance of the PostgreSQL specifics class.
|
String |
getJobConfigsTmpTable(Connection c)
Get a temporary table for short-time use.
|
String |
getOrderByLimitAndOffsetSubClause(long limit,
long offset)
Formats the LIMIT sub-clause of an SQL order clause.
|
protected void |
migrateConfigurationsv3ov4()
Migrates the 'configurations' table from version 3 to version 4.
|
protected void |
migrateConfigurationsv4tov5()
Migrates the 'configurations' table from version 4 to version 5.
|
protected void |
migrateDomainsv2tov3()
Migrates the 'domains' table from version 2 to version 3.
|
protected void |
migrateExtendedFieldTableV1toV2()
Migrates the 'ExtendedFieldTable' from version 1 to version 2 consisting of adding the maxlen field
|
protected void |
migrateExtendedFieldTableValueV1toV2()
Migrates the 'ExtendedFieldValueTable' from version 1 to version 2 changing the maxlen of content to 30000
|
protected void |
migrateFullharvestsv2tov3()
Migrates the 'fullharvests' table from version 2 to version 3.
|
protected void |
migrateFullharvestsv3tov4()
Migrates the 'fullharvests' table from version 3 to version 4.
|
protected void |
migrateFullharvestsv4tov5()
Migrates the 'fullharvests' table from version 4 to version 5.
|
protected void |
migrateHarvestdefinitionsv2tov3()
Migrates the 'harvestdefinitions' table from version 2 to version 3 consisting of adding the string audience with
null as default.
|
protected void |
migrateHarvestdefinitionsv3tov4()
Migrates the 'harvestdefinitions' table from version 3 to version 4 consisting of adding the bigint channel_id
field.
|
protected void |
migrateJobsv3tov4()
Migrates the 'jobs' table from version 3 to version 4 consisting of a change of the field forcemaxbytes from int
to bigint and setting its default to -1.
|
protected void |
migrateJobsv4tov5()
Migrates the 'jobs' table from version 4 to version 5 consisting of adding new fields 'resubmitted_as_job' and
'submittedDate'.
|
protected void |
migrateJobsv5tov6()
Migrates the 'jobs' table from version 5 to version 6.
|
protected void |
migrateJobsv6tov7()
Migrates the 'jobs' table from version 6 to version 7 consisting of adding the bigint fieldcontinuationof with
null as default.
|
protected void |
migrateJobsv7tov8()
Migrates the 'jobs' table from version 7 to version 8 consisting of adding the date creationdate with null as
default.
|
protected void |
migrateJobsv8tov9()
Migrates the 'jobs' table from version 8 to version 9 consisting of adding the string harvestname_prefix with
null as default.
|
protected void |
migrateJobsv9tov10()
Migrates the 'jobs' table from version 9 to version 10 consisting of adding the channel (varchar 300) and a
'snapshot'
|
protected void |
migrateOrderTemplatesTablev1tov2()
Migrates the table 'ordertemplates' from version 1 to version 2, adding a boolean 'isActive" flag.
|
protected void |
migrateRunningJobsHistoryTableV1ToV2()
Migrates the 'runningjobshistory' table from version 1 to version 2.
|
protected void |
migrateRunningJobsMonitorTableV1ToV2()
Migrates the 'runningjobsmonitor' table from version 1 to version 2.
|
boolean |
supportsClob()
Returns true if the target RDBMS supports CLOBs.
|
updateTable, updateTables, upgradeEavAttributeTable, upgradeEavTypeAttributeTable
getInstance
public PostgreSQLSpecifics()
public static DBSpecifics getInstance()
public String getJobConfigsTmpTable(Connection c) throws SQLException
getJobConfigsTmpTable
in class DBSpecifics
c
- The DB connection to use.SQLException
- if there is a problem getting the table.public void dropJobConfigsTmpTable(Connection c, String tableName)
dropJobConfigsTmpTable
in class DBSpecifics
c
- The DB connection to use.tableName
- The name of the temporary tablepublic String getDriverClassName()
getDriverClassName
in class DBSpecifics
public String getOrderByLimitAndOffsetSubClause(long limit, long offset)
DBSpecifics
getOrderByLimitAndOffsetSubClause
in class DBSpecifics
limit
- the maximum number of rows to fetch.offset
- the starting offset in the full query results.public boolean supportsClob()
DBSpecifics
supportsClob
in class DBSpecifics
protected void migrateJobsv3tov4()
migrateJobsv3tov4
in class DBSpecifics
IOFailure
- in case of problems in interacting with the databaseprotected void migrateJobsv4tov5()
migrateJobsv4tov5
in class DBSpecifics
IOFailure
- in case of problems in interacting with the databaseprotected void migrateConfigurationsv3ov4()
migrateConfigurationsv3ov4
in class DBSpecifics
protected void migrateFullharvestsv2tov3()
migrateFullharvestsv2tov3
in class DBSpecifics
protected void createGlobalCrawlerTrapExpressions()
DBSpecifics
createGlobalCrawlerTrapExpressions
in class DBSpecifics
protected void createGlobalCrawlerTrapLists()
DBSpecifics
createGlobalCrawlerTrapLists
in class DBSpecifics
public void createFrontierReportMonitorTable()
DBSpecifics
createFrontierReportMonitorTable
in class DBSpecifics
public void createRunningJobsHistoryTable()
DBSpecifics
createRunningJobsHistoryTable
in class DBSpecifics
public void createRunningJobsMonitorTable()
DBSpecifics
createRunningJobsMonitorTable
in class DBSpecifics
protected void migrateRunningJobsHistoryTableV1ToV2()
migrateRunningJobsHistoryTableV1ToV2
in class DBSpecifics
protected void migrateRunningJobsMonitorTableV1ToV2()
migrateRunningJobsMonitorTableV1ToV2
in class DBSpecifics
protected void migrateDomainsv2tov3()
DBSpecifics
migrateDomainsv2tov3
in class DBSpecifics
protected void migrateConfigurationsv4tov5()
DBSpecifics
migrateConfigurationsv4tov5
in class DBSpecifics
protected void migrateFullharvestsv3tov4()
DBSpecifics
migrateFullharvestsv3tov4
in class DBSpecifics
protected void migrateJobsv5tov6()
DBSpecifics
migrateJobsv5tov6
in class DBSpecifics
protected void migrateFullharvestsv4tov5()
DBSpecifics
migrateFullharvestsv4tov5
in class DBSpecifics
protected void createExtendedFieldTypeTable()
DBSpecifics
createExtendedFieldTypeTable
in class DBSpecifics
protected void createExtendedFieldTable()
DBSpecifics
createExtendedFieldTable
in class DBSpecifics
protected void createExtendedFieldValueTable()
DBSpecifics
createExtendedFieldValueTable
in class DBSpecifics
protected void migrateJobsv6tov7()
DBSpecifics
migrateJobsv6tov7
in class DBSpecifics
protected void migrateJobsv7tov8()
DBSpecifics
migrateJobsv7tov8
in class DBSpecifics
protected void migrateJobsv8tov9()
DBSpecifics
migrateJobsv8tov9
in class DBSpecifics
protected void migrateHarvestdefinitionsv2tov3()
DBSpecifics
migrateHarvestdefinitionsv2tov3
in class DBSpecifics
protected void migrateHarvestdefinitionsv3tov4()
DBSpecifics
migrateHarvestdefinitionsv3tov4
in class DBSpecifics
protected void migrateJobsv9tov10()
DBSpecifics
migrateJobsv9tov10
in class DBSpecifics
protected void createHarvestChannelTable()
createHarvestChannelTable
in class DBSpecifics
protected void migrateExtendedFieldTableV1toV2()
migrateExtendedFieldTableV1toV2
in class DBSpecifics
protected void migrateExtendedFieldTableValueV1toV2()
migrateExtendedFieldTableValueV1toV2
in class DBSpecifics
protected void migrateOrderTemplatesTablev1tov2()
DBSpecifics
migrateOrderTemplatesTablev1tov2
in class DBSpecifics
public void createEavTypeAttributeTable(int toVersion)
DBSpecifics
createEavTypeAttributeTable
in class DBSpecifics
public void createEavAttributeTable(int toVersion)
DBSpecifics
createEavAttributeTable
in class DBSpecifics
Copyright © 2005–2018 The Royal Danish Library, the National Library of France and the Austrian National Library.. All rights reserved.