Package org.pentaho.commons.connection.memory

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

218
219
220
221
222
223
224
225
226
227
228
    Object[][] rowHeaders = new String[rHeaders.size()][1];
    for ( int i = 0; i < rHeaders.size(); i++ ) {
      rowHeaders[i][0] = rHeaders.get( i );
    }

    IPentahoMetaData metaData = new MemoryMetaData( columnHeaders, rowHeaders );
    MemoryResultSet result = new MemoryResultSet( metaData );
    for ( int i = 0; i < data.size(); i++ ) {
      result.addRow( ( (List) data.get( i ) ).toArray() );
    }
    return result;
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
    MemoryResultSet resultSet = null;
    int n = ( (SQLConnection) connection ).execute( query );

    Object[][] columnHeaders = new Object[1][1];
    columnHeaders[0][0] = "result"; //$NON-NLS-1$
    IPentahoMetaData metadata = new MemoryMetaData( columnHeaders, null );

    resultSet = new MemoryResultSet( metadata );

    Object[] rowObjects = new Object[1];
    rowObjects[0] = new Integer( n );
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
    boolean continueOnException = sqlExecuteAction.getContinueOnException().getBooleanValue( false );
    String[] columnHeaders =
        new String[] { Messages.getInstance().getString( "SQLExecute.USER_AFFECTED_ROWS_COLUMN_NAME" ), //$NON-NLS-1$
          Messages.getInstance().getString( "SQLExecute.USER_AFFECTED_ROW_STATUS" ) //$NON-NLS-1$
        };
    MemoryMetaData metaData = new MemoryMetaData( new String[][] { columnHeaders }, null );
    metaData.setColumnTypes( new String[] { "int", "string" } ); //$NON-NLS-1$ //$NON-NLS-2$
    MemoryResultSet affectedRowsResultSet = new MemoryResultSet( metaData );
    String successMsg = Messages.getInstance().getString( "SQLExecute.USER_SUCCESS" ); //$NON-NLS-1$
    String failMsg = Messages.getInstance().getString( "SQLExecute.USER_FAILED" ); //$NON-NLS-1$
    try {
      if ( conn == null ) {
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
    List<String> cols = new ArrayList<String>();
    cols.add( "MESES" );
    cols.add( "ACTUAL" );
    cols.add( "ANTERIOR" );

    query_result.setMetaData( new MemoryMetaData( cols ) );
    query_result.addRow( new Object[] { "Enero", 0, 0 } );
    query_result.addRow( new Object[] { "Febrero", 0, 0 } );
    query_result.addRow( new Object[] { "Marzo", 0, 0 } );
    query_result.addRow( new Object[] { "Abril", 0, 0 } );
    query_result.addRow( new Object[] { "Mayo", 0, 0 } );
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
    return outputHandler;
  }

  private IPentahoResultSet getResultSet() {
    Object[][] columnHeaders = new Object[][] { { "COL1", "COL2", "COL3" } }; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    IPentahoMetaData md = new MemoryMetaData( columnHeaders, null );
    MemoryResultSet rs = new MemoryResultSet( md );
    rs.addRow( new Object[] { "DATA1", "DATA2", new Date() } ); //$NON-NLS-1$ //$NON-NLS-2$
    rs.isScrollable();
    return rs;
  }
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
    Object[][] columnHeaders = new Object[][] { { "COL1", "COL2", "COL3" } }; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    List columnHeadersList = new ArrayList();
    columnHeadersList.add( "COL1" ); //$NON-NLS-1$
    columnHeadersList.add( "COL2" ); //$NON-NLS-1$
    columnHeadersList.add( "COL3" ); //$NON-NLS-1$
    MemoryMetaData md2 = new MemoryMetaData( columnHeaders, null );
    //    emd.getAttribute(1, 1, "COL1"); //$NON-NLS-1$
    // emd.setBusinessColumns(columnHeadersList);
    MemoryResultSet rs = new MemoryResultSet( md2 );
    rs.addRow( new Object[] { "DATA1", "DATA2", new Date() } ); //$NON-NLS-1$ //$NON-NLS-2$
    return rs;
View Full Code Here
191
192
193
194
195
196
197
198
199
200
  private IPentahoResultSet getResultSet3() {
    List columnHeadersList = new ArrayList();
    columnHeadersList.add( "COL1" ); //$NON-NLS-1$
    columnHeadersList.add( "COL2" ); //$NON-NLS-1$
    columnHeadersList.add( "COL3" ); //$NON-NLS-1$
    MemoryMetaData md3 = new MemoryMetaData( columnHeadersList );
    MemoryResultSet rs = new MemoryResultSet( md3 );
    rs.addRow( new Object[] { "DATA1", "DATA2", new Date() } ); //$NON-NLS-1$ //$NON-NLS-2$
    return rs;
  }
View Full Code Here
836
837
838
839
840
841
842
843
844
845
846
            }
            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 );
View Full Code Here
404
405
406
407
408
409
410
411
412
413
414
        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;
View Full Code Here
292
293
294
295
296
297
298
299
  protected IPentahoMetaData getMetadata( final IPentahoResultSet resultSet, final boolean live ) {
    if ( live ) {
      return resultSet.getMetaData();
    } else {
      Object[][] columnHeaders = resultSet.getMetaData().getColumnHeaders();
      return new MemoryMetaData( columnHeaders, null );
    }
  }
View Full Code Here
TOP

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

  • org.pentaho.platform.plugin.action.kettle.KettleComponent
  • org.pentaho.platform.plugin.action.sql.SQLBaseComponent
  • 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
  • org.pentaho.platform.plugin.services.connections.xquery.XQResultSet
    • 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.