Examples of ThinQuery

Examples of org.saiku.olap.query2.ThinQuery

119
120
121
122
123
124
125
126
127
128
129
130
131
132
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
159
160
161
162
      @PathParam("queryname") String queryName,
      @FormParam("json") String jsonFormParam,
      @FormParam("file") String fileFormParam,
      MultivaluedMap<String, String> formParams) throws ServletException {
    try {
      ThinQuery tq = null;
      String file = fileFormParam;
      String json = jsonFormParam;
      if (formParams != null) {
        json = formParams.containsKey("json") ? formParams.getFirst("json") : jsonFormParam;
        file = formParams.containsKey("file") ? formParams.getFirst("file") : fileFormParam;
      }
      String filecontent = null;
      if (StringUtils.isNotBlank(json)) {
        filecontent = json;
      } else if (StringUtils.isNotBlank(file)) {
        Response f = repository.getResource(file);
        filecontent = new String((byte[]) f.getEntity());
      }
      if (StringUtils.isBlank(filecontent)) {
        throw new SaikuServiceException(
            "Cannot create new query. Empty file content " + StringUtils.isNotBlank(json) + " or read from file:"
            + file);
      }
      if (thinQueryService.isOldQuery(filecontent)) {
        tq = thinQueryService.convertQuery(filecontent);
      } else {
        ObjectMapper om = new ObjectMapper();
        tq = om.readValue(filecontent, ThinQuery.class);
      }

      if (LOG.isDebugEnabled()) {
        LOG.debug("TRACK\t" + "\t/query/" + queryName + "\tPOST\t tq:" + (tq == null) + " file:" + file);
      }

      if (tq == null) {
        throw new SaikuServiceException("Cannot create blank query (ThinQuery object = null)");
      }
      tq.setName(queryName);

      //SaikuCube cube = tq.getCube();
      //if (StringUtils.isNotBlank(xml)) {
      //String query = ServletUtil.replaceParameters(formParams, xml);
      //return thinQueryService.createNewOlapQuery(queryName, query);
View Full Code Here

Examples of org.saiku.olap.query2.ThinQuery

183
184
185
186
187
188
189
190
191
192
193
        rsc.setRuntime(runtime.intValue());
        return rsc;
      }

      QueryResult qr = RestUtil.convert(thinQueryService.execute(tq));
      ThinQuery tqAfter = thinQueryService.getContext(tq.getName()).getOlapQuery();
      qr.setQuery(tqAfter);
      return qr;
    } catch (Exception e) {
      LOG.error("Cannot execute query (" + tq + ")", e);
      String error = ExceptionUtils.getRootCauseMessage(e);
View Full Code Here

Examples of org.saiku.olap.query2.ThinQuery

214
215
216
217
218
219
220
221
222
223
224
  @POST
  @Consumes({ "application/json" })
  @Path("/enrich")
  public ThinQuery enrich(ThinQuery tq) {
    try {
      ThinQuery tqAfter = thinQueryService.updateQuery(tq);
      return tqAfter;
    } catch (Exception e) {
      LOG.error("Cannot enrich query (" + tq + ")", e);
      String error = ExceptionUtils.getRootCauseMessage(e);
      throw new WebApplicationException(Response.serverError().entity(error).build());
View Full Code Here

Examples of org.saiku.olap.query2.ThinQuery

344
345
346
347
348
349
350
351
352
353
354
            }
            realPositions.add(cellPosition);
          }
        }
      }
      ThinQuery tq = thinQueryService.zoomIn(queryName, realPositions);
      return tq;

    } catch (Exception e) {
      LOG.error("Cannot zoom in on query (" + queryName + ")", e);
      throw new WebApplicationException(e);
View Full Code Here

Examples of org.saiku.olap.query2.ThinQuery

532
533
534
535
536
537
538
539
      @PathParam("queryname") String queryname,
      @QueryParam("format") String format,
      @QueryParam("css") @DefaultValue("false") Boolean css,
      @QueryParam("tableonly") @DefaultValue("false") Boolean tableonly,
      @QueryParam("wrapcontent") @DefaultValue("true") Boolean wrapcontent) {
    ThinQuery tq = thinQueryService.getContext(queryname).getOlapQuery();
    return exportHtml(tq, format, css, tableonly, wrapcontent);
  }
View Full Code Here

Examples of org.saiku.olap.query2.ThinQuery

600
601
602
603
604
605
606
607
608
609
610
      }
      ObjectMapper mapper = new ObjectMapper();
      Map<String, List<String>> levels = mapper.readValue(returns, TypeFactory
          .mapType(Map.class, TypeFactory.fromClass(String.class),
              TypeFactory.collectionType(ArrayList.class, String.class)));
      ThinQuery q = thinQueryService.drillacross(queryName, cellPosition, levels);
      return q;

    } catch (Exception e) {
      LOG.error("Cannot execute query (" + queryName + ")", e);
      String error = ExceptionUtils.getRootCauseMessage(e);
View Full Code Here

Examples of org.saiku.olap.query2.ThinQuery

76
77
78
79
80
81
82
83
84
85
86
87
88
      String queryName = UUID.randomUUID().toString();
      //fileContent = ServletUtil.replaceParameters(servletRequest, fileContent);
//queryResource.createQuery(queryName,  null,  null, null, fileContent, queryName, null);
//queryResource.execute(queryName, formatter, 0);
      Map<String, String> parameters = ServletUtil.getParameters(servletRequest);
      ThinQuery tq = query2Resource.createQuery(queryName, fileContent, null, null);
      if (parameters != null) {
        tq.getParameters().putAll(parameters);
      }
      query2Resource.execute(tq);
      return query2Resource.getQueryExcelExport(queryName, formatter);
    } catch (Exception e) {
      LOG.error("Error exporting XLS for file: " + file, e);
View Full Code Here

Examples of org.saiku.olap.query2.ThinQuery

102
103
104
105
106
107
108
109
110
111
112
113
114
      //fileContent = ServletUtil.replaceParameters(servletRequest, fileContent);
      String queryName = UUID.randomUUID().toString();
//query2Resource.createQuery(null,  null,  null, null, fileContent, queryName, null);
//query2Resource.execute(queryName,formatter, 0);
      Map<String, String> parameters = ServletUtil.getParameters(servletRequest);
      ThinQuery tq = query2Resource.createQuery(queryName, fileContent, null, null);
      if (parameters != null) {
        tq.getParameters().putAll(parameters);
      }
      query2Resource.execute(tq);
      return query2Resource.getQueryCsvExport(queryName);
    } catch (Exception e) {
      LOG.error("Error exporting CSV for file: " + file, e);
View Full Code Here

Examples of org.saiku.olap.query2.ThinQuery

128
129
130
131
132
133
134
135
136
137
138
139
140
      fileContent = ServletUtil.replaceParameters(servletRequest, fileContent);
      String queryName = UUID.randomUUID().toString();
//query2Resource.createQuery(null,  null,  null, null, fileContent, queryName, null);
//QueryResult qr = query2Resource.execute(queryName, formatter, 0);
      Map<String, String> parameters = ServletUtil.getParameters(servletRequest);
      ThinQuery tq = query2Resource.createQuery(queryName, fileContent, null, null);
      if (parameters != null) {
        tq.getParameters().putAll(parameters);
      }
      QueryResult qr = query2Resource.execute(tq);
      return Response.ok().entity(qr).build();
    } catch (Exception e) {
      LOG.error("Error exporting JSON for file: " + file, e);
View Full Code Here

Examples of org.saiku.olap.query2.ThinQuery

127
128
129
130
131
132
133
134
135
136
137
  @Deprecated
  public ThinQuery createEmpty(String name, SaikuCube cube) {
    try {
      Cube cub = olapDiscoverService.getNativeCube(cube);
      Query query = new Query(name, cub);
      ThinQuery tq = Thin.convert(query, cube);
      return tq;

    } catch (Exception e) {
      LOG.error("Cannot create new query for cube :" + cube, e);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.