Package org.pentaho.commons.connection

Examples of org.pentaho.commons.connection.IPentahoResultSet

173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
              IPentahoConnection.MDX_DATASOURCE,
              "jdbc:hsqldb:hsql://localhost:9001/sampledata; Catalog=" + file.toURI().toString(), "mondrian", "sa", "",
              session, this ); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$

    try {
      IPentahoResultSet results = connection.executeQuery( "select * from DEPARTMENT_MANAGERS" ); //$NON-NLS-1$
      Object[][] columnHeaders = results.getMetaData().getColumnHeaders();
      for ( int row = 0; row < columnHeaders.length; row++ ) {
        for ( int col = 0; col < columnHeaders[0].length; col++ ) {
          outputStream.write( columnHeaders[row][col].toString().getBytes() );
          outputStream.write( ",".getBytes() ); //$NON-NLS-1$
        }
        outputStream.write( "\n".getBytes() ); //$NON-NLS-1$
      }
      Object[] row = results.next();
      while ( row != null ) {
        for ( int i = 0; i < row.length; i++ ) {
          outputStream.write( row[i].toString().getBytes() );
          outputStream.write( ",".getBytes() ); //$NON-NLS-1$
        }
        outputStream.write( "\n".getBytes() ); //$NON-NLS-1$
        row = results.next();
      }

    } catch ( Exception e ) {
      // TODO Auto-generated catch block
      e.printStackTrace();
View Full Code Here
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
              session, null ); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
    String query =
        "select {[Measures].[Actual], [Measures].[Budget]} on rows, {[Region].[All Regions]} ON columns from [Quadrant Analysis] WHERE ([Positions].[All Positions])"; //$NON-NLS-1$

    try {
      IPentahoResultSet results = connection.executeQuery( query );
      Object[][] columnHeaders = results.getMetaData().getColumnHeaders();
      for ( int row = columnHeaders.length - 1; row >= 0; row-- ) {
        for ( int col = 0; col < columnHeaders[row].length; col++ ) {
          outputStream.write( ( columnHeaders[row][col] + "\t" ).getBytes() ); //$NON-NLS-1$
        }
        outputStream.write( '\n' );
      }

      Object[][] rowHeaders = results.getMetaData().getRowHeaders();
      int rowIdx = 0;

      Object[] row = results.next();
      while ( row != null ) {
        for ( int colIdx = rowHeaders[rowIdx].length - 1; colIdx >= 0; colIdx-- ) {
          outputStream.write( ( rowHeaders[rowIdx][colIdx].toString() + "\t" ).getBytes() ); //$NON-NLS-1$
        }
        for ( int colIdx = 0; colIdx < row.length; colIdx++ ) {
          outputStream.write( ( row[colIdx] + "\t" ).getBytes() ); //$NON-NLS-1$
        }
        outputStream.write( '\n' );
        row = results.next();
        rowIdx++;
      }
      results.close();

    } catch ( Exception e ) {
      e.printStackTrace();
    }
    connection.close();
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
            "jdbc:hsqldb:hsql://localhost:9001/sampledata; Catalog=" + catalog, "mondrian", "sa", "", session, null ); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
    String query =
        "select {[Measures].[Actual], [Measures].[Budget]} on rows, {[Region].[All Regions]} ON columns from [Quadrant Analysis] WHERE ([Positions].[All Positions])"; //$NON-NLS-1$

    try {
      IPentahoResultSet results = connection.executeQuery( query );
      Object[][] columnHeaders = results.getMetaData().getColumnHeaders();
      for ( int row = columnHeaders.length - 1; row >= 0; row-- ) {
        for ( int col = 0; col < columnHeaders[row].length; col++ ) {
          outputStream.write( ( columnHeaders[row][col] + "\t" ).getBytes() ); //$NON-NLS-1$
        }
        outputStream.write( '\n' );
      }

      Object[][] rowHeaders = results.getMetaData().getRowHeaders();
      int rowIdx = 0;

      Object[] row = results.next();
      while ( row != null ) {
        for ( int colIdx = rowHeaders[rowIdx].length - 1; colIdx >= 0; colIdx-- ) {
          outputStream.write( ( rowHeaders[rowIdx][colIdx].toString() + "\t" ).getBytes() ); //$NON-NLS-1$
        }
        for ( int colIdx = 0; colIdx < row.length; colIdx++ ) {
          outputStream.write( ( row[colIdx] + "\t" ).getBytes() ); //$NON-NLS-1$
        }
        outputStream.write( '\n' );
        row = results.next();
        rowIdx++;
      }
      results.close();

    } catch ( Exception e ) {
      e.printStackTrace();
    }
    connection.close();
View Full Code Here
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
      IPentahoConnection connection =
          PentahoConnectionFactory.getConnection( IPentahoConnection.XML_DATASOURCE, session, this );
      String query =
          "doc(\"" + PentahoSystem.getApplicationContext().getSolutionPath( "samples/datasources/books.xml" ) + "\")/bookstore/book"; //$NON-NLS-1$ //$NON-NLS-2$//$NON-NLS-3$
      query = query.replace( '\\', '/' );
      IPentahoResultSet results = connection.executeQuery( query );
      assertNotNull( results );
      Object[][] columnHeaders = results.getMetaData().getColumnHeaders();
      for ( int row = 0; row < columnHeaders.length; row++ ) {
        for ( int col = 0; col < columnHeaders[0].length; col++ ) {
          outputStream.write( columnHeaders[row][col].toString().getBytes() );
          outputStream.write( ',' );
        }
        outputStream.write( '\n' );
      }
      Object[] row = results.next();
      while ( row != null ) {
        for ( int i = 0; i < row.length; i++ ) {
          outputStream.write( row[i].toString().getBytes() );
          outputStream.write( ',' );
        }
        outputStream.write( '\n' );
        row = results.next();
      }

    } catch ( Exception e ) {
      // TODO Auto-generated catch block
      e.printStackTrace();
View Full Code Here
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
    XQueryAction xQueryAction = (XQueryAction) getActionDefinition();
    boolean success = false;
    String finalQuery = applyInputsToFormat( rawQuery );
    // execute the query, read the results and cache them
    try {
      IPentahoResultSet resultSet = ( (XQConnection) localConnection ).executeQuery( finalQuery, columnTypes );
      if ( resultSet != null ) {
        if ( !xQueryAction.getLive().getBooleanValue( true ) ) {
          resultSet = resultSet.memoryCopy();
        }
        try {
          IActionOutput resultSetOutput = xQueryAction.getOutputResultSet();
          if ( resultSetOutput != null ) {
            resultSetOutput.setValue( resultSet );
          }
          success = true;
        } finally {
          resultSet.close();
        }
      }
    } catch ( XPathException e ) {
      error(
        Messages.getInstance().getErrorString( "XQueryBaseComponent.ERROR_0006_EXECUTE_FAILED", getActionName() ),
View Full Code Here
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
      TemplateUtil.applyTemplate( preparedQuery, getRuntimeContext(), new MapParameterResolver( preparedParams,
        IPreparedComponent.PREPARE_LATER_PREFIX, getRuntimeContext() ) );

    // execute the query, read the results and cache them
    try {
      IPentahoResultSet resultSet = ( (XQConnection) connection ).executeQuery( finalQuery, preparedColumnTypes );
      if ( resultSet != null ) {
        boolean live = getInputBooleanValue( StandardSettings.LIVE, true );
        if ( !live ) {
          resultSet = resultSet.memoryCopy();
        }
        try {
          return resultSet;
        } finally {
          resultSet.close();
        }
      }
    } catch ( XPathException e ) {
      error(
        Messages.getInstance().getErrorString( "XQueryBaseComponent.ERROR_0006_EXECUTE_FAILED", getActionName() ),
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
    return MemoryResultSet.createFromLists( hdr, data );
  }

  private IPentahoSession getSession() {
    IPentahoResultSet rs = getFakeResultSet();
    IPentahoSession session = new StandaloneSession( "REPOSTEST.JUNIT_TEST_SESSION" ); //$NON-NLS-1$
    session.setAttribute( "customerNamesList", rs ); //$NON-NLS-1$

    // IPentahoResultSet data = (IPentahoResultSet) PentahoSystem.getGlobalParameters().getParameter(listSource);
View Full Code Here
134
135
136
137
138
139
140
141
142
    return session;
  }

  private void setGlobalParams() {
    IPentahoResultSet rs = getFakeResultSet();
    SimpleParameterProvider spp = (SimpleParameterProvider) PentahoSystem.getGlobalParameters();
    spp.setParameter( "customerNamesList", rs ); //$NON-NLS-1$
  }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
  }

  public void testExecuteQuery() throws Exception {

    XQConnection connection = new XQConnection();
    IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
    assertNotNull( "result set is null", data );

    assertTrue( "result set is wrong type", data instanceof XQResultSet );

    assertFalse( "Should not be scrollable", data.isScrollable() );

    assertEquals( "row count is wrong", 4, data.getRowCount() );
    assertEquals( "column count is wrong", 4, data.getColumnCount() );
    assertEquals( "column header is wrong", "title", data.getMetaData().getColumnHeaders()[0][0] );
    assertEquals( "column header is wrong", "author", data.getMetaData().getColumnHeaders()[0][1] );
    assertEquals( "column header is wrong", "year", data.getMetaData().getColumnHeaders()[0][2] );
    assertEquals( "column header is wrong", "price", data.getMetaData().getColumnHeaders()[0][3] );

    // these don't do much but they should not cause errors
    data.close();
    data.closeConnection();
  }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
      XQConnection connection = new XQConnection();
      StaticQueryContext mockContext = mock( StaticQueryContext.class );
      when( mockContext.compileQuery( TEST_QUERY ) ).thenThrow( new XPathException( "Test XPathException" ) );
      connection.sqc = mockContext;

      IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
      fail( "Should throw XPathException" );
    } catch ( XPathException e ) {
      // valid
    }
  }
View Full Code Here
TOP

Related Classes of org.pentaho.commons.connection.IPentahoResultSet

  • org.pentaho.platform.engine.services.MessageFormatter
  • org.pentaho.platform.engine.services.runtime.MapParameterResolver
  • org.pentaho.platform.engine.services.runtime.TemplateUtil
  • org.pentaho.platform.engine.services.runtime.TemplateUtil$InputProperties
  • org.pentaho.platform.plugin.action.datatransforms.ResultSetCompareComponent
  • org.pentaho.platform.plugin.action.datatransforms.ResultSetCrosstabComponent
  • org.pentaho.platform.plugin.action.datatransforms.ResultSetExportComponent
  • org.pentaho.platform.plugin.action.datatransforms.ResultSetFlattenerComponent
  • org.pentaho.platform.plugin.action.hql.HQLBaseComponent
  • org.pentaho.platform.plugin.action.jfreechart.ChartComponent
    • 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.