Magic words:
psql -U postgresIf 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 *.*
| CREATE OR REPLACE | |
| PROCEDURE CREATE_RPL2( | |
| p_order_item_id IN ORDER_ITEM_PRICES.ORDER_ITEM_PRICE_ID%TYPE, | |
| p_rpl IN ORDER_ITEM_PRICES.PRICE%TYPE, | |
| p_start_day IN NUMBER, | |
| p_created_by IN ORDER_ITEM_PRICES.CREATED_BY%TYPE) | |
| IS | |
| V_ORDER_MONTH NUMBER; | |
| V_ORDER_YEAR NUMBER; | |
| V_MONTH_END NUMBER; |
| 101687767 | |
| 101808423 | |
| 102049377 | |
| 102570381 | |
| 102802964 | |
| 102820901 | |
| 102843596 | |
| 103045972 | |
| 103088787 | |
| 103106751 |
| express = require 'express' | |
| app = express(); | |
| # Configure | |
| require('./config')(app) | |
| # Routes | |
| require('./routes')(app) | |
| module.exports = app |
| Modular Express Setup with CoffeeScript | |
| https://gist.github.com/padwasabimasala/9744843 | |
| Test Express with Supertest | |
| https://github.com/visionmedia/supertest | |
| Mocha & CoffeeScript Setup |
| require 'logger' | |
| class Builder | |
| attr :base_dir, :repo, :build_dir, :log | |
| def initialize(dir) | |
| @base_dir = File.expand_path dir | |
| @repo = File.join base_dir, "#{base_dir.split(File::SEPARATOR).last}.git" | |
| @build_dir = File.join base_dir, 'builds', latest_commit | |
| @log = Logger.new STDERR #File.join @base_dir, 'build.log' |
| #!/bin/bash | |
| init() { | |
| mkdir $name | |
| cd $name | |
| echo "{\"name\": \"$name\"}" > package.json | |
| npm install --save coffee-script | |
| } |
| #!/bin/bash | |
| export PATH='/home/git/jruby-1.7.11/bin':$PATH | |
| webapps=/opt/tomcat_ruby/webapps | |
| base=/home/git/passport | |
| repo=$base/passport.git | |
| latest_commit=$(cd $repo && git log --pretty=oneline -n1 |cut -d' ' -f1) | |
| build_dir=$base/builds/$latest_commit | |
| function run { |
| HOST=${1-https://vision.appreciatehub.com} | |
| API=$HOST/api | |
| if test -z $CLIENT_ID || test -z $CLIENT_SECRET; then | |
| echo CLIENT_ID or CLIENT_SECRET not set in the ENV >&2 | |
| exit 1 | |
| fi | |
| parse() { | |
| jq $1 |sed -e 's/"//g' |
| # DRAFT - Event Publishing Spec | |
| The purpose of this doc is to define some simple guidelines for event publishing to be used on our teams | |
| ## Why publish events? | |
| ## What is a domain? | |
| ## Queue Names | |
| environment . product/dept . domain . eventType |