meganlkm

#!/bin/bash

myproject='myproject'
mywwwdir='public_html'

# initialize project
composer create-project laravel/laravel $myproject 4.2.*
cd $myproject

perl -pi -e "s|/public|/../${mywwwdir}|" bootstrap/paths.php

meganlkm

# get external ip
wget -q -O - checkip.dyndns.org | sed -e 's/.*Current IP Address: //' -e 's/<.*$//'

# javafy regex
echo '/^\d{5}\\(?:[-\s]\d{4})?$/' | sed 's/\\/\\\\/g'

# loop to make dirs
for i in {1..5}; do mkdir unit$i; done

meganlkm

-- postgres snippets

-- show databases owned by a specific user
psql -d postgres -c "SELECT datname FROM pg_database JOIN pg_authid ON pg_database.datdba = pg_authid.oid WHERE rolname = 'rolename'"

-- see all active sessions
SELECT * FROM pg_stat_activity;

-- kill sessions
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'dbname' AND pid <> pg_backend_pid();