Contents

# frozen_string_literal: true

module UffDbLoader
  module Postgresql
    def self.dump_extension
      "dump"
    end

    def self.dump_command_template
      "ssh %user%@%host% \"docker exec -i %app_name%_%environment%_db sh -c 'exec pg_dump --username \\$POSTGRES_USER --clean --no-owner --no-acl --format=c %database%'\" > %target%"
    end

    def self.restore_command(database_name, result_file_path)
      "pg_restore --username postgres --clean --if-exists --no-owner --no-acl --dbname #{database_name} #{result_file_path}"
    end

    def self.list_databases
      ActiveRecord::Base
        .connection
        .execute("SELECT datname FROM pg_database;")
        .values
        .flatten
    end

    def self.create_database(database_name)
      ActiveRecord::Base.connection.execute("CREATE DATABASE #{database_name};")
    end

    def self.drop_database(database_name)
      ActiveRecord::Base.connection.execute("DROP DATABASE IF EXISTS #{database_name};")
    end
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
uff_db_loader-2.1.0	lib/uff_db_loader/postgresql.rb
uff_db_loader-2.0.1	lib/uff_db_loader/postgresql.rb
uff_db_loader-2.0.0	lib/uff_db_loader/postgresql.rb
uff_db_loader-1.4.0	lib/uff_db_loader/postgresql.rb
uff_db_loader-1.3.0	lib/uff_db_loader/postgresql.rb
uff_db_loader-1.2.0	lib/uff_db_loader/postgresql.rb
uff_db_loader-1.1.1	lib/uff_db_loader/postgresql.rb