com.viaoa.ds.jdbc.query

Class QueryConverter

java.lang.Object

com.viaoa.ds.jdbc.query.QueryConverter

public class QueryConverter
extends Object

Used internally for queries/selects to convert OA object queries into SQL.
Uses JOINs or LEFT OUTER JOINS to connect super/sub classes and ONE type references.
Uses EXISTS for MANY type references.
Will work with any valid object path.
Allows OR, ||, AND, &&, (), =, !=, NULL, <, <=, >, >=

Converts to SQL using OAQueryTokenizer to parse object query into tokens, along with Database to Object Mapping.

See Also:

to see if the query will require the use of the "DISTINCT" keyword.

Constructor Summary

Constructors

Constructor and Description
QueryConverter(Database database, DBMetaData dbmd)
QueryConverter(OADataSourceJDBC ds)

Method Summary

Modifier and Type	Method and Description
protected void	cleanTokens(Vector vec, Object[] params)
String	convertForPreparedStatmentSql(Class selectClass, Object whereObject, String propertyFromWhereObject, String orderBy)
String	convertToPreparedStatementSql(Class selectClass, Object whereObject, String extraWhere, Object[] args, String propertyFromWhereObject, String orderBy)
String	convertToSql(Class selectClass, Object whereObject, String extraWhere, Object[] args, String propertyFromWhereObject, String orderBy) propertyFromWhereObject name of link to use, from whereObject from Table(clazz).getLinks()[].propertyName = propertyFromWhereObject
String	convertToSql(Class clazz, String where, Object[] params, String orderBy)
protected String	convertToSql(Class clazz, String where, Object[] params, String orderBy, boolean bGetSubclasses)
protected String	convertToSql(Class clazz, String where, Object[] params, String orderBy, boolean bGetSubclasses, boolean bUsingPreparedStatement)
Object[]	getArguments()
protected String	getJoins()
protected String	getJoins(Vector vec, com.viaoa.ds.jdbc.query.QueryConverter.Linkinfo liStart, com.viaoa.ds.jdbc.query.QueryConverter.Linkinfo liEnd)
String	getPrimaryKeyColumns(Class clazz) returns list of columns to select for clazz primary key column
Class[]	getSelectClasses(Class startClass)
Column[]	getSelectColumnArray(Class clazz)
String	getSelectColumns(Class clazz, boolean bDirty) returns list of columns to select for clazz, not pkey or fkey columns, includes columns for superClasses
boolean	getUseDistinct() returns true if this query will only be able to select the Pk columns and the "Distinct" keyword should be used by the query to make sure that duplicates are not selected.
protected Column	parseLink(Vector vec, String line)
protected String	parseOrderBy(Class clazz, String line)
protected String	parseWhereUseExist(Class clazz, String whereClause, Object[] params, boolean bUsingPreparedStatement)
protected String	parseWhereUseJoin(Class clazz, String whereClause, Object[] params, boolean bUsingPreparedStatement)
protected void	reset()

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryConverter

public QueryConverter(OADataSourceJDBC ds)

QueryConverter

public QueryConverter(Database database,
                      DBMetaData dbmd)

Method Detail

getUseDistinct

public boolean getUseDistinct()

returns true if this query will only be able to select the Pk columns and the "Distinct" keyword should be used by the query to make sure that duplicates are not selected.

reset

protected void reset()

getPrimaryKeyColumns

public String getPrimaryKeyColumns(Class clazz)

returns list of columns to select for clazz primary key column

getSelectColumnArray

public Column[] getSelectColumnArray(Class clazz)

getSelectColumns

public String getSelectColumns(Class clazz,
                               boolean bDirty)

returns list of columns to select for clazz, not pkey or fkey columns, includes columns for superClasses

getSelectClasses

public Class[] getSelectClasses(Class startClass)

convertForPreparedStatmentSql

public String convertForPreparedStatmentSql(Class selectClass,
                                            Object whereObject,
                                            String propertyFromWhereObject,
                                            String orderBy)

convertToSql

public String convertToSql(Class selectClass,
                           Object whereObject,
                           String extraWhere,
                           Object[] args,
                           String propertyFromWhereObject,
                           String orderBy)

propertyFromWhereObject name of link to use, from whereObject from Table(clazz).getLinks()[].propertyName = propertyFromWhereObject

convertToPreparedStatementSql

public String convertToPreparedStatementSql(Class selectClass,
                                            Object whereObject,
                                            String extraWhere,
                                            Object[] args,
                                            String propertyFromWhereObject,
                                            String orderBy)

getArguments

public Object[] getArguments()

convertToSql

public String convertToSql(Class clazz,
                           String where,
                           Object[] params,
                           String orderBy)

convertToSql

protected String convertToSql(Class clazz,
                              String where,
                              Object[] params,
                              String orderBy,
                              boolean bGetSubclasses)

convertToSql

protected String convertToSql(Class clazz,
                              String where,
                              Object[] params,
                              String orderBy,
                              boolean bGetSubclasses,
                              boolean bUsingPreparedStatement)

parseOrderBy

protected String parseOrderBy(Class clazz,
                              String line)

parseWhereUseJoin

protected String parseWhereUseJoin(Class clazz,
                                   String whereClause,
                                   Object[] params,
                                   boolean bUsingPreparedStatement)

parseWhereUseExist

protected String parseWhereUseExist(Class clazz,
                                    String whereClause,
                                    Object[] params,
                                    boolean bUsingPreparedStatement)

parseLink

protected Column parseLink(Vector vec,
                           String line)

Parameters:

vec - list of Linkinfos to find property.

cleanTokens

protected void cleanTokens(Vector vec,
                           Object[] params)

getJoins

protected String getJoins()

getJoins

protected String getJoins(Vector vec,
                          com.viaoa.ds.jdbc.query.QueryConverter.Linkinfo liStart,
                          com.viaoa.ds.jdbc.query.QueryConverter.Linkinfo liEnd)