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_wildcard() { $search = new mock\Search(); $search->addSchema('schema2', 'alias'); $search->addColumn('*'); $this->assertEquals(4, count($search->getColumns())); $search = new mock\Search(); $search->addSchema('schema2', 'alias'); $search->addColumn('schema2.*'); $this->assertEquals(4, count($search->getColumns())); $search = new mock\Search(); $search->addSchema('schema2', 'alias'); $search->addColumn('alias.*'); $this->assertEquals(4, count($search->getColumns())); $search = new mock\Search(); $search->addSchema('schema2', 'alias'); $search->addColumn('nope.*'); $this->assertEquals(0, count($search->getColumns())); }
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()); }