Arsham Shirvani arsham

## TwoSpacesToFourIndention.sublime-macro
[
	{
		"args": null,
		"command": "select_all"
	},
	{
		"args": {
			"setting": "tab_size",
			"value": 2
		},

## md5dir

#!/bin/bash
find $1/ -type f -exec md5sum {} + | awk '{print $1}' | sort | md5sum

## install_package_in_env_env
# Do this in your environment
python setup.py develop --install-dir /path/to/virtualen/lib/python3.4/site-packages
# or: python setup.py develop --multi-version --exclude-scripts --install-dir /path/to/virtualen/lib/python3.4/site-packages

## database_size
-- PostgreSql
SELECT
  pg_database.datname AS "Database Name",
  pg_database_size(pg_database.datname) / 1024.0 / 1024.0 AS "Database Size (MB)"
FROM pg_database;

-- MySql
SELECT
  table_schema "Database Name",
  sum( data_length + index_length ) / 1024 / 1024 "Database Size (MB)"

## Convert aggs results to KML

//This function was used in my test rig to convert elasticsearch results to a KML structure which is
// later fed to an iFrame wrapping the GoogleEarth plugin

var data=[];
var buckets=inData.aggregations.map.buckets;

function addCommas(nStr)
{
    nStr += '';

## update_auto_val
SELECT setval('TEABLE_NAME_id_seq', (SELECT MAX(id) FROM TEABLE_NAME));

## python_email_debugger
#!/bin/bash
python -m smtpd -n -c DebuggingServer localhost:1025

## request_generator.py
from django.test.client import RequestFactory
factory = RequestFactory()
request = factory.get('/')

## list_ssh_tunnels
sudo lsof -i -n | egrep '\<ssh\>'

## purge_queue.sh
manage.py celery amqp queue.purge <QUEUE_NAME>
	[
	{
	"args": null,
	"command": "select_all"
	},
	{
	"args": {
	"setting": "tab_size",
	"value": 2
	},

	#!/bin/bash
	find $1/ -type f -exec md5sum {} + \| awk '{print $1}' \| sort \| md5sum
	# Do this in your environment
	python setup.py develop --install-dir /path/to/virtualen/lib/python3.4/site-packages
	# or: python setup.py develop --multi-version --exclude-scripts --install-dir /path/to/virtualen/lib/python3.4/site-packages
	-- PostgreSql
	SELECT
	pg_database.datname AS "Database Name",
	pg_database_size(pg_database.datname) / 1024.0 / 1024.0 AS "Database Size (MB)"
	FROM pg_database;

	-- MySql
	SELECT
	table_schema "Database Name",
	sum( data_length + index_length ) / 1024 / 1024 "Database Size (MB)"

	//This function was used in my test rig to convert elasticsearch results to a KML structure which is
	// later fed to an iFrame wrapping the GoogleEarth plugin

	var data=[];
	var buckets=inData.aggregations.map.buckets;

	function addCommas(nStr)
	{
	nStr += '';
	#!/bin/bash
	python -m smtpd -n -c DebuggingServer localhost:1025
	from django.test.client import RequestFactory
	factory = RequestFactory()
	request = factory.get('/')