elizabrock

1. Write a query to display all records in the orders table

SELECT * FROM orders;

2. Show me the employees whose name starts with A.

SELECT * FROM employees WHERE first_name LIKE 'A%';

Note: ILIKE can be used for case-insensitive search.

elizabrock

Final Capstone

This is the final capstone for this portion of the class.

This capstone is intended to demonstrate your mastery of basic git, project documentation (README, comments), writing unit tests, javascript, jQuery, basic-to-intermediate Angular, and basic API integrations.

Project Criteria:

• Pick a project you're excited about!
• Pick a project that demonstrates the major skills you've learned so far (see above)

elizabrock

Battleship

Basic Gameplay

1. Two players begin the game
2. Prepare for Battle
   • There's a 10 x 10 ocean grid for each player's ships
   • Each player secretly places their ships on their grid

• The ships are: 1 5sq aircraft carrier, 1 4sq battleship, 1 3sq submarine, 1 3sq destroyer and 1 2sq patrol boat

elizabrock

# this makes the "delete" key work rather than
# just entering a ~

"\e[3~": delete-char
 
# these allow you to use ctrl+left/right arrow keys
# to jump the cursor over words

"\e[5C": forward-word
"\e[5D": backward-word

elizabrock

Great Papers in Computer Science

19th Century

Lovelace, Ada Augusta (1842) "Notes on the Analytical Engine"

1930's

Aiken, Howard (1937) "Proposed Automatic Calculating Machine"

elizabrock

require 'spec_helper'

describe '/api/v2/favorites', :api do
  let!(:facility) { FactoryGirl.create(:facility) }
  let!(:user) { FactoryGirl.create(:user, facility: facility) }
  let!(:user2) { FactoryGirl.create(:user, facility: facility) }
  let!(:other_user) { FactoryGirl.create(:user, facility: facility) }
  before(:each) { user.reset_authentication_token! }

  describe 'POST' do

elizabrock

** Will - I spy with my little eye (via. Instagram)

• Andrew - LoL character simulator
• Matt O. - TeeTime - Golf platonic matchmaking
• Carter - Personal Lending Library
• Richmond - JSFiddle Clone
• Seth - Video LMS
• Amber - Recipe Tracker
• MaRisa - Concert Managment ** Chad - Foursquare of Baseball
• Adam - Boss Stalker

elizabrock

• Omniauth / OAuth (Wes)
• Testing: https://github.com/intridea/omniauth/wiki/Integration-Testing and http://cookieshq.co.uk/posts/how-to-test-facebook-login-using-devise-omniauth-rspec-and-capybara/
• VCR + Webmock (Nathan)
• ActiveAdmin (Samantha)
• kaminari (Bob)
• ActionMailer/letter_opener (Matt O)
• user stamping (Alex)
• Resque (Carter)
• Cron / Whenever (Richmond)
• Figaro (Courey)

elizabrock

• https://relishapp.com/rspec/rspec-mocks/v/3-0/docs/old-syntax/any-instance#block-implementation-is-passed-the-receiver-as-first-arg
• http://guides.rubyonrails.org/active_record_querying.html#scopes
• http://api.rubyonrails.org/classes/ActionDispatch/Routing/Mapper/Scoping.html#method-i-scope

elizabrock

class CreateLineItems < ActiveRecord::Migration
  def change
    create_table :line_items do |t|
      t.references :order
      t.references :product
      t.integer :quantity
      t.boolean :delivered
    end
  end
end