DB Structure Diagram WAPT

package           : tis-db-structure-diagram-wapt
version           : 2.6.1.17870-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      : cde1ef16-927b-4462-babb-e23014b3dda7
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-09-06T16:02:43.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         : F5cWz7IY9Cj8OB6vAXDKcRwCUTMB2aArc9DE1HLg2IK8pKuUCsbBXSFl0TEG0eXgoNMv9Dn/iMe2jTNoL2gHws8zf3+cI7JOS+pdMHhc6PF/1ExYQqeVsmmsswrwhhcVJugrhu3JFl4hi32gc5Kx439uX3FTBbDOXuq+s573TmlomsFIcUUTwZO/kNgdvFTuL1KftdVlZXUJDDjd3IoyEpdy0JVWbgxeYXHw65RsqvkbHsHUflsz3e7EWznkT3W4qETii5wj+BNSr2moSfmK1xx/CUVkawpOFJzugtt+R8IICoHi0r2KD+KWwYZzSTU6Ch6pvZ4Al6zc58zLP0WPhg==

# -*- 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
1b1a650ec916e7b7185af32ca75866a2b990b041dab020cbd7fe8a4b90f32a5a : WAPT/control
3e7c51325356b282e0569bff8d9048055254a9616167b66f893703b14e6957d1 : WAPT/icon.png
ab5495743f4c97b0273e655365b6355e9aef3f364d320ee6722a7f0fa1a08ad9 : luti.json
9b5484c8ef6d771d9d6b55367a4771773be9918424a7ecbef98faffe17211a19 : setup.py
fbb30b51c197ff68511630ba73aae323c9d84252b7516654c5f5f8366623064a : update_package.py
cfbaa24efc39423ec46fc626b843ab6c68ca9455443a3fc2074973d4cfe31b24 : wapt.dia
2c475ae3ec6288c757820b664166a7cd4c9954fabbd275c974996e447b12328f : wapt.dot
686da35dcf4a92c182178266555522a3a922253a4edfca8cc1b194d6054cb458 : wapt.dot_shortfk
ffd772def519048507c3e04590c24c08c20d0782c4014dc4f8afd78e052b5b10 : wapt.html
53b925e2a5c010d730b2938fe0eed5d8ef96c295bd7b275757454e9ca6a99f01 : wapt.neato
a02fb2df08f9b4bc29f5dfe7808108c4e65029e17726e3fe78ece5b400c8ffec : wapt.svg
263871a46590c8f7646119978c0026f9334a86740a982faf2091f66caba53698 : wapt.xml
cf2f435c8adb328cc4fb9cff1b2e0b0becc87fcec25ae934bcda63293a5bcce7 : wapt.zigzag.dia