Example #1
0
 @Test(groups = {"acceptance"})
 public void createAndListTable() throws RqlDriverException {
   SecureRandom random = new SecureRandom();
   String database = new BigInteger(130, random).toString(32);
   String table = new BigInteger(130, random).toString(32);
   RqlConnection r = RqlConnection.connect("localhost", 28015);
   r.run(r.db_create(database));
   RqlCursor cursor = r.run(r.db(database).table_create(table));
   assert Double.valueOf(1.0).equals(cursor.next().getAs("created"))
       : "Table was not created successfully ";
   cursor = r.run(r.db(database).table_list());
   boolean found = false;
   for (Object o : cursor.next().getList()) {
     if (table.equals(o)) {
       found = true;
       break;
     }
   }
   assert found == true : "Table was not able to be listed";
   cursor = r.run(r.db(database).table_drop(table));
   assert Double.valueOf(1.0).equals(cursor.next().getAs("dropped"))
       : "Table was not dropped successfully ";
   r.run(r.db_drop(database));
   r.close();
 }
Example #2
0
  @SuppressWarnings({"unchecked", "rawtypes", "serial"})
  @Test(groups = {"acceptance"})
  public void insertAndRetrieveSingleRow() throws RqlDriverException {
    SecureRandom random = new SecureRandom();
    String database = new BigInteger(130, random).toString(32);
    String table = new BigInteger(130, random).toString(32);
    RqlConnection r = RqlConnection.connect("localhost", 28015);
    r.run(r.db_create(database));
    r.run(r.db(database).table_create(table));

    RqlCursor cursor =
        r.run(
            r.db(database)
                .table(table)
                .insert(
                    Arrays.asList(
                        new HashMap() {
                          {
                            put("name", "Worf");
                            put("show", "Star Trek TNG");
                          }
                        },
                        new HashMap() {
                          {
                            put("name", "Data");
                            put("show", "Star Trek TNG");
                          }
                        },
                        new HashMap() {
                          {
                            put("name", "William Adama");
                            put("show", "Battlestar Galactica");
                          }
                        },
                        new HashMap() {
                          {
                            put("name", "Homer Simpson");
                            put("show", "The Simpsons");
                          }
                        })));

    List generatedKeys = cursor.next().getAs("generated_keys");

    Iterator it = generatedKeys.iterator();

    while (it.hasNext()) {
      cursor = r.run(r.db(database).table(table).get(it.next()));
      for (RqlObject o : cursor) {
        assert o.toString() != null : "Failed to get single row";
      }
    }

    r.run(r.db(database).table_drop(table));
    r.run(r.db_drop(database));
    r.close();
  }
Example #3
0
  @SuppressWarnings({"unchecked", "rawtypes", "serial"})
  @Test(groups = {"benchmark"})
  public void largeDataSetTest() throws RqlDriverException {
    final double rowsPerIteration = 8192.0;
    final double numberOfIterations = 256.0;
    final SecureRandom random = new SecureRandom();
    String database = new BigInteger(130, random).toString(32);
    String table = new BigInteger(130, random).toString(32);
    RqlConnection r = RqlConnection.connect("localhost", 28015);
    r.run(r.db_create(database));
    r.run(r.db(database).table_create(table));

    for (long j = 0; j < numberOfIterations; j++) {
      List<Object> l = new ArrayList<Object>();
      System.out.println("Inserting Rows...");
      for (long i = 0; i < rowsPerIteration; i++) {
        final long id = (i * (long) rowsPerIteration) + j;
        l.add(
            new HashMap() {
              {
                put("id", BigInteger.valueOf(id).toString(32));
                put("name", new BigInteger(64, random).toString(32));
              }
            });
      }
      RqlCursor cursor = r.run(r.db(database).table(table).insert(l));
      RqlObject obj = cursor.next();
      Double result = obj.getAs("inserted");
      assert result == rowsPerIteration
          : "Error inserting Data into Database on iteration "
              + j
              + " ("
              + result
              + " did not equal "
              + rowsPerIteration
              + ")";
    }
    RqlCursor cursor = r.run(r.db(database).table(table).count());
    assert Double.valueOf(numberOfIterations * rowsPerIteration).equals(cursor.next().getNumber())
        : "Error getting large row count";

    cursor = r.run(r.db(database).table(table));
    long rowCount = 0;
    for (RqlObject o : cursor) {
      rowCount++;
    }
    assert rowCount == (rowsPerIteration * numberOfIterations)
        : "Error fetching all rows in large dataset";
    System.out.println("We got " + rowCount + " results back ");

    r.run(r.db(database).table_drop(table));
    r.run(r.db_drop(database));
    r.close();
  }
Example #4
0
  @SuppressWarnings({"unchecked", "rawtypes", "serial"})
  @Test(groups = {"acceptance"})
  public void insertAndRetrieveData() throws RqlDriverException {
    SecureRandom random = new SecureRandom();
    String database = new BigInteger(130, random).toString(32);
    String table = new BigInteger(130, random).toString(32);
    RqlConnection r = RqlConnection.connect("localhost", 28015);
    r.run(r.db_create(database));
    r.run(r.db(database).table_create(table));

    RqlCursor cursor =
        r.run(
            r.db(database)
                .table(table)
                .insert(
                    Arrays.asList(
                        new HashMap() {
                          {
                            put("name", "Worf");
                            put("show", "Star Trek TNG");
                          }
                        },
                        new HashMap() {
                          {
                            put("name", "Data");
                            put("show", "Star Trek TNG");
                          }
                        },
                        new HashMap() {
                          {
                            put("name", "William Adama");
                            put("show", "Battlestar Galactica");
                          }
                        },
                        new HashMap() {
                          {
                            put("name", "Homer Simpson");
                            put("show", "The Simpsons");
                          }
                        })));
    assert Double.valueOf(4.0).equals(cursor.next().getAs("inserted"))
        : "Error inserting Data into Database";
    cursor =
        r.run(
            r.db(database)
                .table(table)
                .filter(
                    new HashMap() {
                      {
                        put("show", "Star Trek TNG");
                      }
                    }));
    // We Expect Two results
    int count = 0;
    for (RqlObject o : cursor) {
      Map<String, Object> m = o.getMap();
      assert m.containsKey("name") : "Data that came back was malformed (missing \"name\")";
      assert m.containsKey("show") : "Data that came back was malformed (missing \"show\")";
      assert "Star Trek TNG".equals(m.get("show"))
          : "Data that came back was just plain wrong (\"show\" was not \"Star Trek TNG\");";
      count++;
    }

    cursor =
        r.run(
            r.db(database)
                .table(table)
                .filter(
                    new HashMap() {
                      {
                        put("name", "donald duck");
                        put("show", "Disney show");
                      }
                    })
                .is_empty());
    Boolean isEmpty = null;
    for (RqlObject o : cursor) {
      isEmpty = o.getBoolean();
    }
    assert isEmpty == true : "Failed at verifying query resultset is empty.";

    cursor = r.run(r.db(database).table(table).count());
    double rowCount = 0;
    for (RqlObject o : cursor) {
      rowCount = o.getNumber();
    }
    assert rowCount == 4.0 : "Failed at getting the correct row count.";

    r.run(r.db(database).table_drop(table));
    r.run(r.db_drop(database));
    r.close();
  }