Module: PostgresHelper

Defined in:
lib/capistrano/ops/rails/lib/tasks/pg/postgres_helper.rb

Instance Method Summary collapse

Instance Method Details

#configs ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
15
16
 
# File 'lib/capistrano/ops/rails/lib/tasks/pg/postgres_helper.rb', line 4

def configs
  @configs ||= {
    database: Rails.configuration.database_configuration[Rails.env]['database'],
    username: Rails.configuration.database_configuration[Rails.env]['username'],
    password: Rails.configuration.database_configuration[Rails.env]['password'],
    hostname: Rails.configuration.database_configuration[Rails.env]['host'],
    portnumber: Rails.configuration.database_configuration[Rails.env]['port'],
    backup_path: Rails.root.join(Rails.env.development? ? 'tmp/backups' : '../../shared/backups').to_s,
    backups_enabled: Rails.env.production? || ENV['BACKUPS_ENABLED'] == 'true',
    external_backup: Rails.env.production? || ENV['EXTERNAL_BACKUP_ENABLED'] == 'true',
    filename: "#{Rails.configuration.database_configuration[Rails.env]['database']}_#{Time.now.to_i}.dump"
  }
end

#content(result, settings = {}) ⇒ Object 



22
23
24
25
26
27
28
29
30
31
32
33
34
35
 
# File 'lib/capistrano/ops/rails/lib/tasks/pg/postgres_helper.rb', line 22

def content(result, settings = {})
  database = settings[:database]
  backup_path = settings[:backup_path]
  filename = settings[:filename]

  messages = []
  if result
    messages << "Backup of #{database} successfully finished at #{Time.now}"
    messages << "Backup path:\`#{backup_path}/#{filename}\`"
  else
    messages << "Backup of #{database} failed at #{Time.now}"
  end
  messages.join("\n")
end

#dump_cmd(settings = {}) ⇒ Object 



37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
 
# File 'lib/capistrano/ops/rails/lib/tasks/pg/postgres_helper.rb', line 37

def dump_cmd(settings = {})
  hostname = settings[:hostname]
  database = settings[:database]
  username = settings[:username]
  password = settings[:password]
  portnumber = settings[:portnumber]
  backup_path = settings[:backup_path]

  date = Time.now.to_i
  options = []
  options << " -d #{database}" if database.present?
  options << " -U #{username}" if username.present?
  options << " -h #{hostname}" if hostname.present?
  options << " -p #{portnumber}" if portnumber.present?

  filename = "#{database}_#{date}.dump"

  commandlist = []
  commandlist << "export PGPASSWORD='#{password}'"
  commandlist << "cd #{backup_path}"
  commandlist << "pg_dump --no-acl --no-owner #{options.join('')} > #{filename}"
  commandlist.join(' && ')
end

#size_str(size) ⇒ Object 



61
62
63
64
65
66
 
# File 'lib/capistrano/ops/rails/lib/tasks/pg/postgres_helper.rb', line 61

def size_str(size)
  units = %w[B KB MB GB TB]
  e = (Math.log(size) / Math.log(1024)).floor
  s = format('%.2f', size.to_f / 1024**e)
  s.sub(/\.?0*$/, units[e])
end

#title ⇒ Object 



18
19
20
 
# File 'lib/capistrano/ops/rails/lib/tasks/pg/postgres_helper.rb', line 18

def title
  ENV['DEFAULT_URL'] || "#{Rails.env} Backup"
end