Sha256: 44d08a6b61415f79d21e47edd73e32c8f01c40844f7a85effa65969ae5dc3dfc
Contents?: true
Size: 1.05 KB
Versions: 22
Compression:
Stored size: 1.05 KB
Contents
# frozen_string_literal: true
require 'avm/instances/data/unit'
module Avm
module EacPostgresqlBase0
class Instance
class DataUnit < ::Avm::Instances::Data::Unit
EXTENSION = '.pgdump.gz'
TABLES_SQL = 'select tablename from pg_tables where schemaname = \'public\''
before_load :clear_database
def dump_command
instance.dump_gzip_command
end
def load_command
instance.load_gzip_command
end
private
def clear_database
info 'Clearing database (Dropping all tables)...'
ts = tables
if ts.empty?
info 'Database has no tables'
else
info "Removing #{ts.count} table(s)..."
run_sql('drop table ' + ts.map { |t| "\"#{t}\"" }.join(', ') + ' cascade')
end
end
def run_sql(sql)
instance.psql_command_command(sql).execute!
end
def tables
run_sql(TABLES_SQL).each_line.map(&:strip).reject(&:blank?)
end
end
end
end
end
Version data entries
22 entries across 22 versions & 2 rubygems