def update(form: Any) -> None:
for field in form:
if field.type in ['CSRFTokenField', 'HiddenField', 'SubmitField']:
continue
value = field.data
if field.type == 'BooleanField':
value = 'True' if field.data else ''
Db.update(field.name, value)
def get_settings() -> Dict[str, Any]:
settings: Dict[str, Union[int, str, List[str]]] = {}
for name in app.config[
'MODULES']: # Set empty in case it doesn't exist, e.g. after upgrade
settings['module_' + name] = ''
for row in Db.get_settings():
settings[row['name']] = row['value']
if row['name'] in [
'table_rows', 'failed_login_forget_minutes',
'failed_login_tries', 'file_upload_max_size',
'minimum_password_length', 'random_password_length',
'reset_confirm_hours'
]:
settings[row['name']] = int(row['value'])
if row['name'] in [
'mail_recipients_feedback', 'file_upload_allowed_extension'
]:
settings[row['name']] = row['value'].split(' ')
return settings
def get_settings() -> dict[str, Any]:
settings: dict[str, Any] = {}
for name in Settings.MODULES: # Set empty in case it doesn't exist
settings[f'module_{name}'] = ''
for name, value in Db.get_settings().items():
settings[name] = value
if name in [
'table_rows', 'failed_login_forget_minutes',
'failed_login_tries', 'file_upload_max_size',
'minimum_password_length', 'random_password_length',
'reset_confirm_hours'
]:
settings[name] = int(value)
elif name in [
'mail_recipients_feedback', 'file_upload_allowed_extension'
]:
settings[name] = value.split(' ')
return settings
def set_logo(file_id: Optional[int] = None) -> None:
Db.set_logo(file_id if file_id else '')
'DATABASE_PASS': DATABASE_PASS,
'DATABASE_PORT': DATABASE_PORT,
'DATABASE_HOST': DATABASE_HOST
}
start = time.time()
for item in config:
try:
config[item] = vars(production)[item]
except:
pass
db = open_connection(config)
cursor = db.cursor(cursor_factory=extras.DictCursor)
settings = Settings.get_settings(cursor)
def database_upgrade() -> None:
print(f"{VERSION} OpenAtlas version")
print(f"{DATABASE_VERSION} Database version required")
check_database_version_exist()
print(f"{settings['database_version']} Installed database version")
check_database_version_supported()
check_upgrade_needed()
backup_database()
execute_upgrade()
def execute_upgrade() -> None:
is_before = True
def update(data: dict[str, str]) -> None:
for name, value in data.items():
Db.update(name, value)