Java SqlBuilder类代码示例

import org.apache.ddlutils.platform.SqlBuilder; //导入依赖的package包/类
@Override
protected void writeAllDDLs(Connection conn, Writer writer, boolean exportAll)
    throws SQLException, IOException {
  CallableStatement cstmt = conn.prepareCall("call SYS.EXPORT_DDLS(?)");
  cstmt.setBoolean(1, exportAll);
  ResultSet rs = cstmt.executeQuery();
  while (rs.next()) {
    writer.write(rs.getString(3));
    writer.write(';');
    writer.write(SqlBuilder.LINE_SEPARATOR);
    writer.write(SqlBuilder.LINE_SEPARATOR);
  }
  rs.close();
  writer.flush();
}
 

import org.apache.ddlutils.platform.SqlBuilder; //导入依赖的package包/类
protected void writeAddIdentityUsingAlterTable(Platform platform,
    Database model) throws DataSinkException {
  // if identity column has to be set using alter table then
  // do it after loading the data
  if (_addIdentityUsingAlterTable && platform.getPlatformInfo()
          .isAddingIdentityUsingAlterTableSupported()) {
    StringWriter buffer = new StringWriter();
  
    SqlBuilder builder = platform.getSqlBuilder();
    builder.setWriter(buffer);
    for (int index = 0; index < model.getTableCount(); index++) {
      Table table = model.getTable(index);
      for (int col = 0; col < table.getColumnCount(); col++) {
        Column column = table.getColumn(col);
        if (column.isAutoIncrement()) {
          try {
            builder.writeAddIdentityColumnUsingAlterTable(table, column);
          } catch (IOException ioe) {
            throw new DataSinkException(ioe);
          }
        }
      }
    }
    String sql = buffer.toString();
    platform.evaluateBatch(sql, false);
  }
}
 

import org.apache.ddlutils.platform.SqlBuilder; //导入依赖的package包/类
private String constructInsertSingleTable(Table table, StructuredStore store, SqlBuilder sqlBuilder) {
    StringBuilder ret = new StringBuilder();
    List<Map<String, Object>> allData = store.selectRows(table.getName(), null, null, null, null, -1);
    for (Map<String, Object> row : allData) {
        ret.append(sqlBuilder.getInsertSql(table, row, false) + "\n");
    }
    return ret.toString();
}
 

import org.apache.ddlutils.platform.SqlBuilder; //导入依赖的package包/类
@Before
public void setup() {
    sqlGenerator = new StandardSqlGenerator() {
        @Override
        public String constructRenameTableColumns(String schema, String table, Map<String, String> columns) {
            return null;
        }

        @Override
        protected SqlBuilder getDdlSqlBuilder(String schema, Platform platform) {
            // TODO Auto-generated method stub
            return null;
        }
    };
}
 

import org.apache.ddlutils.platform.SqlBuilder; //导入依赖的package包/类
private Pair<Database, SqlBuilder> getDatabaseAndSqlBuilderPair(String schema, DataSource dataSource) {
    Platform platform = PlatformFactory.createNewPlatformInstance(dataSource);
    return Pair.of(platform.readModelFromDatabase(null, null, caseConverter.convert(schema), null), getDdlSqlBuilder(schema, platform));
}
 

import org.apache.ddlutils.platform.SqlBuilder; //导入依赖的package包/类
/**
 * Returns the sql builder for the this platform.
 * 
 * @return The sql builder
 */
public SqlBuilder getSqlBuilder();
 

import org.apache.ddlutils.platform.SqlBuilder; //导入依赖的package包/类
/**
 * Returns the SQL builder of the tested platform.
 * 
 * @return The builder object
 */
protected SqlBuilder getSqlBuilder()
{
    return getPlatform().getSqlBuilder();
}
 

import org.apache.ddlutils.platform.SqlBuilder; //导入依赖的package包/类
protected abstract SqlBuilder getDdlSqlBuilder(String schema, Platform platform);