Package it.eng.qbe.query

Examples of it.eng.qbe.query.DataMartSelectField

189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
    StringBuffer buffer;
    List selectFields;
    List allSelectFields;
    List<InLineCalculatedSelectField> selectInLineCalculatedFields = new ArrayList<InLineCalculatedSelectField>();
    AbstractSelectField selectAbstractField;
    DataMartSelectField selectField;
    InLineCalculatedSelectField selectInLineField;
    IModelEntity rootEntity;
    IModelField datamartField;
    String queryName;
    String rootEntityAlias;
    String selectClauseElement; // rootEntityAlias.queryName
    Map entityAliases;
     
    logger.debug("IN");
    buffer = new StringBuffer();
    try {
      selectFields = query.getSelectFields(true);
     
      if(selectFields == null ||selectFields.size() == 0) {
        return "";
      }
     
      entityAliases = (Map)entityAliasesMaps.get(query.getId());
           
      buffer.append(SELECT);   
      if (query.isDistinctClauseEnabled()) {
        buffer.append(" " + DISTINCT);
      }
     
      Iterator it = selectFields.iterator();
      if(it.hasNext()){
        selectAbstractField = (AbstractSelectField)it.next();
        String[] idsForQuery = new String[selectFields.size()-query.getCalculatedSelectFields(true).size()];
        int index=0;
        do{       
          if(selectAbstractField.isDataMartField()){
         
            selectField = (DataMartSelectField)selectAbstractField;
           
            logger.debug("select field unique name [" + selectField.getUniqueName() + "]");
           
            datamartField = getDataSource().getModelStructure().getField(selectField.getUniqueName());
           
            Couple queryNameAndRoot = datamartField.getQueryName();
           
            queryName = (String) queryNameAndRoot.getFirst();
            logger.debug("select field query name [" + queryName + "]");
           
            if(queryNameAndRoot.getSecond()!=null){
              rootEntity = (IModelEntity)queryNameAndRoot.getSecond();  
            }else{
              rootEntity = datamartField.getParent().getRoot();  
            }
           
             
            logger.debug("select field root entity unique name [" + rootEntity.getUniqueName() + "]");
           
            rootEntityAlias = (String)entityAliases.get(rootEntity.getUniqueName());
            if(rootEntityAlias == null) {
              rootEntityAlias = getNextAlias(entityAliasesMaps);
              entityAliases.put(rootEntity.getUniqueName(), rootEntityAlias);
            }
            logger.debug("select field root entity alias [" + rootEntityAlias + "]");
           
           
            selectClauseElement = rootEntityAlias + "." + queryName.substring(0,1).toLowerCase()+queryName.substring(1);
            //selectClauseElement = rootEntityAlias + "." + queryName;
            logger.debug("select clause element before aggregation [" + selectClauseElement + "]");
           
            selectClauseElement = selectField.getFunction().apply(selectClauseElement);
            logger.debug("select clause element after aggregation [" + selectClauseElement + "]");
           
           
            idsForQuery[index] = " " + selectClauseElement;
            index++;
View Full Code Here
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
    try {
    Map<String, Set<String>> viewToInnerEntitiesMap = new HashMap<String, Set<String>>();
    List<ISelectField> selectFields =  query.getSelectFields(true);
    for(ISelectField selectField : selectFields) {
      if(selectField.isDataMartField()){
        DataMartSelectField dataMartSelectField = (DataMartSelectField)selectField;
        IModelField modelField = getDataSource().getModelStructure().getField(dataMartSelectField.getUniqueName());
        List<ModelViewEntity> viewEntities = modelField.getParentViews();
        if(viewEntities!=null){
          for(ModelViewEntity viewEntity : viewEntities) {
            if( !viewToInnerEntitiesMap.containsKey( viewEntity.getUniqueName() ) ) {
              viewToInnerEntitiesMap.put(viewEntity.getUniqueName(), new HashSet<String>());
View Full Code Here
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
      if(abstractSelectedField.isInLineCalculatedField()){
        InLineCalculatedSelectField icf = (InLineCalculatedSelectField)abstractSelectedField;
        fieldName = parseInLinecalculatedField(icf.getExpression(), query, entityAliasesMaps);
      }else{
     
        DataMartSelectField groupByField = (DataMartSelectField)abstractSelectedField;
        IModelField datamartField = getDataSource().getModelStructure().getField(groupByField.getUniqueName());
       
           
        Couple queryNameAndRoot = datamartField.getQueryName();
        IModelEntity root;
        String queryName = (String) queryNameAndRoot.getFirst();
View Full Code Here
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
 
  private List getOrderByFields(Query query) {
    List orderByFields = new ArrayList();
    Iterator it = query.getDataMartSelectFields(false).iterator();
    while( it.hasNext() ) {
      DataMartSelectField selectField = (DataMartSelectField)it.next();
      if(selectField.isOrderByField()) {
        orderByFields.add(selectField);
      }
    }
    return orderByFields;
  }
View Full Code Here
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
  }
 
  private String buildOrderByClause(Query query, Map entityAliasesMaps) {
    StringBuffer buffer;
    Iterator it;
    DataMartSelectField selectField;
   
    it = getOrderByFields(query).iterator();   
    if(!it.hasNext()) {
      return "";
    }
   
    buffer = new StringBuffer(); 
    buffer.append("ORDER BY");
   
    Map entityAliases = (Map)entityAliasesMaps.get(query.getId());
         
    while( it.hasNext() ) {
      selectField = (DataMartSelectField)it.next();
     
      Assert.assertTrue(selectField.isOrderByField(), "Field [" + selectField.getUniqueName() +"] is not an orderBy filed");
     
      IModelField datamartField = getDataSource().getModelStructure().getField(selectField.getUniqueName());
      Couple queryNameAndRoot = datamartField.getQueryName();
      IModelEntity root;
      String queryName = (String) queryNameAndRoot.getFirst();
      logger.debug("select field query name [" + queryName + "]");
     
      if(queryNameAndRoot.getSecond()!=null){
        root = (IModelEntity)queryNameAndRoot.getSecond();  
      }else{
        root = datamartField.getParent().getRoot();  
      }
     
      if(!entityAliases.containsKey(root.getUniqueName())) {
        entityAliases.put(root.getUniqueName(), getNextAlias(entityAliasesMaps));
      }
      String entityAlias = (String)entityAliases.get( root.getUniqueName() );
      String fieldName = entityAlias + "." + queryName;
      buffer.append(" " + selectField.getFunction().apply(fieldName));
      buffer.append(" " + (selectField.isAscendingOrder()?"ASC": "DESC") );
           
      if( it.hasNext() ) {
        buffer.append(",");
      }
    }
View Full Code Here
TOP

Related Classes of it.eng.qbe.query.DataMartSelectField

  • it.eng.qbe.query.serializer.json.QueryJSONSerializer
  • it.eng.qbe.statement.AbstractQbeDataSet
  • it.eng.qbe.statement.hibernate.HQLStatement
  • it.eng.qbe.statement.jpa.JPQLStatement
  • it.eng.spagobi.engines.qbe.services.formviewer.ExecuteMasterQueryAction
  • it.eng.spagobi.engines.qbe.services.formviewer.FormViewerQueryTransformer
  • it.eng.spagobi.engines.qbe.services.formviewer.GetSelectedColumnsAction
  • it.eng.spagobi.engines.qbe.utils.crosstab.CrosstabQueryCreator
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.