Skip to content

Instantly share code, notes, and snippets.

@bayendor
bayendor / audit_info.rb
Created Mar 14, 2014
Migration Results Import & Update Code
View audit_info.rb
class AuditInfo < ActiveRecord::Base
belongs_to :arc_info
def self.import(file)
begin
if file.path
CSV.foreach(file.path, headers: true, col_sep: "\t") do |row|
audit_info = AuditInfo.create! row.to_hash
arc_info = audit_info.arc_info
arc_info.update_attribute(:status, audit_info.computed_status)
@bayendor
bayendor / unused_index.sql
Last active Aug 29, 2015 — forked from jberkus/gist:6b1bcaf7724dfc2a54f3
Finding Unused Indexes Query
View unused_index.sql
WITH table_scans as (
SELECT relid,
tables.idx_scan + tables.seq_scan as all_scans,
( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
pg_relation_size(relid) as table_size
FROM pg_stat_user_tables as tables
),
all_writes as (
SELECT sum(writes) as total_writes
FROM table_scans
@bayendor
bayendor / cleaner.rb
Last active Aug 29, 2015
Turing RegEx Cleaner
View cleaner.rb
class Cleaner
def domain_from_email(email)
email.match(/([\w+\-.]+)@([a-z\d\-.]+\.[a-z]{2,4}+)/)[2]
end
def area_code_only(phone_number)
phone_number.match(/(\+*\d{1,})*([ |\(])*(\d{3})[^\d]*(\d{3})[^\d]*(\d{4})/)[3]
end
def get_secret_message(string)
@bayendor
bayendor / into_to_sql.md
Last active Aug 29, 2015
Intro to SQL Notes
View into_to_sql.md

#What are database tables, column, and rows? What's the purpose of each?

Table is a collection of columns and rows

Column is a particular datatype, named with lowercase_separated_with_underscores

Row is a collection of data elements in a table each represented by a column, synonym for record

#How's a database similar and different from a spreadsheet?

View user_stories.rb
describe "the idea creation process", :type => :feature do
it "goes to the home page" do
visit '/'
within("#session") do
fill_in 'Title', :with => 'great idea'
fill_in 'Description', :with => 'so awesome all the things'
end
click_button 'submit'
expect(page).to have_content 'Great Idea'
end
@bayendor
bayendor / gist:bd055224d757e64c2663
Last active Aug 29, 2015
Storing State in Sessions
View gist:bd055224d757e64c2663
  1. What's the difference between a cookie and a session? A session lasts until the browser is closed, a cookie is persistent state stored in a small text file.
  2. What's serialization and how does it come into play with cookies? The cookies stores serialized data about the session.
  3. Can a cookie be shared by more than one user? How/why? Probably.
  4. What would it mean to store a shopping cart in a cookie? The shopping cart would persist from session to session.
  5. What advantages/disadvantages are there between cookie-stored carts and database-stored carts?
@bayendor
bayendor / session_example.rb
Last active Aug 29, 2015
Rails Session Use Examples
View session_example.rb
class Counter
def self.counter(session)
session[:hit_counter] ||= 0
session[:hit_counter] += 1
end
end
# access with
class ItemsController < ApplicationController
before_action :load_counter
View inject_spec.rb
require 'rspec'
def sum(numbers)
numbers.inject(0) { |sum, number| sum + number }
end
def product(numbers)
numbers.inject(1) { |sum, number| sum * number }
end
View deploy.rake
namespace :deploy do
desc "Deploys app to Github & production."
task all: :environment do
if system("rake test:all") == false
puts "The tests fail."
break
end
puts "The tests passed."
@bayendor
bayendor / arctive_record_queries.rb
Last active Aug 29, 2015
ActiveRecord Homework for Module 4 of Turing
View arctive_record_queries.rb
# Find all the items that have the word "elegant" in it.
items = Item.where("name LIKE ?", "%elegant%")
# Add three orders to a user.
3.times do |i|
user = User.first
order = Order.create!(user_id: user.id)
order.items << Item.find(i + 1)
end