productivity

general place for productivity gains

JIRA / JQL

some SQL queries

-- query all active users
SELECT u.user_name,u.first_name,u.last_name,u.email_address,d.directory_name 
  FROM cwd_user u JOIN cwd_directory d on u.directory_id = d.id 
 WHERE u.active = 1;

-- show base_url, see following URL for details on how to change it
-- https://confluence.atlassian.com/jirakb/change-the-base-url-of-jira-server-in-the-database-733940375.html
SELECT propertyvalue 
  FROM propertyentry PE 
  JOIN propertystring PS ON PE.id=PS.id 
 WHERE PE.property_key = 'jira.baseurl';

-- show issues of certain reporter of certain project
SELECT id, issuenum, project, reporter, assignee, issuetype, summary 
  FROM jiraissue 
 WHERE reporter = 'current_reporter' 
   AND project = (select id from project where pkey='PRJKEY');

-- change reporter of issues matching certain reporter and project
UPDATE jiraissue SET reporter = 'new_reporter' 
 WHERE reporter = 'current_reporter' 
   AND project = (SELECT id FROM project WHERE pkey='SHRT');

VSC

  • list all extensions
    code --list-extensions | xargs -L 1 echo code --install-extension
  • config 
    {
    "http.proxy": "http://your_proxy/",
    "editor.formatOnPaste": true,
    "editor.fontSize": 15,
    "editor.lineHeight": 24,
    "editor.fontWeight": "normal",
    "files.autoSave": "off",
    "terminal.integrated.fontSize": 14,
    "terminal.integrated.lineHeight": 1.3,
    "workbench.editor.enablePreviewFromQuickOpen": false,
    "editor.minimap.enabled": true,
    "editor.codeLens": false,
    "editor.renderLineHighlight": "all",
    "terminal.integrated.fontFamily": "Consolas",
    // cupertino special
    "terminal.integrated.shellArgs.osx": ["-l"],
    // redmond special
    "terminal.integrated.shell.windows": "C:\\path_to_git\\bin\\bash.exe",
    "typescript.npm": "C:\\path_to_node\\node-v7.2.1-win-x64\\npm",
}

tmux

extensive tmux cheat sheet of Mohamed Alaa

  • create session: 
    tmux new -s s_name
  • attach to session: 
    tmux attach -t session_name
  • attach to session: 
    tmux switch -t session_name

CTRL + B - d: detach, " or %: split, arrows: jump windows, q: list window numbers
  • list sessions: 
    tmux ls
  • list keys: 
    tmux list_keys

tutorials

chart libs

Linux process stuff

$ killall -9 firefox

git aliases

alias         gs='git status'
alias         gc='git commit -m'
alias      gpull='git pull'
alias      gpush='git push'
alias         gb='git branch'
alias         gl='git log'
alias        gll='git log --graph --full-history --all --color --pretty=format:"%x1b[31m%h%x09%x1b[32m%d%x1b[0m%x20%s"'
alias         ga='git add'
alias        ga.='git add .'
alias        gco='git checkout'
alias     gitwho='git config --global user.name; git config --global user.email'
alias  gitperson='git config --global user.name "YOUR_NAME"; git config --global user.email "your.name@yourdomain.com"'
alias     gfetch='echo "git fetch upstream"; git fetch upstream'

bash

filter git commits, change committer

git filter-branch --commit-filter '
if [ "$GIT_COMMITTER_NAME" = "Jason Foo" ];
then
    GIT_COMMITTER_NAME="John Doe";
    GIT_AUTHOR_NAME="John Doe";
    GIT_COMMITTER_EMAIL="john@doe.com";
    GIT_AUTHOR_EMAIL="john@doe.com";
    git commit-tree "$@";
else
    git commit-tree "$@";
fi' HEAD

vi settings

vi .vimrc
syntax on
colorscheme desert
set number
set ruler

powerline

https://github.com/Powerlevel9k/powerlevel9k/wiki/Install-Instructions#step-1-install-powerlevel9k
https://gist.github.com/kevin-smets/8568070

delete node_modules

find . -name "node_modules" -type d -prune -exec rm -rf '{}' +
https://rtmccormick.com/2018/01/10/clear-node-modules-folders-recursively-mac-linux/

brew install