dlokesh

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <name>hello</name>
    <groupId>com.hello.service</groupId>
    <artifactId>hello-service</artifactId>
    <version>1.0.1-SNAPSHOT</version>

dlokesh

# Something in lines of http://stackoverflow.com/questions/348630/how-can-i-download-all-emails-with-attachments-from-gmail
# Make sure you have IMAP enabled in your gmail settings.
# Right now it won't download same file name twice even if their contents are different.

import email
import getpass, imaplib
import os
import sys

detach_dir = '.'

dlokesh

# http://www.cocoanetics.com/2012/07/you-dont-need-the-xcode-command-line-tools/
RECEIPT_FILE=/var/db/receipts/com.apple.pkg.DeveloperToolsCLI.bom
RECEIPT_PLIST=/var/db/receipts/com.apple.pkg.DeveloperToolsCLI.plist
 
if [ ! -f "$RECEIPT_FILE" ]
then
  echo "Command Line Tools not installed."
  exit 1
fi
 

dlokesh

[user]
	name = <name>
	email = <email>

[alias] 
	st = status
	ci = commit
	co = checkout
	w = whatchanged

dlokesh

brew install fuse4x
brew install ntfs-3g
sudo mv /sbin/mount_ntfs /sbin/mount_ntfs.orig
sudo ln -s /usr/local/Cellar/ntfs-3g/2013.1.13/sbin/mount_ntfs /sbin/mount_ntfs

# Install kernel extensions
sudo cp -rfX /usr/local/Cellar/fuse4x-kext/0.9.2/Library/Extensions/fuse4x.kext /Library/Extensions
sudo chmod +s /Library/Extensions/fuse4x.kext/Support/load_fuse4x

dlokesh

Oracle sqls

find all constraints of a table

select * from all_constraints where table_name='TABLE_NAME' and owner='OWNER_NAME';

find all primary keys of a table

SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner

dlokesh

yum install git
yum -y install make gcc gcc-c++ kernel-devel
yum install openssl

wget https://github.com/joyent/node/archive/v0.4.9.zip
cd node-0.4.9
./configure --prefix=/opt/node
make -j2
sudo make install
echo 'export NODE_PATH=/opt/node:/opt/node/lib/node_modules' >> ~/.bashrc

dlokesh

Bash commands

replace in file

perl -p -i -e 's/oldstring/newstring/g' *
sed -i ‘s/oldstring/newstring/g’ *
find app/views/ -type f -exec perl -p -i -e 's/alert.unit/unit/g' {} \;

date format

dlokesh

Git commands

add tracking branch

git branch --set-upstream prod origin/prod

create patch from commit hash

dlokesh

Postgres Commands

current activity

SELECT datname,usename,procpid,client_addr,waiting,query_start,current_query FROM pg_stat_activity;

shared buffer in OS X

sudo sysctl -w kern.sysv.shmmax=209715200