]> git.openstreetmap.org Git - nominatim.git/blob - lib-php/tokenizer/legacy_icu_tokenizer.php
adapt special terms lookup to new word table
[nominatim.git] / lib-php / tokenizer / legacy_icu_tokenizer.php
1 <?php
2
3 namespace Nominatim;
4
5 class Tokenizer
6 {
7     private $oDB;
8
9     private $oNormalizer;
10     private $oTransliterator;
11     private $aCountryRestriction;
12
13     public function __construct(&$oDB)
14     {
15         $this->oDB =& $oDB;
16         $this->oNormalizer = \Transliterator::createFromRules(CONST_Term_Normalization_Rules);
17         $this->oTransliterator = \Transliterator::createFromRules(CONST_Transliteration);
18     }
19
20     public function checkStatus()
21     {
22         $sSQL = "SELECT word_id FROM word WHERE word_token == 'a'";
23         $iWordID = $this->oDB->getOne($sSQL);
24         if ($iWordID === false) {
25             throw new Exception('Query failed', 703);
26         }
27         if (!$iWordID) {
28             throw new Exception('No value', 704);
29         }
30     }
31
32
33     public function setCountryRestriction($aCountries)
34     {
35         $this->aCountryRestriction = $aCountries;
36     }
37
38
39     public function normalizeString($sTerm)
40     {
41         if ($this->oNormalizer === null) {
42             return $sTerm;
43         }
44
45         return $this->oNormalizer->transliterate($sTerm);
46     }
47
48     private function makeStandardWord($sTerm)
49     {
50         return trim($this->oTransliterator->transliterate(' '.$sTerm.' '));
51     }
52
53
54     public function tokensForSpecialTerm($sTerm)
55     {
56         $aResults = array();
57
58         $sSQL = "SELECT word_id, info->>'class' as class, info->>'type' as type ";
59         $sSQL .= '   FROM word WHERE word_token = :term and type = \'S\'';
60
61         Debug::printVar('Term', $sTerm);
62         Debug::printSQL($sSQL);
63         $aSearchWords = $this->oDB->getAll($sSQL, array(':term' => $this->makeStandardWord($sTerm)));
64
65         Debug::printVar('Results', $aSearchWords);
66
67         foreach ($aSearchWords as $aSearchTerm) {
68             $aResults[] = new \Nominatim\Token\SpecialTerm(
69                 $aSearchTerm['word_id'],
70                 $aSearchTerm['class'],
71                 $aSearchTerm['type'],
72                 \Nominatim\Operator::TYPE
73             );
74         }
75
76         Debug::printVar('Special term tokens', $aResults);
77
78         return $aResults;
79     }
80
81
82     public function extractTokensFromPhrases(&$aPhrases)
83     {
84         $sNormQuery = '';
85         $aWordLists = array();
86         $aTokens = array();
87         foreach ($aPhrases as $iPhrase => $oPhrase) {
88             $sNormQuery .= ','.$this->normalizeString($oPhrase->getPhrase());
89             $sPhrase = $this->makeStandardWord($oPhrase->getPhrase());
90             Debug::printVar('Phrase', $sPhrase);
91             if (strlen($sPhrase) > 0) {
92                 $aWords = explode(' ', $sPhrase);
93                 Tokenizer::addTokens($aTokens, $aWords);
94                 $aWordLists[] = $aWords;
95             } else {
96                 $aWordLists[] = array();
97             }
98         }
99
100         Debug::printVar('Tokens', $aTokens);
101         Debug::printVar('WordLists', $aWordLists);
102
103         $oValidTokens = $this->computeValidTokens($aTokens, $sNormQuery);
104
105         foreach ($aPhrases as $iPhrase => $oPhrase) {
106             $oPhrase->computeWordSets($aWordLists[$iPhrase], $oValidTokens);
107         }
108
109         return $oValidTokens;
110     }
111
112
113     private function computeValidTokens($aTokens, $sNormQuery)
114     {
115         $oValidTokens = new TokenList();
116
117         if (!empty($aTokens)) {
118             $this->addTokensFromDB($oValidTokens, $aTokens, $sNormQuery);
119
120             // Try more interpretations for Tokens that could not be matched.
121             foreach ($aTokens as $sToken) {
122                 if ($sToken[0] != ' ' && !$oValidTokens->contains($sToken)) {
123                     if (preg_match('/^([0-9]{5}) [0-9]{4}$/', $sToken, $aData)) {
124                         // US ZIP+4 codes - merge in the 5-digit ZIP code
125                         $oValidTokens->addToken(
126                             $sToken,
127                             new Token\Postcode(null, $aData[1], 'us')
128                         );
129                     } elseif (preg_match('/^[0-9]+$/', $sToken)) {
130                         // Unknown single word token with a number.
131                         // Assume it is a house number.
132                         $oValidTokens->addToken(
133                             $sToken,
134                             new Token\HouseNumber(null, trim($sToken))
135                         );
136                     }
137                 }
138             }
139         }
140
141         return $oValidTokens;
142     }
143
144
145     private function addTokensFromDB(&$oValidTokens, $aTokens, $sNormQuery)
146     {
147         // Check which tokens we have, get the ID numbers
148         $sSQL = 'SELECT word_id, word_token, type';
149         $sSQL .= "      info->>'cc' as country, info->>'postcode' as postcode,";
150         $sSQL .= "      info->>'op' as operator,";
151         $sSQL .= "      info->>'class' as class, info->>'type' as type,";
152         $sSQL .= "      info->>'count' as count";
153         $sSQL .= ' FROM word WHERE word_token in (';
154         $sSQL .= join(',', $this->oDB->getDBQuotedList($aTokens)).')';
155
156         Debug::printSQL($sSQL);
157
158         $aDBWords = $this->oDB->getAll($sSQL, null, 'Could not get word tokens.');
159
160         foreach ($aDBWords as $aWord) {
161             $iId = (int) $aWord['word_id'];
162
163             switch ($aWord['type']) {
164                 'C':  // country name tokens
165                     if ($aWord['country'] === null
166                         || ($this->aCountryRestriction
167                             && !in_array($aWord['country'], $this->aCountryRestriction))
168                     ) {
169                         continue;
170                     }
171                     $oToken = new Token\Country($iId, $aWord['country'])
172                     break;
173                 'H':  // house number tokens
174                     $oToken = new Token\HouseNumber($iId, $aWord['word_token']);
175                     break;
176                 'P':  // postcode tokens
177                     // Postcodes are not normalized, so they may have content
178                     // that makes SQL injection possible. Reject postcodes
179                     // that would need special escaping.
180                     if ($aWord['postcode'] === null
181                         || pg_escape_string($aWord['postcode']) == $aWord['postcode']
182                     ) {
183                        continue;
184                     }
185                     $sNormPostcode = $this->normalizeString($aWord['postcode']);
186                     if (strpos($sNormQuery, $sNormPostcode) === false) {
187                         continue;
188                     }
189                     $oToken = new Token\Postcode($iId, $aWord['postcode'], null);
190                     break;
191                 'S':  // tokens for classification terms (special phrases)
192                     if ($aWord['class'] === null || $aWord['type'] === null
193                     ) {
194                         continue;
195                     }
196                     $oToken = new Token\SpecialTerm(
197                         $iId,
198                         $aWord['class'],
199                         $aWord['type'],
200                         $aWord['op'] ? Operator::NEAR : Operator::NONE
201                     );
202                     break;
203                 'W': // full-word tokens
204                     $oToken = new Token\Word(
205                         $iId,
206                         (int) $aWord['count'],
207                         substr_count($aWord['word_token'], ' ')
208                     );
209                     break;
210                 'w':  // partial word terms
211                     $oToken = new Token\Partial(
212                         $iId,
213                         $aWord['word_token'],
214                         (int) $aWord['count']
215                     );
216                     break;
217                 default:
218                     continue;
219             }
220
221             $oValidTokens->addToken($aWord['word_token'], $oToken);
222         }
223     }
224
225
226     /**
227      * Add the tokens from this phrase to the given list of tokens.
228      *
229      * @param string[] $aTokens List of tokens to append.
230      *
231      * @return void
232      */
233     private static function addTokens(&$aTokens, $aWords)
234     {
235         $iNumWords = count($aWords);
236
237         for ($i = 0; $i < $iNumWords; $i++) {
238             $sPhrase = $aWords[$i];
239             $aTokens[$sPhrase] = $sPhrase;
240
241             for ($j = $i + 1; $j < $iNumWords; $j++) {
242                 $sPhrase .= ' '.$aWords[$j];
243                 $aTokens[$sPhrase] = $sPhrase;
244             }
245         }
246     }
247 }