Package it.eng.qbe.query.catalogue

Examples of it.eng.qbe.query.catalogue.QueryCatalogue

74
75
76
77
78
79
80
81
82
83
84
   
    logger.debug("IN");
   
    this.template = template;
   
    queryCatalogue = new QueryCatalogue();
    queryCatalogue.addQuery(new Query());
   
       
    it.eng.spagobi.tools.datasource.bo.IDataSource dataSrc = (it.eng.spagobi.tools.datasource.bo.IDataSource)env.get( EngineConstants.ENV_DATASOURCE );
    SpagoBiDataSource ds = dataSrc.toSpagoBiDataSource();
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
    JSONArray queriesJSON;
    JSONObject queryJSON;
    JSONArray filtersJSON;
    JSONObject filterJSON;
    // just to create well formed id for loaded queries
    QueryCatalogue catalogue;
   
    logger.debug("IN");
   
    resultJSON = new JSONObject();
    catalogueJSON = new JSONObject();
    queriesJSON = new JSONArray();
    try {
      logger.debug( "Converting from encoding version [" + FROM_VERSION + "] to encoding version [" + TO_VERSION + "] ..." );
     
      queryJSON = data;
      // fix query encoding ...
      catalogue = new QueryCatalogue();
      String queryId = catalogue.getNextValidId();
      queryJSON.put( "id",  queryId);
      queryJSON.put( "name", "query_" + queryId );
      queryJSON.put("description", "query_" + queryId );
      queryJSON.put( "distinct", false );
      queryJSON.put( "subqueries", new JSONArray() );
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
   
    return rowData.getBytes();
  }

  public QueryCatalogue getCatalogue() {
    QueryCatalogue catalogue;
    JSONObject catalogueJSON;
    JSONArray queriesJSON;
    JSONObject queryJSON;
    Query query;
   
    catalogue = new QueryCatalogue();
    catalogueJSON = (JSONObject)getProperty( QbeEngineStaticVariables.CATALOGUE );
    try {
      queriesJSON = catalogueJSON.getJSONArray("queries");
   
      for(int i = 0; i < queriesJSON.length(); i++) {
        queryJSON = queriesJSON.getJSONObject(i);
        query = SerializerFactory.getDeserializer("application/json").deserializeQuery(queryJSON, getDataSource());
               
        catalogue.addQuery(query);
      }
    } catch (Throwable e) {
      throw new SpagoBIEngineRuntimeException("Impossible to deserialize catalogue", e);
    }
   
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
  public void service(SourceBean request, SourceBean response) {
   
    String searchType;
    String searchFilter;
    QbeEngineInstance engineInstance;
    QueryCatalogue queryCatalogue;
    Set<Query> queries;
    JSONObject queryJSON;
    JSONObject responseJSON;
    JSONArray resultsJSON;
   
    logger.debug("IN");
   
    try {
      super.service(request, response); 
     
      searchType = getAttributeAsString(SEARCH_TYPE);   
      logger.debug("Parameter [" + SEARCH_TYPE + "] is equals to [" + searchType + "]");
      if(StringUtilities.isEmpty(searchType)) searchType = SEARCH_TYPE_FULLDUMP;
     
      searchFilter = getAttributeAsString(SEARCH_FILTER); 
      logger.debug("Parameter [" + SEARCH_FILTER + "] is equals to [" + searchFilter + "]");
     
      // retrieve first query from catalog
      engineInstance = getEngineInstance();
      queryCatalogue = engineInstance.getQueryCatalogue();
     
      queries = new HashSet();
      if(SEARCH_TYPE_FULLDUMP.equalsIgnoreCase(searchType)) {
        queries.addAll( queryCatalogue.getAllQueries(false) );
      } else if (SEARCH_TYPE_BYID.equalsIgnoreCase(searchType)) {
        queries.add(queryCatalogue.getQuery(searchFilter));
      } else if (SEARCH_TYPE_BYNAME.equalsIgnoreCase(searchType)) {
        queries.addAll(queryCatalogue.getQueryByName(searchFilter));
      } else if (SEARCH_TYPE_BYTYPE.equalsIgnoreCase(searchType)) {
        if(searchFilter.equalsIgnoreCase("first")) {
          queries.add(queryCatalogue.getFirstQuery());
        }
      }
     
      // serialize query
      resultsJSON = new JSONArray();
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
   
    try {
      super.service(request, response); 
      // retrieve first query from catalog
      QbeEngineInstance engineInstance = getEngineInstance();
      QueryCatalogue queryCatalogue = engineInstance.getQueryCatalogue();
      Query query = queryCatalogue.getFirstQuery();
      // serialize query
      JSONObject queryJSON = (JSONObject)SerializerFactory.getSerializer("application/json").serialize(query, getEngineInstance().getDataSource(), getLocale());
     
      try {
        writeBackToClient( new JSONSuccess(queryJSON) );
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
147
     
      if(queryType.equalsIgnoreCase("standard")) {
        query = buildQuery(entityId, orderEntity, orderType, queryRootEntity);
      } else {
        QbeEngineInstance engineInstance = this.getEngineInstance();
        QueryCatalogue queryCatalogue = engineInstance.getQueryCatalogue();
        query = queryCatalogue.getQuery(lookupQuery);
        if(query == null) {
          throw new SpagoBIEngineServiceException(getActionName(), "Impossible to retrive custom query [" + lookupQuery + "] from catalogue");
        }
       
      }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
96
  }
   
    private void init() {
      if (ds == null) {
        it.eng.qbe.datasource.IDataSource qbeDataSource = getQbeDataSource();
        QueryCatalogue catalogue = getCatalogue(jsonQuery, qbeDataSource);
        Query query = catalogue.getFirstQuery();
       
        ds = QbeDatasetFactory.createDataSet(qbeDataSource.createStatement(query));
        ds.setUserProfileAttributes(attributes);
        ds.setParamsMap(params);
        ds.setTransformerId(transformerId);
View Full Code Here
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
        return dialectName;
    }
   
   
  public QueryCatalogue getCatalogue(String json, it.eng.qbe.datasource.IDataSource dataSource) {
    QueryCatalogue catalogue;
    JSONObject catalogueJSON;
    JSONArray queriesJSON;
    JSONObject queryJSON;
    Query query;
   
    catalogue = new QueryCatalogue();
    try {
      catalogueJSON = new JSONObject(json).getJSONObject("catalogue");
      queriesJSON = catalogueJSON.getJSONArray("queries");
   
      for(int i = 0; i < queriesJSON.length(); i++) {
        queryJSON = queriesJSON.getJSONObject(i);
        query = it.eng.qbe.query.serializer.SerializerFactory.getDeserializer("application/json").deserializeQuery(queryJSON, dataSource);
               
        catalogue.addQuery(query);
      }
    } catch (Throwable e) {
      throw new SpagoBIEngineRuntimeException("Impossible to deserialize catalogue", e);
    }
   
View Full Code Here
TOP

Related Classes of it.eng.qbe.query.catalogue.QueryCatalogue

  • it.eng.qbe.dataset.QbeDataSet
  • it.eng.qbe.query.Query
  • it.eng.spagobi.engines.qbe.analysisstateloaders.Version0QbeEngineAnalysisStateLoader
  • it.eng.spagobi.engines.qbe.QbeEngineAnalysisState
  • it.eng.spagobi.engines.qbe.QbeEngineInstance
  • it.eng.spagobi.engines.qbe.services.core.catalogue.GetFirstQueryAction
  • it.eng.spagobi.engines.qbe.services.core.catalogue.GetQueryAction
  • it.eng.spagobi.engines.qbe.services.core.GetFilterValuesAction
  • java.util.HashMap
  • java.util.Set
    • 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.