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

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

johngrimes

upstream unicorn-myapp { server 127.0.0.1:3000; }

server {
  server_name myapp.com;
  rewrite ^(.*) http://www.myapp.com$1 permanent;
}

server {
  listen *:80;
  server_name www.myapp.com;

johngrimes

/* Adapted from Tom Cunningham's 'Data Warehousing with MySql' (www.meansandends.com/mysql-data-warehouse) */

###### small-numbers table
DROP TABLE IF EXISTS numbers_small;
CREATE TABLE numbers_small (number INT);
INSERT INTO numbers_small VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

###### main numbers table
DROP TABLE IF EXISTS numbers;
CREATE TABLE numbers (number BIGINT);

johngrimes

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

set :application, 'myapp'

set :repository,  '[email protected]:johngrimes/myapp.git'
set :scm, 'git'

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

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

$timeStart = microtime(true);

/* The code that you want to time */

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

johngrimes

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