public function testInstaller()
{
global $settings;
$cdc = new FlexCDC($settings);
$this->assertTrue($cdc->get_source() && $cdc->get_dest());
$conn = $cdc->get_source();
mysql_query('DROP DATABASE IF EXISTS test') or die(mysql_error() . "\n");
#keep moving up directories looking for the installer. error out when we can move no further up
while (1) {
$this->assertTrue(chdir('..'));
if (file_exists('./install.sql')) {
break;
}
}
$output = `test/sandbox/use -uroot -pmsandbox < install.sql`;
echo md5($output);
$this->assertTrue(md5($output) == "b83cfd9e5fd29f1c458f8d4070c86511");
$sql = "CREATE DATABASE IF NOT EXISTS test";
mysql_query($sql, $conn);
$sql = "CREATE TABLE test.t1 (c1 int primary key)";
mysql_query($sql, $conn);
$sql = "CALL flexviews.create_mvlog('test','t1')";
mysql_query($sql, $conn);
$sql = "INSERT INTO test.t1 values (1),(2),(3)";
mysql_query($sql, $conn);
$sql = "CREATE TABLE test.t2 (c1 int, c2 int, primary key(c2), key(c1))";
mysql_query($sql, $conn);
$sql = "CALL flexviews.create_mvlog('test','t2')";
mysql_query($sql, $conn);
$sql = "INSERT INTO test.t2 values (1,1),(2,2),(3,3),(1,4)";
mysql_query($sql, $conn);
#VERIFY THAT FLEXCDC IS WORKING - The consumer is going to run in the background
sleep(1);
$sql = "select count(*) from flexviews.test_t1";
$stmt = mysql_query($sql, $conn) or die(mysql_error() . "\n");
return $cdc;
}
