covard

require 'roo'

# Spreadsheet courtesy of the A List Apart 2010 Web Design Survey:
# http://www.alistapart.com/articles/survey2010

workbook = Excel.new('a-list-apart-web-design-survey-sample.xls')

# Set the worksheet you want to work with as the default worksheet.  You could
# also iterate over all the worksheets in the workbook.
workbook.default_sheet = workbook.sheets[0]

covard

workbook.default_sheet = workbook.sheets.first

header = workbook.row(1)
    (2..workbook.last_row).each do |i|
      row_data_hash = Hash[[header, workbook.row(i)].transpose]
end

covard

def self.get_headers(workbook)
  headers = Hash.new
  workbook.row(1).each_with_index { |header,i| headers[header] = i }
end

covard

# how to take an array of hashes and transform it into a hash
ary = [{a: :b}, {c: :d}]
ary.reduce Hash.new, :merge

# output {:a=>:b, :c=>:d}

# Happy Rubying =)

covard

require 'terminal-notifier'
message = 'Script has completed'
title = 'Hey You!'

TerminalNotifier.notify message, title: title

# Happy Rubying =)

covard

require 'active_record'
require 'yaml'
require 'logger'
require 'database_cleaner'
require_relative 'models/market'

CONFIG = YAML::load(File.open('config/database.yml'))

task :default => :migrate
namespace :db do

covard

# when using ActiveDirectory outside of rails need to do it like this for ActiveRecord 4.0
require 'action_controller'

raw_parameters = { :email => "[email protected]", :name => "John", :admin => true }
parameters = ActionController::Parameters.new(raw_parameters)
user = User.create(parameters.permit(:name, :email))

# Happy Rubying =)

covard

first_hdr = ["hello", "world"]
second_hdr = ["hello", "world", "!"]
new_columns = second_hdr - first_hdr # changed the code to use the way Morgan found, seems more ruby to me ;)

# output
# new_columns => ["!"]

# can also use reject! and that will reject on the second_hdr so then it would be
# second_hdr => ["!"]

covard

This gist is for installing PostgreSQL using Hombrew and the luncy gem.

$ brew install postgresql

When you install Postgres, you will see a bunch of output in your Terminal. The important sections are Build Notes, Create/Upgrade a Database, and Start/Stop PostgreSQL. Make sure to follow those instructions to the letter.

Create and upgrade a DB

covard

# stop OSX from asking if you want to run application

sudo xattr -d com.apple.quarantine /Applications/Adium.app