Class SQLBuilder
- java.lang.Object
-
- net.ontopia.persistence.query.sql.SQLBuilder
-
public class SQLBuilder extends Object
INTERNAL: Class used to build SQL queries from JDO queries.
-
-
Field Summary
Fields Modifier and Type Field Description protected booleandebugprotected ObjectRelationalMappingIFmapping
-
Constructor Summary
Constructors Constructor Description SQLBuilder(ObjectRelationalMappingIF mapping)SQLBuilder(ObjectRelationalMappingIF mapping, boolean debug)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description protected ClasscheckCompatibility(JDOValueIF value, Class type, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected ClasscheckCompatibility(JDOValueIF value1, JDOValueIF value2, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected FieldInfoIFgetFieldInfo(JDOCollection coll, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected FieldInfoIFgetFieldInfo(JDOField field, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected FieldInfoIFgetFieldInfo(JDOObject object, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected FieldInfoIFgetFieldInfo(JDOParameter param, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected FieldInfoIFgetFieldInfo(JDOValueIF jdovalue, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected FieldInfoIFgetFieldInfo(JDOVariable var, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLQuerygetFirstSQLQuery(SQLSetOperation sqlset)protected ClassgetIdentifiableValueType(JDOField field, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected ClassgetIdentifiableValueType(JDOValueIF jdovalue, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected String[]getInlineColumns(FieldInfoIF finfo)protected String[]getKeyColumns(FieldInfoIF finfo)protected intgetSQLOrder(JDOOrderBy orderby)protected ClassgetValueType(JDOField field, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected ClassgetValueType(JDOValueIF value, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected booleanisAggregateParameter(String param, JDOQuery jdoquery)protected booleanisAggregateType(Class type)protected booleanisAggregateVariable(String var, JDOQuery jdoquery)protected booleanisIdentifiableParameter(String param, JDOQuery jdoquery)protected booleanisIdentifiableType(Class type)protected booleanisIdentifiableValueType(JDOValueIF jdovalue, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected booleanisIdentifiableVariable(String var, JDOQuery jdoquery)protected booleanisPrimitiveParameter(String param, JDOQuery jdoquery)protected booleanisPrimitiveType(Class type)protected booleanisPrimitiveVariable(String var, JDOQuery jdoquery)protected SQLExpressionIFmakeAndExpression(List<SQLExpressionIF> expressions)protected SQLExpressionIFmakeOrExpression(SQLExpressionIF[] expressions)SQLQuerymakeQuery(JDOQuery jdoquery, ObjectAccessIF oaccess)protected voidproduceAnd(JDOAnd and_expr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceBoolean(JDOBoolean boolean_expr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproduceCollection(JDOCollection coll, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceContains(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceEndsWith(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceEquals(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceExpression(JDOExpressionIF jdoexpr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLExpressionIF[]produceExpressions(JDOExpressionIF[] jdoexprs, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproduceField(JDOField field, SQLTable endtable, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected net.ontopia.persistence.query.sql.SQLBuilder.ValuesproduceFieldValues(JDOField field, SQLTable endtable, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproduceFunction(JDOFunction func, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceIsEmpty(JDOValueIF value, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceLike(JDOValueIF left, JDOValueIF right, boolean caseSensitive, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceLikeWithPattern(JDOValueIF left, JDOValueIF right, boolean caseSensitive, List<SQLExpressionIF> expressions, boolean starts_not_ends, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproduceNativeValue(JDONativeValue field, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceNot(JDONot not_expr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceNotEquals(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproduceObject(JDOObject object, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected net.ontopia.persistence.query.sql.SQLBuilder.ValuesproduceObjectFieldValues(JDOObject obj, String[] path, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceOr(JDOOr or_expr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproduceParameter(JDOParameter par, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproducePrimitive(JDOPrimitive primitive, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLAggregateIFproduceSelectSQLAggregateIF(JDOAggregateIF aggregate, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproduceSelectSQLValueIF(JDOValueIF value, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLSetOperationproduceSetOperation(JDOSetOperation setop_expr, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLOrderByproduceSQLOrderBy(JDOOrderBy orderby, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceStartsWith(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproduceValue(JDOValueIF value, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected voidproduceValueExpression(JDOValueExpression jdoexpr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIF[]produceValues(JDOValueIF[] values, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLValueIFproduceVariable(JDOVariable var, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected net.ontopia.persistence.query.sql.SQLBuilder.ValuesproduceVariableFieldValues(JDOValueIF root, String[] path, SQLTable endtable, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)protected SQLAggregateIFwrapAggregate(int aggtype, SQLValueIF sqlvalue)
-
-
-
Field Detail
-
debug
protected boolean debug
-
mapping
protected ObjectRelationalMappingIF mapping
-
-
Constructor Detail
-
SQLBuilder
public SQLBuilder(ObjectRelationalMappingIF mapping)
-
SQLBuilder
public SQLBuilder(ObjectRelationalMappingIF mapping, boolean debug)
-
-
Method Detail
-
makeQuery
public SQLQuery makeQuery(JDOQuery jdoquery, ObjectAccessIF oaccess)
-
getFirstSQLQuery
protected SQLQuery getFirstSQLQuery(SQLSetOperation sqlset)
-
produceSQLOrderBy
protected SQLOrderBy produceSQLOrderBy(JDOOrderBy orderby, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getSQLOrder
protected int getSQLOrder(JDOOrderBy orderby)
-
produceSelectSQLValueIF
protected SQLValueIF produceSelectSQLValueIF(JDOValueIF value, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getKeyColumns
protected String[] getKeyColumns(FieldInfoIF finfo)
-
getInlineColumns
protected String[] getInlineColumns(FieldInfoIF finfo)
-
produceSelectSQLAggregateIF
protected SQLAggregateIF produceSelectSQLAggregateIF(JDOAggregateIF aggregate, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
wrapAggregate
protected SQLAggregateIF wrapAggregate(int aggtype, SQLValueIF sqlvalue)
-
makeAndExpression
protected SQLExpressionIF makeAndExpression(List<SQLExpressionIF> expressions)
-
makeOrExpression
protected SQLExpressionIF makeOrExpression(SQLExpressionIF[] expressions)
-
produceExpression
protected void produceExpression(JDOExpressionIF jdoexpr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceSetOperation
protected SQLSetOperation produceSetOperation(JDOSetOperation setop_expr, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceBoolean
protected void produceBoolean(JDOBoolean boolean_expr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceValueExpression
protected void produceValueExpression(JDOValueExpression jdoexpr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceAnd
protected void produceAnd(JDOAnd and_expr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceNot
protected void produceNot(JDONot not_expr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceOr
protected void produceOr(JDOOr or_expr, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceExpressions
protected SQLExpressionIF[] produceExpressions(JDOExpressionIF[] jdoexprs, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceEquals
protected void produceEquals(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceNotEquals
protected void produceNotEquals(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceContains
protected void produceContains(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceIsEmpty
protected void produceIsEmpty(JDOValueIF value, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceStartsWith
protected void produceStartsWith(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceEndsWith
protected void produceEndsWith(JDOValueIF left, JDOValueIF right, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceLike
protected void produceLike(JDOValueIF left, JDOValueIF right, boolean caseSensitive, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceLikeWithPattern
protected void produceLikeWithPattern(JDOValueIF left, JDOValueIF right, boolean caseSensitive, List<SQLExpressionIF> expressions, boolean starts_not_ends, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceValues
protected SQLValueIF[] produceValues(JDOValueIF[] values, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceValue
protected SQLValueIF produceValue(JDOValueIF value, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceField
protected SQLValueIF produceField(JDOField field, SQLTable endtable, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceFieldValues
protected net.ontopia.persistence.query.sql.SQLBuilder.Values produceFieldValues(JDOField field, SQLTable endtable, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceVariableFieldValues
protected net.ontopia.persistence.query.sql.SQLBuilder.Values produceVariableFieldValues(JDOValueIF root, String[] path, SQLTable endtable, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceObjectFieldValues
protected net.ontopia.persistence.query.sql.SQLBuilder.Values produceObjectFieldValues(JDOObject obj, String[] path, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceVariable
protected SQLValueIF produceVariable(JDOVariable var, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceParameter
protected SQLValueIF produceParameter(JDOParameter par, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
producePrimitive
protected SQLValueIF producePrimitive(JDOPrimitive primitive, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceNativeValue
protected SQLValueIF produceNativeValue(JDONativeValue field, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceFunction
protected SQLValueIF produceFunction(JDOFunction func, List<SQLExpressionIF> expressions, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceObject
protected SQLValueIF produceObject(JDOObject object, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
produceCollection
protected SQLValueIF produceCollection(JDOCollection coll, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getFieldInfo
protected FieldInfoIF getFieldInfo(JDOValueIF jdovalue, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getFieldInfo
protected FieldInfoIF getFieldInfo(JDOVariable var, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getFieldInfo
protected FieldInfoIF getFieldInfo(JDOParameter param, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getFieldInfo
protected FieldInfoIF getFieldInfo(JDOObject object, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getFieldInfo
protected FieldInfoIF getFieldInfo(JDOCollection coll, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getFieldInfo
protected FieldInfoIF getFieldInfo(JDOField field, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
checkCompatibility
protected Class checkCompatibility(JDOValueIF value1, JDOValueIF value2, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
checkCompatibility
protected Class checkCompatibility(JDOValueIF value, Class type, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getValueType
protected Class getValueType(JDOValueIF value, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getValueType
protected Class getValueType(JDOField field, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
isIdentifiableValueType
protected boolean isIdentifiableValueType(JDOValueIF jdovalue, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getIdentifiableValueType
protected Class getIdentifiableValueType(JDOValueIF jdovalue, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
getIdentifiableValueType
protected Class getIdentifiableValueType(JDOField field, net.ontopia.persistence.query.sql.SQLBuilder.BuildInfo info)
-
isIdentifiableType
protected boolean isIdentifiableType(Class type)
-
isAggregateType
protected boolean isAggregateType(Class type)
-
isPrimitiveType
protected boolean isPrimitiveType(Class type)
-
-