ryanoboril

#!/bin/bash

sudo yum install -y wget gcc
wget http://download.redis.io/redis-stable.tar.gz
tar xvzf redis-stable.tar.gz
cd redis-stable/src
make redis-cli
sudo cp redis-stable/src/redis-cli /usr/local/bin/

ryanoboril

# copy/import data from heroku postgres to localhost pg database

# useful for copying admin's work on live site into local database to reproduce errors
# https://devcenter.heroku.com/articles/heroku-postgres-import-export

# take heroku pg snapshot and download
heroku pg:backups:capture
heroku pg:backups:download

# load the dump into local postgres database, assuming $DATABASE_URL set locally

ryanoboril

div
  = @safe JST["templates/carrier_reference_number"]({order: @order, user_id: @user_id, edit: true})

ryanoboril

echo `ifconfig | grep '192.168' | awk '{ print $2 }' | sed 's/addr://g'`

ryanoboril

sudo du -k / | sort -n | tail -10

ryanoboril

RAILS_ENV=production rake db:migrate; echo "Done" | mail -s "Interrupted `date`" ryan@arcweb.co

this requires mail server to be set up in /etc/ssmtp/ssmtp.conf

ryanoboril

find /path/to/files -type f -exec sed -i '' 's/oldstring/new string/g' {} \;

ryanoboril

# ~/.bashrc

alias rails="bundle exec rails"
alias rake="bundle exec rake"
alias rspec="bundle exec rspec"
alias cap="bundle exec cap"

ryanoboril

C:\Windows\SysWOW64\odbcad32.exe

Useful when you can't find ODBC connections that you KNOW are there....

ryanoboril

-- Backup Database to .bak File
-- Need to pass in FILENAME and DB arguments
DECLARE @fileName VARCHAR(90);
DECLARE @db_name VARCHAR(20);
DECLARE @fileDate VARCHAR(20);

SET @fileName = FILENAME;
SET @db_name = DB;
SET @fileDate = CONVERT(VARCHAR(20), GETDATE(),112);
SET @fileName = @fileName + @db_name + '_' + RTRIM(@fileDate) + '.bak';