|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.unitils.core.dbsupport.DbSupport org.unitils.core.dbsupport.PostgreSqlDbSupport
public class PostgreSqlDbSupport
Implementation of DbSupport
for a PostgreSql database.
Field Summary |
---|
Fields inherited from class org.unitils.core.dbsupport.DbSupport |
---|
PROPKEY_IDENTIFIER_QUOTE_STRING, PROPKEY_STORED_IDENTIFIER_CASE |
Constructor Summary | |
---|---|
PostgreSqlDbSupport()
Creates support for PostgreSql databases. |
Method Summary | |
---|---|
void |
disableReferentialConstraints()
Disables all referential constraints (e.g. foreign keys) on all table in the schema |
protected void |
disableReferentialConstraints(String tableName)
|
void |
disableValueConstraints()
Disables all value constraints (e.g. not null) on all tables in the schema |
protected void |
disableValueConstraints(String tableName)
|
void |
dropSequence(String sequenceName)
Drops the sequence with the given name from the database Note: the sequence name is surrounded with quotes, making it case-sensitive. |
void |
dropTrigger(String triggerName)
Drops the trigger with the given name from the database. |
Set<String> |
getColumnNames(String tableName)
Gets the names of all columns of the given table. |
Set<String> |
getSequenceNames()
Retrieves the names of all the sequences in the database schema. |
long |
getSequenceValue(String sequenceName)
Returns the value of the sequence with the given name. |
Set<String> |
getTableNames()
Returns the names of all tables in the database. |
Set<String> |
getTriggerNames()
Retrieves the names of all the triggers in the database schema. |
Set<String> |
getTypeNames()
Retrieves the names of all user-defined types in the database schema. |
Set<String> |
getViewNames()
Retrieves the names of all the views in the database schema. |
void |
incrementSequenceToValue(String sequenceName,
long newSequenceValue)
Sets the next value of the sequence with the given sequence name to the given sequence value. |
boolean |
supportsCascade()
Cascade are supported. |
boolean |
supportsSequences()
Sequences are supported. |
boolean |
supportsTriggers()
Triggers are supported. |
boolean |
supportsTypes()
Types are supported |
Methods inherited from class org.unitils.core.dbsupport.DbSupport |
---|
dropMaterializedView, dropSynonym, dropTable, dropType, dropView, getDatabaseDialect, getIdentifierQuoteString, getIdentityColumnNames, getLongDataType, getMaterializedViewNames, getSchemaName, getSQLHandler, getStoredIdentifierCase, getSynonymNames, getTextDataType, incrementIdentityColumnToValue, init, qualified, quoted, supportsIdentityColumns, supportsMaterializedViews, supportsSynonyms, toCorrectCaseIdentifier |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public PostgreSqlDbSupport()
Method Detail |
---|
public Set<String> getTableNames()
getTableNames
in class DbSupport
public Set<String> getColumnNames(String tableName)
getColumnNames
in class DbSupport
tableName
- The table, not null
public Set<String> getViewNames()
getViewNames
in class DbSupport
public Set<String> getSequenceNames()
getSequenceNames
in class DbSupport
public Set<String> getTriggerNames()
getTriggerNames
in class DbSupport
public void dropSequence(String sequenceName)
dropSequence
in class DbSupport
sequenceName
- The sequence to drop (case-sensitive), not nullpublic void dropTrigger(String triggerName)
dropTrigger
in class DbSupport
triggerName
- The trigger to drop as 'trigger-name' ON 'table name', not nullpublic Set<String> getTypeNames()
getTypeNames
in class DbSupport
public void disableReferentialConstraints()
disableReferentialConstraints
in class DbSupport
protected void disableReferentialConstraints(String tableName)
public void disableValueConstraints()
disableValueConstraints
in class DbSupport
protected void disableValueConstraints(String tableName)
public long getSequenceValue(String sequenceName)
getSequenceValue
in class DbSupport
sequenceName
- The sequence, not null
public void incrementSequenceToValue(String sequenceName, long newSequenceValue)
incrementSequenceToValue
in class DbSupport
sequenceName
- The sequence, not nullnewSequenceValue
- The value to setpublic boolean supportsSequences()
supportsSequences
in class DbSupport
public boolean supportsTriggers()
supportsTriggers
in class DbSupport
public boolean supportsTypes()
supportsTypes
in class DbSupport
public boolean supportsCascade()
supportsCascade
in class DbSupport
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |