org.pentaho.di.core.database.Database.getQueryFields()方法的使用及代码示例

x33g5p2x  于2022-01-18 转载在 其他  
字(5.5k)|赞(0)|评价(0)|浏览(334)

本文整理了Java中org.pentaho.di.core.database.Database.getQueryFields()方法的一些代码示例,展示了Database.getQueryFields()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Database.getQueryFields()方法的具体详情如下:
包路径:org.pentaho.di.core.database.Database
类名称:Database
方法名:getQueryFields

Database.getQueryFields介绍

暂无

代码示例

代码示例来源:origin: pentaho/pentaho-kettle

  1. public RowMetaInterface getQueryFields( String sql, boolean param ) throws KettleDatabaseException {
  2. return getQueryFields( sql, param, null, null );
  3. }

代码示例来源:origin: pentaho/pentaho-kettle

  1. /**
  2. * Returns a RowMeta describing the fields of a table expression.
  3. *
  4. * <p>Note that this implementation makes use of a SQL statement
  5. * in order to populate the ValueMeta object in the RowMeta it returns.
  6. * This is sometimes necessary when the caller needs the ValueMeta
  7. * values to be properly casted.
  8. *
  9. * <p>In cases where a simple list of columns is required, it is preferable
  10. * to use {@link #getTableFieldsMeta(String, String)}. This other method
  11. * will not use a SQL query and will populate whatever information it can
  12. * using @link {@link DatabaseMetaData#getColumns(String, String, String, String)}.
  13. *
  14. * @param tablename This is the properly quoted, and schema prefixed table name.
  15. */
  16. public RowMetaInterface getTableFields( String tablename ) throws KettleDatabaseException {
  17. return getQueryFields( databaseMeta.getSQLQueryFields( tablename ), false );
  18. }

代码示例来源:origin: pentaho/pentaho-kettle

  1. public void run( IProgressMonitor monitor ) throws InvocationTargetException, InterruptedException {
  2. db = new Database( Spoon.loggingObject, dbMeta );
  3. try {
  4. db.connect();
  5. result = db.getQueryFields( sql, false );
  6. if ( monitor.isCanceled() ) {
  7. throw new InvocationTargetException( new Exception( "This operation was cancelled!" ) );
  8. }
  9. } catch ( Exception e ) {
  10. throw new InvocationTargetException( e, "Problem encountered determining query fields: " + e.toString() );
  11. } finally {
  12. db.disconnect();
  13. }
  14. }
  15. };

代码示例来源:origin: pentaho/pentaho-kettle

  1. return getQueryFields( databaseMeta.getQuotedSchemaTableCombination( schemaName, tableName ), false );

代码示例来源:origin: pentaho/pentaho-kettle

  1. RowMetaInterface r = db.getQueryFields( sql, true );
  2. if ( r != null ) {
  3. cr =

代码示例来源:origin: pentaho/pentaho-kettle

  1. @Test
  2. public void testGetFields() throws Exception {
  3. TableInputMetaHandler meta = new TableInputMetaHandler();
  4. meta.setLazyConversionActive( true );
  5. DatabaseMeta dbMeta = mock( DatabaseMeta.class );
  6. meta.setDatabaseMeta( dbMeta );
  7. Database mockDB = meta.getDatabase();
  8. when( mockDB.getQueryFields( anyString(), anyBoolean() ) ).thenReturn( createMockFields() );
  9. RowMetaInterface expectedRowMeta = new RowMeta();
  10. ValueMetaInterface valueMeta = new ValueMetaString( "field1" );
  11. valueMeta.setStorageMetadata( new ValueMetaString( "field1" ) );
  12. valueMeta.setStorageType( ValueMetaInterface.STORAGE_TYPE_BINARY_STRING );
  13. expectedRowMeta.addValueMeta( valueMeta );
  14. VariableSpace space = mock( VariableSpace.class );
  15. RowMetaInterface rowMetaInterface = new RowMeta();
  16. meta.getFields( rowMetaInterface, "TABLE_INPUT_META", null, null, space, null, null );
  17. assertEquals( expectedRowMeta.toString(), rowMetaInterface.toString() );
  18. }

代码示例来源:origin: pentaho/pentaho-kettle

  1. db.getQueryFields( transMeta.environmentSubstitute( sql ), true, param, new Object[param.size()] );
  2. if ( r != null ) {
  3. cr =

代码示例来源:origin: pentaho/pentaho-kettle

  1. add = db.getQueryFields( realSQL, false );
  2. } catch ( KettleDatabaseException dbe ) {
  3. throw new KettleStepException( BaseMessages.getString(
  4. add = db.getQueryFields( realSQL, false );
  5. for ( int i = 0; i < add.size(); i++ ) {
  6. ValueMetaInterface v = add.getValueMeta( i );

代码示例来源:origin: pentaho/pentaho-kettle

  1. if ( db != null ) {
  2. if ( isAddRowsResult && iscustomSQL && ar != null ) {
  3. rowMeta = db.getQueryFields( countStatement, false );

代码示例来源:origin: pentaho/pentaho-kettle

  1. add = db.getQueryFields( space.environmentSubstitute( sql ), true, param, new Object[param.size()] );
  2. } catch ( KettleDatabaseException dbe ) {
  3. throw new KettleStepException( BaseMessages.getString(
  4. add = db.getQueryFields( space.environmentSubstitute( sql ), true, param, new Object[param.size()] );
  5. for ( int i = 0; i < add.size(); i++ ) {
  6. ValueMetaInterface v = add.getValueMeta( i );

代码示例来源:origin: pentaho/pentaho-kettle

  1. @Override
  2. public RowMetaInterface getTableFields() {
  3. // Build a dummy parameter row...
  4. //
  5. RowMetaInterface param = new RowMeta();
  6. for ( int i = 0; i < parameterField.length; i++ ) {
  7. ValueMetaInterface v;
  8. try {
  9. v = ValueMetaFactory.createValueMeta( parameterField[i], parameterType[i] );
  10. } catch ( KettlePluginException e ) {
  11. v = new ValueMetaNone( parameterField[i] );
  12. }
  13. param.addValueMeta( v );
  14. }
  15. RowMetaInterface fields = null;
  16. if ( databaseMeta != null ) {
  17. Database db = new Database( loggingObject, databaseMeta );
  18. databases = new Database[] { db }; // Keep track of this one for cancelQuery
  19. try {
  20. db.connect();
  21. fields =
  22. db.getQueryFields( databaseMeta.environmentSubstitute( sql ), true, param, new Object[param.size()] );
  23. } catch ( KettleDatabaseException dbe ) {
  24. logError( BaseMessages.getString( PKG, "DatabaseJoinMeta.Log.DatabaseErrorOccurred" ) + dbe.getMessage() );
  25. } finally {
  26. db.disconnect();
  27. }
  28. }
  29. return fields;
  30. }

代码示例来源:origin: pentaho/pentaho-kettle

  1. add = db.getQueryFields( sNewSQL, param );
  2. } catch ( KettleDatabaseException dbe ) {
  3. throw new KettleStepException( "Unable to get queryfields for SQL: " + Const.CR + sNewSQL, dbe );
  4. add = db.getQueryFields( sNewSQL, param, paramRowMeta, paramData );

代码示例来源:origin: pentaho/pentaho-kettle

  1. RowMetaInterface rowMeta = db.getQueryFields( countSQLStatement, false );

代码示例来源:origin: pentaho/pentaho-kettle

  1. try {
  2. db.connect();
  3. RowMetaInterface fields = db.getQueryFields( sql, false );
  4. if ( fields != null ) {
  5. sql = "SELECT" + Const.CR;

代码示例来源:origin: pentaho/pentaho-kettle

  1. try {
  2. db.connect();
  3. RowMetaInterface fields = db.getQueryFields( sql, false );
  4. if ( fields != null ) {
  5. sql = "SELECT" + Const.CR;

代码示例来源:origin: pentaho/pentaho-kettle

  1. try {
  2. db.connect();
  3. RowMetaInterface fields = db.getQueryFields( sql, false );
  4. if ( fields != null ) {
  5. sql = "SELECT" + Const.CR;

相关文章