public function test_search()
{
// prepare some data
$this->loadSchemaJSON('pageschema');
$this->saveData('syntax', 'pageschema', array('singlepage' => 'wiki:dokuwiki', 'multipage' => array('wiki:dokuwiki', 'wiki:syntax', 'wiki:welcome'), 'singletitle' => 'wiki:dokuwiki', 'multititle' => array('wiki:dokuwiki', 'wiki:syntax', 'wiki:welcome')));
// make sure titles for some pages are known (not for wiki:welcome)
$title = new Title('wiki:dokuwiki');
$title->setTitle('DokuWiki Overview');
$title = new Title('wiki:syntax');
$title->setTitle('DokuWiki Foobar Syntax');
// search
$search = new Search();
$search->addSchema('pageschema');
$search->addColumn('singlepage');
$search->addColumn('multipage');
$search->addColumn('singletitle');
$search->addColumn('multititle');
/** @var Value[][] $result */
$result = $search->execute();
// no titles:
$this->assertEquals('wiki:dokuwiki', $result[0][0]->getValue());
$this->assertEquals(array('wiki:dokuwiki', 'wiki:syntax', 'wiki:welcome'), $result[0][1]->getValue());
// titles as JSON:
$this->assertEquals('["wiki:dokuwiki","DokuWiki Overview"]', $result[0][2]->getValue());
$this->assertEquals(array('["wiki:dokuwiki","DokuWiki Overview"]', '["wiki:syntax","DokuWiki Foobar Syntax"]', '["wiki:welcome",null]'), $result[0][3]->getValue());
// search single with title
$single = clone $search;
$single->addFilter('singletitle', 'Overview', '*~', 'AND');
$result = $single->execute();
$this->assertTrue(is_array($result));
$this->assertEquals(1, count($result));
// search multi with title
$multi = clone $search;
$multi->addFilter('multititle', 'Foobar', '*~', 'AND');
$result = $multi->execute();
$this->assertTrue(is_array($result));
$this->assertEquals(1, count($result));
// search single with page
$single = clone $search;
$single->addFilter('singletitle', 'wiki:dokuwiki', '*~', 'AND');
$result = $single->execute();
$this->assertTrue(is_array($result));
$this->assertEquals(1, count($result));
// search multi with page
$multi = clone $search;
$multi->addFilter('multititle', 'welcome', '*~', 'AND');
$result = $multi->execute();
$this->assertTrue(is_array($result));
$this->assertEquals(1, count($result));
}
public function test_ranges()
{
$search = new mock\Search();
$search->addSchema('schema2');
$search->addColumn('%pageid%');
$search->addColumn('afirst');
$search->addColumn('asecond');
$search->addFilter('%pageid%', '%ag%', '~', 'AND');
$search->addSort('%pageid%', false);
/** @var meta\Value[][] $result */
$result = $search->execute();
$count = $search->getCount();
// check result dimensions
$this->assertEquals(12, $count, 'result count');
$this->assertEquals(12, count($result), 'result rows');
$this->assertEquals(3, count($result[0]), 'result columns');
// check sorting
$this->assertEquals('page20', $result[0][0]->getValue());
$this->assertEquals('page19', $result[1][0]->getValue());
$this->assertEquals('page18', $result[2][0]->getValue());
// now add limit
$search->setLimit(5);
$result = $search->execute();
$count = $search->getCount();
// check result dimensions
$this->assertEquals(12, $count, 'result count');
// full result set
$this->assertEquals(5, count($result), 'result rows');
// wanted result set
// check the values
$this->assertEquals('page20', $result[0][0]->getValue());
$this->assertEquals('page16', $result[4][0]->getValue());
// now add offset
$search->setOffset(5);
$result = $search->execute();
$count = $search->getCount();
// check result dimensions
$this->assertEquals(12, $count, 'result count');
// full result set
$this->assertEquals(5, count($result), 'result rows');
// wanted result set
// check the values
$this->assertEquals('page15', $result[0][0]->getValue());
$this->assertEquals('page11', $result[4][0]->getValue());
}
public function test_filter()
{
$this->loadSchemaJSON('decimal');
$this->waitForTick();
$this->saveData('page1', 'decimal', array('field' => '5000'));
$this->saveData('page2', 'decimal', array('field' => '5000.001'));
$this->saveData('page3', 'decimal', array('field' => '900.5'));
$this->saveData('page4', 'decimal', array('field' => '1.5'));
$search = new Search();
$search->addSchema('decimal');
$search->addColumn('%pageid%');
$search->addColumn('field');
$search->addFilter('field', '800', '>', 'AND');
$search->addSort('field', true);
/** @var Value[][] $result */
$result = $search->execute();
$this->assertEquals(3, count($result));
$this->assertEquals('page3', $result[0][0]->getValue());
$this->assertEquals('page1', $result[1][0]->getValue());
$this->assertEquals('page2', $result[2][0]->getValue());
}
