DB Structure Diagram WAPT

package           : tis-db-structure-diagram-wapt
version           : 2.6.1.17813-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      : 977003ff-5388-41df-a361-c5dadaa15192
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    : 2026-06-14T11:36:20.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         : HcCLR/Zvds3lg3XY8D/ZqZzmoumti0XxaKeOBbWKo/w+V+QS7H31eRtVhYQkfNbPkB/39oTy6XymKLEmAjnRg/GmXlsPASej4FH1v/vs/rZ1Pb431e54Kp30h5oiZ9RF4T0R4wgbPJX6lXtvnfi2Pvy6uitKcyl5X8W9Jj1InFenuqf+iSAAQRD5AuZ+vBA9PUrTFdzww5Ll0tpnabn4CDrqjdnFa0N1WUJYLHY5ogZfaQqPSyCDwqqR3cEhVe5Xz1zOVesB4aQd2aP6mfX3nwAdHaSMottAh26qWRjYYW4kQT/sC7XvnJQB2IBnTr/s3CHZc6TftnLt6zTq6T+6HA==

# -*- 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-2026.gpg > /usr/share/keyrings/tiswapt-pub.gpg ; 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)

38d056ab130f7bf7c481c12636a4e9959de36561d3dfcbe54c6e3571bc0c1dc3 : WAPT/certificate.crt
42ad9a11a6fed0e36174a4e1fb132c06af05d4a35f9f0c2a0910cc2dcce671e2 : WAPT/control
3e7c51325356b282e0569bff8d9048055254a9616167b66f893703b14e6957d1 : WAPT/icon.png
cf1187fe6ed94dace85c800a992a8e6cfb4ad54b410abcb727de0065f09c6b34 : luti.json
9b5484c8ef6d771d9d6b55367a4771773be9918424a7ecbef98faffe17211a19 : setup.py
fbb30b51c197ff68511630ba73aae323c9d84252b7516654c5f5f8366623064a : update_package.py
db684eee6d012bfad7404f4e7242c3217a678eb861c9980c6b318ee67d564bbd : wapt.dia
587ec542e44a6148241f02502c8679b026508bce8f95de976191b2383f1a20eb : wapt.dot
3e820276b9db3450a479cb94803dfd3e72d4b505609bf6840108d709292e450c : wapt.dot_shortfk
65f8f9f70f3532050cfe51b0420a08311a7bc57ef2294894d5e6c9cb06a9dc90 : wapt.html
6d8383e3fc6b2cf2ffb0ce61a914edae1975ce7f64ebd49bae1ed007bafeea54 : wapt.neato
5c1d3b29428841a458a026083be9a1d6677e45374fcb41ad540876f7047f10f8 : wapt.svg
3eb013a96de603a9846f8c0e8de5ca2d9604250d9928a49757528ae988ea2110 : wapt.xml
cef529a32dd13c1490b013297f81c2cf0970a139a8d5485379863cb6075952f6 : wapt.zigzag.dia