Package org.pentaho.commons.connection

Examples of org.pentaho.commons.connection.IPentahoMetaData

266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
    setXslProperty( "baseUrl", requestContext.getContextPath() ); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    setXslProperty( "fullyQualifiedServerUrl", PentahoSystem.getApplicationContext().getFullyQualifiedServerURL() ); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$

    Element root = result.addElement( "widgets" ); //$NON-NLS-1$

    IPentahoMetaData metaData = resultSet.getMetaData();
    // TODO support multiple column headers / row headers
    // TODO support an iteration across columns for a given row

    // find the column that we have been told to you
    Object[][] columnHeaders = metaData.getColumnHeaders();
    int nameColumnNo = -1;
    int valueColumnNo = -1;
    for ( int idx = 0; idx < columnHeaders[0].length; idx++ ) {
      if ( columnHeaders[0][idx].toString().equalsIgnoreCase( nameItem ) ) {
        nameColumnNo = idx;
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
      final String dispColName, final String displayName, final String displayStyle ) {
    if ( resultSet == null ) {
      return ( null );
    }

    IPentahoMetaData metaData = resultSet.getMetaData();
    if ( ( metaData == null ) || ( metaData.getColumnCount() < 1 ) ) {
      // TODO surface an error
      return ( null );
    }

    int valueColumnNo = ( valueColName == null ) ? 0 : metaData.getColumnIndex( valueColName );
    if ( valueColumnNo < 0 ) {
      // TODO surface an error
      return ( null );
    }

    int dispColumnNo = -1;
    if ( dispColName != null ) {
      dispColumnNo = metaData.getColumnIndex( dispColName );
      if ( dispColumnNo < 0 ) {
        // TODO surface an error
        return ( null );
      }
    }
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
123
124
    if ( ( resultSet == null ) || ( valueColIndex < 0 ) ) {
      return ( null );
    }

    IPentahoMetaData metaData = resultSet.getMetaData();
    if ( ( metaData == null ) || ( metaData.getColumnCount() < valueColIndex )
        || ( metaData.getColumnCount() < dispColIndex ) ) {
      return ( null );
    }

    ArrayList<Object> values = new ArrayList<Object>();
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
    Element root = gridDocument.addElement( "datagrid" ); //$NON-NLS-1$

    // add metadata about the headers
    Element metadataNode = root.addElement( "metadata" ); //$NON-NLS-1$
    HashMap<String, String> headerMap = new HashMap<String, String>();
    IPentahoMetaData metadata = results.getMetaData();
    // first process the column headers
    Object[][] headers = metadata.getColumnHeaders();
    addHeaderMetadata( headers, metadataNode, headerMap );

    // now process the rows in the data set
    Element rowsNode = root.addElement( "data" ); //$NON-NLS-1$
    Object[] row = results.next();
View Full Code Here
301
302
303
304
305
306
307
308
309
310
311
312
    // TODO Auto-generated method stub
  }

  public IPentahoResultSet memoryCopy() {
    try {
      IPentahoMetaData metadata = getMetaData();
      Object[][] columnHeaders = metadata.getColumnHeaders();
      MemoryMetaData cachedMetaData = new MemoryMetaData( columnHeaders, null );
      // set column types of cachedMetaData
      String[] columnTypeClones = new String[columnTypes.length];
      System.arraycopy( columnTypes, 0, columnTypeClones, 0, columnTypes.length );
      cachedMetaData.setColumnTypes( columnTypeClones );
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
201
    return null;
  }

  public IPentahoResultSet memoryCopy() {
    try {
      IPentahoMetaData localMetadata = getMetaData();
      Object[][] columnHeaders = localMetadata.getColumnHeaders();
      MemoryMetaData cachedMetaData = new MemoryMetaData( columnHeaders, null );
      MemoryResultSet cachedResultSet = new MemoryResultSet( cachedMetaData );
      Object[] rowObjects = next();
      while ( rowObjects != null ) {
        cachedResultSet.addRow( rowObjects );
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
152
153
  private void setReportConfigParameters( final MasterReport report, final IPentahoResultSet values ) {
    int rowCount = values.getRowCount();
    int colCount = values.getColumnCount();
    ModifiableConfiguration config = report.getReportConfiguration();
    if ( colCount >= 2 ) {
      IPentahoMetaData md = values.getMetaData();
      int nameIdx = md.getColumnIndex( "name" ); //$NON-NLS-1$
      int valIdx = md.getColumnIndex( "value" ); //$NON-NLS-1$
      if ( nameIdx < 0 ) {
        nameIdx = 0;
      }
      if ( valIdx < 0 ) {
        valIdx = 1;
View Full Code Here
192
193
194
195
196
197
198
199
200
201
202
          } else {
            localResultSet =
                sqlConnection.executeQuery( sql, SQLConnection.RESULTSET_FORWARDONLY, SQLConnection.CONCUR_READONLY );
          }
        }
        IPentahoMetaData metadata = mappedQuery.generateMetadata( localResultSet.getMetaData() );
        ( (SQLResultSet) localResultSet ).setMetaData( metadata );
        closeConnection = false;

      } catch ( Exception e ) {
        logger.error( Messages.getInstance().getErrorString(
View Full Code Here
192
193
194
195
196
197
198
199
200
201
202
203
204
    return mdxMetaData.getColumnCount();
  }

  public IPentahoResultSet memoryCopy() {
    try {
      IPentahoMetaData metadata = getMetaData();
      Object[][] columnHeaders = metadata.getColumnHeaders();
      Object[][] rowHeaders = metadata.getRowHeaders();

      MemoryMetaData cachedMetaData = new MemoryMetaData( columnHeaders, rowHeaders );
      MemoryResultSet cachedResultSet = new MemoryResultSet( cachedMetaData );

      Object[] rowObjects = next();
View Full Code Here
TOP

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

  • org.pentaho.platform.engine.services.runtime.MapParameterResolver
  • org.pentaho.platform.engine.services.runtime.SelectionMapper
  • org.pentaho.platform.engine.services.runtime.TemplateUtil$InputProperties
  • org.pentaho.platform.plugin.action.jfreereport.components.JFreeReportConfigParameterComponent
  • org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent
  • org.pentaho.platform.plugin.action.sql.SQLBaseComponent
  • org.pentaho.platform.plugin.action.sql.SQLBaseComponent$ParamResolver
  • org.pentaho.platform.plugin.action.sql.SQLDdlComponent
  • org.pentaho.platform.plugin.services.connections.hql.HQLResultSet
  • org.pentaho.platform.plugin.services.connections.metadata.sql.SqlMetadataQueryExec
    • 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.