예제 #1
0
파일: Client.java 프로젝트: pedia/zeroc-ice
 @Override
 public int run(String[] args) {
   java.io.PrintWriter out = getWriter();
   InitialPrx initial = AllTests.allTests(this, false, out);
   initial.shutdown();
   return 0;
 }
예제 #2
0
  @SuppressWarnings("serial")
  public void testExample() throws Exception {
    if (!AllTests.isSetup()) {
      return;
    }

    Job job = getJob();
    VerticaInputFormat.setInput(job, "select * from mrsource");
    job.waitForCompletion(true);

    job = getJob();
    VerticaInputFormat.setInput(
        job, "select * from mrsource where key = ?", "select distinct key from mrsource");
    job.waitForCompletion(true);

    job = getJob();
    Collection<List<Object>> params = new HashSet<List<Object>>() {};
    List<Object> param = new ArrayList<Object>();
    param.add(new Integer(0));
    params.add(param);
    VerticaInputFormat.setInput(job, "select * from mrsource where key = ?", params);
    job.waitForCompletion(true);

    job = getJob();
    VerticaInputFormat.setInput(job, "select * from mrsource where key = ?", "0", "1", "2");
    job.waitForCompletion(true);

    VerticaOutputFormat.optimize(job.getConfiguration());
  }
예제 #3
0
 @Override
 public int run(String[] args) {
   Ice.Communicator communicator = communicator();
   ChecksumPrx checksum = AllTests.allTests(communicator, false, getWriter());
   checksum.shutdown();
   return 0;
 }
예제 #4
0
    @Override
    String runTest() throws Exception {
      client testPlayer = AllTests.getTestPlayerClient();

      testPlayer.getInventoryHandler().removeAllEquipment();
      testPlayer.getInventoryHandler().removeAllItems();

      testPlayer.getInventoryHandler().addItem(4153);

      int expected = 4;
      int itemId = 4151;

      for (int i = 0; i < expected; i++) {
        testPlayer.getInventoryHandler().addItem(itemId);
      }

      int count = testPlayer.getInventoryHandler().itemAmount(4151);

      if (count != expected)
        return "Inventory Handler calculated wrong item amount: Expected "
            + expected
            + ". Actual: "
            + count;

      testPlayer.getInventoryHandler().removeAllEquipment();
      testPlayer.getInventoryHandler().removeAllItems();
      return null;
    }
예제 #5
0
 @Override
 public int run(String[] args) {
   Ice.Communicator communicator = communicator();
   TestIntfPrx test = AllTests.allTests(communicator, false, getWriter());
   test.shutdown();
   return 0;
 }
예제 #6
0
 public void tearDown() {
   try {
     Connection con = AllTests.getConnection();
     Statement st = con.createStatement();
     st.execute("drop table " + table);
     st.close();
   } catch (Throwable e) {
     // e.printStackTrace();
   }
 }
예제 #7
0
  public Job getJob() throws IOException {
    Configuration conf = new Configuration(true);
    Cluster cluster = new Cluster(conf);
    Job job = Job.getInstance(cluster);

    conf = job.getConfiguration();
    conf.set("mapreduce.job.tracker", "local");

    job.setJarByClass(TestExample.class);
    job.setJobName("vertica test");

    job.setOutputKeyClass(Text.class);
    job.setOutputValueClass(VerticaRecord.class);
    job.setInputFormatClass(VerticaInputFormat.class);
    job.setOutputFormatClass(VerticaOutputFormat.class);
    job.setMapOutputKeyClass(Text.class);
    job.setMapOutputValueClass(DoubleWritable.class);
    job.setMapperClass(Map.class);
    job.setReducerClass(Reduce.class);
    VerticaOutputFormat.setOutput(
        job,
        "mrtarget",
        true,
        "a int",
        "b boolean",
        "c char(1)",
        "d date",
        "f float",
        "t timestamp",
        "v varchar",
        "z varbinary");
    VerticaConfiguration.configureVertica(
        conf,
        new String[] {AllTests.getHostname()},
        AllTests.getDatabase(),
        AllTests.getUsername(),
        AllTests.getPassword());
    return job;
  }
예제 #8
0
  @Override
  public int run(String[] args) {
    com.zeroc.Ice.Communicator communicator = communicator();
    AllTests.allTests(communicator);

    //
    // Shutdown the IceBox server.
    //
    com.zeroc.Ice.ProcessPrx.uncheckedCast(
            communicator.stringToProxy("DemoIceBox/admin -f Process:default -p 9996"))
        .shutdown();
    return 0;
  }
예제 #9
0
  public void setUp() {
    tearDown();
    try {
      Connection con = AllTests.getConnection();
      Statement st = con.createStatement();
      st.execute(
          "create table " + table + "(a " + testValue.dataType + ", b " + testValue.dataType + ")");
      st.close();
      PreparedStatement pr = con.prepareStatement("INSERT into " + table + "(a,b) Values(?,?)");

      pr.setObject(1, testValue.small);
      pr.setObject(2, testValue.large);
      pr.execute();

      pr.setObject(1, testValue.small);
      pr.setObject(2, testValue.small);
      pr.execute();

      pr.setObject(1, testValue.large);
      pr.setObject(2, testValue.large);
      pr.execute();

      pr.setObject(1, testValue.large);
      pr.setObject(2, testValue.small);
      pr.execute();

      pr.setObject(1, null);
      pr.setObject(2, testValue.small);
      pr.execute();

      pr.setObject(1, testValue.small);
      pr.setObject(2, null);
      pr.execute();

      pr.setObject(1, null);
      pr.setObject(2, null);
      pr.execute();
      pr.close();
    } catch (Throwable e) {
      e.printStackTrace();
    }
  }
예제 #10
0
    @Override
    String runTest() throws Exception {

      client testPlayer = AllTests.getTestPlayerClient();

      testPlayer.getInventoryHandler().removeAllEquipment();
      testPlayer.getInventoryHandler().removeAllItems();

      for (int i = 0; i < testPlayer.playerEquipment.length; i++) {
        if (testPlayer.playerEquipment[i] > 0)
          return "On "
              + testPlayer.playerName
              + ", playerEquipment in slot "
              + i
              + " is "
              + testPlayer.playerEquipment[i]
              + "\n It should be 0.";
      }
      return null;
    }
예제 #11
0
  public void runTest() throws Exception {
    Connection con = AllTests.getConnection();
    Statement st = con.createStatement();
    ResultSet rs;

    rs = st.executeQuery("Select * from " + table + " where 1 = 0");
    assertFalse("To many rows", rs.next());

    rs = st.executeQuery("Select * from " + table + " where a = b");
    assertTrue("To few rows", rs.next());
    assertEqualsObject("Values not equals", rs.getObject(1), rs.getObject(2), false);
    assertTrue("To few rows", rs.next());
    assertEqualsObject("Values not equals", rs.getObject(1), rs.getObject(2), false);
    assertFalse("To many rows", rs.next());

    rs = st.executeQuery("Select * from " + table + " where a <= b and b <= a");
    assertTrue("To few rows", rs.next());
    assertEqualsObject("Values not equals", rs.getObject(1), rs.getObject(2), false);
    assertTrue("To few rows", rs.next());
    assertEqualsObject("Values not equals", rs.getObject(1), rs.getObject(2), false);
    assertFalse("To many rows", rs.next());

    rs = st.executeQuery("Select * from " + table + " where (a > (b))");
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());

    rs = st.executeQuery("Select * from " + table + " where a >= b");
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());

    rs = st.executeQuery("Select * from " + table + " where not (a >= b)");
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());

    rs = st.executeQuery("Select * from " + table + " where a < b");
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());

    rs = st.executeQuery("Select * from " + table + " where a < b or a>b");
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());

    rs = st.executeQuery("Select * from " + table + " where a <= b");
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());

    rs = st.executeQuery("Select * from " + table + " where a <> b");
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());

    PreparedStatement pr =
        con.prepareStatement("Select * from " + table + " where a between ? and ?");
    pr.setObject(1, testValue.small);
    pr.setObject(2, testValue.large);
    rs = pr.executeQuery();
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());
    pr.close();

    pr = con.prepareStatement("Select * from " + table + " where a not between ? and ?");
    pr.setObject(1, testValue.small);
    pr.setObject(2, testValue.large);
    rs = pr.executeQuery();
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());
    pr.close();

    pr = con.prepareStatement("Select * from " + table + " where a in(?,?)");
    pr.setObject(1, testValue.small);
    pr.setObject(2, testValue.large);
    rs = pr.executeQuery();
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());
    pr.close();

    pr = con.prepareStatement("Select * from " + table + " where a not in(?,?)");
    pr.setObject(1, testValue.small);
    pr.setObject(2, testValue.large);
    rs = pr.executeQuery();
    assertTrue("To few rows", rs.next());
    assertTrue("To few rows", rs.next());
    assertFalse("To many rows", rs.next());
    pr.close();

    st.close();
  }
예제 #12
0
 @Test
 public void checkFileContent() {
   System.out.println("Test12 -SELECT- checkFileContent");
   AllTests.fileComparison("12books.txt");
 }