Raffo

Fun with ssh and scp

Estabilish a shh tunnel

ssh -i private_key user@remote_host -L local_port:remote_host:remote_port -f -N

scp to remote host

scp file user@IP:/dir/to/write/to

SOCKS5 dirty trick

ssh -D127.0.0.1:1080 vagrant@localhost -p 2222

Raffo

Keep a branch in sync with master

git checkout master
git pull
git checkout branchname
git merge master

I made some changes on the master but I want to bring (and commit) them to a different (NEW) branch.

Raffo

ssh into a running docker container

sudo docker exec -i -t 665b4a1e17b6 bash #by ID

Removes all the exited containers.

docker rm $(docker ps -q -f status=exited)

Get logfile for a container:

Raffo

Java Print Method name //This is really dirty, but works, do not use this for production code, just for testing purposes.

public String getCurrentMethodName() {
	StackTraceElement stackTraceElements[] = (new Throwable()).getStackTrace();
	return stackTraceElements[1].toString();
}

Raffo

Oracle SQL distinct on single column

 select * 
 from TABLE_NAME 
 where rowid in 
  (
    select max(ROWID) 
    from TABLE_NAME 
    GROUP BY COLUMN_NAME

Raffo

Passing parameters when starting an Activity from http://stackoverflow.com/questions/2091465/how-do-i-pass-data-between-activities-in-android

Intent intent = new Intent(getBaseContext(), NameOfActivity.class);
intent.putExtra("PARAMNAME", param);
startActivity(intent);