Package org.pentaho.commons.connection

Examples of org.pentaho.commons.connection.IPentahoResultSet

322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
    component.execute();

    // Postprocessor test code will add condition changing
    // resultset to 10 rows, all contactfirstnames starting with 'A'

    IPentahoResultSet rs = component.getResultSet();
    try {
      Assert.assertNotNull( rs );
      Assert.assertEquals( 10, rs.getRowCount() );
      Object[] obj;
      while ( ( obj = rs.next() ) != null ) {
        System.out.println( obj[0] );
      }

    } finally {
      rs.close();
      rs.closeConnection();
    }
  }
View Full Code Here
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
    MetadataQueryComponent component = new MetadataQueryComponent();
    component.setQuery( mql );
    component.execute();

    IPentahoResultSet rs = component.getResultSet();
    try {
      Assert.assertNotNull( rs );
      Assert.assertEquals( 1, rs.getColumnCount() );
      Assert.assertEquals( 122, rs.getRowCount() );
      Object[] obj;
      while ( ( obj = rs.next() ) != null ) {
        System.out.println( obj[0] );
      }

    } finally {
      if ( rs != null ) {
        rs.close();
        rs.closeConnection();
      }
    }
  }
View Full Code Here
62
63
64
65
66
67
68
69
70
        row.add( value );
      }
      data.add( row );
    }

    IPentahoResultSet resultSet = MemoryResultSet.createFromLists( colHeaders, data );

    return resultSet;
  }
View Full Code Here
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
    component.setQuery( mql );
    boolean result = component.execute();

    Assert.assertTrue( result );

    IPentahoResultSet rs = component.getResultSet();
    try {
      Assert.assertNotNull( rs );
      Assert.assertEquals( 1, rs.getColumnCount() );
      Assert.assertEquals( 122, rs.getRowCount() );
      Object[] obj;
      while ( ( obj = rs.next() ) != null ) {
        System.out.println( obj[0] );
      }

    } finally {
      if ( rs != null ) {
        rs.close();
        rs.closeConnection();
      }
    }

    // second, test with forceDb = true
View Full Code Here
429
430
431
432
433
434
435
436
437
438
    finishTest();
  }

  public void testDataUtility() {
    startTest();
    IPentahoResultSet rs = getResultSet();
    String xmlString = DataUtilities.getXMLString( rs );
    assertTrue( xmlString.indexOf( "DATA2" ) > 0 ); //$NON-NLS-1$
    finishTest();
  }
View Full Code Here
437
438
439
440
441
442
443
444
445
446
    finishTest();
  }

  public void testDataUtility1() {
    startTest();
    IPentahoResultSet rs1 = getResultSetFromArray();
    String xmlString1 = DataUtilities.getXMLString( rs1 );
    assertTrue( xmlString1.indexOf( "VAL1" ) > 0 ); //$NON-NLS-1$
    finishTest();
  }
View Full Code Here
445
446
447
448
449
450
451
452
453
454
455
    finishTest();
  }

  public void testDataUtility3() {
    startTest();
    IPentahoResultSet rs3 = getResultSet2();
    String xmlString3 = DataUtilities.getXMLString( rs3 );
    assertTrue( xmlString3.indexOf( "DATA2" ) > 0 ); //$NON-NLS-1$

    finishTest();
  }
View Full Code Here
454
455
456
457
458
459
460
461
462
463
    finishTest();
  }

  public void testDataUtility4() {
    startTest();
    IPentahoResultSet rs4 = getResultSet3();
    String xmlString4 = DataUtilities.getXMLString( rs4 );
    assertTrue( xmlString4.indexOf( "DATA2" ) > 0 ); //$NON-NLS-1$  
    finishTest();
  }
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
182
183
184
  protected boolean executeAction() {
    int height = -1;
    int width = -1;
    String title = ""; //$NON-NLS-1$
    Node chartDocument = null;
    IPentahoResultSet data = (IPentahoResultSet) getInputValue( ChartComponent.CHART_DATA_PROP );
    if ( !data.isScrollable() ) {
      getLogger().debug( "ResultSet is not scrollable. Copying into memory" ); //$NON-NLS-1$
      IPentahoResultSet memSet = data.memoryCopy();
      data.close();
      data = memSet;
    }

    String urlTemplate = (String) getInputValue( ChartComponent.URL_TEMPLATE );
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
139
140
141
  protected boolean executeAction() {
    log.debug( "start to run open flash chart component......" ); //$NON-NLS-1$

    // input data

    IPentahoResultSet data = (IPentahoResultSet) getInputValue( CHART_DATA );
    if ( !data.isScrollable() ) {
      getLogger().debug( "ResultSet is not scrollable. Copying into memory" ); //$NON-NLS-1$
      IPentahoResultSet memSet = data.memoryCopy();
      data.close();
      data = memSet;
    }
    // chart width
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.