本文整理汇总了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;
}
示例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;
}
示例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");
}
示例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();
}
示例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);
}
}
示例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();
}
示例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" );
}
}
示例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;
}
示例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();
}
示例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;
}
示例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;
}