You are browsing a read-only backup copy of Wikitech. The live site can be found at


From Wikitech-static
Revision as of 14:42, 18 February 2022 by imported>JackPotte (→‎MySQL)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

{{#babel:fr|en-4|de-2|es-2|pt-1|it-1|ru-1|ar-1|hi-1|zh-1|ja-1|la-1|el-1|vi-0|id-0|ko-0|nl-0}} User UTC + 1 (Paris, France)

Own tools

Hosted tools

Other tools


Connect to the wikis replicas

$ mysql -h enwiki.labsdb
MariaDB [(none)]> connect enwiki_p
$ mysql --defaults-file=~/ -h enwiktionary.labsdb enwiktionary_p
MariaDB [(none)]> connect enwiktionary_p
$ mysql -h frwiktionary.labsdb
connect frwiktionary_p

Create one's own database

mysql --defaults-file=replica.cnf -h tools-db
create database p48358730291690573246813765835736425432__mycooldb;


Executable on

See also

Page content by title

SELECT CAST(pp_page AS CHAR(1000000) CHARACTER SET utf8) FROM page JOIN page_props ON page_id = pp_page WHERE page_namespace = 0 and page_title = 'jackpot';

Page name by content

USE frwiki_p;
SELECT p.page_title
FROM page p
JOIN page_props pp ON p.page_id = pp.pp_page
WHERE p.page_namespace = 0 AND pp.pp_page REGEXP '\n *titre *='

Pages modified by

SELECT page_title FROM pp_value JOIN page ON page_id = pp_page WHERE pp_value = 'JackPotte';

Edit count

select user_editcount from user where user_name='JackPotte';

Created pages

SELECT DISTINCT page_title FROM page JOIN revision ON page_id=rev_page WHERE rev_user_text='JackPotte' and page_namespace=0 AND page_is_redirect=0;

Hidden editions

SELECT DISTINCT page_title FROM page JOIN revision ON page_id=rev_page WHERE rev_user_text='JackPotte' and page_namespace=0 AND page_is_redirect=0 and rev_deleted=1;

Count the number of editions on a day

SELECT COUNT(*) FROM revision where rev_timestamp like '20150531%';


local-jackbot@tools-login:~$ crontab -l
0 0 * * * jsub -mem 1G -once -quiet -N WT "$HOME/"
1 0 * * * jsub -mem 1G -once -quiet -N WP "$HOME/"
0 */6 * * * jsub -mem 1G -once -quiet -N WN "$HOME/"
0 */24 * * * webservice restart
2 0 * * * jsub -mem 1G -once -quiet -N redirect "$HOME/"
3 0 * * * jsub -mem 1G -once -quiet -N redirect "$HOME/"
local-jackbot@tools-login:~$ qstat
job-ID  prior   name       user         state submit/start at     queue                          slots ja-task-ID
 111816 0.26093 WP         local-jackbo r     05/25/2013 00:00:08 task@tools-exec-02.pmtpa.wmfla     1
local-jackbot@tools-login:~$ qdel 111816
local-jackbot has registered the job 111816 for deletion
local-jackbot@tools-login:~$ qstat


tools.jackbot@tools-login:~$ cat
cd JackBot
git stash
git pull


apt-get remove git-review
pip install git-review
git review -s
git branch
git remote -v
git review -s
git config -l
git config --global "jackpotte"
git clone
git review -sgit pull origin master
git pull origin master
git checkout -b jackbot-1 master
git diff
git status
git add test1.php
git status
git diff --cached
git commit
git pull origin master
git rebase master
git review -R
cd .git
git fetch refs/changes/69/17069/1 && git checkout FETCH_HEAD

Git / Gerrit


git clone ssh://
cd Quiz
vim Quiz.class.php
git add Quiz.class.php
git commit
git fetch
git push ssh:// HEAD:refs/for/master
# Error with a change ID
git commit --amend
# Insertion of the change ID at the last line
git push ssh:// HEAD:refs/for/master


git clone
cd core

gitdir=$(git rev-parse --git-dir); scp -p -P 29418 ${gitdir}/hooks/
pip install -r requirements.txt

cd scripts
git clone

# Modification here
git add -A
git commit -m "Add a French translation for clean_sandbox"
git push origin HEAD:refs/for/master