def upgrade(self, dbname, db):
"""Upgrade all schemas in single db."""
curs = db.cursor()
ignore = {}
for schema, ver, fn, recheck_func in version_list:
# skip schema?
if schema in ignore:
continue
if not skytools.exists_schema(curs, schema):
ignore[schema] = 1
continue
# new enough?
ok, oldver = check_version(curs, schema, ver, recheck_func, self.options.force)
if ok:
continue
# too old schema, no way to upgrade
if fn is None:
self.log.info('%s: Cannot upgrade %s, too old version', dbname, schema)
ignore[schema] = 1
continue
if self.options.not_really:
self.log.info ("%s: Would upgrade '%s' version %s to %s", dbname, schema, oldver, ver)
continue
curs = db.cursor()
curs.execute('begin')
self.log.info("%s: Upgrading '%s' version %s to %s", dbname, schema, oldver, ver)
skytools.installer_apply_file(db, fn, self.log)
curs.execute('commit')
def upgrade(self, dbname, db):
"""Upgrade all schemas in single db."""
curs = db.cursor()
ignore = {}
for schema, ver, fn, recheck_func in version_list:
# skip schema?
if schema in ignore:
continue
if not skytools.exists_schema(curs, schema):
ignore[schema] = 1
continue
# new enough?
if check_version(curs, schema, ver, recheck_func):
continue
# too old schema, no way to upgrade
if fn is None:
self.log.info('%s: Cannot upgrade %s, too old version', dbname, schema)
ignore[schema] = 1
continue
curs = db.cursor()
curs.execute('begin')
skytools.installer_apply_file(db, fn, self.log)
curs.execute('commit')
def upgrade(self, db):
curs = db.cursor()
for schema, ver, sql, recheck_fn in version_list:
if not skytools.exists_schema(curs, schema):
continue
if check_version(curs, schema, ver, recheck_fn):
continue
fn = "upgrade/final/%s" % sql
skytools.installer_apply_file(db, fn, self.log)
def upgrade(self, db):
curs = db.cursor()
for schema, ver, sql, recheck_fn in version_list:
if not skytools.exists_schema(curs, schema):
continue
if check_version(curs, schema, ver, recheck_fn):
continue
fn = "upgrade/final/%s" % sql
skytools.installer_apply_file(db, fn, self.log)
def upgrade(self, dbname, db):
"""Upgrade all schemas in single db."""
curs = db.cursor()
ignore = {}
for schema, ver, fn, recheck_func in version_list:
# skip schema?
if schema in ignore:
continue
if not skytools.exists_schema(curs, schema):
ignore[schema] = 1
continue
# new enough?
ok, oldver = check_version(curs, schema, ver, recheck_func)
if ok:
continue
# too old schema, no way to upgrade
if fn is None:
self.log.info('%s: Cannot upgrade %s, too old version', dbname,
schema)
ignore[schema] = 1
continue
if self.options.not_really:
self.log.info("%s: Would upgrade '%s' version %s to %s",
dbname, schema, oldver, ver)
continue
curs = db.cursor()
curs.execute('begin')
self.log.info("%s: Upgrading '%s' version %s to %s", dbname,
schema, oldver, ver)
skytools.installer_apply_file(db, fn, self.log)
curs.execute('commit')