johngrimes

# Get the device identifier of the device, which is the one that currently does not have a valid partition table.
fdisk -l

# Use fdisk to create a new primary Linux partition, which takes up all of the available space.
fdisk /dev/sdb

# Make a new ext4 filesystem within the new partition.
mkfs -t ext4 /dev/sdb1

# Get the UUID of the new filesystem.

johngrimes

SELECT exec('ALTER TABLE ' || quote_ident(s.nspname) || '.' || quote_ident(s.relname) || ' OWNER TO $NEWUSER')
FROM (SELECT nspname, relname
    FROM pg_class c JOIN pg_namespace n ON (c.relnamespace = n.oid) 
    WHERE nspname NOT LIKE E'pg\\_%' AND 
      nspname <> 'information_schema' AND 
      relkind IN ('r','S','v') ORDER BY relkind = 'S'
  ) s;

johngrimes

var email = new LiveValidation('email');
email.add(Validate.Presence);
email.add(Validate.Format, { pattern: /\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*/i });

johngrimes

$timeStart = microtime(true);

/* The code that you want to time */

$timeEnd = microtime(true);
$duration = $timeEnd - $timeStart;

johngrimes

namespace :seed_data do
  desc 'Load seed data into the database of the current environment'
  task :load => :environment do
    require 'active_record/fixtures'
    Dir.glob(RAILS_ROOT + '/db/seed_data/*.yml').each do |file|
      Fixtures.create_fixtures('db/seed_data', File.basename(file, '.*'))
    end
  end
end

johngrimes

require 'bundler/capistrano'
require 'rvm/capistrano'

set :application, 'myapp'

set :repository,  'git@github.com:johngrimes/myapp.git'
set :scm, 'git'

set :bundle_flags, '--deployment'
set :bundle_without, []

johngrimes

find public/images -name '*.png' | xargs optipng
find public/images -name '*.jpg' | xargs jpegoptim

johngrimes

CREATE OR REPLACE FUNCTION resync_id_sequences() RETURNS void AS $$
DECLARE
  table RECORD;
  sequence_name VARCHAR;
  id_present RECORD;
  max_id RECORD;
BEGIN
  FOR table IN SELECT * FROM information_schema.tables WHERE table_schema = 'public' LOOP
    SELECT COUNT(*) AS count INTO id_present
    FROM pg_attribute a INNER JOIN pg_class c 

johngrimes

# Put this into /etc/newsyslog.conf, or into a .conf file under /etc/newsyslog.d/
# Format: [logfile_name] [owner:group] [mode] [count] [size] [when] [flags] [path_to_pid_file] [signal_number]
# See https://developer.apple.com/library/mac/documentation/Darwin/Reference/Manpages/man5/newsyslog.conf.5.html#//apple_ref/doc/man/5/newsyslog.conf

# This trims any log file in this directory that has exceeded 10 MiB in size.
# The G flag allows you to use globbing in the logfile_name field.
/path/to/your/log/files/*.log user:group 640 0 10486 * G

johngrimes

def index
  @areas = Area.all
  @area = Area.find_by(slug: params[:area_slug]).presence || Area.find_by(slug: 'city')

  conditions = { area: @area.subtree }
  conditions.merge! params.select { |k,v|
    [:bedrooms, :unit].include?(k) and !v.blank?
  }
  conditions[:property_type] = params[:type] || 'residential'