Diego Camacho hackvan

Prereq:

apt-get install zsh
apt-get install git-core

Getting zsh to work in ubuntu is weird, since sh does not understand the source command. So, you do this to install zsh

wget https://github.com/robbyrussell/oh-my-zsh/raw/master/tools/install.sh -O - | zsh

Title

<Additional information about your API call. Try to use verbs that match both request type (fetching vs modifying) and plurality (one vs multiple).>

URL

<The URL Structure (path only, no root url)>
Method:

Chapter 1

Every programming community quickly converges on a style, an accepted set of idioms. Programming is all about communication and knowing those idioms are key to being a successful programmer in that community.

Ruby style of programming:

Code should be crystal clear, it should shout its intent
Good code is also concise

Ruby indentation convention:

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Parse JSON in PL/SQL

Download and install PL/JSON.

Following is an example of how to parse a JSON array represented as string:

declare
	my_clob clob := '[

	DROP TYPE Student;
	DROP TYPE Person;

	CREATE OR REPLACE TYPE Person As Object (
	firstName VARCHAR2(30),
	lastName VARCHAR2(30),
	phoneNumber CHAR(10)
	) NOT FINAL;
	/
	CREATE OR REPLACE TYPE Student UNDER Person (

	# encoding: utf-8
	#
	# Prerequisite:
	# gem install ruby-oci8

	require 'oci8'

	def log(message)
	puts "#{Time.now.strftime("%Y-%m-%d %H:%M:%S")} #{message}"
	end

	# coding:utf-8
	# usage: ruby oracle_to_csv.rb > sample.csv
	require 'rubygems'
	require 'oci8' # before you need install : gem install ruby-oci8

	def csvout(user, pass, world, sql)
	begin
	ora = OCI8.new(user,pass,world)
	c = ora.exec(sql)

	################################################################################
	require 'oci8'
	require 'iconv'

	################################################################################
	class OracleReader
	################################################################################
	def initialize(server, username, password)
	# Open the connection.
	@connection = OCI8.new(username, password, server)

	# Based on https://gist.github.com/fernandoaleman/5083680

	# Start the old vagrant
	$ vagrant init ubuntu_saucy
	$ vagrant up

	# You should see a message like:
	# [default] The guest additions on this VM do not match the install version of
	# VirtualBox! This may cause things such as forwarded ports, shared
	# folders, and more to not work properly. If any of those things fail on