de.topicmapslab.majortom.database.jdbc.postgres.optimized
Class PostGreSqlQueryBuilder

java.lang.Object
  extended by de.topicmapslab.majortom.database.jdbc.rdbms.RDBMSQueryBuilder
      extended by de.topicmapslab.majortom.database.jdbc.postgres.sql99.Sql99QueryBuilder
          extended by de.topicmapslab.majortom.database.jdbc.postgres.optimized.PostGreSqlQueryBuilder
All Implemented Interfaces:
IQueryBuilder

public class PostGreSqlQueryBuilder
extends Sql99QueryBuilder

Author:
Sven Krosse

Field Summary
private  java.sql.PreparedStatement preparedStatementIndexAssociationsByTypeTransitive
           
private  java.sql.PreparedStatement preparedStatementIndexAssociationsByTypeTransitivePaged
           
private  java.sql.PreparedStatement preparedStatementIndexNamesByTypeTransitive
           
private  java.sql.PreparedStatement preparedStatementIndexNamesByTypeTransitivePaged
           
private  java.sql.PreparedStatement preparedStatementIndexOccurrencesByTypeTransitive
           
private  java.sql.PreparedStatement preparedStatementIndexOccurrencesByTypeTransitivePaged
           
private  java.sql.PreparedStatement preparedStatementIndexRolesByTypeTransitive
           
private  java.sql.PreparedStatement preparedStatementIndexRolesByTypeTransitivePaged
           
private  java.sql.PreparedStatement preparedStatementIndexScopesByThemesUsed
           
private  java.sql.PreparedStatement preparedStatementIndexSubtypesOfTopic
           
private  java.sql.PreparedStatement preparedStatementIndexSubtypesOfTopicPaged
           
private  java.sql.PreparedStatement preparedStatementIndexSubtypesOfTopics
           
private  java.sql.PreparedStatement preparedStatementIndexSubtypesOfTopicsPaged
           
private  java.sql.PreparedStatement preparedStatementIndexSupertypesOfTopic
           
private  java.sql.PreparedStatement preparedStatementIndexSupertypesOfTopicPaged
           
private  java.sql.PreparedStatement preparedStatementIndexSupertypesOfTopics
           
private  java.sql.PreparedStatement preparedStatementIndexSupertypesOfTopicsPaged
           
private  java.sql.PreparedStatement preparedStatementIndexTopicsByTypesTransitive
           
private  java.sql.PreparedStatement preparedStatementIndexTopicsByTypesTransitivePaged
           
private  java.sql.PreparedStatement preparedStatementIndexTopicsByTypeTransitive
           
private  java.sql.PreparedStatement preparedStatementIndexTopicsByTypeTransitivePaged
           
private  java.sql.PreparedStatement preparedStatementReadBestLabel
           
private  java.sql.PreparedStatement preparedStatementReadBestLabelWithTheme
           
private  java.sql.PreparedStatement preparedStatementReadScopeByThemes
           
private  java.sql.PreparedStatement preparedStatementReadSupertypes
           
private  java.sql.PreparedStatement preparedStatementRemoveDuplicates
           
private  java.sql.PreparedStatement preparedStatementRemoveDuplicateTopicContent
           
 
Constructor Summary
PostGreSqlQueryBuilder(PostGreSqlSession session)
          constructor
 
Method Summary
 void close()
          
 java.sql.PreparedStatement getPerformRemoveDuplicates()
          Returns the prepared SQL statement to perform method 'remove_duplicates'
 java.sql.PreparedStatement getPerformRemoveDuplicateTopicContent()
          Returns the prepared SQL statement to perform method 'remove_duplicate_topiccontent'
 PostGreSqlQueryProcessor getProcessor()
           
 java.sql.PreparedStatement getQueryReadBestLabel()
           
 java.sql.PreparedStatement getQueryReadBestLabelWithTheme()
           
 java.sql.PreparedStatement getQueryReadScopeByTheme()
          
 java.sql.PreparedStatement getQueryReadSupertypes()
          
 java.sql.PreparedStatement getQueryScopesByThemesUsed()
          
 java.sql.PreparedStatement getQuerySelectAssociationsByTypeTransitive(boolean paged)
          
 java.sql.PreparedStatement getQuerySelectNamesByTypeTransitive(boolean paged)
          
 java.sql.PreparedStatement getQuerySelectOccurrencesByTypeTransitive(boolean paged)
          
 java.sql.PreparedStatement getQuerySelectRolesByTypeTransitive(boolean paged)
          
 java.sql.PreparedStatement getQuerySelectSubtypesOfTopic(boolean paged)
          
 java.sql.PreparedStatement getQuerySelectSubtypesOfTopics(boolean paged)
          
 java.sql.PreparedStatement getQuerySelectSupertypesOfTopic(boolean paged)
          
 java.sql.PreparedStatement getQuerySelectSupertypesOfTopics(boolean paged)
          
 java.sql.PreparedStatement getQuerySelectTopicsByTypesTransitive(boolean paged)
          
 java.sql.PreparedStatement getQuerySelectTopicsByTypeTransitive(boolean paged)
          
 PostGreSqlSession getSession()
          Returns the internal session
 
Methods inherited from class de.topicmapslab.majortom.database.jdbc.postgres.sql99.Sql99QueryBuilder
getPerformMergeTopics, getQueryAddItemIdentifier, getQueryAddSubjectIdentifier, getQueryAddSubjectLocator, getQueryAddThemes, getQueryAssociationDump, getQueryAssociationsByScope, getQueryAssociationsByScopes, getQueryAssociationsByTheme, getQueryAssociationsByThemes, getQueryAssociationScopes, getQueryAssociationThemes, getQueryCharacteristicsByScope, getQueryClearTopicMap, getQueryCreateAssociation, getQueryCreateAssociationWithScope, getQueryCreateChangeset, getQueryCreateLocator, getQueryCreateMetadata, getQueryCreateName, getQueryCreateNameWithScope, getQueryCreateOccurrence, getQueryCreateOccurrenceWithScope, getQueryCreateRevision, getQueryCreateRole, getQueryCreateScope, getQueryCreateTag, getQueryCreateTopic, getQueryCreateTopicMap, getQueryCreateVariant, getQueryDeleteAssociation, getQueryDeleteItemIdentifier, getQueryDeleteName, getQueryDeleteOccurrence, getQueryDeleteRole, getQueryDeleteSubjectIdentifier, getQueryDeleteSubjectLocator, getQueryDeleteSupertype, getQueryDeleteTopic, getQueryDeleteTopicMap, getQueryDeleteType, getQueryDeleteVariant, getQueryDuplicateAssociations, getQueryDuplicateName, getQueryDuplicateOccurrence, getQueryDuplicateRoles, getQueryDuplicateVariant, getQueryModifyMetadata, getQueryModifyPlayer, getQueryModifyReifier, getQueryModifyScope, getQueryModifySupertypes, getQueryModifyTag, getQueryModifyType, getQueryModifyTypes, getQueryModifyValue, getQueryModifyValueWithDatatype, getQueryMoveItemIdentifiers, getQueryMoveVariants, getQueryNameDump, getQueryNamesByScope, getQueryNamesByScopes, getQueryNamesByTheme, getQueryNamesByThemes, getQueryNameScopes, getQueryNameThemes, getQueryOccurrenceDump, getQueryOccurrencesByScope, getQueryOccurrencesByScopes, getQueryOccurrencesByTheme, getQueryOccurrencesByThemes, getQueryOccurrenceScopes, getQueryOccurrenceThemes, getQueryReadAssociation, getQueryReadAssociationWithType, getQueryReadAssociationWithTypeAndScope, getQueryReadChangesets, getQueryReadChangesetsByAssociationType, getQueryReadChangesetsByTopic, getQueryReadChangesetType, getQueryReadConstructById, getQueryReadConstructByItemIdentifier, getQueryReadDataType, getQueryReadEmptyScope, getQueryReadFirstRevision, getQueryReadFutureRevision, getQueryReadHistory, getQueryReadItemIdentifiers, getQueryReadLastModification, getQueryReadLastModificationOfTopic, getQueryReadLastRevision, getQueryReadMetadata, getQueryReadMetadataByKey, getQueryReadNames, getQueryReadNamesWithScope, getQueryReadNamesWithType, getQueryReadNamesWithTypeAndScope, getQueryReadNumberOfAssociationsPlayed, getQueryReadNumberOfNames, getQueryReadNumberOfOccurrences, getQueryReadNumberOfRoles, getQueryReadNumberOfRolesPlayed, getQueryReadNumberOfTopicsWithoutSupertypes, getQueryReadNumberOfTypes, getQueryReadNumberOfVariants, getQueryReadOccurrences, getQueryReadOccurrencesWithScope, getQueryReadOccurrencesWithType, getQueryReadOccurrencesWithTypeAndScope, getQueryReadPastRevision, getQueryReadPlayedAssociation, getQueryReadPlayedAssociationWithScope, getQueryReadPlayedAssociationWithType, getQueryReadPlayedAssociationWithTypeAndScope, getQueryReadPlayedRoles, getQueryReadPlayedRolesWithType, getQueryReadPlayedRolesWithTypeAndAssociationType, getQueryReadPlayer, getQueryReadReified, getQueryReadReifier, getQueryReadRevisionByTag, getQueryReadRevisionByTimestamp, getQueryReadRevisionsByAssociationType, getQueryReadRevisionsByTopic, getQueryReadRoles, getQueryReadRolesWithType, getQueryReadRoleTypes, getQueryReadScope, getQueryReadScopeByThemes, getQueryReadSubjectIdentifiers, getQueryReadSubjectLocators, getQueryReadThemes, getQueryReadTimestamp, getQueryReadTopicBySubjectIdentifier, getQueryReadTopicBySubjectLocator, getQueryReadTopicMap, getQueryReadTopicMapLocators, getQueryReadTopics, getQueryReadTopicsWithType, getQueryReadType, getQueryReadTypes, getQueryReadValue, getQueryReadVariants, getQueryReadVariantsWithScope, getQueryRoleDump, getQueryScopables, getQuerySelectAssociationsByType, getQuerySelectAssociationsByTypes, getQuerySelectAssociationTypes, getQuerySelectCharacteristics, getQuerySelectCharacteristicsByDatatype, getQuerySelectCharacteristicsByPattern, getQuerySelectCharacteristicsByPatternAndDatatype, getQuerySelectCharacteristicsByType, getQuerySelectCharacteristicsByTypes, getQuerySelectCharacteristicsByValue, getQuerySelectCharacteristicTypes, getQuerySelectConstructsByIdentitifer, getQuerySelectConstructsByItemIdentitifer, getQuerySelectDatatypeAwaresByDatatype, getQuerySelectDirectSubtypes, getQuerySelectDirectSupertypes, getQuerySelectItemIdentifiers, getQuerySelectNames, getQuerySelectNamesByPattern, getQuerySelectNamesByType, getQuerySelectNamesByTypes, getQuerySelectNamesByValue, getQuerySelectNameTypes, getQuerySelectOccurrences, getQuerySelectOccurrencesByDatatype, getQuerySelectOccurrencesByDateRange, getQuerySelectOccurrencesByPattern, getQuerySelectOccurrencesByPatternAndDatatype, getQuerySelectOccurrencesByRange, getQuerySelectOccurrencesByType, getQuerySelectOccurrencesByTypes, getQuerySelectOccurrencesByValue, getQuerySelectOccurrencesByValueAndDatatype, getQuerySelectOccurrenceTypes, getQuerySelectRolesByType, getQuerySelectRolesByTypes, getQuerySelectRoleTypes, getQuerySelectSubjectIdentifiers, getQuerySelectSubjectLocators, getQuerySelectSubtypes, getQuerySelectSupertypes, getQuerySelectTopicsBySubjectIdentitifer, getQuerySelectTopicsBySubjectLocator, getQuerySelectTopicsByTypes, getQuerySelectTopicsWithoutSubtypes, getQuerySelectTopicsWithoutSupertypes, getQuerySelectTopicTypes, getQuerySelectVariants, getQuerySelectVariantsByDatatype, getQuerySelectVariantsByPattern, getQuerySelectVariantsByPatternAndDatatype, getQuerySelectVariantsByValue, getQuerySelectVariantsByValueAndDatatype, getQueryTopicDump, getQueryVariantDump, getQueryVariantsByScope, getQueryVariantsByScopes, getQueryVariantsByTheme, getQueryVariantsByThemes, getQueryVariantScopes, getQueryVariantThemes
 
Methods inherited from class de.topicmapslab.majortom.database.jdbc.rdbms.RDBMSQueryBuilder
getConnection, getQueryAssociationDumpInsertIntoHistory, getQueryAssociationDumpSelect, getQueryDeleteAllHistoryEntries, getQueryDeleteAllRevisions, getQueryDeleteAllScopes, getQueryDeleteAllThemes, getQueryDeleteHistory, getQueryDeleteItemIdentifiers, getQueryDeleteScope, getQueryDeleteThemesOfScope, getQueryModifyAssociationReifier, getQueryModifyAssociationScope, getQueryModifyAssociationType, getQueryModifyNameReifier, getQueryModifyNameScope, getQueryModifyNameType, getQueryModifyNameValue, getQueryModifyOccurrenceReifier, getQueryModifyOccurrenceScope, getQueryModifyOccurrenceType, getQueryModifyOccurrenceValueWithDatatype, getQueryModifyRoleReifier, getQueryModifyRoleType, getQueryModifySupertypesInsert, getQueryModifySupertypesSelect, getQueryModifyTopicMapReifier, getQueryModifyVariantReifier, getQueryModifyVariantScope, getQueryModifyVariantValueWithDatatype, getQueryNameDumpInsertIntoHistory, getQueryNameDumpSelect, getQueryOccurrenceDumpInsertIntoHistory, getQueryOccurrenceDumpSelect, getQueryReadAssociation, getQueryReadAssociationReifier, getQueryReadAssociationScope, getQueryReadAssociationType, getQueryReadAssociationWithScope, getQueryReadConstructById, getQueryReadConstructIdsByItemIdentifier, getQueryReadLocator, getQueryReadNameReifier, getQueryReadNameScope, getQueryReadNameType, getQueryReadNameValue, getQueryReadNumberOfAssociations, getQueryReadNumberOfTopics, getQueryReadOccurrenceDataType, getQueryReadOccurrenceReifier, getQueryReadOccurrenceScope, getQueryReadOccurrenceType, getQueryReadOccurrenceValue, getQueryReadRoleReifier, getQueryReadRoleType, getQueryReadTopicMapReifier, getQueryReadTopics, getQueryReadUsedScopeByTheme, getQueryReadVariantDataType, getQueryReadVariantReifier, getQueryReadVariantScope, getQueryReadVariantValue, getQueryRoleDumpInsertIntoHistory, getQueryRoleDumpSelect, getQuerySelectAllTopicsByTypes, getQuerySelectAllTopicsWithoutType, getQuerySelectConstructIdentifiersByPattern, getQuerySelectConstructItemIdentifiersByPattern, getQuerySelectTypes, getQueryTopicDumpInsertIntoHistory, getQueryTopicDumpSelect, getQueryUnsetTopicMapReifier, getQueryVariantDumpInsertIntoHistory, getQueryVariantDumpSelect
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

preparedStatementReadSupertypes

private java.sql.PreparedStatement preparedStatementReadSupertypes

preparedStatementReadBestLabel

private java.sql.PreparedStatement preparedStatementReadBestLabel

preparedStatementReadBestLabelWithTheme

private java.sql.PreparedStatement preparedStatementReadBestLabelWithTheme

preparedStatementReadScopeByThemes

private java.sql.PreparedStatement preparedStatementReadScopeByThemes

preparedStatementIndexAssociationsByTypeTransitive

private java.sql.PreparedStatement preparedStatementIndexAssociationsByTypeTransitive

preparedStatementIndexRolesByTypeTransitive

private java.sql.PreparedStatement preparedStatementIndexRolesByTypeTransitive

preparedStatementIndexNamesByTypeTransitive

private java.sql.PreparedStatement preparedStatementIndexNamesByTypeTransitive

preparedStatementIndexOccurrencesByTypeTransitive

private java.sql.PreparedStatement preparedStatementIndexOccurrencesByTypeTransitive

preparedStatementIndexTopicsByTypeTransitive

private java.sql.PreparedStatement preparedStatementIndexTopicsByTypeTransitive

preparedStatementIndexTopicsByTypesTransitive

private java.sql.PreparedStatement preparedStatementIndexTopicsByTypesTransitive

preparedStatementIndexAssociationsByTypeTransitivePaged

private java.sql.PreparedStatement preparedStatementIndexAssociationsByTypeTransitivePaged

preparedStatementIndexRolesByTypeTransitivePaged

private java.sql.PreparedStatement preparedStatementIndexRolesByTypeTransitivePaged

preparedStatementIndexNamesByTypeTransitivePaged

private java.sql.PreparedStatement preparedStatementIndexNamesByTypeTransitivePaged

preparedStatementIndexOccurrencesByTypeTransitivePaged

private java.sql.PreparedStatement preparedStatementIndexOccurrencesByTypeTransitivePaged

preparedStatementIndexTopicsByTypeTransitivePaged

private java.sql.PreparedStatement preparedStatementIndexTopicsByTypeTransitivePaged

preparedStatementIndexTopicsByTypesTransitivePaged

private java.sql.PreparedStatement preparedStatementIndexTopicsByTypesTransitivePaged

preparedStatementIndexScopesByThemesUsed

private java.sql.PreparedStatement preparedStatementIndexScopesByThemesUsed

preparedStatementIndexSubtypesOfTopic

private java.sql.PreparedStatement preparedStatementIndexSubtypesOfTopic

preparedStatementIndexSubtypesOfTopics

private java.sql.PreparedStatement preparedStatementIndexSubtypesOfTopics

preparedStatementIndexSupertypesOfTopic

private java.sql.PreparedStatement preparedStatementIndexSupertypesOfTopic

preparedStatementIndexSupertypesOfTopics

private java.sql.PreparedStatement preparedStatementIndexSupertypesOfTopics

preparedStatementIndexSubtypesOfTopicPaged

private java.sql.PreparedStatement preparedStatementIndexSubtypesOfTopicPaged

preparedStatementIndexSubtypesOfTopicsPaged

private java.sql.PreparedStatement preparedStatementIndexSubtypesOfTopicsPaged

preparedStatementIndexSupertypesOfTopicPaged

private java.sql.PreparedStatement preparedStatementIndexSupertypesOfTopicPaged

preparedStatementIndexSupertypesOfTopicsPaged

private java.sql.PreparedStatement preparedStatementIndexSupertypesOfTopicsPaged

preparedStatementRemoveDuplicates

private java.sql.PreparedStatement preparedStatementRemoveDuplicates

preparedStatementRemoveDuplicateTopicContent

private java.sql.PreparedStatement preparedStatementRemoveDuplicateTopicContent
Constructor Detail

PostGreSqlQueryBuilder

public PostGreSqlQueryBuilder(PostGreSqlSession session)
constructor

Parameters:
session - the session
Method Detail

getProcessor

public PostGreSqlQueryProcessor getProcessor()
Overrides:
getProcessor in class RDBMSQueryBuilder
Returns:
the processor

getSession

public PostGreSqlSession getSession()
Returns the internal session

Overrides:
getSession in class RDBMSQueryBuilder
Returns:
the session

close

public void close()

Specified by:
close in interface IQueryBuilder
Overrides:
close in class Sql99QueryBuilder

getQueryReadScopeByTheme

public java.sql.PreparedStatement getQueryReadScopeByTheme()
                                                    throws java.sql.SQLException

Specified by:
getQueryReadScopeByTheme in interface IQueryBuilder
Overrides:
getQueryReadScopeByTheme in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQueryReadSupertypes

public java.sql.PreparedStatement getQueryReadSupertypes()
                                                  throws java.sql.SQLException

Specified by:
getQueryReadSupertypes in interface IQueryBuilder
Overrides:
getQueryReadSupertypes in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQueryReadBestLabel

public java.sql.PreparedStatement getQueryReadBestLabel()
                                                 throws java.sql.SQLException
Throws:
java.sql.SQLException
Since:
1.1.2

getQueryReadBestLabelWithTheme

public java.sql.PreparedStatement getQueryReadBestLabelWithTheme()
                                                          throws java.sql.SQLException
Throws:
java.sql.SQLException
Since:
1.1.2

getQuerySelectAssociationsByTypeTransitive

public java.sql.PreparedStatement getQuerySelectAssociationsByTypeTransitive(boolean paged)
                                                                      throws java.sql.SQLException

Specified by:
getQuerySelectAssociationsByTypeTransitive in interface IQueryBuilder
Overrides:
getQuerySelectAssociationsByTypeTransitive in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQuerySelectRolesByTypeTransitive

public java.sql.PreparedStatement getQuerySelectRolesByTypeTransitive(boolean paged)
                                                               throws java.sql.SQLException

Specified by:
getQuerySelectRolesByTypeTransitive in interface IQueryBuilder
Overrides:
getQuerySelectRolesByTypeTransitive in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQuerySelectNamesByTypeTransitive

public java.sql.PreparedStatement getQuerySelectNamesByTypeTransitive(boolean paged)
                                                               throws java.sql.SQLException

Specified by:
getQuerySelectNamesByTypeTransitive in interface IQueryBuilder
Overrides:
getQuerySelectNamesByTypeTransitive in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQuerySelectOccurrencesByTypeTransitive

public java.sql.PreparedStatement getQuerySelectOccurrencesByTypeTransitive(boolean paged)
                                                                     throws java.sql.SQLException

Specified by:
getQuerySelectOccurrencesByTypeTransitive in interface IQueryBuilder
Overrides:
getQuerySelectOccurrencesByTypeTransitive in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQuerySelectTopicsByTypeTransitive

public java.sql.PreparedStatement getQuerySelectTopicsByTypeTransitive(boolean paged)
                                                                throws java.sql.SQLException

Specified by:
getQuerySelectTopicsByTypeTransitive in interface IQueryBuilder
Overrides:
getQuerySelectTopicsByTypeTransitive in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQuerySelectTopicsByTypesTransitive

public java.sql.PreparedStatement getQuerySelectTopicsByTypesTransitive(boolean paged)
                                                                 throws java.sql.SQLException

Specified by:
getQuerySelectTopicsByTypesTransitive in interface IQueryBuilder
Overrides:
getQuerySelectTopicsByTypesTransitive in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQueryScopesByThemesUsed

public java.sql.PreparedStatement getQueryScopesByThemesUsed()
                                                      throws java.sql.SQLException

Specified by:
getQueryScopesByThemesUsed in interface IQueryBuilder
Overrides:
getQueryScopesByThemesUsed in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQuerySelectSubtypesOfTopic

public java.sql.PreparedStatement getQuerySelectSubtypesOfTopic(boolean paged)
                                                         throws java.sql.SQLException

Specified by:
getQuerySelectSubtypesOfTopic in interface IQueryBuilder
Overrides:
getQuerySelectSubtypesOfTopic in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQuerySelectSubtypesOfTopics

public java.sql.PreparedStatement getQuerySelectSubtypesOfTopics(boolean paged)
                                                          throws java.sql.SQLException

Specified by:
getQuerySelectSubtypesOfTopics in interface IQueryBuilder
Overrides:
getQuerySelectSubtypesOfTopics in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQuerySelectSupertypesOfTopic

public java.sql.PreparedStatement getQuerySelectSupertypesOfTopic(boolean paged)
                                                           throws java.sql.SQLException

Specified by:
getQuerySelectSupertypesOfTopic in interface IQueryBuilder
Overrides:
getQuerySelectSupertypesOfTopic in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getQuerySelectSupertypesOfTopics

public java.sql.PreparedStatement getQuerySelectSupertypesOfTopics(boolean paged)
                                                            throws java.sql.SQLException

Specified by:
getQuerySelectSupertypesOfTopics in interface IQueryBuilder
Overrides:
getQuerySelectSupertypesOfTopics in class Sql99QueryBuilder
Throws:
java.sql.SQLException

getPerformRemoveDuplicates

public java.sql.PreparedStatement getPerformRemoveDuplicates()
                                                      throws java.sql.SQLException
Returns the prepared SQL statement to perform method 'remove_duplicates'

Returns:
the prepared statement and never null
Throws:
java.sql.SQLException - thrown if the statement cannot be created

getPerformRemoveDuplicateTopicContent

public java.sql.PreparedStatement getPerformRemoveDuplicateTopicContent()
                                                                 throws java.sql.SQLException
Returns the prepared SQL statement to perform method 'remove_duplicate_topiccontent'

Returns:
the prepared statement and never null
Throws:
java.sql.SQLException - thrown if the statement cannot be created