view sat/memory/sqla_config.py @ 3743:54c249ec35ce

core (memory/migration): ignore FTS table when autogenerating script for migration: SQLite Full-Text Search stable are not associated to Python object and can't be detected by Alembic. To avoid the generation of unwanted drop commands, they are now ignored when autogenerating migration scripts. rel 364
author Goffi <goffi@goffi.org>
date Tue, 22 Mar 2022 17:00:42 +0100
parents 71516731d0aa
children 4edfd7521418
line wrap: on
line source

#!/usr/bin/env python3

# Libervia: an XMPP client
# Copyright (C) 2009-2021 Jérôme Poisson (goffi@goffi.org)

# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.

# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU Affero General Public License for more details.

# You should have received a copy of the GNU Affero General Public License
# along with this program.  If not, see <http://www.gnu.org/licenses/>.

from pathlib import Path
from urllib.parse import quote
from sat.core.constants import Const as C
from sat.tools import config


def getDbConfig() -> dict:
    """Get configuration for database

    @return: dict with following keys:
        - type: only "sqlite" for now
        - path: path to the sqlite DB
    """
    main_conf = config.parseMainConf()
    local_dir = Path(config.getConfig(main_conf, "", "local_dir"))
    database_path = (local_dir / C.SAVEFILE_DATABASE).expanduser()
    url = f"sqlite+aiosqlite:///{quote(str(database_path))}"
    return {
        "type": "sqlite",
        "path": database_path,
        "url": url,
    }