public class SqlConstraintUtils extends Object
SqlConstraint
,
used to generate constraints into SqlQuery
.Modifier and Type | Method and Description |
---|---|
static void |
addContextConstraint(SqlQuery sqlQuery,
AggStar aggStar,
Evaluator evaluator,
boolean restrictMemberTypes)
For every restricting member in the current context, generates
a WHERE condition and a join to the fact table.
|
static void |
addMemberConstraint(SqlQuery sqlQuery,
RolapCube baseCube,
AggStar aggStar,
List<RolapMember> members,
boolean restrictMemberTypes,
boolean crossJoin,
boolean exclude)
Creates a "WHERE exp IN (...)" condition containing the values
of all parents.
|
static void |
addMemberConstraint(SqlQuery sqlQuery,
RolapCube baseCube,
AggStar aggStar,
RolapMember parent,
boolean restrictMemberTypes)
Creates a "WHERE parent = value" constraint.
|
static String |
constrainLevel(RolapLevel level,
SqlQuery query,
RolapCube baseCube,
AggStar aggStar,
String columnValue,
boolean caseSensitive)
Generates a sql expression constraining a level by some value
|
static boolean |
containsCalculatedMember(Member[] members) |
static boolean |
hasMultiPositionSlicer(Evaluator evaluator)
Looks at the given
evaluator to determine if it has more
than one slicer member from any particular hierarchy. |
static void |
joinLevelTableToFactTable(SqlQuery sqlQuery,
RolapCube baseCube,
AggStar aggStar,
Evaluator e,
RolapCubeLevel level)
Ensures that the table of
level is joined to the fact
table |
(package private) static List<Member> |
removeCalculatedMembers(List<Member> members) |
protected static Member[] |
removeMultiPositionSlicerMembers(Member[] members,
Evaluator evaluator) |
public static void addContextConstraint(SqlQuery sqlQuery, AggStar aggStar, Evaluator evaluator, boolean restrictMemberTypes)
sqlQuery
- the query to modifyaggStar
- Aggregate table, or null if query is against fact tablerestrictMemberTypes
- defines the behavior if the current context
contains calculated members. If true, thows an exception.evaluator
- Evaluatorpublic static boolean hasMultiPositionSlicer(Evaluator evaluator)
evaluator
to determine if it has more
than one slicer member from any particular hierarchy.evaluator
- the evaluator to look attrue
if the evaluator's slicer has more than one
member from any particular hierarchyprotected static Member[] removeMultiPositionSlicerMembers(Member[] members, Evaluator evaluator)
public static boolean containsCalculatedMember(Member[] members)
public static void joinLevelTableToFactTable(SqlQuery sqlQuery, RolapCube baseCube, AggStar aggStar, Evaluator e, RolapCubeLevel level)
level
is joined to the fact
tablesqlQuery
- sql query under constructionaggStar
- e
- evaluator corresponding to querylevel
- level to be added to querypublic static void addMemberConstraint(SqlQuery sqlQuery, RolapCube baseCube, AggStar aggStar, RolapMember parent, boolean restrictMemberTypes)
sqlQuery
- the query to modifybaseCube
- base cube if virtualaggStar
- Definition of the aggregate table, or nullparent
- the list of parent membersrestrictMemberTypes
- defines the behavior if parent
is a calculated member. If true, an exception is thrownpublic static void addMemberConstraint(SqlQuery sqlQuery, RolapCube baseCube, AggStar aggStar, List<RolapMember> members, boolean restrictMemberTypes, boolean crossJoin, boolean exclude)
If this constraint is part of a native cross join, there are multiple constraining members, and the members comprise the cross product of all unique member keys referenced at each level, then generating IN expressions would result in incorrect results. In that case, "WHERE ((level1 = val1a AND level2 = val2a AND ...) OR (level1 = val1b AND level2 = val2b AND ...) OR ..." is generated instead.
sqlQuery
- the query to modifybaseCube
- base cube if virtualaggStar
- (not used)members
- the list of members for this constraintrestrictMemberTypes
- defines the behavior if parents
contains calculated members.
If true, and one of the members is calculated, an exception is thrown.crossJoin
- true if constraint is being generated as part of
a native crossjoinexclude
- whether to exclude the members in the SQL predicate.
e.g. not in { member list}.public static String constrainLevel(RolapLevel level, SqlQuery query, RolapCube baseCube, AggStar aggStar, String columnValue, boolean caseSensitive)
level
- the levelquery
- the query that the sql expression will be added tobaseCube
- base cube for virtual levelsaggStar
- aggregate star if availablecolumnValue
- value constraining the levelcaseSensitive
- if true, need to handle case sensitivity of the
member value