Namespace: OpenEdge.DataAdmin.Lang
Class
QueryString
Parent classes:
Progress.Lang.Object
OpenEdge.DataAdmin.Lang.QueryString

Inherits: Progress.Lang.Object

CLASS QueryString HD
Purpose Manage query string tranformation and manipulation.
String based, need no handles or compilation.
Manages a query string with field expressions and allows a caller
to add these expressions to the correct tables in an existing query.
The main purpose is to support query transformation from a query
with field expressions against a domain table to a query expressed
against physical tables.
The mapping and transformation is optionally triggered by
passing an object that implements IQueryMap as the second parameter.
Parameters: pcQueryWhere complete query expression
pQueryMap optional IQueryMap (columnSource, defaultQuery)
Notes: This is a copied subset of ADM2's query manipulation with
additional parsing.
- The BaseQuery are important for transformation, but can also
be used provide table options to the main query when used with no tranformation.
(and workaround the lack of full query parsing)
- The passed pcQueryWhere could fail with too complex queries ...
There is still an attempt to handle anything by just giving up and
treat complex expressions as a single expression while the
transformation continues.. . If it fails with expressions on
functions with parenthesis try to add a parenthesis around
functions that also have parenthesis (no promise..) or fix the code.
- The passed query is expected to be a working (compilable) dynamic
temp-table query with no database options like locking. Outer
joins would not make sense in this context either.
- It is crucial that all values are quoted to be correctly parsed,
(also needed to handle non american numeric and date formats,
assuming same session format settings here as when applied)
- The transformation can split the expressions on different tables
if they are using an AND operator. An expression against multiple
tables with an OR operator between them will be added to the query
entry of the last of the tables.
- Allthough some of the code is based on the ADM, it is still meant
as sample of query manipulation.
There are alternatives to full parsing.
The query syntax is after all is a subset of the ABL programming
language. Maybe reconsider the design to see if some of the
complexity could be better encapsulated in the data access or data
source object. Even if this logic expects the query to be in
compilable form it is not really necessary at this stage, so tokens
and special patterns could be used to ease the
transformation/mapping.




Method Summary
Options Name Purpose
AddExpression (character)
AddFilter (character, character, character)
AddFilter (log[], character[], character[], character[])
CHARACTER BufferWhereClause (character, character, integer)
CHARACTER BuildDefaultQueryString (character) Return a default query from data (no table options) ------------------------------------------------------------------------------*/
CHARACTER BuildFindString (character) /* untested and doesn't do anything that you could not do with buildQueryString */
CHARACTER BuildFindString (character, character) /* untested and doesn't do anything that you could not do with buildQueryString */
CHARACTER BuildFindString (handle)
CHARACTER BuildParsedQueryString (character)
CHARACTER BuildQueryString ()
CHARACTER BuildQueryString (character)
CHARACTER BuildQueryString (handle)
CHARACTER BuildSortExpression (character) /* return sort only for specified tables */
LOGICAL CanAddRefTables (character, integer, character)
CHARACTER CheckIndex (handle)
ClearFilter ()
ClearQuery ()
CHARACTER GetCased (character)
CHARACTER GetEvaluation (integer)
CHARACTER GetEvaluationTables (integer, character)
CHARACTER GetParsedQueryTables ()
CHARACTER GetTableEvaluation (integer, integer, character)
CHARACTER GetTableExpression (character)
CHARACTER GetUnparsedWhereClause (character) /** get the buffer where clause from the unparsed query ..*/
CHARACTER InsertExpression (character, character, character)
CHARACTER InsertString (character, character, integer, integer) /* workaround for temporary core bug */
LOGICAL InsertToQuery (handle) /* insert the querystring into the query - uses mQueryRef IQueryMap:BaseQuery if unprepared - buffers decide the order (can be different than BaseQuery )*/
CHARACTER MaskQuotes (character, character) Utility function that masks all quoted strings in the passed string Parameters: pcString = string that might have embedded quoted strings. must be syntactically correct - paired single or double. pcReplaceChar = single char to insert in quoted positions.
CHARACTER MergeQueryString (character, character)
CHARACTER NewQuerySort (character, character)
ParseQuery (character)
ParseSortExpression (character)
CHARACTER ResolveColumn (character, integer)
SetQueryString (character) /* set querystring */
SetSort (character) /* ParseSortExpression will transform and set SortExpression property, which has a protected set */
Showdata ()
CHARACTER TableEvaluation (integer, character)
CHARACTER WhereClauseBuffer (character)

Constructor Summary
Options Name Purpose
QueryString () /* use as utility - InsertExpression */
QueryString (character) /* queryWhere is a simple query without any table options like no-lock */
QueryString (character, character) /* QueryWhere - is a simple query without any table options like no-lock can have query options like indexed-reposition Basequery - query to which the QueryWhere and filters should be merged - provide table options as well as a fixed expressions - uses BuildDefaultQuery if base query is blank or ? */
QueryString (character, IQueryMap) /* queryWhere is a simple query without any table options like no-lock Basequery */
QueryString (IQueryMap)

Property Summary
Options Name Purpose
CHARACTER BaseQuery
LOGICAL MergeQuery
CHARACTER QueryOptions
CHARACTER SortExpression
CHARACTER Statement
CHARACTER Tables
LOGICAL UpperCaseKeyWords


Method Detail
Top

PUBLIC AddExpression (character)
Parameters:
pcExpression CHARACTER
Top

PUBLIC AddFilter (character, character, character)
Parameters:
pColumnName CHARACTER
pColumnOperator CHARACTER
pColValue CHARACTER
Top

PUBLIC AddFilter (log[], character[], character[], character[])
Parameters:
logicalAnd LOGICAL
columnNames CHARACTER
columnOperators CHARACTER
colValues CHARACTER
Top

PRIVATE CHARACTER BufferWhereClause (character, character, integer)
Parameters:
pcBuffer CHARACTER
pcWhere CHARACTER
piPos INTEGER
Returns CHARACTER
Top

PROTECTED CHARACTER BuildDefaultQueryString (character)
Purpose: Return a default query from data (no table options)
Parameters:
pcTables CHARACTER
Returns CHARACTER
Top

PUBLIC CHARACTER BuildFindString (character)
/* untested and doesn't do anything that you could not do with buildQueryString
Parameters:
pcTable CHARACTER
Returns CHARACTER
Top

PRIVATE CHARACTER BuildFindString (character, character)
/* untested and doesn't do anything that you could not do with buildQueryString
Parameters:
pcTable CHARACTER
pcQuery CHARACTER
Returns CHARACTER
Top

PUBLIC CHARACTER BuildFindString (handle)
Parameters:
phQuery HANDLE
Returns CHARACTER
Top

PUBLIC CHARACTER BuildParsedQueryString (character)
Parameters:
pcTables CHARACTER
Returns CHARACTER
Top

PUBLIC CHARACTER BuildQueryString ()
Returns CHARACTER
Top

PUBLIC CHARACTER BuildQueryString (character)
Parameters:
pcTables CHARACTER
Returns CHARACTER
Top

PUBLIC CHARACTER BuildQueryString (handle)
Parameters:
phQuery HANDLE
Returns CHARACTER
Top

PUBLIC CHARACTER BuildSortExpression (character)
/* return sort only for specified tables
Parameters:
pcTables CHARACTER
Returns CHARACTER
Top

PRIVATE LOGICAL CanAddRefTables (character, integer, character)
Parameters:
pcRefTables CHARACTER
piTableLevel INTEGER
pcTables CHARACTER
Returns LOGICAL
Top

PUBLIC CHARACTER CheckIndex (handle)
Parameters:
phBuffer HANDLE
Returns CHARACTER
Top

PUBLIC ClearFilter ()
Top

PROTECTED ClearQuery ()
Top

PRIVATE CHARACTER GetCased (character)
Parameters:
word CHARACTER
Returns CHARACTER
Top

PRIVATE CHARACTER GetEvaluation (integer)
Parameters:
piEval INTEGER
Returns CHARACTER
Top

PRIVATE CHARACTER GetEvaluationTables (integer, character)
Parameters:
piEval INTEGER
pcTables CHARACTER
Returns CHARACTER
Top

PUBLIC CHARACTER GetParsedQueryTables ()
Returns CHARACTER
Top

PRIVATE CHARACTER GetTableEvaluation (integer, integer, character)
Parameters:
piEval INTEGER
piTableEntry INTEGER
pcTables CHARACTER
Returns CHARACTER
Top

PUBLIC CHARACTER GetTableExpression (character)
Parameters:
pcTable CHARACTER
Returns CHARACTER
Top

PUBLIC CHARACTER GetUnparsedWhereClause (character)
Purpose: get the buffer where clause from the unparsed query ..
Parameters:
pcBuffer CHARACTER
Returns CHARACTER
Top

PUBLIC CHARACTER InsertExpression (character, character, character)
Parameters:
pcWhere CHARACTER
pcExpression CHARACTER
pcAndOr CHARACTER
Returns CHARACTER
Top

PROTECTED CHARACTER InsertString (character, character, integer, integer)
/* workaround for temporary core bug
Parameters:
pcString CHARACTER
pcTargetString CHARACTER
piPos INTEGER
piLength INTEGER
Returns CHARACTER
Top

PUBLIC LOGICAL InsertToQuery (handle)
/* insert the querystring into the query
- uses mQueryRef IQueryMap:BaseQuery if unprepared
- buffers decide the order (can be different than BaseQuery )
Parameters:
phQuery HANDLE
Returns LOGICAL
Top

PUBLIC CHARACTER MaskQuotes (character, character)
Purpose: Utility function that masks all quoted strings in the passed string
Parameters: pcString = string that might have embedded quoted strings.
must be syntactically correct - paired single or double.
pcReplaceChar = single char to insert in quoted positions.
Notes: Used in various query manipulation before looking for keywords
(Basically a workaround for lack of full parsing )
Parameters:
pcString CHARACTER
pcReplaceChar CHARACTER
Returns CHARACTER
Top

PRIVATE CHARACTER MergeQueryString (character, character)
Parameters:
pcTables CHARACTER
pcBaseQuery CHARACTER
Returns CHARACTER
Top

PRIVATE CHARACTER NewQuerySort (character, character)
Parameters:
pcQuery CHARACTER
pcSort CHARACTER
Returns CHARACTER
Top

PROTECTED ParseQuery (character)
Parameters:
pcQuery CHARACTER
Top

PRIVATE ParseSortExpression (character)
Parameters:
pcSort CHARACTER
Top

PRIVATE CHARACTER ResolveColumn (character, integer)
Parameters:
pcColumn CHARACTER
piExp INTEGER
Returns CHARACTER
Top

PUBLIC SetQueryString (character)
/* set querystring
Parameters:
cQuery CHARACTER
Top

PUBLIC SetSort (character)
/* ParseSortExpression will transform and set SortExpression property,
which has a protected set
Parameters:
cSort CHARACTER
Top

PUBLIC Showdata ()
Top

PRIVATE CHARACTER TableEvaluation (integer, character)
Parameters:
piTableEntry INTEGER
pcTables CHARACTER
Returns CHARACTER
Top

PRIVATE CHARACTER WhereClauseBuffer (character)
Parameters:
pcWhere CHARACTER
Returns CHARACTER


Constructor Detail
Top

PUBLIC QueryString ()
/* use as utility - InsertExpression
Top

PUBLIC QueryString (character)
/* queryWhere is a simple query without any table options like no-lock
Parameters:
pcQueryWhere CHARACTER
Top

PUBLIC QueryString (character, character)
/* QueryWhere - is a simple query without any table options like no-lock can have query options
like indexed-reposition
Basequery - query to which the QueryWhere and filters should be merged
- provide table options as well as a fixed expressions
- uses BuildDefaultQuery if base query is blank or ?
Parameters:
pcQueryWhere CHARACTER
pcBaseWhere CHARACTER
Top

PUBLIC QueryString (character, IQueryMap)
/* queryWhere is a simple query without any table options like no-lock
Basequery
Parameters:
pcQueryWhere CHARACTER
pQueryMap OpenEdge.DataAdmin.Lang.IQueryMap
Top

PUBLIC QueryString (IQueryMap)
Parameters:
pQueryMap OpenEdge.DataAdmin.Lang.IQueryMap


Property Detail
Top

PUBLIC CHARACTER BaseQuery
Returns CHARACTER
Top

PUBLIC LOGICAL MergeQuery
Returns LOGICAL
Top

PUBLIC CHARACTER QueryOptions
Returns CHARACTER
Top

PUBLIC CHARACTER SortExpression
Returns CHARACTER
Top

PUBLIC CHARACTER Statement
Returns CHARACTER
Top

PUBLIC CHARACTER Tables
Returns CHARACTER
Top

PUBLIC LOGICAL UpperCaseKeyWords
Returns LOGICAL


Copyright © 2019 Progress Software Corporation. All rights Reserved.

Progress® OpenEdge® Release 12.0.0