本文整理了Java中org.pentaho.di.core.database.Database.getCreateTableStatement()
方法的一些代码示例,展示了Database.getCreateTableStatement()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Database.getCreateTableStatement()
方法的具体详情如下:
包路径:org.pentaho.di.core.database.Database
类名称:Database
方法名:getCreateTableStatement
[英]Generates SQL
[中]生成SQL
代码示例来源:origin: pentaho/pentaho-kettle
/**
* Return SQL CREATION statement for a Table
*
* @param tableName The table to create
* @throws KettleDatabaseException
*/
public String getDDLCreationTable( String tableName, RowMetaInterface fields ) throws KettleDatabaseException {
String retval;
// First, check for reserved SQL in the input row r...
databaseMeta.quoteReservedWords( fields );
String quotedTk = databaseMeta.quoteField( null );
retval = getCreateTableStatement( tableName, fields, quotedTk, false, null, true );
return retval;
}
代码示例来源:origin: pentaho/pentaho-kettle
public String getDDL( String tableName, RowMetaInterface fields, String tk, boolean use_autoinc, String pk,
boolean semicolon ) throws KettleDatabaseException {
String retval;
// First, check for reserved SQL in the input row r...
databaseMeta.quoteReservedWords( fields );
String quotedTk = tk != null ? databaseMeta.quoteField( tk ) : null;
if ( checkTableExists( tableName ) ) {
retval = getAlterTableStatement( tableName, fields, quotedTk, use_autoinc, pk, semicolon );
} else {
retval = getCreateTableStatement( tableName, fields, quotedTk, use_autoinc, pk, semicolon );
}
return retval;
}
代码示例来源:origin: pentaho/pentaho-kettle
RowMetaInterface r = targetdb.getTableFields( tableName );
String sql = targetdb.getCreateTableStatement( tableName, r, null, false, null, true );
SQLEditor se =
new SQLEditor( this.getDatabaseMeta(), this.dbExplorerDialog.getShell(), SWT.NONE, this.model
代码示例来源:origin: pentaho/pentaho-kettle
public void getDDL() {
if ( model.getTable() == null ) {
return;
}
Database db = new Database( null, this.model.getDatabaseMeta() );
try {
db.connect();
String tableName = getSchemaAndTable( this.model );
RowMetaInterface r = db.getTableFields( tableName );
String sql = db.getCreateTableStatement( tableName, r, null, false, null, true );
SQLEditor se =
new SQLEditor( this.getDatabaseMeta(), this.dbExplorerDialog.getShell(), SWT.NONE, this.model
.getDatabaseMeta(), this.dbcache, sql );
se.open();
} catch ( KettleDatabaseException dbe ) {
new ErrorDialog(
this.dbExplorerDialog.getShell(), BaseMessages.getString( PKG, "Dialog.Error.Header" ), BaseMessages
.getString( PKG, "DatabaseExplorerDialog.Error.RetrieveLayout" ), dbe );
} finally {
db.disconnect();
}
}
代码示例来源:origin: pentaho/pentaho-kettle
.getCreateTableStatement(
tableName,
data.db.getTableFieldsMeta( data.realSchemaName, tableName ),
内容来源于网络,如有侵权,请联系作者删除!