当前位置: 首页>>代码示例>>Java>>正文

Java Database.truncateTable方法代码示例

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


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

示例1: execute

import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
/**
 * Execute fastload.
 * 
 * @throws KettleException
 *             ...
 */
public void execute() throws KettleException {
    if (this.meta.getTruncateTable().getValue()) {
        Database db = new Database(this, this.meta.getDbMeta());
        db.connect();
        db.truncateTable(this.meta.getTargetTable().getValue());
        db.commit();
        db.disconnect();
    }
    startFastLoad();

    if (this.meta.getUseControlFile().getValue()) {
        this.invokeLoadingControlFile();
    } else {
        this.invokeLoadingCommand();
    }
}
开发者ID:yintaoxue，项目名称:read-open-source-code，代码行数:23，代码来源:TeraFast.java

示例2: TruncateTables

import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private boolean TruncateTables(LogWriter log,String tablename, String schemaname, Database db)
{
	boolean retval=false;
	String realSchemaname=schemaname;
	String realTablename=tablename;
	try{

		if(!Const.isEmpty(realSchemaname))
               	realTablename = db.getDatabaseMeta().getQuotedSchemaTableCombination(realSchemaname, realTablename);
               
		// check if table exists!
		if(db.checkTableExists(realTablename)){
			if(!Const.isEmpty(realSchemaname))
				db.truncateTable(realSchemaname, tablename);
			else
				db.truncateTable(tablename);
	
			if(log.isDetailed()) log.logDetailed(toString(), Messages.getString("JobEntryTruncateTables.Log.TableTruncated",realTablename));
			
			retval=true;
		}else{
			log.logError(toString(), Messages.getString("JobEntryTruncateTables.Error.CanNotFindTable",realTablename));
		}
	}catch (Exception e)
	{
		log.logError(toString(), Messages.getString("JobEntryTruncateTables.Error.CanNotTruncateTables",realTablename,e.toString()));
	}
	return retval;
}
开发者ID:icholy，项目名称:geokettle-2.0，代码行数:30，代码来源:JobEntryTruncateTables.java

示例3: clearLogTable

import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
/**
    * User requested to clear the log table.<br>
    * Better ask confirmation
    */
   public void clearLogTable() {
   	String logTable = jobGraph.getManagedObject().getLogTable();
   	DatabaseMeta databaseMeta = jobGraph.getManagedObject().getLogConnection();
   	
   	if (databaseMeta!=null && !Const.isEmpty(logTable)) {
   	
    	MessageBox mb = new MessageBox(jobGraph.getShell(), SWT.YES | SWT.NO | SWT.ICON_QUESTION);
        mb.setMessage(Messages.getString("JobGraph.Dialog.AreYouSureYouWantToRemoveAllLogEntries.Message", logTable)); // Nothing found that matches your criteria
		mb.setText(Messages.getString("JobGraph.Dialog.AreYouSureYouWantToRemoveAllLogEntries.Title")); // Sorry!
		if (mb.open()==SWT.YES) {
			Database database = new Database(databaseMeta);
			try {
				database.connect();
				database.truncateTable(logTable);
			}
			catch(Exception e) {
				new ErrorDialog(jobGraph.getShell(), Messages.getString("JobGraph.Dialog.ErrorClearningLoggingTable.Title"), 
						Messages.getString("JobGraph.Dialog.ErrorClearningLoggingTable.Message"), e);
			}
			finally
			{
				if (database!=null) {
					database.disconnect();
				}
				
				refreshHistory();
				wText.setText("");
			}
		}

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

示例4: clearLogTable

import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
/**
    * User requested to clear the log table.<br>
    * Better ask confirmation
    */
   public void clearLogTable() {
   	String logTable = transGraph.getManagedObject().getLogTable();
   	DatabaseMeta databaseMeta = transGraph.getManagedObject().getLogConnection();
   	
   	if (databaseMeta!=null && !Const.isEmpty(logTable)) {
   	
    	MessageBox mb = new MessageBox(transGraph.getShell(), SWT.YES | SWT.NO | SWT.ICON_QUESTION);
        mb.setMessage(Messages.getString("TransGraph.Dialog.AreYouSureYouWantToRemoveAllLogEntries.Message", logTable)); // Nothing found that matches your criteria
		mb.setText(Messages.getString("TransGraph.Dialog.AreYouSureYouWantToRemoveAllLogEntries.Title")); // Sorry!
		if (mb.open()==SWT.YES) {
			Database database = new Database(databaseMeta);
			try {
				database.connect();
				database.truncateTable(logTable);
			}
			catch(Exception e) {
				new ErrorDialog(transGraph.getShell(), Messages.getString("TransGraph.Dialog.ErrorClearningLoggingTable.Title"), 
						Messages.getString("TransGraph.Dialog.ErrorClearningLoggingTable.Message"), e);
			}
			finally
			{
				if (database!=null) {
					database.disconnect();
				}
				
				refreshHistory();
				wText.setText("");
			}
		}

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

示例5: truncateTables

import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private boolean truncateTables(String tablename, String schemaname, Database db)
{
	boolean retval=false;
	String realSchemaname=schemaname;
	String realTablename=tablename;
	try{

		if(!Const.isEmpty(realSchemaname))
               	realTablename = db.getDatabaseMeta().getQuotedSchemaTableCombination(realSchemaname, realTablename);
               
		// check if table exists!
		if(db.checkTableExists(realTablename)){
			if(!Const.isEmpty(realSchemaname))
				db.truncateTable(realSchemaname, tablename);
			else
				db.truncateTable(tablename);
	
			if(log.isDetailed()) logDetailed(BaseMessages.getString(PKG, "JobEntryTruncateTables.Log.TableTruncated",realTablename));
			
			retval=true;
		}else{
			logError(BaseMessages.getString(PKG, "JobEntryTruncateTables.Error.CanNotFindTable",realTablename));
		}
	}catch (Exception e)
	{
		logError(BaseMessages.getString(PKG, "JobEntryTruncateTables.Error.CanNotTruncateTables",realTablename,e.toString()));
	}
	return retval;
}
开发者ID:yintaoxue，项目名称:read-open-source-code，代码行数:30，代码来源:JobEntryTruncateTables.java

示例6: clearLogTable

import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
/**
 * User requested to clear the log table.<br>
 * Better ask confirmation
 */
private void clearLogTable(int index) {

  LogTableInterface logTable = models[index].logTable;

  if (logTable.isDefined()) {
    String schemaTable = logTable.getQuotedSchemaTableCombination();
    DatabaseMeta databaseMeta = logTable.getDatabaseMeta();

    MessageBox mb = new MessageBox(jobGraph.getShell(), SWT.YES | SWT.NO | SWT.ICON_QUESTION);
    mb.setMessage(BaseMessages.getString(PKG, "JobGraph.Dialog.AreYouSureYouWantToRemoveAllLogEntries.Message", schemaTable)); // Nothing found that matches your criteria //$NON-NLS-1$
    mb.setText(BaseMessages.getString(PKG, "JobGraph.Dialog.AreYouSureYouWantToRemoveAllLogEntries.Title")); // Sorry! //$NON-NLS-1$
    if (mb.open() == SWT.YES) {
      Database database = new Database(loggingObject, databaseMeta);
      try {
        database.connect();
        database.truncateTable(schemaTable);
      } catch (Exception e) {
        new ErrorDialog(jobGraph.getShell(), BaseMessages.getString(PKG, "JobGraph.Dialog.ErrorClearningLoggingTable.Title"), BaseMessages.getString(PKG, "JobGraph.Dialog.AreYouSureYouWantToRemoveAllLogEntries.Message"), e); //$NON-NLS-1$//$NON-NLS-2$
      } finally {
        if (database != null) {
          database.disconnect();
        }

        refreshHistory();
        if (wText.get(index) != null) {
          wText.get(index).setText(""); //$NON-NLS-1$
        }
      }
    }
  }
}
开发者ID:yintaoxue，项目名称:read-open-source-code，代码行数:36，代码来源:JobHistoryDelegate.java

示例7: clearLogTable

import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
/**
 * User requested to clear the log table.<br>
 * Better ask confirmation
 */
private void clearLogTable(int index) {

  LogTableInterface logTable = models[index].logTable;

  if (logTable.isDefined()) {
    String schemaTable = logTable.getQuotedSchemaTableCombination();
    DatabaseMeta databaseMeta = logTable.getDatabaseMeta();

    MessageBox mb = new MessageBox(transGraph.getShell(), SWT.YES | SWT.NO | SWT.ICON_QUESTION);
    mb.setMessage(BaseMessages.getString(PKG, "TransGraph.Dialog.AreYouSureYouWantToRemoveAllLogEntries.Message", schemaTable)); // Nothing found that matches your criteria //$NON-NLS-1$
    mb.setText(BaseMessages.getString(PKG, "TransGraph.Dialog.AreYouSureYouWantToRemoveAllLogEntries.Title")); // Sorry! //$NON-NLS-1$
    if (mb.open() == SWT.YES) {
      Database database = new Database(loggingObject, databaseMeta);
      try {
        database.connect();
        database.truncateTable(schemaTable);
      } catch (Exception e) {
        new ErrorDialog(transGraph.getShell(), BaseMessages.getString(PKG, "TransGraph.Dialog.ErrorClearningLoggingTable.Title"), //$NON-NLS-1$
            BaseMessages.getString(PKG, "TransGraph.Dialog.ErrorClearningLoggingTable.Message"), e); //$NON-NLS-1$
      } finally {
        if (database != null) {
          database.disconnect();
        }

        refreshHistory();
        if (wText.get(index) != null) {
          wText.get(index).setText(""); //$NON-NLS-1$
        }
      }
    }
  }
}
开发者ID:yintaoxue，项目名称:read-open-source-code，代码行数:37，代码来源:TransHistoryDelegate.java


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