Class: Backup::Database

Inherits:
Object
  • Object
show all
Defined in:
lib/backup/database.rb

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initializeDatabase

Returns a new instance of Database


7
8
9
10
# File 'lib/backup/database.rb', line 7

def initialize
  @config = YAML.load_file(File.join(Rails.root,'config','database.yml'))[Rails.env]
  @db_file_name = File.join(Gitlab.config.backup.path, 'db', 'database.sql.gz')
end

Instance Attribute Details

#configObject (readonly)

Returns the value of attribute config


5
6
7
# File 'lib/backup/database.rb', line 5

def config
  @config
end

#db_file_nameObject (readonly)

Returns the value of attribute db_file_name


5
6
7
# File 'lib/backup/database.rb', line 5

def db_file_name
  @db_file_name
end

Instance Method Details

#dumpObject


12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
# File 'lib/backup/database.rb', line 12

def dump
  FileUtils.mkdir_p(File.dirname(db_file_name))
  FileUtils.rm_f(db_file_name)
  compress_rd, compress_wr = IO.pipe
  compress_pid = spawn(*%W(gzip -1 -c), in: compress_rd, out: [db_file_name, 'w', 0600])
  compress_rd.close

  dump_pid = case config["adapter"]
  when /^mysql/ then
    $progress.print "Dumping MySQL database #{config['database']} ... "
    # Workaround warnings from MySQL 5.6 about passwords on cmd line
    ENV['MYSQL_PWD'] = config["password"].to_s if config["password"]
    spawn('mysqldump', *mysql_args, config['database'], out: compress_wr)
  when "postgresql" then
    $progress.print "Dumping PostgreSQL database #{config['database']} ... "
    pg_env
    pgsql_args = ["--clean"] # Pass '--clean' to include 'DROP TABLE' statements in the DB dump.
    if Gitlab.config.backup.pg_schema
      pgsql_args << "-n"
      pgsql_args << Gitlab.config.backup.pg_schema
    end
    spawn('pg_dump', *pgsql_args, config['database'], out: compress_wr)
  end
  compress_wr.close

  success = [compress_pid, dump_pid].all? { |pid| Process.waitpid(pid); $?.success? }

  report_success(success)
  abort 'Backup failed' unless success
end

#restoreObject


43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
# File 'lib/backup/database.rb', line 43

def restore
  decompress_rd, decompress_wr = IO.pipe
  decompress_pid = spawn(*%W(gzip -cd), out: decompress_wr, in: db_file_name)
  decompress_wr.close

  restore_pid = case config["adapter"]
  when /^mysql/ then
    $progress.print "Restoring MySQL database #{config['database']} ... "
    # Workaround warnings from MySQL 5.6 about passwords on cmd line
    ENV['MYSQL_PWD'] = config["password"].to_s if config["password"]
    spawn('mysql', *mysql_args, config['database'], in: decompress_rd)
  when "postgresql" then
    $progress.print "Restoring PostgreSQL database #{config['database']} ... "
    pg_env
    spawn('psql', config['database'], in: decompress_rd)
  end
  decompress_rd.close

  success = [decompress_pid, restore_pid].all? { |pid| Process.waitpid(pid); $?.success? }

  report_success(success)
  abort 'Restore failed' unless success
end