Wikipedia:WikiProject Interlanguage Links/Scripts: Difference between revisions
Content deleted Content added
mNo edit summary |
mNo edit summary |
||
Line 3:
Extract interlanguage links into a single table for anaylysis
----
<pre>
CREATE TABLE inter (
from_lang varchar(10),
Line 11:
to_title varchar(255)
);
USE en;
Line 27 ⟶ 26:
WHERE page.page_id = langlinks.ll_from
AND page.page_namespace = 0;
... etc
</pre>
----
Tidy up this table and index it:
----
<pre>
update inter set from_title = replace( from_title, '_', ' ' );
update inter set to_title = replace( to_title, '_', ' ' );
Line 47 ⟶ 46:
ALTER TABLE inter ADD INDEX ( from_lang, from_title );
ALTER TABLE inter ADD INDEX ( to_lang, to_title );
</pre>
----
And extract suggested red links, ie:
----
<pre>
// a:x -> b:x and b:x exists and no link from b:? to a:x exists => b:x -> a:x
Line 70 ⟶ 69:
AND b.from_lang IS NULL;
</pre>
----
Finally, extract these suggestions in a human-reabale format
----
<pre>
DROP PROCEDURE IF EXISTS report_suggestions;
DELIMITER //
Line 114:
call report_suggestions( 10, 'en', 'sv' );
</pre>
| |||