oracle.ifs.search

Class SQLGenerator

java.lang.Object

oracle.ifs.search.SQLGenerator

public class SQLGenerator
extends Object

The S_SQLGenerator class encapsulates SQL generation functionality.

Version:

1.0

Author:

Harish Butani

See Also:

SearchSpecification, SearchQualification, Search

(Unpublished)

Field Summary

Fields

Modifier and Type	Field and Description
protected S_LibrarySession	m_Session
protected SQLGeneration_Helper	m_SQLHelper

Method Summary

Modifier and Type	Method and Description
protected static SQLGenerator	constructGenerator(S_LibrarySession sess)
static void	disposeGenerator(S_LibrarySession session) Disposes any previously-constructed SQLGenerator for the specified session.
protected String	generateFromClause(AttributeSearchSpecification asp)
protected String	generateOrderByClause(AttributeSearchSpecification asp, oracle.ifs.search.ContextScoreVisitor vis)
protected String	generateSecurityClause(AttributeSearchSpecification asp, String ownerValue)
protected String	generateSelectList(AttributeSearchSpecification asp, boolean searchCountOnly)
protected String	generateSubClassClause(AttributeSearchSpecification asp)
protected String	generateViewSelectList(AttributeSearchSpecification asp, ViewSpecification vsp)
protected String	generateWhereClause(AttributeSearchSpecification asp, String ownerValue)
protected String[]	getOrderAttributes(SearchSpecification sp, String clss, String name, oracle.ifs.search.ContextScoreVisitor vis)
protected String	getSQLStatement(String prefix, AttributeSearchSpecification asp, boolean searchCountOnly)
protected String	getSQLStatement(String prefix, ContextSearchSpecification csp, ContextTable[] ctxTabs, boolean searchCountOnly)
protected String	getViewStatement(ViewSpecification vsp, AttributeSearchSpecification asp)
protected String	getViewStatement(ViewSpecification vsp, ContextSearchSpecification csp, ContextTable[] ctxTabs)

Methods inherited from class java.lang.Object

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

Field Detail

m_Session

protected S_LibrarySession m_Session

(Unpublished)

m_SQLHelper

protected SQLGeneration_Helper m_SQLHelper

(Unpublished)

Method Detail

constructGenerator

protected static SQLGenerator constructGenerator(S_LibrarySession sess)

(Unpublished)

disposeGenerator

public static void disposeGenerator(S_LibrarySession session)

Disposes any previously-constructed SQLGenerator for the specified session.

Parameters:

session - the session

(Unpublished)

getSQLStatement

protected String getSQLStatement(String prefix,
                                 AttributeSearchSpecification asp,
                                 boolean searchCountOnly)
                          throws IfsException

Throws:

IfsException

(Unpublished)

getSQLStatement

protected String getSQLStatement(String prefix,
                                 ContextSearchSpecification csp,
                                 ContextTable[] ctxTabs,
                                 boolean searchCountOnly)
                          throws IfsException

Throws:

IfsException

(Unpublished)

generateSelectList

protected String generateSelectList(AttributeSearchSpecification asp,
                                    boolean searchCountOnly)
                             throws IfsException

Throws:

IfsException

(Unpublished)

generateFromClause

protected String generateFromClause(AttributeSearchSpecification asp)
                             throws IfsException

Throws:

IfsException

(Unpublished)

generateWhereClause

protected String generateWhereClause(AttributeSearchSpecification asp,
                                     String ownerValue)
                              throws IfsException

Throws:

IfsException

(Unpublished)

generateSecurityClause

protected String generateSecurityClause(AttributeSearchSpecification asp,
                                        String ownerValue)
                                 throws IfsException

Throws:

IfsException

(Unpublished)

generateSubClassClause

protected String generateSubClassClause(AttributeSearchSpecification asp)
                                 throws IfsException

Throws:

IfsException

(Unpublished)

getOrderAttributes

protected String[] getOrderAttributes(SearchSpecification sp,
                                      String clss,
                                      String name,
                                      oracle.ifs.search.ContextScoreVisitor vis)
                               throws IfsException

Throws:

IfsException

(Unpublished)

generateOrderByClause

protected String generateOrderByClause(AttributeSearchSpecification asp,
                                       oracle.ifs.search.ContextScoreVisitor vis)
                                throws IfsException

Throws:

IfsException

(Unpublished)

getViewStatement

protected String getViewStatement(ViewSpecification vsp,
                                  AttributeSearchSpecification asp)
                           throws IfsException

Throws:

IfsException

(Unpublished)

getViewStatement

protected String getViewStatement(ViewSpecification vsp,
                                  ContextSearchSpecification csp,
                                  ContextTable[] ctxTabs)
                           throws IfsException

Throws:

IfsException

(Unpublished)

generateViewSelectList

protected String generateViewSelectList(AttributeSearchSpecification asp,
                                        ViewSpecification vsp)
                                 throws IfsException

Throws:

IfsException

(Unpublished)