Java SQLStatement.hasSQL方法代码示例

本文整理汇总了Java中org.pentaho.di.core.SQLStatement.hasSQL方法的典型用法代码示例。如果您正苦于以下问题：Java SQLStatement.hasSQL方法的具体用法？Java SQLStatement.hasSQL怎么用？Java SQLStatement.hasSQL使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.pentaho.di.core.SQLStatement的用法示例。

在下文中一共展示了SQLStatement.hasSQL方法的11个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: getSQLStatementsString

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
/**
 * Get the SQL statements, needed to run this transformation, as one String.
 *
 * @return the SQL statements needed to run this transformation.
 */
public String getSQLStatementsString() throws KettleStepException
{
    String sql = ""; //$NON-NLS-1$
    List<SQLStatement> stats = getSQLStatements();
    for (int i = 0; i < stats.size(); i++)
    {
        SQLStatement stat = stats.get(i);
        if (!stat.hasError() && stat.hasSQL())
        {
            sql += stat.getSQL();
        }
    }

    return sql;
}

开发者ID:icholy，项目名称:geokettle-2.0，代码行数:21，代码来源:TransMeta.java

示例2: getSQLStatementsString

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
/**
 * Get the SQL statements (needed to run this transformation) as a single String.
 *
 * @return the SQL statements needed to run this transformation
 * @throws KettleStepException if any errors occur during SQL statement generation
 */
public String getSQLStatementsString() throws KettleStepException
{
    String sql = ""; //$NON-NLS-1$
    List<SQLStatement> stats = getSQLStatements();
    for (int i = 0; i < stats.size(); i++)
    {
        SQLStatement stat = stats.get(i);
        if (!stat.hasError() && stat.hasSQL())
        {
            sql += stat.getSQL();
        }
    }

    return sql;
}

开发者ID:bsspirit，项目名称:kettle-4.4.0-stable，代码行数:22，代码来源:TransMeta.java

示例3: autoAdjustSchema

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
public void autoAdjustSchema( MonetDBBulkLoaderMeta meta )  throws KettleException {
	
		   if (log.isDetailed()) logDetailed("Attempting to auto adjust table structure" );

   drop();

	   if (log.isDetailed()) logDetailed("getTransMeta: "+getTransMeta() );
  		   if (log.isDetailed()) logDetailed("getStepname: "+getStepname() );
  		   SQLStatement statement = meta.getTableDdl(getTransMeta(), getStepname(), true, data, true);
  		   if (log.isDetailed()) logDetailed("Statement: "+statement );
 		   if (log.isDetailed() && statement != null) logDetailed("Statement has SQL: "+statement.hasSQL() );
   		
 		   if(statement != null && statement.hasSQL()) {
   			String cmd = statement.getSQL();
    		  try {
           executeSql(cmd);
         } catch (Exception e) {
           throw new KettleException("Error while creating table " + data.schemaTable, e);
    	    }
    	 }

	if (log.isDetailed()) logDetailed("Successfull");
}

开发者ID:jjeb，项目名称:kettle-trunk，代码行数:24，代码来源:MonetDBBulkLoader.java

示例4: getSQL

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
private String getSQL()
{
	StringBuffer sql = new StringBuffer();
	
	int idx[] = wFields.table.getSelectionIndices();
	
	// None selected: don't waste users time: select them all!
	if (idx.length==0) 
	{
		idx=new int[stats.size()];
		for (int i=0;i<stats.size();i++) idx[i]=i;
	}
	
	for (int i=0;i<idx.length;i++)
	{
		SQLStatement stat = (SQLStatement)stats.get(idx[i]);
		DatabaseMeta di = stat.getDatabase();
		if (i > 0)
		    sql.append("-------------------------------------------------------------------------------------------").append(Const.CR);
		sql.append(Messages.getString("SQLStatementDialog.Log.Step", stat.getStepname()));
		sql.append(Messages.getString("SQLStatementDialog.Log.Connection", (di != null ? di.getName() : Messages.getString("SQLStatementDialog.Log.Undefined"))));
		if (stat.hasSQL())
		{
			sql.append("-- SQL                  : ");
			sql.append(stat.getSQL()).append(Const.CR);
		}
		if (stat.hasError())
		{
			sql.append(Messages.getString("SQLStatementDialog.Log.Error", stat.getError()));
		}
	}

	return sql.toString();
}

开发者ID:icholy，项目名称:geokettle-2.0，代码行数:35，代码来源:SQLStatementsDialog.java

示例5: autoAdjustSchema

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
public void autoAdjustSchema( Runtime rt, String mClientCmd )  throws KettleException {
	
   	try {
		   if (log.isDetailed()) logDetailed("Attempting to auto adjust table structure" );
		
	   Process p = rt.exec(mClientCmd);
	   OutputStream stdIn = p.getOutputStream();
		  	
	   if (log.isDetailed()) logDetailed("getTransMeta: "+getTransMeta() );
  		   if (log.isDetailed()) logDetailed("getStepname: "+getStepname() );
  		   SQLStatement statement = meta.getTableDdl(getTransMeta(), getStepname(), true, data);
  		   if (log.isDetailed()) logDetailed("Statement: "+statement );
 		   if (log.isDetailed() && statement != null) logDetailed("Statement has SQL: "+statement.hasSQL() );
   		
 		   if(statement != null && statement.hasSQL()) {
   			String cmd = statement.getSQL();
    		  	if (log.isDetailed()) logDetailed("Trying: "+cmd);
    		  	stdIn.write(cmd.getBytes());
    		  	if (log.isDetailed()) logDetailed("Successfull: "+cmd);
   		}	    	
		  	 		   
		   stdIn.flush();
		   stdIn.close();
		    // wait for the process to finish and check for any error...

		   int exitVal = p.waitFor();
		   logBasic(BaseMessages.getString(PKG, "MonetDBBulkLoader.Log.ExitValuePsqlPath", "" + exitVal)); //$NON-NLS-1$
	
    	}
    	catch(Exception e) {
    		throw new KettleException("An error occurred writing data to the mclient process", e);
    	}		
    	
}

开发者ID:yintaoxue，项目名称:read-open-source-code，代码行数:35，代码来源:MonetDBBulkLoader.java

示例6: getSQL

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
private String getSQL()
{
	StringBuffer sql = new StringBuffer();
	
	int idx[] = wFields.table.getSelectionIndices();
	
	// None selected: don't waste users time: select them all!
	if (idx.length==0) 
	{
		idx=new int[stats.size()];
		for (int i=0;i<stats.size();i++) idx[i]=i;
	}
	
	for (int i=0;i<idx.length;i++)
	{
		SQLStatement stat = (SQLStatement)stats.get(idx[i]);
		DatabaseMeta di = stat.getDatabase();
		if (i > 0)
		    sql.append("-------------------------------------------------------------------------------------------").append(Const.CR);
		sql.append(BaseMessages.getString(PKG, "SQLStatementDialog.Log.Step", stat.getStepname()));
		sql.append(BaseMessages.getString(PKG, "SQLStatementDialog.Log.Connection", (di != null ? di.getName() : BaseMessages.getString(PKG, "SQLStatementDialog.Log.Undefined"))));
		if (stat.hasSQL())
		{
			sql.append("-- SQL                  : ");
			sql.append(stat.getSQL()).append(Const.CR);
		}
		if (stat.hasError())
		{
			sql.append(BaseMessages.getString(PKG, "SQLStatementDialog.Log.Error", stat.getError()));
		}
	}

	return sql.toString();
}

开发者ID:yintaoxue，项目名称:read-open-source-code，代码行数:35，代码来源:SQLStatementsDialog.java

示例7: autoAdjustSchema

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
public void autoAdjustSchema( MonetDBBulkLoaderMeta meta ) throws KettleException {

    if ( log.isDetailed() ) {
      logDetailed( "Attempting to auto adjust table structure" );
    }

    drop();

    if ( log.isDetailed() ) {
      logDetailed( "getTransMeta: " + getTransMeta() );
    }
    if ( log.isDetailed() ) {
      logDetailed( "getStepname: " + getStepname() );
    }
    SQLStatement statement = meta.getTableDdl( getTransMeta(), getStepname(), true, data, true );
    if ( log.isDetailed() ) {
      logDetailed( "Statement: " + statement );
    }
    if ( log.isDetailed() && statement != null ) {
      logDetailed( "Statement has SQL: " + statement.hasSQL() );
    }

    if ( statement != null && statement.hasSQL() ) {
      String cmd = statement.getSQL();
      try {
        executeSql( cmd );
      } catch ( Exception e ) {
        throw new KettleException( "Error while creating table " + data.schemaTable, e );
      }
    }

    if ( log.isDetailed() ) {
      logDetailed( "Successfull" );
    }
  }

开发者ID:pentaho，项目名称:pentaho-kettle，代码行数:36，代码来源:MonetDBBulkLoader.java

示例8: getSQLStatementsString

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
/**
 * Get the SQL statements (needed to run this transformation) as a single String.
 *
 * @return the SQL statements needed to run this transformation
 * @throws KettleStepException
 *           if any errors occur during SQL statement generation
 */
public String getSQLStatementsString() throws KettleStepException {
  String sql = "";
  List<SQLStatement> stats = getSQLStatements();
  for ( int i = 0; i < stats.size(); i++ ) {
    SQLStatement stat = stats.get( i );
    if ( !stat.hasError() && stat.hasSQL() ) {
      sql += stat.getSQL();
    }
  }

  return sql;
}

开发者ID:pentaho，项目名称:pentaho-kettle，代码行数:20，代码来源:TransMeta.java

示例9: getSQL

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
private String getSQL() {
  StringBuilder sql = new StringBuilder();

  int[] idx = wFields.table.getSelectionIndices();

  // None selected: don't waste users time: select them all!
  if ( idx.length == 0 ) {
    idx = new int[stats.size()];
    for ( int i = 0; i < stats.size(); i++ ) {
      idx[i] = i;
    }
  }

  for ( int i = 0; i < idx.length; i++ ) {
    SQLStatement stat = stats.get( idx[i] );
    DatabaseMeta di = stat.getDatabase();
    if ( i > 0 ) {
      sql
        .append( "-------------------------------------------------------------------------------------------" )
        .append( Const.CR );
    }
    sql.append( BaseMessages.getString( PKG, "SQLStatementDialog.Log.Step", stat.getStepname() ) );
    sql.append( BaseMessages.getString( PKG, "SQLStatementDialog.Log.Connection", ( di != null
      ? di.getName() : BaseMessages.getString( PKG, "SQLStatementDialog.Log.Undefined" ) ) ) );
    if ( stat.hasSQL() ) {
      sql.append( "-- SQL                  : " );
      sql.append( stat.getSQL() ).append( Const.CR );
    }
    if ( stat.hasError() ) {
      sql.append( BaseMessages.getString( PKG, "SQLStatementDialog.Log.Error", stat.getError() ) );
    }
  }

  return sql.toString();
}

开发者ID:pentaho，项目名称:pentaho-kettle，代码行数:36，代码来源:SQLStatementsDialog.java

示例10: adjustSchema

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
@Override
public boolean adjustSchema() {
	TableOutputMeta meta = getMeta();
	TableOutputData data = getData();
	TransMeta transMeta = getTransMeta();
	StepMeta stepMeta = meta.getParentStepMeta();
	DBCache dbcache = transMeta.getDbCache();
	StringBuffer messageBuffer = new StringBuffer();

	try {
		RowMetaInterface prev = transMeta.getPrevStepFields(stepMeta.getName());
 		   if (log.isDetailed()) logDetailed("Attempting to auto adjust table structure" );
 		  	
		   if (log.isDetailed()) logDetailed("getTransMeta: "+getTransMeta() );
   		   if (log.isDetailed()) logDetailed("getStepname: "+getStepname() );
   		   
   		   SQLStatement statement = meta.getSQLStatements(transMeta, stepMeta, prev);
   		   
   		   if (log.isDetailed()) logDetailed("Statement: "+statement );
  		   if (log.isDetailed() && statement != null) logDetailed("Statement has SQL: "+statement.hasSQL() );
    		
  		   if(statement != null && statement.hasSQL()) {
    			String sql = statement.getSQL();
     		  	if (log.isDetailed()) logDetailed("Trying: "+sql);
     		  	
				try
				{
				    log.logDetailed("Executing SQL: "+Const.CR+sql);
					data.db.execStatement(sql);
                       
					// Clear the database cache, in case we're using one...
					if (dbcache!=null) dbcache.clear(data.databaseMeta.getName());
				}
				catch(Exception dbe)
				{
                       String error = BaseMessages.getString(PKG, "SQLEditor.Log.SQLExecError", sql, dbe.toString());
                       messageBuffer.append(error).append(Const.CR);
                       return false;
				}

     		  	if (log.isDetailed()) logDetailed("Successfull: "+sql);
  		   } 
  		   else if(statement.getError() == null) {
  			   // there were no changes to be made
  			   return true;
  		   } else {
  			   this.message = statement.getError();
  			   logError(statement.getError());
  			   return false;
  		   }
     	}
     	catch(Exception e) {
		   logError("An error ocurred trying to adjust the table schema", e);
     	}
	return true;
}

开发者ID:bsspirit，项目名称:kettle-4.4.0-stable，代码行数:57，代码来源:TableAgileMart.java

示例11: adjustSchema

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
@Override
public boolean adjustSchema() {
  TableOutputMeta meta = getMeta();
  TableOutputData data = getData();
  TransMeta transMeta = getTransMeta();
  StepMeta stepMeta = meta.getParentStepMeta();
  DBCache dbcache = transMeta.getDbCache();
  StringBuilder messageBuffer = new StringBuilder();

  try {
    RowMetaInterface prev = transMeta.getPrevStepFields( stepMeta.getName() );
    if ( log.isDetailed() ) {
      logDetailed( "Attempting to auto adjust table structure" );
    }

    if ( log.isDetailed() ) {
      logDetailed( "getTransMeta: " + getTransMeta() );
    }
    if ( log.isDetailed() ) {
      logDetailed( "getStepname: " + getStepname() );
    }

    SQLStatement statement = meta.getSQLStatements( transMeta, stepMeta, prev, repository, metaStore );

    if ( log.isDetailed() ) {
      logDetailed( "Statement: " + statement );
    }
    if ( log.isDetailed() && statement != null ) {
      logDetailed( "Statement has SQL: " + statement.hasSQL() );
    }

    if ( statement != null && statement.hasSQL() ) {
      String sql = statement.getSQL();
      if ( log.isDetailed() ) {
        logDetailed( "Trying: " + sql );
      }

      try {
        log.logDetailed( "Executing SQL: " + Const.CR + sql );
        data.db.execStatement( sql );

        // Clear the database cache, in case we're using one...
        if ( dbcache != null ) {
          dbcache.clear( data.databaseMeta.getName() );
        }
      } catch ( Exception dbe ) {
        String error = BaseMessages.getString( PKG, "SQLEditor.Log.SQLExecError", sql, dbe.toString() );
        messageBuffer.append( error ).append( Const.CR );
        return false;
      }

      if ( log.isDetailed() ) {
        logDetailed( "Successfull: " + sql );
      }
    } else if ( statement.getError() == null ) {
      // there were no changes to be made
      return true;
    } else {
      this.message = statement.getError();
      logError( statement.getError() );
      return false;
    }
  } catch ( Exception e ) {
    logError( "An error ocurred trying to adjust the table schema", e );
  }
  return true;
}

开发者ID:pentaho，项目名称:pentaho-kettle，代码行数:68，代码来源:TableAgileMart.java

注：本文中的org.pentaho.di.core.SQLStatement.hasSQL方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。