public function test_should_import_numsplit_to_ib_works_fine()
{
$task = new \Myfox\App\Task\Import(-1, array('table' => 'numsplit_v2'));
$this->assertEquals(Task::IGNO, $task->execute());
self::cleanTable('default', 'route_info');
\Myfox\App\Model\Router::set('numsplit_v2', array(array('field' => array('thedate' => '2011-06-10', 'cid' => 1), 'count' => 1201), array('field' => array('thedate' => '2011-06-10', 'cid' => 2), 'count' => 998)));
$task = new \Myfox\App\Task\Import(10, array('table' => 'numsplit_v2', 'route' => 'cid=1,thedate=20110610', 'file' => realpath(__DIR__ . '/resource/numsplit_import_data_file.txt'), 'bucket' => 'numsplit_0.t_2_0', 'hosts' => '4,5', 'engine' => 'BRIGHTHOUSE'), '1,1,999999,-98');
$this->drop_test_table('ibtest_1', 'numsplit_0.t_2_0');
$this->drop_test_table('ibtest_2', 'numsplit_0.t_2_0');
$this->assertEquals(Task::WAIT, $task->execute());
$this->assertEquals(Task::SUCC, $task->wait());
$this->assertEquals('4,5', $task->result());
$ib1 = \Myfox\App\Model\Server::instance('ibtest_1')->getlink();
$ib2 = \Myfox\App\Model\Server::instance('ibtest_2')->getlink();
$this->assertContains('BRIGHTHOUSE', json_encode($ib1->getAll($ib1->query('SHOW CREATE TABLE numsplit_0.t_2_0'))));
$this->assertContains('BRIGHTHOUSE', json_encode($ib2->getAll($ib1->query('SHOW CREATE TABLE numsplit_0.t_2_0'))));
$this->assertEquals(10, $ib1->getOne($ib1->query('SELECT COUNT(*) FROM numsplit_0.t_2_0')));
$this->assertEquals(10, $ib2->getOne($ib2->query('SELECT COUNT(*) FROM numsplit_0.t_2_0')));
}
public function test_should_import_numsplit_works_fine()
{
$task = new \Myfox\App\Task\Import(-1, array('table' => 'numsplit'));
$this->assertEquals(Task::IGNO, $task->execute());
self::cleanTable('default', 'route_info');
\Myfox\App\Model\Router::set('numsplit', array(array('field' => array('thedate' => '2011-06-10', 'cid' => 1), 'count' => 1201), array('field' => array('thedate' => '2011-06-10', 'cid' => 2), 'count' => 998)));
$task = new \Myfox\App\Task\Import(10, array('table' => 'numsplit', 'route' => 'cid=1,thedate=20110610', 'file' => realpath(__DIR__ . '/resource/numsplit_import_data_file.txt'), 'bucket' => 'numsplit_0.t_2_0', 'hosts' => '3,1'), '1,1,999999,-98');
$this->assertEquals(Task::WAIT, $task->execute());
$this->assertEquals(Task::SUCC, $task->wait());
$this->assertEquals('3', $task->result());
}
