def update_db():
"""
This function handles update of an existing database
"""
try:
db_version, db_file_path = get_db_file(GLSettings.db_path)
if db_version == 0:
return 0
from globaleaks.db import migration
log.err("Found an already initialized database version: %d" %
db_version)
if db_version >= FIRST_DATABASE_VERSION_SUPPORTED and db_version < DATABASE_VERSION:
log.err(
"Performing schema migration from version %d to version %d" %
(db_version, DATABASE_VERSION))
migration.perform_schema_migration(db_version)
log.err("Migration completed with success!")
else:
log.err('Performing data update')
# TODO on normal startup this line is run. We need better control flow here.
migration.perform_data_update(
os.path.abspath(
os.path.join(GLSettings.db_path,
'glbackend-%d.db' % DATABASE_VERSION)))
except Exception as exception:
log.err("Migration failure: %s" % exception)
log.err("Verbose exception traceback:")
etype, value, tback = sys.exc_info()
log.info('\n'.join(traceback.format_exception(etype, value, tback)))
return -1
def perform_system_update():
"""
This function checks the system and database versions and executes migration
routines based on the system's state. After this function has completed the
node is either ready for initialization (0), running a version of the DB
(>1), or broken (-1).
"""
from globaleaks.db import migration
db_files = []
max_version = 0
min_version = 0
for filename in os.listdir(GLSettings.db_path):
if filename.startswith('glbackend'):
filepath = os.path.join(GLSettings.db_path, filename)
if filename.endswith('.db'):
db_files.append(filepath)
nameindex = filename.rfind('glbackend')
extensindex = filename.rfind('.db')
fileversion = int(filename[nameindex + len('glbackend-'):extensindex])
max_version = fileversion if fileversion > max_version else max_version
min_version = fileversion if fileversion < min_version else min_version
db_version = max_version
if len(db_files) > 1:
log.msg("Error: Cannot start the application because more than one database file are present in: %s" % GLSettings.db_path)
log.msg("Manual check needed and is suggested to first make a backup of %s\n" % GLSettings.working_path)
log.msg("Files found:")
for f in db_files:
log.msg("\t%s" % f)
return -1
if len(db_files) == 1:
log.msg("Found an already initialized database version: %d" % db_version)
if db_version < DATABASE_VERSION:
log.msg("Performing schema migration from version %d to version %d" % (db_version, DATABASE_VERSION))
try:
migration.perform_schema_migration(db_version)
except Exception as exception:
log.msg("Migration failure: %s" % exception)
log.msg("Verbose exception traceback:")
etype, value, tback = sys.exc_info()
log.msg('\n'.join(traceback.format_exception(etype, value, tback)))
return -1
log.msg("Migration completed with success!")
else:
log.msg('Performing data update')
migration.perform_data_update(os.path.abspath(os.path.join(GLSettings.db_path, 'glbackend-%d.db' % DATABASE_VERSION)))
return db_version
def perform_system_update():
"""
This function checks the system and database versions and executes migration
routines based on the system's state. After this function has completed the
node is either ready for initialization (0), running a version of the DB
(>1), or broken (-1).
"""
from globaleaks.db import migration
db_files = []
max_version = 0
min_version = 0
for filename in os.listdir(GLSettings.db_path):
if filename.startswith('glbackend'):
filepath = os.path.join(GLSettings.db_path, filename)
if filename.endswith('.db'):
db_files.append(filepath)
nameindex = filename.rfind('glbackend')
extensindex = filename.rfind('.db')
fileversion = int(filename[nameindex +
len('glbackend-'):extensindex])
max_version = fileversion if fileversion > max_version else max_version
min_version = fileversion if fileversion < min_version else min_version
db_version = max_version
if len(db_files) > 1:
log.msg(
"Error: Cannot start the application because more than one database file are present in: %s"
% GLSettings.db_path)
log.msg(
"Manual check needed and is suggested to first make a backup of %s\n"
% GLSettings.working_path)
log.msg("Files found:")
for f in db_files:
log.msg("\t%s" % f)
return -1
if len(db_files) == 1:
log.msg("Found an already initialized database version: %d" %
db_version)
if db_version < DATABASE_VERSION:
log.msg(
"Performing schema migration from version %d to version %d" %
(db_version, DATABASE_VERSION))
try:
migration.perform_schema_migration(db_version)
except Exception as exception:
log.msg("Migration failure: %s" % exception)
log.msg("Verbose exception traceback:")
etype, value, tback = sys.exc_info()
log.msg('\n'.join(
traceback.format_exception(etype, value, tback)))
return -1
log.msg("Migration completed with success!")
else:
log.msg('Performing data update')
migration.perform_data_update(
os.path.abspath(
os.path.join(GLSettings.db_path,
'glbackend-%d.db' % DATABASE_VERSION)))
return db_version