Package it.eng.spagobi.behaviouralmodel.lov.bo

Examples of it.eng.spagobi.behaviouralmodel.lov.bo.QueryDetail

151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
//    HttpSession httpSess = httpReq.getSession();
//    profile = (IEngUserProfile)httpSess.getAttribute(IEngUserProfile.ENG_USER_PROFILE);
    // based on lov type fill the spago list / paginator object / valColName
    SourceBean rowsSourceBean = null;
    if(typeLov.equalsIgnoreCase("QUERY")) {
      QueryDetail qd = QueryDetail.fromXML(looProvider);
//      if (qd.requireProfileAttributes()) {
//        String message = PortletUtilities.getMessage("scheduler.noProfileAttributesSupported", "component_scheduler_messages");
//        response.setAttribute(SpagoBIConstants.MESSAGE_INFO, message);
//        return list;
//      }
      valColName = qd.getValueColumnName();     
      //String pool = qd.getConnectionName();
      String datasource = qd.getDataSource();
      String statement = qd.getQueryDefinition();
      // execute query
      try {
        statement = StringUtilities.substituteProfileAttributesInString(statement, profile);
        //rowsSourceBean = (SourceBean) executeSelect(getRequestContainer(), getResponseContainer(), pool, statement);
        rowsSourceBean = (SourceBean) executeSelect(getRequestContainer(), getResponseContainer(), datasource, statement);
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
109
110
111
    }
    // based on lov type fill the spago list and paginator object
    SourceBean rowsSourceBean = null;
    List colNames = new ArrayList();
    if(typeLov.equalsIgnoreCase("QUERY")) {
      QueryDetail qd = QueryDetail.fromXML(looProvider);
      //String pool = qd.getConnectionName();
      String datasource = qd.getDataSource();
      String statement = qd.getQueryDefinition();
      // execute query
      try {
        statement = StringUtilities.substituteProfileAttributesInString(statement, profile);
        //rowsSourceBean = (SourceBean) executeSelect(getRequestContainer(), getResponseContainer(), pool, statement, colNames);
        rowsSourceBean = (SourceBean) executeSelect(getRequestContainer(), getResponseContainer(), datasource, statement, colNames);
View Full Code Here
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
        Object objectToTest = null;
       
       
        if(input_type_cd.equalsIgnoreCase("QUERY")) {
          String lovProv = modVal.getLovProvider();
          QueryDetail query = null;
          if( (lovProv==null) || (lovProv.trim().equals("")) ) {
            query = new QueryDetail();
          } else {
            query = (QueryDetail)LovDetailFactory.getLovFromXML(lovProv);
          }
          recoverQueryWizardValues(request, query);
          String lovProvider = query.toXML();
          modVal.setLovProvider(lovProvider);
          ValidationCoordinator.validate("PAGE", "QueryWizardValidation", this);
          objectToTest = query;
        }
       
View Full Code Here
758
759
760
761
762
763
764
765
766
767
768
769
    logger.debug("IN");
    try {
      String type = lov.getITypeCd();
      if(type.equalsIgnoreCase("QUERY")) {
        String provider = lov.getLovProvider();
        QueryDetail queryDet = QueryDetail.fromXML(provider);
        String datasourceName = queryDet.getDataSource();
        IDataSourceDAO dsDAO = DAOFactory.getDataSourceDAO();
        List allDS = dsDAO.loadAllDataSources();
        Iterator allDSIt = allDS.iterator();
        IDataSource dsFound = null;
        while (allDSIt.hasNext()) {
View Full Code Here
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
      Iterator iterLovs = lovs.iterator();
      while (iterLovs.hasNext()) {
        lov = (SbiLov) iterLovs.next();
        if (lov.getInputTypeCd().equalsIgnoreCase("QUERY")) {
          String lovProv = lov.getLovProvider();
          QueryDetail qDet = QueryDetail.fromXML(lovProv);
          String oldDataSource = qDet.getDataSource();
          String assDataSource = (String) associations.get(oldDataSource);

          // register user association
          if ((assDataSource != null) && !assDataSource.trim().equals("") && (oldDataSource != null)
              && !oldDataSource.trim().equals("")) {

            qDet.setDataSource(assDataSource);
            lovProv = qDet.toXML();
            lov.setLovProvider(lovProv);
            session.save(lov);
            log.log("Changed the data source label from " + oldDataSource + " to " + assDataSource
                + " for the lov " + lov.getName());
          }
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
142
143
144
      ExecutionInstance executionInstance) {
    logger.debug("IN");
    String toReturn = null;
    String userID = (String)((UserProfile)profile).getUserId();
    if (lovDefinition instanceof QueryDetail) {
      QueryDetail queryDetail = (QueryDetail) lovDefinition;
      QueryDetail clone = queryDetail.clone();
      clone.setQueryDefinition(queryDetail.getWrappedStatement(dependencies, executionInstance));
      toReturn = userID + ";" + clone.toXML();
    } else {
      toReturn = userID + ";" + lovDefinition.toXML();
    }
    logger.debug("OUT: returning [" + toReturn + "]");
    return toReturn;
View Full Code Here
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
    newlov.setName(lov.getName());
    newlov.setProfileAttr(lov.getProfileAttr());

    try {
      // if user has associated another datasource then set the associated one, else put the same
      QueryDetail queryDetail=new QueryDetail(lov.getLovProvider());
      String dataSource=queryDetail.getDataSource();
      if(dsExportUser!=null && dsExportUser.get(dataSource)!=null){
        String newDs=dsExportUser.get(dataSource);
        queryDetail.setDataSource(newDs);
      } else {
        queryDetail.setDataSource(dataSource);
      }
      newlov.setLovProvider(queryDetail.toXML());       
    }
    catch (Exception e) {
      logger.error("error in reading the xml of lov provider; transcribe the original by default ");   
    }
    if(newlov.getLovProvider() == null){
View Full Code Here
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
      existingLov.setDescr(exportedLov.getDescr());
      existingLov.setLabel(exportedLov.getLabel());

      try {
        // if user has associated another datasource then set the associated one, else put the same
        QueryDetail queryDetail=new QueryDetail(exportedLov.getLovProvider());
        String dataSource=queryDetail.getDataSource();
        if(dsExportUser!=null && dsExportUser.get(dataSource)!=null){
          String newDs=dsExportUser.get(dataSource);
          queryDetail.setDataSource(newDs);
        } else {
          queryDetail.setDataSource(dataSource);
        }

        existingLov.setLovProvider(queryDetail.toXML());       
      }
      catch (Exception e) {
        logger.error("error in reading the xml of lov provider; transcribe the original by default ");   
        existingLov.setLovProvider(exportedLov.getLovProvider());
      }
View Full Code Here
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
  private SourceBean executeQuery(String lovProvider, SourceBean response, IEngUserProfile profile) throws Exception {
  logger.debug("IN");
  SourceBean result = null;
  logger.debug("lovProvider="+lovProvider);
  QueryDetail qd = QueryDetail.fromXML(lovProvider);
  /*
  if (qd.requireProfileAttributes()) {
      String message = PortletUtilities.getMessage("scheduler.noProfileAttributesSupported",
        "component_scheduler_messages");
      response.setAttribute(SpagoBIConstants.MESSAGE_INFO, message);
      return result;
  }
  */
  valColName = qd.getValueColumnName();
  visibleColNames = qd.getVisibleColumnNames();
 
  logger.debug("valColName="+valColName);
  descriptionColName = qd.getDescriptionColumnName();
  logger.debug("descriptionColName="+descriptionColName);
  String datasource = qd.getDataSource();
  String statement = qd.getQueryDefinition();

  try {
      statement = StringUtilities.substituteProfileAttributesInString(statement, profile);
      result = (SourceBean) executeSelect(getRequestContainer(), getResponseContainer(), datasource, statement);
  } catch (Exception e) {
View Full Code Here
TOP

Related Classes of it.eng.spagobi.behaviouralmodel.lov.bo.QueryDetail

  • it.eng.spago.base.SourceBean
  • it.eng.spago.dbaccess.sql.DataConnection
  • it.eng.spago.dbaccess.sql.result.DataResult
  • it.eng.spago.dbaccess.sql.result.ScrollableDataResult
  • it.eng.spago.dbaccess.sql.SQLCommand
  • it.eng.spago.error.EMFUserError
  • it.eng.spagobi.analiticalmodel.document.handlers.LovResultCacheManager
  • it.eng.spagobi.analiticalmodel.execution.service.SelectParametersLookupModule
  • it.eng.spagobi.behaviouralmodel.analyticaldriver.bo.BIObjectParameter
  • it.eng.spagobi.behaviouralmodel.analyticaldriver.bo.ObjParuse
    • 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.