Friday, 5 July 2013

List all tasks from your custom rake file

namespace :my_application do |ns|
  desc "Lists all tasks available"
  task :tasklist do
    ns.tasks.each do |t|
      name   = t.name_with_args
      spaces = name.length >= 25 ? "\t" : "\t\t" # hack for spacing
      puts name + spaces + t.comment.to_s
    end
  end
end

Thursday, 4 July 2013

Postgres - SQL to get rows count for all tables

SELECT relname, n_tup_ins - n_tup_del as rowcount FROM pg_stat_all_tables where (n_tup_ins - n_tup_del) > 0 AND relname NOT LIKE 'pg_%';