org.opensubsystems.patterns.listdata.persist.db
Class ListQueryPreprocessor

java.lang.Object
  org.opensubsystems.patterns.listdata.persist.db.ListQueryPreprocessor

public final class ListQueryPreprocessor
extends java.lang.Object

Utility class to share code which helps in preprocessing list queries

Version:

$Id: ListQueryPreprocessor.java,v 1.6 2007/02/20 04:15:23 bastafidli Exp $

Author:

Miro Halas

Code reviewer:

Miro Halas

Code reviewed:

1.3 2006/03/13 16:58:13 bastafidli

Method Summary

static java.lang.String

preprocessSelectQueryForCreationDate(java.lang.String inputQuery, ListOptions options, ListDatabaseSchema schema) Preprocess the query to correctly handle situation when we request to sort the data using the creation date in case the database doesn't provide very good precision for dates.

Methods inherited from class java.lang.Object

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

Method Detail

preprocessSelectQueryForCreationDate

public static java.lang.String preprocessSelectQueryForCreationDate(java.lang.String inputQuery,
                                                                    ListOptions options,
                                                                    ListDatabaseSchema schema)
                                                             throws org.opensubsystems.core.error.OSSException

Preprocess the query to correctly handle situation when we request to sort the data using the creation date in case the database doesn't provide very good precision for dates. In this case the result set will be sorted by both, creation date and id of the object.

Parameters:

inputQuery - - query to preprocess

options - - list options specifig what to rieve

schema - - schema requesting this preprocessing

Returns:

String - corrected query

Throws:

org.opensubsystems.core.error.OSSException - - an error has occured