bayendor

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

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

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

#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?

bayendor

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

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

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

bayendor

require 'rspec'

def sum(numbers)
  numbers.inject(0) { |sum, number| sum + number }
end

def product(numbers)
  numbers.inject(1) { |sum, number| sum * number }
end

bayendor

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

# 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