User:JackPotte

From Wikitech
Jump to: navigation, search
Babel user information
fr-N Cet utilisateur a pour langue maternelle le français.
en-4 This user has near native speaker knowledge of English.
de-2 Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau.
es-2 Este usuario tiene un conocimiento intermedio del español.
pt-1 Este utilizador pode contribuir com um nível básico de português.
it-1 Questo utente può contribuire con un livello elementare in italiano.
ru-1 Этот участник владеет русским языком на начальном уровне.
ar-1 هذا المستخدم لديه معرفة أساسية بالعربية.
hi-1 इस सदस्य को हिन्दी का प्राथमिक ज्ञान है।
zh-1 这位用户的中文达到初级水平
ja-1 この利用者は初級日本語ができます。
la-1 Hic usor simplici latinitate contribuere potest.
el-1 Αυτός ο χρήστης μπορεί να συνεισφέρει σε βασικού επιπέδου Ελληνικά.
vi-0 Thành viên này hoàn toàn không biết tiếng Việt (hoặc rất khó khăn để hiểu).
id-0 Pengguna ini tidak mengerti bahasa Indonesia (atau hanya dengan sangat sulit).
ko-0 이 사용자는 한국어모르거나, 이해하는 데 어려움이 있습니다.
nl-0 Deze gebruiker heeft geen kennis van het Nederlands (of begrijpt het met grote moeite).
Users by language

User UTC + 1 (Paris, France)

Own tools

Other tools

Crons

local-jackbot@tools-login:~$ crontab -l
0 0 * * * jsub -mem 1G -once -N redirect "$HOME/redirect.sh"
0 0 * * * jsub -mem 1G -once -N WT "$HOME/WT.sh"
0 0 * * * jsub -mem 1G -once -N WP "$HOME/WP.sh"
0 0 * * * jsub -mem 1G -once -N WP "$HOME/WN.sh"
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
local-jackbot@tools-login:~$

MySQL

Read Wikipedia

local-xtools@tools-login:~$ mysql --defaults-file=replica.my.cnf -h enwiki.labsdb
...
MariaDB [(none)]> connect enwiki_p
...
MariaDB [enwiki_p]> select * from user where user_name='JackPotte';
...
 
local-xtools@tools-login:~$ mysql --defaults-file=~/replica.my.cnf -h enwiktionary.labsdb enwiktionary_p

Create own database

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


Git

apt-get remove git-review
pip install git-review
git review -s
git branch
git remote -v
ssh jackpotte@gerrit.wikimedia.org:29418/test/mediawiki/extensions/examples.git
git review -s
git config -l
git config --global user.name "jackpotte"
git clone https://gerrit.wikimedia.org/r/p/test/mediawiki/extensions/examples.git
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 https://gerrit.wikimedia.org/r/mediawiki/core refs/changes/69/17069/1 && git checkout FETCH_HEAD