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