iamvery

ALTER TABLE "TableName"
ADD CONSTRAINT "ConstraintName" FOREIGN KEY ("columnName")
  REFERENCES "AnotherTableName" ("anotherColumnName") MATCH SIMPLE
  ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY IMMEDIATE;

-- I generally use the form "TableName_fk_constraintname" for foreign key constraint names (for reference)
-- This particular foreign key will cascade on update and delete, but those particular directives aren't required. (for reference)

iamvery

$('form').bind('ajax:success', function(e, data){
	alert(data);
});

iamvery

# Specify your own GEM_HOME, but keep the standard gem path in GEM_PATH
ENV['GEM_HOME'] = "#{ENV['HOME']}/.gems"
ENV['GEM_PATH'] = "#{ENV['GEM_HOME']}:/usr/lib/ruby/gems/1.8"
require 'rubygems'
Gem.clear_paths

iamvery

# psql.exe is generally found in C:\Program Files [(x86)]\PostgreSQL\PG_VERSION\bin\
psql.exe DATABASE_NAME < C:\LOCATION_TO_BACKUP\backup.sql

iamvery

Array.new(3).map { ('A'..'Z').to_a.sample }.join

iamvery

def takes_and_has_opts(*args)
  opts = args.extract_options!
  lambda do |*args|
    o = args.extract_options!
    o.merge!(opts)
    o
  end
end

iamvery

# See https://discussions.apple.com/thread/3173994?start=0&tstart=0
sudo launchctl unload /System/Library/LaunchDaemons/com.apple.racoon.plist
sudo launchctl load /System/Library/LaunchDaemons/com.apple.racoon.plist

iamvery

# change this variable to the appropriate libmysqlclient lib version
VERSION=18
# change this variable to the path to your mysql2 gem
MYSQL_GEM_PATH=~/.rvm/gems/ruby-1.9.2-p180/gems/mysql2-0.2.7

sudo install_name_tool -change libmysqlclient.$VERSION.dylib /usr/local/mysql/lib/libmysqlclient.$VERSION.dylib $MYSQL_GEM_PATH/lib/mysql2/mysql2.bundle

iamvery

** This issue came up in a Rails 3.0.11 app **

Article Model - the good parts

has_many :categorizations
has_many :categories, :through => :categorizations

scope :not_news, includes(:categories).where(Category.arel_table[:name].not_eq('news'))
scope :by_date,  order('articles.post_date DESC, articles.id DESC')

iamvery

-- Function: "Safe_Cast_Str_to_Int"(character varying, integer)

CREATE OR REPLACE FUNCTION "Safe_Cast_Str_to_Int"(input_string character varying, default_value integer DEFAULT NULL::integer)
  RETURNS integer AS
$BODY$
BEGIN
	BEGIN
		RETURN input_string::integer;
	EXCEPTION WHEN data_exception THEN
		RETURN default_value;