class DbDumper::Configuration::Postgres

Public Instance Methods

copy_data_command(sql, file_path) click to toggle source
# File lib/db_dumper/configuration/postgres.rb, line 4
def copy_data_command(sql, file_path)
  "\\COPY (#{sql}) TO '#{file_path}';"
end
dump_data_command(dump_data_file_path) click to toggle source
# File lib/db_dumper/configuration/postgres.rb, line 17
def dump_data_command(dump_data_file_path)
  util_command('psql', "#{db_config.dump_copy_options} -c \"#{dump_data_file_path}\"")
end
dump_schema_command(dump_schema_file_path) click to toggle source
# File lib/db_dumper/configuration/postgres.rb, line 8
def dump_schema_command(dump_schema_file_path)
  util_command('pg_dump', "#{db_config.dump_schema_options} -f #{dump_schema_file_path}")
end
dump_table_data_command(dumped_tables, dump_table_data_file_path) click to toggle source
# File lib/db_dumper/configuration/postgres.rb, line 12
def dump_table_data_command(dumped_tables, dump_table_data_file_path)
  joined_tables = "-t #{dumped_tables.join(' -t ')}"
  util_command('pg_dump', "#{db_config.dump_data_options} #{joined_tables} -f #{dump_table_data_file_path}")
end

Private Instance Methods

util_command(util, command) click to toggle source
# File lib/db_dumper/configuration/postgres.rb, line 23
      def util_command(util, command)
        <<-CMD.squish
          PGPASSWORD=#{db_config.password} #{util}
            -h #{db_config.host}
            -p #{db_config.port}
            -U #{db_config.username}
            -d #{db_config.database}
          #{command}
        CMD
      end