brossetti1

http://awesome-ruby.com/

##################PRODUCTION##################
# pry rails for heroku and dev - https://github.com/rweng/pry-rails
group :development, :test do
  gem 'pry-rails'
  gem 'pry-byebug'
  gem 'pry-remote'
  gem 'pry-nav'
  gem 'pry-toys'

brossetti1

=Navigating=
    visit('/projects')
    visit(post_comments_path(post))

=Clicking links and buttons=
    click_link('id-of-link')
    click_link('Link Text')
    click_button('Save')
    click('Link Text') # Click either a link or a button
    click('Button Value')

brossetti1

# This is a skeleton for testing models including examples of validations, callbacks,
# scopes, instance & class methods, associations, and more.
# Pick and choose what you want, as all models don't NEED to be tested at this depth.
#
# I'm always eager to hear new tips & suggestions as I'm still new to testing,
# so if you have any, please share!
#
# @kyletcarlson
#
# This skeleton also assumes you're using the following gems: 

brossetti1

## From Lynda.com course 'RSpec Testing Framework with Ruby'

describe 'Expectation Matchers' do
  
  describe 'equivalence matchers' do

    it 'will match loose equality with #eq' do
      a = "2 cats"
      b = "2 cats"
      expect(a).to eq(b)

brossetti1

require 'rails_helper'

RSpec.describe TodosController, :type => :controller do

  context "GET index" do
  #context "POST create" do
  #context "GET show" do
  #context "PATCH update" do (or PUT update)
  #context "DELETE destroy" do
  #context "GET new" do

brossetti1

PostgreSQL Cheatsheet

PSQL main commands

Opening PostgreSQL console:

psql -h <hostname> -U <user> <db> # db is optional

Working with pgsql console

brossetti1

PostgreSQL & PostGIS Cheatsheet

This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.

TOC

• Installing Postgres & PostGIS
• Using Postgres on the command line: PSQL
• Importing Data into Postgres
• Exporting Data from Postgres
• Joining Tables

brossetti1

-- SQL Basic Syntax -- 

--initialize SQLite database w/ command line:
sqlite3 database_name.db

--helpful commands
.help -- list of commands
.tables -- see all tables
.mode column / .header on -- helpful for viewing

brossetti1

PSQL - 00000001

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

brossetti1

BASH CHEAT SHEET - 0000001

This file contains short tables of commonly used items in this shell. In most cases the information applies to both the Bourne shell (sh) and the newer bash shell.

Tests (for ifs and loops) are done with [ ] or with the test command.

Checking files:

-r file    # Check if file is readable.