Exemple #1
0
  ServerThread startup() throws Exception {
    String simpleSchema =
        "create table dummy ("
            + "sval1 varchar(100) not null, "
            + "sval2 varchar(100) default 'foo', "
            + "sval3 varchar(100) default 'bar', "
            + "PRIMARY KEY(sval1));";

    File schemaFile = VoltProjectBuilder.writeStringToTempFile(simpleSchema);
    String schemaPath = schemaFile.getPath();
    schemaPath = URLEncoder.encode(schemaPath, "UTF-8");

    VoltProjectBuilder builder = new VoltProjectBuilder();
    builder.addSchema(schemaPath);
    builder.addPartitionInfo("dummy", "sval1");
    builder.addStmtProcedure("Insert", "insert into dummy values (?,?,?);");
    builder.addStmtProcedure("Select", "select * from dummy;");
    builder.setHTTPDPort(8095);
    boolean success =
        builder.compile(Configuration.getPathToCatalogForTest("jsonperf.jar"), 1, 1, 0);
    assert (success);

    VoltDB.Configuration config = new VoltDB.Configuration();
    config.m_pathToCatalog = Configuration.getPathToCatalogForTest("jsonperf.jar");
    config.m_pathToDeployment = builder.getPathToDeployment();
    ServerThread server = new ServerThread(config);
    server.start();
    server.waitForInitialization();

    Client client = ClientFactory.createClient();
    client.createConnection("localhost");

    ClientResponse response1;
    response1 = client.callProcedure("Insert", "FOO", "BAR", "BOO");
    assert (response1.getStatus() == ClientResponse.SUCCESS);

    return server;
  }
  /**
   * Assuming given tables have schema metadata, fill them with random data and compare a pure-java
   * schema migration with an EE schema migration.
   */
  void migrateSchema(VoltTable t1, VoltTable t2, boolean withData) throws Exception {
    ServerThread server = null;
    Client client = null;
    TableHelper helper = new TableHelper();

    try {
      if (withData) {
        helper.randomFill(t1, 1000, 1024);
      }

      String catPath1 = catalogPathForTable(t1, "t1.jar");
      String catPath2 = catalogPathForTable(t2, "t2.jar");
      byte[] catBytes2 = MiscUtils.fileToBytes(new File(catPath2));

      DeploymentBuilder depBuilder = new DeploymentBuilder(1, 1, 0);
      depBuilder.setVoltRoot("/tmp/foobar");
      // disable logging
      depBuilder.configureLogging("/tmp/foobar", "/tmp/foobar", false, false, 1, 1, 3);
      String deployment = depBuilder.getXML();
      File deploymentFile = VoltProjectBuilder.writeStringToTempFile(deployment);

      VoltDB.Configuration config = new VoltDB.Configuration();
      config.m_pathToDeployment = deploymentFile.getAbsolutePath();
      config.m_pathToCatalog = catPath1;
      config.m_ipcPort = 10000;
      // config.m_backend = BackendTarget.NATIVE_EE_IPC;
      server = new ServerThread(config);
      server.start();
      server.waitForInitialization();

      System.out.printf("PRE:  %s\n", TableHelper.ddlForTable(t1));
      System.out.printf("POST: %s\n", TableHelper.ddlForTable(t2));

      ClientConfig clientConfig = new ClientConfig();
      client = ClientFactory.createClient(clientConfig);
      client.createConnection("localhost");

      TableHelper.loadTable(client, t1);

      ClientResponseImpl response =
          (ClientResponseImpl) client.callProcedure("@UpdateApplicationCatalog", catBytes2, null);
      System.out.println(response.toJSONString());

      VoltTable t3 = client.callProcedure("@AdHoc", "select * from FOO").getResults()[0];
      t3 = TableHelper.sortTable(t3);

      // compute the migrated table entirely in Java for comparison purposes
      TableHelper.migrateTable(t1, t2);
      t2 = TableHelper.sortTable(t2);

      // compare the tables
      StringBuilder sb = new StringBuilder();
      if (!TableHelper.deepEqualsWithErrorMsg(t2, t3, sb)) {
        System.out.println("Table Mismatch");
        // System.out.printf("PRE:  %s\n", t2.toFormattedString());
        // System.out.printf("POST: %s\n", t3.toFormattedString());
        System.out.println(sb.toString());
        fail();
      }
    } finally {
      if (client != null) {
        client.close();
      }
      if (server != null) {
        server.shutdown();
      }
    }
  }