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 *.*
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 |