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

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

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

Database.getCreateTableStatement介绍

[英]Generates SQL
[中]生成SQL

代码示例

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

  1. /**
  2. * Return SQL CREATION statement for a Table
  3. *
  4. * @param tableName The table to create
  5. * @throws KettleDatabaseException
  6. */
  7. public String getDDLCreationTable( String tableName, RowMetaInterface fields ) throws KettleDatabaseException {
  8. String retval;
  9. // First, check for reserved SQL in the input row r...
  10. databaseMeta.quoteReservedWords( fields );
  11. String quotedTk = databaseMeta.quoteField( null );
  12. retval = getCreateTableStatement( tableName, fields, quotedTk, false, null, true );
  13. return retval;
  14. }

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

  1. public String getDDL( String tableName, RowMetaInterface fields, String tk, boolean use_autoinc, String pk,
  2. boolean semicolon ) throws KettleDatabaseException {
  3. String retval;
  4. // First, check for reserved SQL in the input row r...
  5. databaseMeta.quoteReservedWords( fields );
  6. String quotedTk = tk != null ? databaseMeta.quoteField( tk ) : null;
  7. if ( checkTableExists( tableName ) ) {
  8. retval = getAlterTableStatement( tableName, fields, quotedTk, use_autoinc, pk, semicolon );
  9. } else {
  10. retval = getCreateTableStatement( tableName, fields, quotedTk, use_autoinc, pk, semicolon );
  11. }
  12. return retval;
  13. }

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

  1. RowMetaInterface r = targetdb.getTableFields( tableName );
  2. String sql = targetdb.getCreateTableStatement( tableName, r, null, false, null, true );
  3. SQLEditor se =
  4. new SQLEditor( this.getDatabaseMeta(), this.dbExplorerDialog.getShell(), SWT.NONE, this.model

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

  1. public void getDDL() {
  2. if ( model.getTable() == null ) {
  3. return;
  4. }
  5. Database db = new Database( null, this.model.getDatabaseMeta() );
  6. try {
  7. db.connect();
  8. String tableName = getSchemaAndTable( this.model );
  9. RowMetaInterface r = db.getTableFields( tableName );
  10. String sql = db.getCreateTableStatement( tableName, r, null, false, null, true );
  11. SQLEditor se =
  12. new SQLEditor( this.getDatabaseMeta(), this.dbExplorerDialog.getShell(), SWT.NONE, this.model
  13. .getDatabaseMeta(), this.dbcache, sql );
  14. se.open();
  15. } catch ( KettleDatabaseException dbe ) {
  16. new ErrorDialog(
  17. this.dbExplorerDialog.getShell(), BaseMessages.getString( PKG, "Dialog.Error.Header" ), BaseMessages
  18. .getString( PKG, "DatabaseExplorerDialog.Error.RetrieveLayout" ), dbe );
  19. } finally {
  20. db.disconnect();
  21. }
  22. }

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

  1. .getCreateTableStatement(
  2. tableName,
  3. data.db.getTableFieldsMeta( data.realSchemaName, tableName ),

相关文章