Sha256: e417206decd2098c65fe889e218cbd92ad55c5218417cbbb64bc2fa342510dd3
Contents?: true
Size: 1006 Bytes
Versions: 46
Compression:
Stored size: 1006 Bytes
Contents
module Dataset
module Database # :nodoc:
# The interface to a PostgreSQL database, this will capture by creating a dump
# file and restore by loading one of the same.
#
class Postgresql < Base
def initialize(database_spec, storage_path)
@database = database_spec[:database]
@username = database_spec[:username]
@password = database_spec[:password]
@storage_path = storage_path
FileUtils.mkdir_p(@storage_path)
end
def capture(datasets)
return if datasets.nil? || datasets.empty?
`pg_dump -c #{@database} > #{storage_path(datasets)}`
end
def restore(datasets)
store = storage_path(datasets)
if File.file?(store)
`psql -U #{@username} -p #{@password} -e #{@database} < #{store}`
true
end
end
def storage_path(datasets)
"#{@storage_path}/#{datasets.collect {|c| c.__id__}.join('_')}.sql"
end
end
end
end
Version data entries
46 entries across 46 versions & 8 rubygems