package           : tis-db-structure-diagram-wapt
version           : 2.6.0.17346-8
architecture      : x64
section           : base
priority          : optional
name              : DB Structure Diagram WAPT
categories        : Utility
maintainer        : WAPT Team,Tranquil IT,administrator,Bertrand LEMOIGNE
description       : DB Structure Diagram WAPT
depends           : 
conflicts         : 
maturity          : PROD
locale            : 
target_os         : all
min_wapt_version  : 2.3
sources           : 
installed_size    : 
impacted_process  : 
description_fr    : 
description_pl    : 
description_de    : 
description_es    : 
description_pt    : 
description_it    : 
description_nl    : 
description_ru    : 
audit_schedule    : 
editor            : 
keywords          : 
licence           : wapt_public
homepage          : 
package_uuid      : 35c875db-1194-4687-a4e3-ede2a9faaff1
valid_from        : 
valid_until       : 
forced_install_on : 
changelog         : 
min_os_version    : 
max_os_version    : 
icon_sha256sum    : 3e7c51325356b282e0569bff8d9048055254a9616167b66f893703b14e6957d1
signer            : Tranquil IT
signer_fingerprint: 8c5127a75392be9cc9afd0dbae1222a673072c308c14d88ab246e23832e8c6bb
signature_date    : 2025-07-07T13:08:13.000000
signed_attributes : package,version,architecture,section,priority,name,categories,maintainer,description,depends,conflicts,maturity,locale,target_os,min_wapt_version,sources,installed_size,impacted_process,description_fr,description_pl,description_de,description_es,description_pt,description_it,description_nl,description_ru,audit_schedule,editor,keywords,licence,homepage,package_uuid,valid_from,valid_until,forced_install_on,changelog,min_os_version,max_os_version,icon_sha256sum,signer,signer_fingerprint,signature_date,signed_attributes
signature         : UngpY/yAMyY0gm6KpEmsuMZjtIGBd64WGOCtmvyhz1+UAIIMa90pPA98y3OqRGs8FlN9F+EvwnbhWP+ZyaiNPavWornN1MZZSP1Hl2HlY/X/RfDvEOisFm17fKNokbWs/iJtGuqb8qo8nP9af5XdnzPvKDdvjtqP/tUeNP/ZAW+RtprW2p+nNESKEPfu7HzuF3hxwlpJUQCdmypTjGQ+nAwdgXlCN0cdIVvQ050vBZEk3zlAcR4efY0fsE1IY3D8drMX7wXrajxv7T3DZD9jXOUD5hBoDQ0jIguHEaazDm13Hie/tS05DVQq+J0vQKHkR8kKYWKbelPWhHxZHye67A==

# -*- coding: utf-8 -*-
from setuphelpers import *


def install():
    files = glob.glob("wapt.*")
    dir = makepath(WAPT.wapt_base_dir, "dbdiagram")
    mkdirs(dir)
    for file in files:
        filecopyto(file, dir)

def audit():
    dir = makepath(WAPT.wapt_base_dir, "dbdiagram")
    if isfile(makepath(dir,'wapt.svg')):
        print('Diagram file exists')
        return "OK"
    else:
        print('Diagram file does NOT exist')
        return "ERROR"

# -*- coding: utf-8 -*-
from setuphelpers import *
from setupdevhelpers import *
import os


def update_package():
    package_dir = os.getcwd()
    # getting version from WAPT public repository:
    for entry in bs_find_all("https://wapt.tranquil.it/wapt/releases/latest/", "a", "href"):
        lnk = entry.attrs["href"]
        if lnk.endswith(".deb"):
            if "amd64" in lnk:
                last_version = lnk.split("-")[2]
                short_version = last_version.rsplit(".", 2)[0]
                break

    # saving version to control file
    control.set_software_version(last_version)
    control.save_control_to_wapt()

    db_structure_diagram = rf"""
    apt remove tis-waptagent -y ; apt install apt-transport-https lsb-release gnupg wget -y ; wget -qO- https://wapt.tranquil.it/$(lsb_release -is)/tiswapt-pub.gpg | tee /usr/share/keyrings/tiswapt-pub.gpg > /dev/null ; echo "deb [signed-by=/usr/share/keyrings/tiswapt-pub.gpg] https://wapt.tranquil.it/$(lsb_release -is)/wapt-{short_version}/ $(lsb_release -c -s) main" > /etc/apt/sources.list.d/wapt.list ; export DEBIAN_FRONTEND=noninteractive ; apt update ; apt install tis-waptserver tis-waptsetup -y ; unset DEBIAN_FRONTEND ; /opt/wapt/waptserver/scripts/postconf.sh -q ; apt install postgresql-autodoc graphviz -y ; cd /tmp ; sudo -u wapt postgresql_autodoc -d wapt ; dot -Tsvg wapt.dot -owapt.svg
    """
    run(db_structure_diagram)
    for file in glob.glob("/tmp/wapt.*"):
        filecopyto(file, package_dir)