lukmdo

SELECT @@profiling;
SET profiling=1|0;
SHOW PROFILES;
SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]


SELECT @@global.time_zone, @@session.time_zone;
SET time_zone = '+00:00';

lukmdo

for ((i=1; i<=14; i++)); do 
  D=`date -v${i}d +%Y%m%d`;
  echo $D;
done 

lukmdo

drop procedure IF EXISTS clear_db;
DELIMITER //

CREATE PROCEDURE clear_db ()
BEGIN
  SET @tName := (SELECT  table_name from information_schema.tables where table_schema = DATABASE() ORDER BY table_name LIMIT 1);
  WHILE @tName IS NOT NULL DO
    # SELECT CONCAT("Dropping tabe: ", @tName) as msg;
    SET @s = CONCAT("DROP TABLE ", @tName);
    PREPARE dropIT FROM @s;

lukmdo

 1) # vim /etc/exports:
# What_to_share With_whom
ABS_PATH IP(rw,all_squash,anonuid=XXX,anongid=YYY,insecure)

# `all_squash` - turns on mapping. Each file created/modified on the client will be mapped to user
# configured by `ananuid` and `anangid` on the server side.
# `anonuid` - id of server side user of the changed files
# `anangid` - gid of server side group of the changed files
# `insecure` - lests in all requests form port higher then 1024

lukmdo

CSS Editor
Eclipse Web Developer Tools
Google App Engine Java SDK
Google Plugin for Eclipse
Google Web Toolkit SDK
PyDev for Eclipse
WTP

Apache MyFaces Trinidad Tag Support (Optional)
Code Coverage - CodePro

lukmdo

export REQUEST_METHOD="GET";
export PATH_INFO="ws/keywords";
export QUERY_STRING="cid=523&tgid=54&begin=20100701&end=20100712";
perl ./cgi/seo2.cgi

lukmdo

git add -p
git stash -p
git reflog
gitk --all `git reflog |cut -c1-7`
git status -M --find-copies-hard
git grep  "supae"
git log -S "supae" -p
git log -P

lukmdo

from itertools import chain, islice

def chunk(seq, chunksize):
    """ Yields items from an iterator in iterable chunks."""
    it = iter(seq)
    while True:
        yield chain([it.next()], islice(it, chunksize - 1))

if __name__ == '__main__':  
    lst = ['a', 'b', 'c', 'd', 'e']  

lukmdo

Add existing user to existing group

sudo dseditgroup -o edit -a USERNAME -t user GROUPNAME

Google Notifier AutocheckInterval

defaults write com.google.GmailNotifier AutocheckInterval EVERY_N_MINUTES
defaults delete com.google.GmailNotifier AutocheckInterval # to reset

Enabling/disabling at family commands

lukmdo

// More than https://github.com/about
// Uses https://api.github.com/orgs/github/members as data source and fetches user data from the url field
[
  {
    "op": "core/column-addition-by-fetching-urls",
    "description": "Create column userData at index 1 by fetching URLs based on column url using expression grel:value",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },