scripts-pde/core/pde.py

'''
    Configuration des scripts
'''
from path import Path

from core.db import AccessSDb

MAIN = Path(__file__).parent.parent.abspath()

# Web url of the WsPde web service
PDE_WS_URL = r"http://localhost:2890/public/WsPDE.asmx"
#     PDE_WS_URL = r"http://webservices.bas-rhin.fr/CG67.AstreGF.WebServices/public/WsPDE.asmx"

# Chemin d'acces au fichier de secu Access, et login/mdp
MDW_PATH = r"\\h2o\local\4-transversal\BDD\mda\cg67Parc.mdw"
UID = "olivier"
PWD = "massot"

# Dirs
WRKDIR = MAIN / "work"
RSCDIR = MAIN / "resources"
DEFAULT_LOG_DIR = MAIN / "log"
LOG_CONFIG_FILE = MAIN / "logging.yaml"


PDA_FILES_DEST = Path(r"\\h2o\LOCAL\4-transversal\BDD\mdb\PDA\Fichiers_PDA")

FACTURES_DB_PATH = Path(r"\\h2o\local\4-transversal\BDD\mdb\Facture_data.mdb")
CONTROLES_DB_PATH = Path(r"\\h2o\local\4-transversal\BDD\mdb\cg67Parc_data.mdb")
WINCAN_DB_PATH = Path(r"\\h2o\local\4-transversal\BDD\mdb\Wincan\parc_2007\DB\PARC_2007.mdb")
COMMUN_DB_PATH = Path(r"\\h2o\local\4-transversal\BDD\mdb\Commun_Data.mdb")
ANALYTIQUE_DB_PATH = Path(r"\\h2o\local\4-transversal\BDD\mdb\Db_analytique.mdb")
BO_DB_PATH = Path(r"\\h2o\local\4-transversal\BDD\mdb\dbBO.mdb")
AGRHUM_DB_PATH = Path(r"\\h2o\local\4-transversal\BDD\mdb\BDD_ParcRH.mdb")
PDA_DB_PATH = Path(r"\\h2o\local\4-transversal\BDD\mdb\PDA\db_PDA.mdb")


### ***********  Ne pas modifier en dessous   *************** ###

DEFAULT_LOG_DIR.mkdir_p()
WRKDIR.mkdir_p()

def mk_workdir(name):
    """ créé le répertoire de travail pour le script 'name' """
    workdir = WRKDIR / name
    workdir.mkdir_p()
    return workdir

class ParcDb(AccessSDb):
    _path = ""
    def __init__(self, **kwargs):
        super(AccessSDb, self).__init__(self._path, systemdb=MDW_PATH, uid=UID, pwd=PWD, **kwargs)

class FacturesDb(ParcDb):
    _path = FACTURES_DB_PATH

class ControlesDb(ParcDb):
    _path = CONTROLES_DB_PATH

class WincanDb(ParcDb):
    _path = COMMUN_DB_PATH

class CommunDb(ParcDb):
    _path = FACTURES_DB_PATH

class AnalytiqueDb(ParcDb):
    _path = ANALYTIQUE_DB_PATH

class BoDb(ParcDb):
    _path = BO_DB_PATH

class AgrhumDb(ParcDb):
    _path = AGRHUM_DB_PATH

class PdaDb(ParcDb):
    _path = PDA_DB_PATH


if __name__ == "__main__":
    for cls in (FacturesDb, ControlesDb, WincanDb, CommunDb, AnalytiqueDb, BoDb, AgrhumDb):
        db = cls()
        db.assert_connected()
    print("connections ok")