https://bugzilla.wikimedia.org/show_bug.cgi?id=59396

       Web browser: ---
            Bug ID: 59396
           Summary: DBQ-139 Create interlanguage links for entire
                    Wikipedia
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Database Queries
          Assignee: wmf.bugconver...@gmail.com
          Reporter: wmf.bugconver...@gmail.com
    Classification: Unclassified
   Mobile Platform: ---

This issue was converted from https://jira.toolserver.org/browse/DBQ-139.
Summary: Create interlanguage links for entire Wikipedia
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <h...@online.de>

-------------------------------------------------------------------------------
From: Thomasmp  <tm.petz...@gmail.com>
Date: Tue, 03 May 2011 13:34:24
-------------------------------------------------------------------------------

Please repeat query #DBQ122 (Create interlanguage links for entire Wikipedia)
with the latest available data. Many thanks! Thomas

Code used in #DBQ122 for running at SGE

    #! /bin/bash
    #$ -N DBQ-122
    #$ -hard
    #$ -l sqlprocs-s1=1
    #$ -l sqlprocs-s2=1
    #$ -l sqlprocs-s3=1
    wikilist=`mysql -wBN -hsql-toolserver toolserver -e "SELECT
GROUP_CONCAT(REPLACE(dbname,'wiki_p','') SEPARATOR ' ') FROM wiki WHERE
family='wikipedia' AND is_closed=0 AND is_meta=0 ORDER BY dbname"`
    SQL="SELECT ss_good_articles FROM site_stats INTO @articles;
         SELECT CONCAT('%WIKI%,', ll_lang, ',', count(*),',',@articles) AS csv
FROM langlinks GROUP BY ll_lang ORDER BY ll_lang";
    echo "wiki,interwiki,interwiki_count,article_count" > DBQ-122.txt
    for runwiki in $wikilist
    do
      echo "querying $runwiki"
      runwiki2=`echo "$runwiki" | sed "s/_/-/g"`
      SQL2=`echo "$SQL" | sed "s/%WIKI%/$runwiki2/g"`
      mysql -wBN -h${runwiki2}wiki-p.rrdb ${runwiki}wiki_p -e "$SQL2" >>
DBQ-122.txt
    done

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to