SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' ORDER BY table_name ASC
SELECT column_name FROM information_schema.columns WHERE table_name ='training_contracts' ORDER BY column_name ASC;
# 0. Make sure you have Ruby 1.9.3 installed, and optionally RVM and PostgreSQL | |
# 0.2 If you are on the Mac, make sure you have a c compiler by installing XCode Command Line Tools or gcc4.2 with homebrew | |
# https://github.com/mxcl/homebrew/wiki/Custom-GCC-and-cross-compilers | |
# 0.5 Make sure you have bundler version ~> 1.2 as Rails depends on it | |
gem install bundler | |
# 1. Get edge Rails source (master branch) | |
git clone https://github.com/rails/rails.git |
SELECT setval('table_id_seq', (SELECT MAX(id) FROM table)); |
heroku pgbackups:capture
curl -o latest.dump `heroku pgbackups:url`
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump
Recipe: postgresql::server_debian | |
* package[postgresql-9.2] action install[2013-05-12T07:44:03+02:00] INFO: Processing package[postgresql-9.2] action install (postgresql::server_debian line 26) | |
[2013-05-12T07:44:03+02:00] DEBUG: package[postgresql-9.2] checking package status for postgresql-9.2 | |
postgresql-9.2: | |
Installed: 9.2.4-0ppa1~lucid | |
Candidate: 9.2.4-0ppa1~lucid | |
Version table: | |
*** 9.2.4-0ppa1~lucid 0 | |
500 http://ppa.launchpad.net/pitti/postgresql/ubuntu/ lucid/main Packages | |
100 /var/lib/dpkg/status |
#!/bin/zsh | |
/usr/bin/vagrant destroy --force | |
yes | knife client delete {NODE_NAME} | |
yes | knife node delete {NODE_NAME} | |
/usr/bin/vagrant up | |
knife bootstrap localhost --node-name {NODE_NAME} --ssh-user vagrant --ssh-password vagrant --ssh-port 2222 --sudo | |
/usr/bin/vagrant provision |
class Animal | |
constructor: (@name) -> | |
move: (meters, direction = "north") -> | |
console.log @name + " moved #{direction} #{meters}m." | |
class Snake extends Animal | |
move: (direction = "south", meters = 5) -> | |
console.log "Slithering..." | |
super meters, direction |
app.users.find_by!(:identifier => identifier).tap do |user| | |
user.verify! | |
end | |
user = app.users.find_by!(:identifier => identifier) | |
user.verify! | |
user |
#assuming a method returning an account | |
Account.where(email: email).first_or_create.tap do |account| | |
account.update_attributes!(name: name, login: login, image: image) | |
end | |
account = Account.where(email: email).first_or_create | |
account.update_attributes!(name: name, login: login, image: image) | |
account |