use of org.bboxdb.storage.entity.TupleStoreConfiguration in project bboxdb by jnidzwetzki.
the class TestZookeeperIntegration method testTableCreateDelete.
/**
* Test the table deletion and creation
* @throws ZookeeperException
* @throws BBoxDBException
* @throws InterruptedException
*/
@Test(timeout = 60000)
public void testTableCreateDelete() throws Exception {
final TupleStoreAdapter tupleStoreAdapter = zookeeperClient.getTupleStoreAdapter();
final SpacePartitioner spacePartitioner = getSpacePartitioner();
final DistributionRegion rootNode = spacePartitioner.getRootNode();
final String rootPath = distributionRegionAdapter.getZookeeperPathForDistributionRegion(rootNode);
distributionRegionAdapter.addSystemToDistributionRegion(rootPath, ZookeeperClientFactory.getLocalInstanceName());
final TupleStoreName tupleStoreName = new TupleStoreName(TEST_GROUP + "_tabletest");
final TupleStoreName tupleStoreName0 = new TupleStoreName(TEST_GROUP + "_tabletest_0");
final TupleStoreConfiguration configuration = TupleStoreConfigurationBuilder.create().build();
tupleStoreAdapter.writeTuplestoreConfiguration(tupleStoreName, configuration);
final TupleStoreManagerRegistry storageRegistry = new TupleStoreManagerRegistry();
storageRegistry.init();
storageRegistry.deleteTable(tupleStoreName0, true);
storageRegistry.createTable(tupleStoreName0, configuration);
storageRegistry.getTupleStoreManager(tupleStoreName0);
Assert.assertTrue(storageRegistry.isStorageManagerKnown(tupleStoreName0));
System.out.println("=== Executing deletion");
tupleStoreAdapter.deleteTable(tupleStoreName0);
Thread.sleep(5000);
Assert.assertFalse(storageRegistry.isStorageManagerKnown(tupleStoreName0));
storageRegistry.shutdown();
}
use of org.bboxdb.storage.entity.TupleStoreConfiguration in project bboxdb by jnidzwetzki.
the class NetworkQueryHelper method executeJoinQuery.
/**
* Execute a join
* @param bboxDBConnection
* @throws InterruptedException
* @throws BBoxDBException
*/
public static void executeJoinQuery(final BBoxDB bboxDBClient, final String distributionGroup) throws InterruptedException, BBoxDBException {
System.out.println("=== Execute join");
final String table1 = distributionGroup + "_table1";
final String table2 = distributionGroup + "_table2";
// Create table1
System.out.println("Create table 1");
final EmptyResultFuture resultCreateTable1 = bboxDBClient.createTable(table1, new TupleStoreConfiguration());
resultCreateTable1.waitForAll();
Assert.assertFalse(resultCreateTable1.isFailed());
System.out.println("Create table 2");
final EmptyResultFuture resultCreateTable2 = bboxDBClient.createTable(table2, new TupleStoreConfiguration());
resultCreateTable2.waitForAll();
Assert.assertFalse(resultCreateTable2.isFailed());
// Insert tuples
System.out.println("Insert tuple 1");
final Tuple tuple1 = new Tuple("abc", new BoundingBox(1.0, 2.0, 1.0, 2.0), "abc".getBytes());
final EmptyResultFuture insertResult1 = bboxDBClient.insertTuple(table1, tuple1);
insertResult1.waitForAll();
Assert.assertFalse(insertResult1.isFailed());
Assert.assertTrue(insertResult1.isDone());
System.out.println("Insert tuple 2");
final Tuple tuple2 = new Tuple("def", new BoundingBox(1.5, 2.5, 1.5, 2.5), "abc".getBytes());
final EmptyResultFuture insertResult2 = bboxDBClient.insertTuple(table1, tuple2);
insertResult2.waitForAll();
Assert.assertFalse(insertResult2.isFailed());
Assert.assertTrue(insertResult2.isDone());
System.out.println("Insert tuple 3");
final Tuple tuple3 = new Tuple("123", new BoundingBox(0.0, 5.0, 0.0, 5.0), "abc".getBytes());
final EmptyResultFuture insertResult3 = bboxDBClient.insertTuple(table2, tuple3);
insertResult3.waitForAll();
Assert.assertFalse(insertResult3.isFailed());
Assert.assertTrue(insertResult3.isDone());
// Execute the join
final JoinedTupleListFuture joinResult = bboxDBClient.queryJoin(Arrays.asList(table1, table2), new BoundingBox(0.0, 10.0, 0.0, 10.0));
joinResult.waitForAll();
final List<JoinedTuple> resultList = Lists.newArrayList(joinResult.iterator());
System.out.println(resultList);
Assert.assertEquals(2, resultList.size());
Assert.assertEquals(2, resultList.get(0).getNumberOfTuples());
Assert.assertEquals(table1, resultList.get(0).getTupleStoreName(0));
Assert.assertEquals(table2, resultList.get(0).getTupleStoreName(1));
Assert.assertEquals(new BoundingBox(1.0, 2.0, 1.0, 2.0), resultList.get(0).getBoundingBox());
Assert.assertEquals(2, resultList.get(1).getNumberOfTuples());
Assert.assertEquals(table1, resultList.get(1).getTupleStoreName(0));
Assert.assertEquals(table2, resultList.get(1).getTupleStoreName(1));
Assert.assertEquals(new BoundingBox(1.5, 2.5, 1.5, 2.5), resultList.get(1).getBoundingBox());
System.out.println("=== End Execute join");
}
use of org.bboxdb.storage.entity.TupleStoreConfiguration in project bboxdb by jnidzwetzki.
the class NetworkQueryHelper method executeBoudingboxAndTimeQuery.
/**
* Execute a bounding box and time query
* @param bboxDBConnection
* @throws BBoxDBException
* @throws InterruptedException
*/
public static void executeBoudingboxAndTimeQuery(final BBoxDB bboxDBClient, final String distributionGroup) throws BBoxDBException, InterruptedException {
final String table = distributionGroup + "_relation9990";
// Create table
final EmptyResultFuture resultCreateTable = bboxDBClient.createTable(table, new TupleStoreConfiguration());
resultCreateTable.waitForAll();
Assert.assertFalse(resultCreateTable.isFailed());
// Inside our bbox query
final Tuple tuple1 = new Tuple("abc", new BoundingBox(0d, 1d, 0d, 1d), "abc".getBytes(), 4);
final EmptyResultFuture result1 = bboxDBClient.insertTuple(table, tuple1);
final Tuple tuple2 = new Tuple("def", new BoundingBox(0d, 0.5d, 0d, 0.5d), "def".getBytes(), 4);
final EmptyResultFuture result2 = bboxDBClient.insertTuple(table, tuple2);
final Tuple tuple3 = new Tuple("geh", new BoundingBox(0.5d, 1.5d, 0.5d, 1.5d), "geh".getBytes(), 1);
final EmptyResultFuture result3 = bboxDBClient.insertTuple(table, tuple3);
// Outside our bbox query
final Tuple tuple4 = new Tuple("ijk", new BoundingBox(-10d, -9d, -10d, -9d), "ijk".getBytes());
final EmptyResultFuture result4 = bboxDBClient.insertTuple(table, tuple4);
final Tuple tuple5 = new Tuple("lmn", new BoundingBox(1000d, 1001d, 1000d, 1001d), "lmn".getBytes());
final EmptyResultFuture result5 = bboxDBClient.insertTuple(table, tuple5);
result1.waitForAll();
result2.waitForAll();
result3.waitForAll();
result4.waitForAll();
result5.waitForAll();
final TupleListFuture future = bboxDBClient.queryBoundingBoxAndTime(table, new BoundingBox(-1d, 2d, -1d, 2d), 2);
future.waitForAll();
final List<Tuple> resultList = Lists.newArrayList(future.iterator());
Assert.assertEquals(3, resultList.size());
Assert.assertTrue(resultList.contains(tuple1));
Assert.assertTrue(resultList.contains(tuple2));
Assert.assertTrue(resultList.contains(tuple3));
Assert.assertFalse(resultList.contains(tuple4));
Assert.assertFalse(resultList.contains(tuple5));
}
use of org.bboxdb.storage.entity.TupleStoreConfiguration in project bboxdb by jnidzwetzki.
the class NetworkQueryHelper method testBoundingBoxQuery.
/**
* Test a bounding box query
* @param bboxDBConnection
* @return
* @throws BBoxDBException
* @throws InterruptedException
*/
public static TupleListFuture testBoundingBoxQuery(final BBoxDB bboxDBClient, final String distributionGroup, final boolean withTupes) throws BBoxDBException, InterruptedException {
System.out.println("=== Running testInsertAndBoundingBoxQuery");
final String table = distributionGroup + "_relation9991";
// Create table
final EmptyResultFuture resultCreateTable = bboxDBClient.createTable(table, new TupleStoreConfiguration());
resultCreateTable.waitForAll();
Assert.assertFalse(resultCreateTable.isFailed());
// Inside our bbox query
final Tuple tuple1 = new Tuple("abc", new BoundingBox(0d, 1d, 0d, 1d), "abc".getBytes());
final Tuple tuple2 = new Tuple("def", new BoundingBox(0d, 0.5d, 0d, 0.5d), "def".getBytes());
final Tuple tuple3 = new Tuple("geh", new BoundingBox(0.5d, 1.5d, 0.5d, 1.5d), "geh".getBytes());
// Outside our bbox query
final Tuple tuple4 = new Tuple("ijk", new BoundingBox(-10d, -9d, -10d, -9d), "ijk".getBytes());
final Tuple tuple5 = new Tuple("lmn", new BoundingBox(1000d, 1001d, 1000d, 1001d), "lmn".getBytes());
if (withTupes) {
final EmptyResultFuture result1 = bboxDBClient.insertTuple(table, tuple1);
final EmptyResultFuture result2 = bboxDBClient.insertTuple(table, tuple2);
final EmptyResultFuture result3 = bboxDBClient.insertTuple(table, tuple3);
final EmptyResultFuture result4 = bboxDBClient.insertTuple(table, tuple4);
final EmptyResultFuture result5 = bboxDBClient.insertTuple(table, tuple5);
result1.waitForAll();
result2.waitForAll();
result3.waitForAll();
result4.waitForAll();
result5.waitForAll();
}
System.out.println("=== Executing query");
final TupleListFuture future = bboxDBClient.queryBoundingBox(table, new BoundingBox(-1d, 2d, -1d, 2d));
future.waitForAll();
System.out.println("=== Query DONE");
Assert.assertFalse(future.isFailed());
final List<Tuple> resultList = Lists.newArrayList(future.iterator());
if (!withTupes) {
Assert.assertEquals(0, resultList.size());
} else {
Assert.assertEquals(3, resultList.size());
Assert.assertTrue(resultList.contains(tuple1));
Assert.assertTrue(resultList.contains(tuple2));
Assert.assertTrue(resultList.contains(tuple3));
Assert.assertFalse(resultList.contains(tuple4));
Assert.assertFalse(resultList.contains(tuple5));
}
System.out.println("=== End testInsertAndBoundingBoxQuery");
return future;
}
use of org.bboxdb.storage.entity.TupleStoreConfiguration in project bboxdb by jnidzwetzki.
the class NetworkQueryHelper method testInsertedTimeQuery.
/**
* Test the version time query
* @param bboxDBConnection
* @param distributionGroup
* @throws InterruptedException
* @throws BBoxDBException
*/
public static void testInsertedTimeQuery(final BBoxDB bboxDBClient, final String distributionGroup) throws InterruptedException, BBoxDBException {
final String table = distributionGroup + "_relationit";
final String key = "key12";
System.out.println("== Executing testInsertedTimeQuery");
// Create table
final EmptyResultFuture resultCreateTable = bboxDBClient.createTable(table, new TupleStoreConfiguration());
resultCreateTable.waitForAll();
Assert.assertFalse(resultCreateTable.isFailed());
final Tuple tuple = new Tuple(key, BoundingBox.FULL_SPACE, "abc".getBytes());
final EmptyResultFuture insertResult = bboxDBClient.insertTuple(table, tuple);
insertResult.waitForAll();
Assert.assertFalse(insertResult.isFailed());
Assert.assertTrue(insertResult.isDone());
System.out.println("Query all versions");
final TupleListFuture getResult1 = bboxDBClient.queryInsertedTime(table, 0);
getResult1.waitForAll();
final List<Tuple> resultList1 = Lists.newArrayList(getResult1.iterator());
Assert.assertEquals(1, resultList1.size());
Assert.assertEquals(tuple, resultList1.get(0));
System.out.println("Query newest versions");
final TupleListFuture getResult2 = bboxDBClient.queryInsertedTime(table, Long.MAX_VALUE);
getResult2.waitForAll();
final List<Tuple> resultList2 = Lists.newArrayList(getResult2.iterator());
Assert.assertTrue(resultList2.isEmpty());
}
Aggregations