scripts-pde/core/pde.py

'''
    Connections to parc databases
'''
from path import Path

from core.db import AccessSDb


# Web url of the WsPde web service
WSPDE_URL = "http://localhost:2890/public/WsPDE.asmx"

MDW_PATH = r"\\h2o\local\4-transversal\BDD\mda\cg67Parc.mdw"
UID = "olivier"
PWD = "massot"

# Dirs
MAIN = Path(__file__).parent.parent.abspath()
WRK = MAIN / "work"
WRK.mkdir_p()

def mk_workdir(name):
    workdir = WRK / name
    workdir.mkdir_p()
    return workdir

DEFAULT_LOG_DIR = MAIN / "log"
DEFAULT_LOG_DIR.mkdir_p()

DB_DIRPATH = Path(r"\\h2o\local\4-transversal\BDD\mdb")
# DB_DIRPATH = Path(r"C:\wrktmp\mdb")

FACTURES_DB_PATH = DB_DIRPATH / "Facture_data.mdb"
CONTROLES_DB_PATH = DB_DIRPATH / "cg67Parc_data.mdb"
WINCAN_DB_PATH = DB_DIRPATH / r"Wincan\parc_2007\DB\PARC_2007.mdb"
COMMUN_DB_PATH = DB_DIRPATH / "Commun_Data.mdb"
ANALYTIQUE_DB_PATH = DB_DIRPATH / "Db_analytique.mdb"
BO_DB_PATH = DB_DIRPATH / "dbBO.mdb"
AGRHUM_DB_PATH = DB_DIRPATH / "BDD_ParcRH.mdb"
PDA_DB_PATH = DB_DIRPATH / "PDA" / "db_PDA.mdb"

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")