marka2g

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

marka2g

This guide assumes that you recently run brew upgrade postgresql and discovered to your dismay that you accidentally bumped from one major version to another: say 9.3.x to 9.4.x. Yes, that is a major version bump in PG land.

First let's check something.

brew info postgresql

The top of what gets printed as a result is the most important:

marka2g

class Array
  def to_csv(csv_filename="hash.csv")
    require 'csv'
    CSV.open(csv_filename, "wb") do |csv|
      csv << first.keys # adds the attributes name on the first line
      self.each do |hash|
        csv << hash.values
      end
    end
  end

marka2g

##References

• ActiveRecord Associations

##Create Models

Create tables:

rails g model Location

rails g model User

rails g model Checkin

marka2g

# require 'active_record'
# ActiveRecord::Base.establish_connection(adapter: 'sqlite3', database: 'db.sqlite3')
#   ActiveRecord::Schema.define do
#     create_table :users, force: true do |t|
#   end
# end
class ActiveRecord::Base
  cattr_accessor :skip_callbacks
end
class User < ActiveRecord::Base

marka2g

Fixing npm On Mac OS X for Homebrew Users

Installing node through Homebrew can cause problems with npm for globally installed packages. To fix it quickly, use the solution below. An explanation is also included at the end of this document.

Solution

This solution fixes the error caused by trying to run npm update npm -g. Once you're finished, you also won't need to use sudo to install npm modules globally.

Before you start, make a note of any globally installed npm packages. These instructions will have you remove all of those packages. After you're finished you'll need to re-install them.

marka2g

Use these rapid keyboard shortcuts to control the GitHub Atom text editor on Mac OSX.

Key to the Keys

• ⌘ : Command key
• ⌃ : Control key
• ⌫ : Delete key
• ← : Left arrow key
• → : Right arrow key
• ↑ : Up arrow key

marka2g

Pry Cheat Sheet

• Youtube Tutorial 2013

Command Line

• pry -r ./config/app_init_file.rb - load your app into a pry session (look at the file loaded by config.ru)
• pry -r ./config/environment.rb - load your rails into a pry session

Debugger

marka2g

require 'rails_helper'

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

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

marka2g

Output Hour Tracking

Hours(Current)

Date	Hours Spent	Daily Total	Running Totals
09-05-18	signed full-time cont		16
09-04-18	10am - 6pm	(-1 hours for lunch)	16
08-31-18	11am - 3pm	3 (-1 hours for lunch)	10
08-30-18	10am - 6pm	7 (-1 hours for lunch)	7