macaw.persistenceLayer.production
Class SQLFilterQueries

java.lang.Object
  macaw.persistenceLayer.production.SQLFilterQueries

public class SQLFilterQueries
extends java.lang.Object

(c) 2009 Medical Research Council of the United Kingdom. Copyright 2010 Medical Research Council Unit for Lifelong Health and Ageing Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Version:

1.0

Author:

Kevin Garwood (kgarwood@users.sourceforge.net)

Constructor Summary

SQLFilterQueries(Log log, SQLListChoiceManager listChoiceManager)

Method Summary

java.util.ArrayList<OntologyTerm>	filterOntologyTerms(java.sql.Connection connection, java.lang.String term, java.lang.String description)
java.util.ArrayList<SupportingDocument>	filterSupportingDocuments(java.sql.Connection connection, java.lang.String documentTitleFilter, java.lang.String documentCodeFilter)
java.util.ArrayList<VariableSummary>	filterVariableSummaries(java.sql.Connection connection, java.lang.String searchText, java.lang.String year, java.lang.String categoryName, VariableTypeFilter variableTypeFilter) we don't need to create a derivedVariables table because there are no concepts beyond the ones in Variables we need to retain.

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLFilterQueries

public SQLFilterQueries(Log log,
                        SQLListChoiceManager listChoiceManager)

Method Detail

filterVariableSummaries

public java.util.ArrayList<VariableSummary> filterVariableSummaries(java.sql.Connection connection,
                                                                    java.lang.String searchText,
                                                                    java.lang.String year,
                                                                    java.lang.String categoryName,
                                                                    VariableTypeFilter variableTypeFilter)
                                                             throws MacawException

we don't need to create a derivedVariables table because there are no concepts beyond the ones in Variables we need to retain. The exception is the list of source variables for each derived variable but that is handled in a separate table.

Parameters:

connection -

Throws:

java.sql.SQLException

MacawException

filterSupportingDocuments

public java.util.ArrayList<SupportingDocument> filterSupportingDocuments(java.sql.Connection connection,
                                                                         java.lang.String documentTitleFilter,
                                                                         java.lang.String documentCodeFilter)
                                                                  throws MacawException

Throws:

MacawException

filterOntologyTerms

public java.util.ArrayList<OntologyTerm> filterOntologyTerms(java.sql.Connection connection,
                                                             java.lang.String term,
                                                             java.lang.String description)
                                                      throws MacawException

Throws:

MacawException