Module: PostgresHelper

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

Instance Method Summary collapse

Instance Method Details

#configuration ⇒ 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 configuration
  @configuration ||=
    {
      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'
    }
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