Index: trunk/extensions/Wikidata/WiktionaryZ/WiktionaryZRecordSets.php |
— | — | @@ -58,23 +58,215 @@ |
59 | 59 | for ($i = 0; $i < $recordSet->getRecordCount(); $i++) { |
60 | 60 | $record = $recordSet->getRecord($i); |
61 | 61 | |
62 | | - foreach($idAttributes as $idAttribute) { |
63 | | - $id = $record->getAttributeValue($idAttribute); |
64 | | - |
65 | | - if (!in_array($id, $ids)) |
66 | | - $ids[] = $id; |
67 | | - } |
| 62 | + foreach($idAttributes as $idAttribute) |
| 63 | + $ids[] = $record->getAttributeValue($idAttribute); |
68 | 64 | } |
69 | 65 | |
70 | | - return $ids; |
| 66 | + return array_unique($ids); |
71 | 67 | } |
72 | 68 | |
| 69 | +// $sql = |
| 70 | +// "SELECT " . |
| 71 | +// " uw_defined_meaning.defined_meaning_id, " . |
| 72 | +// " COALESCE(defining_expression.spelling, user_expression.spelling, english_expression.spelling, any_expression.spelling) AS label, " . |
| 73 | +// " defining_expression.spelling AS defining_spelling," . |
| 74 | +// " user_expression.spelling AS user_spelling," . |
| 75 | +// " english_expression.spelling AS english_spelling, " . |
| 76 | +// " any_expression.spelling AS any_spelling " . |
| 77 | +// " FROM uw_defined_meaning " . |
| 78 | +// getDefiningJoinSQLForLanguage('defining', $userLanguage) . |
| 79 | +// getSynonymJoinSQLForLanguage('user', $userLanguage) . |
| 80 | +// getSynonymJoinSQLForLanguage('english', 85) . |
| 81 | +// getSynonymJoinSQLForAnyLanguage('any') . |
| 82 | +// " WHERE uw_defined_meaning.defined_meaning_id IN (" . implode(", ", $definedMeaningIds) . ")" . |
| 83 | +// " AND " . getLatestTransactionRestriction('uw_defined_meaning') . |
| 84 | +// " GROUP BY defined_meaning_id"; |
| 85 | +// |
| 86 | +// echo $sql . "\n\n"; |
| 87 | +// $dbr =& wfGetDB(DB_SLAVE); |
| 88 | +// $dbr->query( |
| 89 | +// $sql |
| 90 | +// ); |
| 91 | + |
| 92 | +//function getSynonymJoinSQLForLanguage($alias, $languageId) { |
| 93 | +// return |
| 94 | +// " JOIN (uw_syntrans AS ". $alias . "_syntrans, uw_expression_ns AS ". $alias . "_expression) ON " . |
| 95 | +// " (uw_defined_meaning.defined_meaning_id=". $alias . "_syntrans.defined_meaning_id AND ". $alias . "_syntrans.identical_meaning=1 AND " . getLatestTransactionRestriction($alias . '_syntrans') . |
| 96 | +// " AND ". $alias . "_expression.expression_id=". $alias . "_syntrans.expression_id AND ". $alias . "_expression.language_id=" . $languageId . " AND " . getLatestTransactionRestriction($alias . '_expression') . ")"; |
| 97 | +//} |
| 98 | +// |
| 99 | +//function getSynonymJoinSQLForAnyLanguage($alias) { |
| 100 | +// return |
| 101 | +// " JOIN (uw_syntrans AS ". $alias . "_syntrans, uw_expression_ns AS ". $alias . "_expression) ON " . |
| 102 | +// " (uw_defined_meaning.defined_meaning_id=". $alias . "_syntrans.defined_meaning_id AND ". $alias . "_syntrans.identical_meaning=1 AND " . getLatestTransactionRestriction($alias . '_syntrans') . |
| 103 | +// " AND ". $alias . "_expression.expression_id=". $alias . "_syntrans.expression_id AND " . getLatestTransactionRestriction($alias . '_expression') . ")"; |
| 104 | +//} |
| 105 | + |
| 106 | +function getSynonymJoinSQLForLanguage($alias, $languageId) { |
| 107 | + return |
| 108 | + " JOIN (SELECT spelling FROM uw_expression_ns, uw_syntrans WHERE uw_expression_ns.expression_id=uw_syntrans.expression_id" . |
| 109 | + " AND " . getLatestTransactionRestriction('uw_syntrans') . |
| 110 | + " AND " . getLatestTransactionRestriction('uw_expression_ns') . |
| 111 | + " AND uw_expression.ns.language_id=" . $languageId . |
| 112 | + " AND uw_defined_meaning.defined_meaning_id=uw_syntrans.defined_meaning_id " . |
| 113 | + " AND uw_syntrans.identical_meaning=1 " . |
| 114 | + " LIMIT 1) "; |
| 115 | +} |
| 116 | + |
| 117 | +function getSynonymJoinSQLForAnyLanguage($alias) { |
| 118 | + return |
| 119 | + " JOIN (SELECT spelling FROM uw_expression_ns, uw_syntrans WHERE uw_expression_ns.expression_id=uw_syntrans.expression_id" . |
| 120 | + " AND " . getLatestTransactionRestriction('uw_syntrans') . |
| 121 | + " AND " . getLatestTransactionRestriction('uw_expression_ns') . |
| 122 | + " AND uw_defined_meaning.defined_meaning_id=uw_syntrans.defined_meaning_id " . |
| 123 | + " AND uw_syntrans.identical_meaning=1 " . |
| 124 | + " LIMIT 1) "; |
| 125 | +} |
| 126 | + |
| 127 | +function getDefiningJoinSQLForLanguage($alias, $languageId) { |
| 128 | + return |
| 129 | + " JOIN (uw_syntrans AS ". $alias . "_syntrans, uw_expression_ns AS ". $alias . "_expression) ON " . |
| 130 | + " (uw_defined_meaning.defined_meaning_id=". $alias . "_syntrans.defined_meaning_id AND ". $alias . "_syntrans.identical_meaning=1 AND " . getLatestTransactionRestriction($alias . '_syntrans') . |
| 131 | + " AND ". $alias . "_expression.expression_id=". $alias . "_syntrans.expression_id AND ". $alias . "_expression.language_id=" . $languageId . " AND " . getLatestTransactionRestriction($alias . '_expression') . "" . |
| 132 | + " AND uw_defined_meaning.expression_id=". $alias . "_syntrans.expression_id)"; |
| 133 | +} |
| 134 | + |
| 135 | +function fetchDefinedMeaningReferenceRecords($sql, &$definedMeaningIds, &$definedMeaningReferenceRecords) { |
| 136 | + global |
| 137 | + $definedMeaningReferenceStructure, $definedMeaningIdAttribute, $definedMeaningLabelAttribute, |
| 138 | + $definedMeaningDefiningExpressionAttribute; |
| 139 | + |
| 140 | + $foundDefinedMeaningIds = array(); |
| 141 | + |
| 142 | + $dbr =& wfGetDB(DB_SLAVE); |
| 143 | + $queryResult = $dbr->query($sql); |
| 144 | + |
| 145 | + while ($row = $dbr->fetchObject($queryResult)) { |
| 146 | + $definedMeaningId = $row->defined_meaning_id; |
| 147 | + |
| 148 | + $record = new ArrayRecord($definedMeaningReferenceStructure); |
| 149 | + $record->setAttributeValue($definedMeaningIdAttribute, $definedMeaningId); |
| 150 | + $record->setAttributeValue($definedMeaningLabelAttribute, $row->label); |
| 151 | + $record->setAttributeValue($definedMeaningDefiningExpressionAttribute, $row->label); |
| 152 | + |
| 153 | + $definedMeaningReferenceRecords[$definedMeaningId] = $record; |
| 154 | + $foundDefinedMeaningIds[] = $definedMeaningId; |
| 155 | + } |
| 156 | + |
| 157 | + $definedMeaningIds = array_diff($definedMeaningIds, $foundDefinedMeaningIds); |
| 158 | +} |
| 159 | + |
| 160 | +function fetchDefinedMeaningDefiningExpressions(&$definedMeaningIds, &$definedMeaningReferenceRecords) { |
| 161 | + global |
| 162 | + $definedMeaningReferenceStructure, $definedMeaningIdAttribute, $definedMeaningLabelAttribute, |
| 163 | + $definedMeaningDefiningExpressionAttribute; |
| 164 | + |
| 165 | + $dbr =& wfGetDB(DB_SLAVE); |
| 166 | + $queryResult = $dbr->query( |
| 167 | + "SELECT uw_defined_meaning.defined_meaning_id AS defined_meaning_id, uw_expression_ns.spelling" . |
| 168 | + " FROM uw_defined_meaning, uw_expression_ns " . |
| 169 | + " WHERE uw_defined_meaning.expression_id=uw_expression_ns.expression_id " . |
| 170 | + " AND " . getLatestTransactionRestriction('uw_defined_meaning') . |
| 171 | + " AND " . getLatestTransactionRestriction('uw_expression_ns') . |
| 172 | + " AND uw_defined_meaning.defined_meaning_id IN (". implode(", ", $definedMeaningIds) .")" |
| 173 | + ); |
| 174 | + |
| 175 | + while ($row = $dbr->fetchObject($queryResult)) { |
| 176 | + $definedMeaningReferenceRecord = $definedMeaningReferenceRecords[$row->defined_meaning_id]; |
| 177 | + |
| 178 | + if ($definedMeaningReferenceRecord == null) { |
| 179 | + $definedMeaningReferenceRecord = new ArrayRecord($definedMeaningReferenceStructure); |
| 180 | + $definedMeaningReferenceRecord->setAttributeValue($definedMeaningIdAttribute, $row->defined_meaning_id); |
| 181 | + $definedMeaningReferenceRecord->setAttributeValue($definedMeaningLabelAttribute, $row->spelling); |
| 182 | + $definedMeaningReferenceRecords[$row->defined_meaning_id] = $definedMeaningReferenceRecord; |
| 183 | + } |
| 184 | + |
| 185 | + $definedMeaningReferenceRecord->setAttributeValue($definedMeaningDefiningExpressionAttribute, $row->spelling); |
| 186 | + } |
| 187 | +} |
| 188 | + |
| 189 | +function getNullDefinedMeaningReferenceRecord() { |
| 190 | + global |
| 191 | + $definedMeaningReferenceStructure, $definedMeaningIdAttribute, $definedMeaningLabelAttribute, |
| 192 | + $definedMeaningDefiningExpressionAttribute; |
| 193 | + |
| 194 | + $record = new ArrayRecord($definedMeaningReferenceStructure); |
| 195 | + $record->setAttributeValue($definedMeaningIdAttribute, 0); |
| 196 | + $record->setAttributeValue($definedMeaningLabelAttribute, ""); |
| 197 | + $record->setAttributeValue($definedMeaningDefiningExpressionAttribute, ""); |
| 198 | + |
| 199 | + return $record; |
| 200 | +} |
| 201 | + |
73 | 202 | function getDefinedMeaningReferenceRecords($definedMeaningIds) { |
| 203 | + global |
| 204 | + $wgUser; |
| 205 | + |
| 206 | + $startTime = microtime(true); |
| 207 | + |
74 | 208 | $result = array(); |
| 209 | + $definedMeaningIdsForExpressions = $definedMeaningIds; |
| 210 | + |
| 211 | + if (count($definedMeaningIds) > 0) { |
| 212 | + $userLanguage = getLanguageIdForCode($wgUser->getOption('language')); |
| 213 | + |
| 214 | + fetchDefinedMeaningReferenceRecords( |
| 215 | + "SELECT uw_defined_meaning.defined_meaning_id AS defined_meaning_id, any_expression.spelling AS label " . |
| 216 | + "FROM uw_defined_meaning" . |
| 217 | + getDefiningJoinSQLForLanguage('any', $userLanguage) . |
| 218 | + " WHERE uw_defined_meaning.defined_meaning_id IN (" . implode(", ", $definedMeaningIds) . ")" . |
| 219 | + " GROUP BY uw_defined_meaning.defined_meaning_id", |
| 220 | + |
| 221 | + $definedMeaningIds, |
| 222 | + $result |
| 223 | + ); |
75 | 224 | |
76 | | - foreach($definedMeaningIds as $definedMeaningId) |
77 | | - $result[$definedMeaningId] = getDefinedMeaningReferenceRecord($definedMeaningId); |
| 225 | + if (count($definedMeaningIds) > 0) { |
| 226 | + fetchDefinedMeaningReferenceRecords( |
| 227 | + "SELECT uw_defined_meaning.defined_meaning_id AS defined_meaning_id, spelling AS label " . |
| 228 | + "FROM uw_defined_meaning" . |
| 229 | + getSynonymJoinSQLForLanguage('any', $userLanguage) . |
| 230 | + " WHERE uw_defined_meaning.defined_meaning_id IN (" . implode(", ", $definedMeaningIds) . ")",// . |
| 231 | +// " GROUP BY uw_defined_meaning.defined_meaning_id", |
| 232 | + |
| 233 | + $definedMeaningIds, |
| 234 | + $result |
| 235 | + ); |
| 236 | + |
| 237 | + if (count($definedMeaningIds) > 0) { |
| 238 | + fetchDefinedMeaningReferenceRecords( |
| 239 | + "SELECT uw_defined_meaning.defined_meaning_id AS defined_meaning_id, spelling AS label " . |
| 240 | + "FROM uw_defined_meaning" . |
| 241 | + getSynonymJoinSQLForLanguage('any', 85) . |
| 242 | + " WHERE uw_defined_meaning.defined_meaning_id IN (" . implode(", ", $definedMeaningIds) . ")",// . |
| 243 | +// " GROUP BY uw_defined_meaning.defined_meaning_id", |
| 244 | + |
| 245 | + $definedMeaningIds, |
| 246 | + $result |
| 247 | + ); |
78 | 248 | |
| 249 | + if (count($definedMeaningIds) > 0) { |
| 250 | + fetchDefinedMeaningReferenceRecords( |
| 251 | + "SELECT uw_defined_meaning.defined_meaning_id AS defined_meaning_id, spelling AS label " . |
| 252 | + "FROM uw_defined_meaning" . |
| 253 | + getSynonymJoinSQLForAnyLanguage('any') . |
| 254 | + " WHERE uw_defined_meaning.defined_meaning_id IN (" . implode(", ", $definedMeaningIds) . ")",// . |
| 255 | +// " GROUP BY uw_defined_meaning.defined_meaning_id", |
| 256 | + |
| 257 | + $definedMeaningIds, |
| 258 | + $result |
| 259 | + ); |
| 260 | + } |
| 261 | + } |
| 262 | + } |
| 263 | + |
| 264 | + fetchDefinedMeaningDefiningExpressions($definedMeaningIdsForExpressions, $result); |
| 265 | + $result[0] = getNullDefinedMeaningReferenceRecord(); |
| 266 | + } |
| 267 | + |
| 268 | + $queriesTime = microtime(true) - $startTime; |
| 269 | + echo "<!-- Defined meaning reference queries: " . $queriesTime . " -->\n"; |
| 270 | + |
79 | 271 | return $result; |
80 | 272 | } |
81 | 273 | |
— | — | @@ -110,10 +302,13 @@ |
111 | 303 | |
112 | 304 | if (count($expressionIds) > 0) { |
113 | 305 | $dbr =& wfGetDB(DB_SLAVE); |
114 | | - $queryResult = $dbr->query("SELECT expression_id, language_id, spelling" . |
115 | | - " FROM uw_expression_ns" . |
116 | | - " WHERE expression_id IN (". implode(', ', $expressionIds) .")" . |
117 | | - " AND ". getLatestTransactionRestriction('uw_expression_ns')); |
| 306 | + $queryResult = $dbr->query( |
| 307 | + "SELECT expression_id, language_id, spelling" . |
| 308 | + " FROM uw_expression_ns" . |
| 309 | + " WHERE expression_id IN (". implode(', ', $expressionIds) .")" . |
| 310 | + " AND ". getLatestTransactionRestriction('uw_expression_ns') |
| 311 | + ); |
| 312 | + |
118 | 313 | $result = array(); |
119 | 314 | |
120 | 315 | while ($row = $dbr->fetchObject($queryResult)) { |
— | — | @@ -147,9 +342,12 @@ |
148 | 343 | function getTextReferences($textIds) { |
149 | 344 | if (count($textIds) > 0) { |
150 | 345 | $dbr =& wfGetDB(DB_SLAVE); |
151 | | - $queryResult = $dbr->query("SELECT old_id, old_text" . |
152 | | - " FROM text" . |
153 | | - " WHERE old_id IN (". implode(', ', $textIds) .")"); |
| 346 | + $queryResult = $dbr->query( |
| 347 | + "SELECT old_id, old_text" . |
| 348 | + " FROM text" . |
| 349 | + " WHERE old_id IN (". implode(', ', $textIds) .")" |
| 350 | + ); |
| 351 | + |
154 | 352 | $result = array(); |
155 | 353 | |
156 | 354 | while ($row = $dbr->fetchObject($queryResult)) |
— | — | @@ -354,6 +552,7 @@ |
355 | 553 | global |
356 | 554 | $meaningRelationsTable, $relationIdAttribute, $relationTypeAttribute, $otherDefinedMeaningAttribute; |
357 | 555 | |
| 556 | +// $startTime = microtime(true); |
358 | 557 | $recordSet = queryRecordSet( |
359 | 558 | $queryTransactionInformation, |
360 | 559 | $relationIdAttribute, |
— | — | @@ -367,6 +566,8 @@ |
368 | 567 | array('relationtype_mid') |
369 | 568 | ); |
370 | 569 | |
| 570 | +// echo "<!--" . (microtime(true) - $startTime). " -->"; |
| 571 | + |
371 | 572 | expandDefinedMeaningReferencesInRecordSet($recordSet, array($relationTypeAttribute, $otherDefinedMeaningAttribute)); |
372 | 573 | |
373 | 574 | return $recordSet; |