gctools/misc2.py

import os

import typer

import config
from misc import apache_ldap
from misc.convert_mail_csv import convert_folder_to_combined_csv
from misc.csv_cleanup import csv_cleanup
from misc.csv_trim import csv_trim
from misc.datev_status import print_all_mdb_files
from misc.headers import create_headerfiles

app = typer.Typer()
cfg = config.Config()


@app.command()
def headers():
    create_headerfiles(f"{cfg.system_dir}\\Export")


@app.command()
def ldap_backup():
    cred = cfg.cognos11.credentials
    apache_ldap.ldap_backup(cred.username, cred.password, f"{cfg.cognos11.config_dir}\\apacheds_backup.ldif")


@app.command()
def ldap_restore(backup_file: str):
    cred = cfg.cognos11.credentials
    apache_ldap.restore_ldap(cred.username, cred.password, backup_file)


@app.command()
def ldap_password(old_password: str, new_password: str) -> bool:
    return apache_ldap.ldap_change_admin_password(old_password, new_password)


@app.command()
def ldap_admin():
    if ldap_password("gc01gapsC$", ""):
        print("Passwort ist bereits aktuell.")
        return
    for p in ["Cognos#11Cognos#11", "mEn$q3b%P9p1j!A-ku", "Never4getpw#!!##", "Cognos#11"]:
        if ldap_password(p, "gc01gapsC$"):
            print("Passwort erfolgreich geaendert.")
            break


@app.command()
def csv_check(path: str = ""):
    if path == "":
        path = f"{cfg.system_dir}\\export"
    csv_cleanup(path)


@app.command()
def bcp_csv_trim(path: str = ""):
    if path == "":
        path = f"{cfg.system_dir}\\SQL\\temp"
    csv_trim(path)


@app.command()
def combine_csv(path: str = ""):
    if path == "":
        path = f"{cfg.xml_dir}"
    os.makedirs(path + "\\info", exist_ok=True)
    os.makedirs(path + "\\backup", exist_ok=True)
    convert_folder_to_combined_csv(path)


@app.command()
def datev_details(path: str = ""):
    if path == "":
        path = cfg.system_dir
    print_all_mdb_files(path)