Skip to content

Instantly share code, notes, and snippets.

View amitchhajer's full-sized avatar

Amit Chhajer amitchhajer

View GitHub Profile
@amitchhajer
amitchhajer / ntpdate
Created December 28, 2012 06:15 — forked from anonymous/ntpdate
There are times when you need to keep the date and time of your system to be correct.
Ntpdate in linux helps you do the same
sudo ntpdate -u ntp.ubuntu.org
ntpdate are installed on most distributions, if not install using apt-get.
@amitchhajer
amitchhajer / Proxy
Created December 28, 2012 06:20
Tunnelling using ssh
ssh -C2qTnN -D 8080 username@xxx.xxx.xxx.xxx (xxx.xxx.xxx.xxx is the ip which allows ssh access) (can change the port from 8080 to as per requirement)
You are connected to the proxy. To use the proxy, go the one of your browser
and change the proxy settings to use SOCKS protocol and localhost (127.0.0.1) with port 8080.
@amitchhajer
amitchhajer / php datetime
Created December 28, 2012 06:25
Validating php date and date time
Validating a date from format yyyy-mm-dd
$date = DateTime::createFromFormat('Y-m-d', $generatedFrom);
if (!($date instanceof DateTime)) {
throw new ValidationError('Not valid start date');
}
Similarly other formats can be validated.
@amitchhajer
amitchhajer / Count Code lines
Created January 5, 2013 11:08
Count number of code lines in git repository per user
git ls-files -z | xargs -0n1 git blame -w | perl -n -e '/^.*\((.*?)\s*[\d]{4}/; print $1,"\n"' | sort -f | uniq -c | sort -n
@amitchhajer
amitchhajer / mysql formatted result
Created January 10, 2013 13:00
Formatted query result mysql
After into mysql cli
use command " pager less -SFX " and then use mysql cli normally
You can use arrow keys as well as pageup/down keys.
import sublime
import sublime_plugin
class NumberCommand(sublime_plugin.TextCommand):
def run(self, edit):
selection = self.view.sel()
for region in selection:
try:
value = int(self.view.substr(region))
self.view.replace(edit, region, str(self.op(value)))
@amitchhajer
amitchhajer / delete_duplicate.mysql
Created July 20, 2013 14:29
Delete duplicate records from database leaving one of them.
delete from my_table mt1, my_table mt2 where mt1.fieldX = mt2.fieldX and mt1.fieldY = mt2.fieldY and mt1.primary_key > mt2.primary_key
@amitchhajer
amitchhajer / git_branches_specific_user
Last active January 2, 2016 09:18
Get all the branches in git for specific user
git for-each-ref --format='%(committerdate) %09 %(authorname) %09 %(refname)' | sort -k5n -k2M -k3n -k4n | grep 'user'
apt-get install -y ppa-purge
add-apt-repository -y ppa:ondrej/php5-oldstable
apt-get update
ppa-purge ppa:ondrej/php5
apt-get update && apt-get upgrade -y && apt-get autoremove -y && apt-get autoclean -y
@amitchhajer
amitchhajer / fibanacci_recursive_2_vars
Created October 13, 2014 08:07
Fibonaaci recursive with 2 variables
<?php
function fibo($n, $first =1, $second=1)
{
if($n==1 || $n==2)
return $second;
else
return fibo($n-1, $second,($first + $second));
}