def dump(self):
"""
Dump the database using the postgres custom format
"""
dumpfile = self.args.dumpfile
if not dumpfile:
db, env = self.get_db_args_env()
dumpfile = fileutils.timestamp_filename(
'omero-database-%s' % db['name'], 'pgdump')
log.info('Dumping database to %s', dumpfile)
if not self.args.dry_run:
self.pgdump('-Fc', '-f', dumpfile)
def initialise(self):
omerosql = self.args.omerosql
if not omerosql:
omerosql = fileutils.timestamp_filename('omero', 'sql')
log.info('Creating SQL: %s', omerosql)
if not self.args.dry_run:
self.external.omero_cli(
["db", "script", "-f", omerosql, "", "",
self.args.rootpass])
elif os.path.exists(omerosql):
log.info('Using existing SQL: %s', omerosql)
else:
log.error('SQL file not found: %s', omerosql)
raise Stop(40, 'SQL file not found')
log.info('Creating database using %s', omerosql)
if not self.args.dry_run:
self.psql('-f', omerosql)
def init(self):
omerosql = self.args.omerosql
autoupgrade = False
if not omerosql:
omerosql = fileutils.timestamp_filename('omero', 'sql')
log.info('Creating SQL: %s', omerosql)
if not self.args.dry_run:
self.external.omero_cli(
["db", "script", "-f", omerosql, "", "",
self.args.rootpass])
elif os.path.exists(omerosql):
log.info('Using existing SQL: %s', omerosql)
autoupgrade = True
else:
log.error('SQL file not found: %s', omerosql)
raise Stop(40, 'SQL file not found')
log.info('Creating database using %s', omerosql)
if not self.args.dry_run:
self.psql('-f', omerosql)
if autoupgrade:
self.upgrade()
