/** Verify that the filter allows events through if no properties are set. */
public void testUnspecifiedProperties() throws Exception {
ReplicateFilter rf = new ReplicateFilter();
rf.setTungstenSchema("tungsten_foo");
filterHelper.setFilter(rf);
verifyStmtAccept(filterHelper, 0, null, "insert into bar(val) values(1)");
filterHelper.done();
}
/** Verify that we allow operations on schemas including wildcard substitutions. */
public void testSchemasAccepted() throws ReplicatorException, InterruptedException {
// Configure the filter to allow databases including wild cards.
ReplicateFilter rf = new ReplicateFilter();
rf.setTungstenSchema("tungsten_foo");
rf.setDo("foo,ba?, foobar*");
filterHelper.setFilter(rf);
// Confirm that the following commands are accepted if the default
// database is foo.
verifyStmtAccept(filterHelper, 0, null, "create database foo");
verifyStmtAccept(filterHelper, 1, null, "drop database bar");
verifyStmtAccept(filterHelper, 2, null, "insert into foobar1.x1 values(1,2,3)");
verifyStmtAccept(filterHelper, 3, null, "update test_tab set age=32 where id=1");
// Just for calibration ensure we ignore a non-matching schema.
verifyStmtIgnore(filterHelper, 4, null, "insert into test.tab values(52,1)");
// All done.
filterHelper.done();
}
/** Verify that we always accept the Tungsten catalog even if it is explicitly ignored. */
public void testTungstenCatalogAccept() throws ReplicatorException, InterruptedException {
// Configure the filter to allow databases including wild cards.
ReplicateFilter rf = new ReplicateFilter();
rf.setTungstenSchema("tungsten_foo");
rf.setIgnore("tungsten_foo");
filterHelper.setFilter(rf);
// Confirm that the following commands are accepted.
verifyStmtAccept(
filterHelper, 0, "bar", "delete from tungsten_foo.trep_commit_seqno where task_id=9");
verifyRowAccept(
filterHelper,
1,
"tungsten_foo",
"trep_commit_seqno",
new String[] {"task_id"},
new Object[] {0});
// All done.
filterHelper.done();
}
/** Verify that we handle cases where a subset of databases and/or tables is ignored. */
public void testSchemasIgnoreSubset() throws ReplicatorException, InterruptedException {
// Configure the filter to allow databases including wild cards.
ReplicateFilter rf = new ReplicateFilter();
rf.setTungstenSchema("tungsten_foo");
rf.setDo("foobar?,bar*,foo");
rf.setIgnore("foo.test,foobar2,bar23*");
filterHelper.setFilter(rf);
// Confirm that the following commands are accepted if the default
// database is foo.
verifyStmtAccept(filterHelper, 0, null, "create database foobar1");
verifyStmtAccept(filterHelper, 1, "foo", "drop table foo.test2");
verifyStmtAccept(filterHelper, 2, "foo", "delete from bar2.test where id=2");
// Confirm that we ignore subset values.
verifyStmtIgnore(filterHelper, 3, "foo", "delete from foo.test where id=2");
verifyStmtIgnore(filterHelper, 4, "foo", "create table foobar2.foobar1 (id int)");
verifyStmtIgnore(filterHelper, 5, "foo", "drop database bar234");
// All done.
filterHelper.done();
}
/**
* Verify that we handle table acceptance including cases where the table names are wildcarded.
*/
public void testTableAccept() throws ReplicatorException, InterruptedException {
// Configure the filter to allow databases including wild cards.
ReplicateFilter rf = new ReplicateFilter();
rf.setTungstenSchema("tungsten_foo");
rf.setDo("foo.*,bar.test1,bar.wild*,bar.w?");
filterHelper.setFilter(rf);
// Confirm that the following commands are accepted.
verifyStmtAccept(filterHelper, 0, "bar", "insert into foo.test values(1)");
verifyStmtAccept(filterHelper, 1, "foo", "delete from test1 where id=1");
verifyStmtAccept(filterHelper, 2, "bar", "insert into wild1 values(1)");
verifyStmtAccept(filterHelper, 3, "bar", "update w2 set age=29");
// Confirm that the following are ignored, because they do not trigger
// acceptance.
verifyStmtIgnore(filterHelper, 4, null, "create database foo");
verifyStmtIgnore(filterHelper, 5, "bar", "insert into test2 values(1)");
verifyStmtIgnore(filterHelper, 6, "bar", "create table will1 (id int)");
verifyStmtIgnore(filterHelper, 7, "bar", "delete from w22");
// All done.
filterHelper.done();
}
/** Verify that we accept and ignore databases appropriately when using row updates. */
public void testRowHandling() throws ReplicatorException, InterruptedException {
// Configure the filter to allow databases including wild cards.
ReplicateFilter rf = new ReplicateFilter();
rf.setTungstenSchema("tungsten_foo");
rf.setDo("foobar?,bar*,foo");
rf.setIgnore("foo.test,foobar2,bar23*");
filterHelper.setFilter(rf);
// Verify accepted events.
String names[] = {"id"};
Long values[] = {new Long(99)};
verifyRowAccept(filterHelper, 0, "foobar1", "foobar2", names, values);
verifyRowAccept(filterHelper, 1, "bar2", "foo", names, values);
verifyRowAccept(filterHelper, 2, "foo", "test2", names, values);
// Verify ignored events.
verifyRowIgnore(filterHelper, 3, "foo", "test", names, values);
verifyRowIgnore(filterHelper, 4, "foobar2", "foobar1", names, values);
verifyRowIgnore(filterHelper, 5, "bar234", "foobar1", names, values);
// All done.
filterHelper.done();
}