andreleoni

# Vai até a respectiva branch
git checkout dest-branch

# Puxa todas as alterações do git
git fetch --all

# Reseta a branch para a master
git reset --hard origin/master

# Faz merge com sua branch

andreleoni

# DUMP
pg_dump dbname > outfile

# RESTORE DUMP
psql dbname < infile

# CREATE DB
createdb [connection-option...] [option...] [dbname] [description]

# DROP DB

andreleoni

#!/bin/env ruby

# lazy hack from Robert Klemme

module Memory
  # sizes are guessed, I was too lazy to look
  # them up and then they are also platform
  # dependent
  REF_SIZE = 4 # ?
  OBJ_OVERHEAD = 4 # ?

andreleoni

# Create groups
sudo groupadd www-data

# Add users to group
sudo usermod -a -G www-data $(whoami)
sudo usermod -a -G www-data root

# Add users to www-data
sudo usermod -a -G www-data root

andreleoni

# Access crontab -e
crontab -e

# Create a CRON like this
30 10 * * * ~/autobackup.sh

# Create autobackup file
touch ~/autobackup.sh

# autobackup.sh content

andreleoni

rake db:drop
git checkout master db/structure.sql
rake db:create
rake db:structure:load
rake db:migrate

andreleoni

 ActiveRecord::Base.connection.tables.each do |table|
  indexes = ActiveRecord::Base.connection.indexes(table)
  if indexes.length > 0
    puts "====>  #{table} <===="
    indexes.each do |ind|
      puts "----> #{ind.name}"
    end
    puts "====>  #{table} <===="
    2.times{ puts ''}
  end

andreleoni

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

andreleoni

module WithSelfClass
  class << self
    def my_function
      "Presenter"
    end
  end
end

class MyClassWithSelfClass
  extend WithSelfClass

andreleoni

annotate --show-indexes --exclude tests,fixtures,factories,serializers --show-foreign-keys