WrqCalc2Sql (BCD-UI Api)

java.lang.Object

de.businesscode.bcdui.wrs.load.WrqCalc2Sql

public class WrqCalc2Sql extends Object

Parses a Wrq and outputs SQL

Field Summary

Fields

Modifier and Type

Field

Description

protected final Map<String,String>

aggregationMapping

protected List<Element>

boundVariables

protected Element

calc

protected final Map<String,String[]>

calcFktMapping

protected WrqInfo

wrqInfo
Constructor Summary

Constructors

Constructor

Description

WrqCalc2Sql(WrqInfo wrqInfo)
Method Summary

Modifier and Type

Method

Description

protected void

closeOperator(Element e, StringBuffer sql)

protected static boolean

containsAggr(Element calc)

protected String

getWrqCalcAsSql(Element calc, List<Element> boundVariables, boolean enforceAggr, int dataType, List<String> wrqTableAlias)

Returns a list of strings representing parts of SQL All uneven pos (including first) belong to the aggregation level an all even pos give one un-aggregated sql calc Sample 1: SUM(t38.f_k01)+AVG(t38.f_k01*3) |1 | 2 | 3 | 4 | 5 Sample 2: SUM(SUM(t38.f_k01*t38.f_k01)) OVER (PARTITION BY orig_ctr) | 1 | 2 | 3 | 4 |

protected void

openOperator(Element e, StringBuffer sql)

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details
- wrqInfo
  
  protected WrqInfo wrqInfo
- calc
  
  protected Element calc
- boundVariables
  
  protected List<Element> boundVariables
- calcFktMapping
  
  protected final Map<String,String[]> calcFktMapping
- aggregationMapping
  
  protected final Map<String,String> aggregationMapping
Constructor Details
- WrqCalc2Sql
  
  public WrqCalc2Sql(WrqInfo wrqInfo)
Method Details
- getWrqCalcAsSql
  
  protected String getWrqCalcAsSql(Element calc, List<Element> boundVariables, boolean enforceAggr, int dataType, List<String> wrqTableAlias) throws Exception
  
  Returns a list of strings representing parts of SQL All uneven pos (including first) belong to the aggregation level an all even pos give one un-aggregated sql calc Sample 1: SUM(t38.f_k01)+AVG(t38.f_k01*3) |1 | 2 | 3 | 4 | 5 Sample 2: SUM(SUM(t38.f_k01*t38.f_k01)) OVER (PARTITION BY orig_ctr) | 1 | 2 | 3 | 4 |
  
  Throws:
  
  Exception
- containsAggr
  
  protected static boolean containsAggr(Element calc)
- openOperator
  
  protected void openOperator(Element e, StringBuffer sql) throws BindingNotFoundException
  
  Throws:
  
  BindingNotFoundException
- closeOperator
  
  protected void closeOperator(Element e, StringBuffer sql) throws BindingNotFoundException
  
  Throws:
  
  BindingNotFoundException