MatthewRDodds

Helpful Psql Commands Cheat Sheet

Compiling a list of helpful postgres commands as I use them

See schemas with permissions

\dn+

MatthewRDodds

require 'active_support'

job = Sidekiq::RetrySet.new.to_a[0]

job.item['class'].constantize.new.perform(*job.args)

MatthewRDodds

pry(main)> id
=> BSON::ObjectId('5537c5a93338660008010000')

pry(main)> id.to_s # Converting to string
=> "5537c5a93338660008010000"

pry(main)> BSON::ObjectId.from_string id.to_s # Converting from String
=> BSON::ObjectId('5537c5a93338660008010000')

MatthewRDodds

street,city,zip,state,beds,baths,sq__ft,type,sale_date,price,latitude,longitude
3526 HIGH ST,SACRAMENTO,95838,CA,2,1,836,Residential,Wed May 21 00:00:00 EDT 2008,59222,38.631913,-121.434879
51 OMAHA CT,SACRAMENTO,95823,CA,3,1,1167,Residential,Wed May 21 00:00:00 EDT 2008,68212,38.478902,-121.431028
2796 BRANCH ST,SACRAMENTO,95815,CA,2,1,796,Residential,Wed May 21 00:00:00 EDT 2008,68880,38.618305,-121.443839
2805 JANETTE WAY,SACRAMENTO,95815,CA,2,1,852,Residential,Wed May 21 00:00:00 EDT 2008,69307,38.616835,-121.439146
6001 MCMAHON DR,SACRAMENTO,95824,CA,2,1,797,Residential,Wed May 21 00:00:00 EDT 2008,81900,38.51947,-121.435768
5828 PEPPERMILL CT,SACRAMENTO,95841,CA,3,1,1122,Condo,Wed May 21 00:00:00 EDT 2008,89921,38.662595,-121.327813
6048 OGDEN NASH WAY,SACRAMENTO,95842,CA,3,2,1104,Residential,Wed May 21 00:00:00 EDT 2008,90895,38.681659,-121.351705
2561 19TH AVE,SACRAMENTO,95820,CA,3,1,1177,Residential,Wed May 21 00:00:00 EDT 2008,91002,38.535092,-121.481367
11150 TRINITY RIVER DR Unit 114,RANCHO CORDOV

MatthewRDodds

sudo launchctl stop homebrew.mxcl.dnsmasq
sudo launchctl start homebrew.mxcl.dnsmasq

MatthewRDodds

I have:

location /some/path {
	proxy_pass http://other_server/;
}

works as expected:

curl http://server.com/some/path

MatthewRDodds

docker run --rm -v=$PWD:/usr/src/app visualjeff/ember-cli:0.1.12 bash -c "cd /usr/src/app; npm install; bower install --allow-root; ember build"

docker run --rm -v=`pwd`:/usr/src/app -t visualjeff/ember-cli:0.1.12 /bin/bash -c "cd /usr/src/app; npm install; bower install --allow-root; ember build"

docker run --rm  -e "EMBER_ENV=$RAILS_ENV" -v=`pwd`:/usr/src/app visualjeff/ember-cli:0.1.12 bash -c "cd /usr/src/app; npm install; bower install --allow-root; ember build --environment $EMBER_ENV"

docker run --rm  -e "EMBER_ENV=qa" -v=`pwd`:/usr/src/app visualjeff/ember-cli:0.1.12 bash -c "cd /usr/src/app; npm install --force; bower install --force --allow-root; ember build --environment $EMBER_ENV"

MatthewRDodds

module FooBar
  def foo_bar(arg)
    puts arg
    super
  end
end

module Foo
  class Bar
    include FooBar

MatthewRDodds

cd /builds

docker build --tag=tag .

docker run -d tag

docker exec -it container bash

MatthewRDodds

require 'active_record'
require 'sqlite3'

ActiveRecord::Base.establish_connection( adapter: 'sqlite3', database: ":memory:" )

ActiveRecord::Schema.define(version: 1) do
  create_table :articles do |t|
    t.string  :title
    t.date    :published_at
    t.timestamps