Package org.pentaho.commons.connection.memory

Examples of org.pentaho.commons.connection.memory.MemoryResultSet

119
120
121
122
123
124
125
126
127
128
129
  }

  public void testResultSet() {

    MemoryResultSet data = new MemoryResultSet();

    SimpleParameterProvider params = new SimpleParameterProvider();
    params.setParameter( "data", data );
    assertTrue( params.hasParameter( "data" ) );
    assertEquals( "param value is wrong", data, params.getListParameter( "data" ) );
View Full Code Here
837
838
839
840
841
842
843
844
845
846
847
848
            if ( ComponentBase.debug ) {
              debug( Messages.getInstance().getString( "Kettle.DEBUG_CREATING_RESULTSET_METADATA" ) ); //$NON-NLS-1$
            }

            MemoryMetaData metaData = new MemoryMetaData( columns, null );
            results = new MemoryResultSet( metaData );
            errorResults = new MemoryResultSet( metaData );

            // add ourself as a row listener
            step.step.addRowListener( this );
            success = true;
            break;
View Full Code Here
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
        int columnLoc = ordinal % columnCount;

        data[ rowLoc ][ columnLoc ] = value;
      } // CellLoop

      MemoryResultSet resultSet = new MemoryResultSet();
      MemoryMetaData metaData = new MemoryMetaData( columnHeaders, rowHeaders );
      resultSet.setMetaData( metaData );
      for ( Object[] element : data ) {
        resultSet.addRow( element );
      }
      rSet = resultSet;
      if ( resultSet != null ) {
        if ( getResultOutputName() != null ) {
          setOutputValue( getResultOutputName(), resultSet );
View Full Code Here
282
283
284
285
286
287
288
289
290
291
292
293
294
295
  public IPentahoResultSet memoryCopy() {
    try {
      IPentahoMetaData meta = getMetaData();
      Object[][] columnHeaders = meta.getColumnHeaders();
      MemoryMetaData cachedMetaData = new MemoryMetaData( columnHeaders, null );
      MemoryResultSet cachedResultSet = new MemoryResultSet( cachedMetaData );
      Object[] rowObjects = next();
      while ( rowObjects != null ) {
        cachedResultSet.addRow( rowObjects );
        rowObjects = next();
      }
      return cachedResultSet;
    } finally {
      close();
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
    MemoryMetaData metadata = new MemoryMetaData( new String[][] { { "col1", "col2" } }, null );

    metadata.setColumnTypes( new String[] { "string", "int" } );

    MemoryResultSet data = new MemoryResultSet( metadata );

    data.addRow( new Object[] { "a", new Integer( 1 ) } );
    data.addRow( new Object[] { "b", new Integer( 2 ) } );
    data.addRow( new Object[] { "c", new Integer( 3 ) } );

    MarshallableResultSet result = new MarshallableResultSet();
    result.setResultSet( data );
    validate( result );
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
            max = -1;
          }
        }

        // Its OK if there is no min and max - we will derive it later if absent.
        MemoryResultSet set = new MemoryResultSet();
        if ( ( min == -1 ) && ( max == -1 ) ) {
          set.addRow( new Object[] { new Double( val ) } );
        } else {
          set.addRow( new Object[] { new Double( val ), new Double( min ), new Double( max ) } );
        }
        values = set;
      }
    }
View Full Code Here
259
260
261
262
263
264
265
266
267
268
269
  }

  public void testAddRow() {
    MemoryMetaData metadata = new MemoryMetaData( new String[][] { { "col1", "col2" } }, null );

    MemoryResultSet dataSet = new MemoryResultSet( metadata );
    JavaScriptResultSet data = new JavaScriptResultSet();
    data.setResultSet( dataSet );

    data.addRow( new Object[] { "a", new Integer( 1 ) } );
    data.addRow( new Object[] { "b", new Integer( 2 ) } );
View Full Code Here
279
280
281
282
283
284
285
286
287
288
289
  }

  public void testIterators() {
    MemoryMetaData metadata = new MemoryMetaData( new String[][] { { "col1", "col2" } }, null );

    MemoryResultSet dataSet = new MemoryResultSet( metadata );
    JavaScriptResultSet data = new JavaScriptResultSet();
    data.setResultSet( dataSet );

    data.addRow( new Object[] { "a", new Integer( 1 ) } );
    data.addRow( new Object[] { "b", new Integer( 2 ) } );
View Full Code Here
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
  }

  public void testCopyMemoryResultSet() {
    MemoryMetaData metadata = new MemoryMetaData( new String[][] { { "col1", "col2" } }, null );

    MemoryResultSet data1 = new MemoryResultSet( metadata );

    data1.addRow( new Object[] { "a", new Integer( 1 ) } );
    data1.addRow( new Object[] { "b", new Integer( 2 ) } );
    data1.addRow( new Object[] { "c", new Integer( 3 ) } );

    MemoryResultSet data = (MemoryResultSet) data1.memoryCopy();

    assertNotNull( data.getMetaData() );
    assertNotNull( data.getMetaData().getColumnHeaders() );
    assertNull( data.getMetaData().getRowHeaders() );

    assertEquals( 2, data.getMetaData().getColumnCount() );
    assertEquals( 1, data.getMetaData().getColumnHeaders().length );
    assertEquals( 2, data.getMetaData().getColumnHeaders()[0].length );
    assertEquals( "col1", data.getMetaData().getColumnHeaders()[0][0] );
    assertEquals( "col2", data.getMetaData().getColumnHeaders()[0][1] );

    assertEquals( 3, data.getRowCount() );
    assertEquals( "a", data.getValueAt( 0, 0 ) );
    assertEquals( 1, data.getValueAt( 0, 1 ) );
    assertEquals( "b", data.getValueAt( 1, 0 ) );
    assertEquals( 2, data.getValueAt( 1, 1 ) );
    assertEquals( "c", data.getValueAt( 2, 0 ) );
    assertEquals( 3, data.getValueAt( 2, 1 ) );
  }
View Full Code Here
309
310
311
312
313
314
315
316
317
318
319
320
321
322
      // set column types of cachedMetaData
      String[] columnTypeClones = new String[columnTypes.length];
      System.arraycopy( columnTypes, 0, columnTypeClones, 0, columnTypes.length );
      cachedMetaData.setColumnTypes( columnTypeClones );

      MemoryResultSet cachedResultSet = new MemoryResultSet( cachedMetaData );
      Object[] rowObjects = next();
      while ( rowObjects != null ) {
        cachedResultSet.addRow( rowObjects );
        rowObjects = next();
      }
      return cachedResultSet;
    } finally {
      close();
View Full Code Here
TOP

Related Classes of org.pentaho.commons.connection.memory.MemoryResultSet

  • org.pentaho.platform.engine.core.SimpleParameterProviderTest
  • org.pentaho.platform.plugin.action.kettle.KettleComponent
  • org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent
  • org.pentaho.platform.plugin.action.sql.SQLDdlComponent
  • org.pentaho.platform.plugin.action.sql.SQLExecute
  • org.pentaho.platform.plugin.action.xmla.XMLABaseComponent
  • org.pentaho.platform.plugin.services.connections.hql.HQLResultSet
  • org.pentaho.platform.plugin.services.connections.javascript.JavaScriptResultSet
  • org.pentaho.platform.plugin.services.connections.mondrian.MDXResultSet
  • org.pentaho.platform.plugin.services.connections.sql.SQLResultSet
    • 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.