Skip to content

Instantly share code, notes, and snippets.

View didip's full-sized avatar

Didip Kerabat didip

156 followers · 3 following
View GitHub Profile
@didip
didip / re-inserting-to-partitioned-table.sql
Created February 10, 2014 19:45
begin;
insert into table select * from only table where id between 1 and 10000000;
delete from only table where id between 1 and 10000000;
commit;
begin;
insert into table select * from only table where id between 10000001 and 20000000;
delete from only table where id between 10000001 and 20000000;
commit;
@didip
didip / selenium-login.py
Last active August 29, 2015 13:57
#!/usr/bin/env python
from selenium import webdriver
baseurl = "http://staging-v2.postano.com/login"
username = "didip"
password = "baz"
mydriver = webdriver.Firefox()
mydriver.get(baseurl)
@didip
didip / change_crashplan_backup_service_port.sh
Created March 31, 2014 17:37 — forked from thebengeu/change_crashplan_backup_service_port.sh
#!/bin/sh
PORT=4200
sudo launchctl unload /Library/LaunchDaemons/com.crashplan.engine.plist
sudo sed -i '' "s/\(<servicePort>\)[^<]*/\1$PORT/" /Library/Application\ Support/CrashPlan/conf/my.service.xml
sed -i '' "s/#*\(servicePort=\).*/\1$PORT/" /Applications/CrashPlan.app/Contents/Resources/Java/conf/ui.properties
defaults write /Applications/CrashPlan.app/Contents/Resources/CrashPlan\ menu\ bar.app/Contents/Info CPPort $PORT
sudo launchctl load /Library/LaunchDaemons/com.crashplan.engine.plist
@didip
didip / gist:d46e0e6d9931a927e254
Created August 27, 2014 21:49
Removing container through remote API raise "Device is busy" error, but based on the underlying mount, the SHA directory is actually deleted.
> docker version
Client version: 1.1.2
Client API version: 1.13
Go version (client): go1.2.2
Git commit (client): d84a070/1.1.2
Server version: 1.1.2
Server API version: 1.13
Go version (server): go1.2.2
Git commit (server): d84a070/1.1.2
@didip
didip / brew-update-force.sh
Created August 21, 2015 05:56
Force brew update
cd `brew --prefix`
git remote add origin https://github.com/mxcl/homebrew.git
git fetch origin
git reset --hard origin/master
@didip
didip / __init__py
Created June 8, 2009 06:41
My Default tests/__init__.py
from unittest import TestCase
from paste.deploy import loadapp
from paste.script.appinstall import SetupCommand
from pylons import config, url
from routes.util import URLGenerator
from webtest import TestApp
import pylons.test
import sys, os.path
ROOT_PATH = os.path.realpath(os.path.join(os.path.dirname(__file__), '..', '..'))
@didip
didip / name_generator.py
Created November 2, 2009 16:24
import random
KATAKANA_1 = [
'a', 'i', 'u', 'e', 'o',
'ka', 'ki', 'ku', 'ke', 'ko',
'sa', 'shi', 'su', 'se', 'so',
'ta', 'chi', 'tsu', 'te', 'to',
'na', 'ni', 'nu', 'ne', 'no',
'ha', 'hi', 'fu', 'fe', 'fo',
'ma', 'mi', 'mu', 'me', 'mo',
@didip
didip / mysql-change-column-to-utf8.sh
Created November 11, 2009 00:40
mysqldump --user=root --default-character-set=latin1 -c --insert-ignore --skip-set-charset <dbname> <table-name> > <filename>.sql &&
iconv -f ISO-8859-1 -t UTF-8 <filename>.sql > <filename>.utf8.sql &&
perl -pi -w -e 's/CHARSET=latin1/CHARSET=utf8/g;' <filename>.sql.utf8.sql &&
mysql --user=root --max_allowed_packet=16M --default-character-set=utf8 <dbname> < <filename>.utf8.sql
@didip
didip / simple-mysql-replication-fix.sql
Created November 11, 2009 17:13
SHOW SLAVE STATUS \G
STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
START SLAVE;
SHOW SLAVE STATUS \G
@didip
didip / mysql-config.sh
Created December 3, 2009 16:13
#!/bin/bash
perl -ne 'm/^([^#][^\s=]+)\s*(=.*|)/ && printf("%-35s%s\n", $1, $2)' /etc/mysql/my.cnf