Skip to content

Instantly share code, notes, and snippets.

@iambibhas
iambibhas / tco_bypass.js
Created January 8, 2015 06:27
Tweetdeck Web t.co bypass
// ==UserScript==
// @name Tweetdeck T.co bypass
// @namespace http://userscripts.org/users/192333
// @version 1
// @include http*://*twitter.com/*
// @grant GM_deleteValue
// @grant GM_getValue
// @grant GM_setValue
// @grant GM_info
// ==/UserScript==
@iambibhas
iambibhas / Vagrantfile
Last active August 7, 2017 22:10
Ansible playbook for KLP vagrant box
# -*- mode: ruby -*-
# vi: set ft=ruby :
# Vagrantfile API/syntax version. Don't touch unless you know what you're doing!
VAGRANTFILE_API_VERSION = "2"
Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
# Every Vagrant virtual environment requires a box to build off of.
config.vm.box = "dub3"
config.vm.box_url = "http://files.vagrantup.com/precise64.box"
@iambibhas
iambibhas / assesment.ipynb
Created December 3, 2014 17:33
Assesment Anomaly
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@iambibhas
iambibhas / photo_backup.sh
Last active October 13, 2022 17:41
Move your images to creation date wise folders
#!/bin/sh
SRC_DIR=$1
DEST_DIR=$2
for _file in `find $SRC_DIR -type f`;
do
DATE=`date -r $_file +%F`
DIR="$DEST_DIR$DATE"
echo "$_file -> $DIR"
@iambibhas
iambibhas / generate_qrcodes.py
Last active August 29, 2015 14:06
I'm using this script to generate QR codes for all the PyCon India 2014 attendees' names and ticket id
import csv
import qrcode
from PIL import Image, ImageFont, ImageDraw
attendees = []
with open('completed_attendees.csv') as userlist:
userreader = csv.reader(userlist, delimiter=',')
for row in userreader:
attendees.append({
@iambibhas
iambibhas / test.md
Created September 10, 2014 06:20
school comparison
         school_name             |               school_name                |     cluster_name      |    cluster_name     |  block_name  |  block_name  |     district
  |     district      

-------------------------------------+------------------------------------------+-----------------------+---------------------+--------------+--------------+------------- ------+------------------- LPUBS EAST EXTENSION | HPUBS NO.5 EXTN RANEBENNUR | RANEBENNUR (URDU) | URBAN URDU | RANEBENNUR | RANEBENNUR | HAVERI
| HAVERI MOORARJI RESI SHALE | MORARJI DESAI RESIDENTIAL SCHOOL | HUNSUR SOUTH | KARIMUDDANA HALLI | HUNSUR | HUNSUR | MYSORE
| MYSORE VES HPS VYALIKAVAL | VAYALIKAVAL EDU SOCIETY HPS VAYALIKAVAL | KADU MALLESHWARA | PALACE GUTTAHALLI | NORTH2 | NORTH2 | BANGALORE U NORTH | BANGALORE U NORTH

@iambibhas
iambibhas / .tmux.conf
Last active October 13, 2016 08:06
My tmux conf
# use UTF8
set -g utf8
set-window-option -g utf8 on
# make tmux display things in 256 colors
set -g default-terminal "screen-256color"
# set scrollback history to 100000 (100k)
set -g history-limit 100000
@iambibhas
iambibhas / next_palindrome.py
Created August 17, 2014 06:47
Find the palindrome larger than given number
import math
def find_next(n):
try:
n = int(n)
except:
return n
if n < 10:
return n
@iambibhas
iambibhas / geo_on_json.sql
Created June 15, 2014 10:45
Another way of querying geo data from JSON column
explain analyze
SELECT tmp_table.tid,
tmp_table.screen_name,
tmp_table.text
FROM
(SELECT tid,
data->'user'->>'screen_name' AS screen_name,
data->>'text' AS text,
ST_GeomFromText('POINT(' || CAST(data#>>'{geo,coordinates,1}' as varchar) || ' ' || CAST(data#>>'{geo,coordinates,0}' as varchar) || ')', 4326) AS geom
FROM tweet
@iambibhas
iambibhas / aggregators.py
Last active August 29, 2015 14:02
Django PostgreSQL CASE WHEN aggregation
from django.db import models
class SQLSumCase(models.sql.aggregates.Aggregate):
is_ordinal = True
sql_function = 'SUM'
sql_template = "%(function)s(CASE WHEN %(when)s THEN %(field)s ELSE 0 END)"
def __init__(self, col, **extra):
if isinstance(extra['when'], basestring):
extra['when'] = "%s" % extra['when']