Added geo.php

[lhc/web/wiklou.git] / tests / SearchEngineTest.php

diff --git a/tests/SearchEngineTest.php b/tests/SearchEngineTest.php
index 3e04025..cc3df09 100644 (file)
--- a/tests/SearchEngineTest.php
+++ b/tests/SearchEngineTest.php
@@ -16,19 +16,47 @@ class SearchEngine_TestCase extends PHPUnit_TestCase {
        
        function insertSearchData() {
                $this->db->safeQuery( <<<END
-               INSERT INTO ! (cur_id,cur_namespace,cur_title,cur_text)
-               VALUES (1, 0, 'Main_Page', 'This is a main page'),
-                          (2, 1, 'Main_Page', 'This is a talk page to the main page, see [[smithee]]'),
-                          (3, 0, 'Smithee', 'A smithee is one who smiths. See also [[Alan Smithee]]'),
-                          (4, 1, 'Smithee', 'This article sucks.'),
-                          (5, 0, 'Unrelated_page', 'Nothing in this page is about the S word.'),
-                          (6, 0, 'Another_page', 'This page also is unrelated.'),
-                          (7, 4, 'Help', 'Help me!'),
-                          (8, 0, 'Thppt', 'Blah blah'),
-                          (9, 0, 'Alan_Smithee', 'yum'),
-                          (10, 0, 'Pages', 'are food')
+               INSERT INTO ! (page_id,page_namespace,page_title,page_latest)
+               VALUES (1, 0, 'Main_Page', 1),
+                          (2, 1, 'Main_Page', 2),
+                          (3, 0, 'Smithee', 3),
+                          (4, 1, 'Smithee', 4),
+                          (5, 0, 'Unrelated_page', 5),
+                          (6, 0, 'Another_page', 6),
+                          (7, 4, 'Help', 7),
+                          (8, 0, 'Thppt', 8),
+                          (9, 0, 'Alan_Smithee', 9),
+                          (10, 0, 'Pages', 10)
 END
-                       , $this->db->tableName( 'cur' ) );
+                       , $this->db->tableName( 'page' ) );
+               $this->db->safeQuery( <<<END
+               INSERT INTO ! (rev_id,rev_page)
+               VALUES (1, 1),
+                      (2, 2),
+                      (3, 3),
+                      (4, 4),
+                      (5, 5),
+                      (6, 6),
+                      (7, 7),
+                      (8, 8),
+                      (9, 9),
+                      (10, 10)
+END
+                       , $this->db->tableName( 'revision' ) );
+               $this->db->safeQuery( <<<END
+               INSERT INTO ! (old_id,old_text)
+               VALUES (1, 'This is a main page'),
+                          (2, 'This is a talk page to the main page, see [[smithee]]'),
+                          (3, 'A smithee is one who smiths. See also [[Alan Smithee]]'),
+                          (4, 'This article sucks.'),
+                          (5, 'Nothing in this page is about the S word.'),
+                          (6, 'This page also is unrelated.'),
+                          (7, 'Help me!'),
+                          (8, 'Blah blah'),
+                          (9, 'yum'),
+                          (10,'are food')
+END
+                       , $this->db->tableName( 'text' ) );
                $this->db->safeQuery( <<<END
                INSERT INTO ! (si_page,si_title,si_text)
                VALUES (1, 'main page', 'this is a main page'),
@@ -48,9 +76,13 @@ END
        function fetchIds( &$results ) {
                $matches = array();
                while( $row = $results->fetchObject() ) {
-                       $matches[] = IntVal( $row->cur_id );
+                       $matches[] = IntVal( $row->page_id );
                }
                $results->free();
+               # Search is not guaranteed to return results in a certain order;
+               # sort them numerically so we will compare simply that we received
+               # the expected matches.
+               sort( $matches );
                return $matches;
        }