Java JdbcExecutor类代码示例

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
@Override
protected void migrateData(ReviewDb db, UpdateUI ui) throws OrmException, SQLException {
  conn = ((JdbcSchema) db).getConnection();
  dialect = ((JdbcSchema) db).getDialect();
  Map<String, PrimaryKey> corrections = findPKUpdates();
  if (corrections.isEmpty()) {
    return;
  }

  ui.message("Wrong Primary Key Column Order Detected");
  ui.message("The following tables are affected:");
  ui.message(Joiner.on(", ").join(corrections.keySet()));
  ui.message("fixing primary keys...");
  try (JdbcExecutor executor = new JdbcExecutor(conn)) {
    for (Map.Entry<String, PrimaryKey> c : corrections.entrySet()) {
      ui.message(String.format("  table: %s ... ", c.getKey()));
      recreatePK(executor, c.getKey(), c.getValue(), ui);
      ui.message("done");
    }
    ui.message("done");
  }
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
/** Runs check on the prior schema version, and then upgrades. */
private void upgradeFrom(UpdateUI ui, CurrentSchemaVersion curr, CiDb db)
    throws OrmException, SQLException {
  List<SchemaVersion> pending = pending(curr.versionNbr);
  updateSchema(pending, ui, db);
  migrateData(pending, ui, curr, db);

  JdbcSchema s = (JdbcSchema) db;
  final List<String> pruneList = Lists.newArrayList();
  s.pruneSchema(new StatementExecutor() {
    @Override
    public void execute(String sql) {
      pruneList.add(sql);
    }

    @Override
    public void close() {
      // Do nothing.
    }
  });

  try (JdbcExecutor e = new JdbcExecutor(s)) {
    if (!pruneList.isEmpty()) {
      ui.pruneSchema(e, pruneList);
    }
  }
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
private void updateSchema(List<SchemaVersion> pending, UpdateUI ui,
    CiDb db) throws OrmException, SQLException {
  for (SchemaVersion v : pending) {
    ui.message(String.format("Upgrading schema to %d ...", v.getVersionNbr()));
    v.preUpdateSchema(db);
  }

  JdbcSchema s = (JdbcSchema) db;
  try (JdbcExecutor e = new JdbcExecutor(s)) {
    s.updateSchema(e);
  }
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
/** Rename an existing table. */
protected static void renameTable(ReviewDb db, String from, String to)
    throws OrmException {
  JdbcSchema s = (JdbcSchema) db;
  try (JdbcExecutor e = new JdbcExecutor(s)) {
    s.renameTable(e, from, to);
  }
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
/** Rename an existing column. */
protected static void renameColumn(ReviewDb db, String table, String from, String to)
    throws OrmException {
  JdbcSchema s = (JdbcSchema) db;
  try (JdbcExecutor e = new JdbcExecutor(s)) {
    s.renameField(e, table, from, to);
  }
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
public void create(ReviewDb db) throws OrmException, IOException, ConfigInvalidException {
  final JdbcSchema jdbc = (JdbcSchema) db;
  try (JdbcExecutor e = new JdbcExecutor(jdbc)) {
    jdbc.updateSchema(e);
  }

  final CurrentSchemaVersion sVer = CurrentSchemaVersion.create();
  sVer.versionNbr = SchemaVersion.getBinaryVersion();
  db.schemaVersion().insert(Collections.singleton(sVer));

  GroupReference admins = createGroupReference("Administrators");
  GroupReference batchUsers = createGroupReference("Non-Interactive Users");

  initSystemConfig(db);
  allProjectsCreator.setAdministrators(admins).setBatchUsers(batchUsers).create();
  // We have to create the All-Users repository before we can use it to store the groups in it.
  allUsersCreator.setAdministrators(admins).create();

  // Don't rely on injection to construct Sequences, as it requires ReviewDb.
  Sequences seqs =
      new Sequences(
          config,
          () -> db,
          migration,
          repoManager,
          GitReferenceUpdated.DISABLED,
          allProjectsName,
          allUsersName,
          metricMaker);
  try (Repository repository = repoManager.openRepository(allUsersName)) {
    createAdminsGroup(db, seqs, repository, admins);
    createBatchUsersGroup(db, seqs, repository, batchUsers, admins);
  }

  dataSourceType.getIndexScript().run(db);
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
/** Runs check on the prior schema version, and then upgrades. */
private void upgradeFrom(UpdateUI ui, CurrentSchemaVersion curr, ReviewDb db)
    throws OrmException, SQLException {
  List<SchemaVersion> pending = pending(curr.versionNbr);
  updateSchema(pending, ui, db);
  migrateData(pending, ui, curr, db);

  JdbcSchema s = (JdbcSchema) db;
  final List<String> pruneList = new ArrayList<>();
  s.pruneSchema(
      new StatementExecutor() {
        @Override
        public void execute(String sql) {
          pruneList.add(sql);
        }

        @Override
        public void close() {
          // Do nothing.
        }
      });

  try (JdbcExecutor e = new JdbcExecutor(s)) {
    if (!pruneList.isEmpty()) {
      ui.pruneSchema(e, pruneList);
    }
  }
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
private void updateSchema(List<SchemaVersion> pending, UpdateUI ui, ReviewDb db)
    throws OrmException, SQLException {
  for (SchemaVersion v : pending) {
    ui.message(String.format("Upgrading schema to %d ...", v.getVersionNbr()));
    v.preUpdateSchema(db);
  }

  JdbcSchema s = (JdbcSchema) db;
  try (JdbcExecutor e = new JdbcExecutor(s)) {
    s.updateSchema(e);
  }
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
/** Rename an existing table. */
protected static void renameTable(ReviewDb db, String from, String to) throws OrmException {
  JdbcSchema s = (JdbcSchema) db;
  try (JdbcExecutor e = new JdbcExecutor(s)) {
    s.renameTable(e, from, to);
  }
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
/** Rename an existing column. */
protected static void renameColumn(ReviewDb db, String table, String from, String to)
    throws OrmException {
  JdbcSchema s = (JdbcSchema) db;
  try (JdbcExecutor e = new JdbcExecutor(s)) {
    s.renameColumn(e, table, from, to);
  }
}
 

import com.google.gwtorm.jdbc.JdbcExecutor; //导入依赖的package包/类
/** Open a new statement executor. */
protected static JdbcExecutor newExecutor(ReviewDb db) throws OrmException {
  return new JdbcExecutor(((JdbcSchema) db).getConnection());
}