pgAdmin III

package           : tis-pgadmin3
version           : 1.22.2-29
architecture      : all
section           : base
priority          : optional
name              : pgAdmin III
categories        : Development
maintainer        : WAPT Team,Tranquil IT,Jimmy PELÉ
description       : pgAdmin III
depends           : 
conflicts         : 
maturity          : PROD
locale            : all
target_os         : windows
min_wapt_version  : 2.0
sources           : 
installed_size    : 33615872
impacted_process  : pg_dump,pg_dumpall,pg_restore,pgadmin3,psql
description_fr    : pgAdmin III
description_pl    : pgAdmin III
description_de    : pgAdmin III
description_es    : pgAdmin III
description_pt    : pgAdmin III
description_it    : pgAdmin III
description_nl    : pgAdmin III
description_ru    : pgAdmin III
audit_schedule    : 
editor            : 
keywords          : 
licence           : 
homepage          : 
package_uuid      : 083f118f-ab48-4e3c-9429-d123f3f3c2d4
valid_from        : 
valid_until       : 
forced_install_on : 
changelog         : https://www.postgresql.org/message-id/CA%2BOCxoyQDA5dg3L-E2wDzM9HjjtP%3DRbopTOzfhoTEi%3DR_bEbkQ%40mail.gmail.com
min_os_version    : 6.0
max_os_version    : 
icon_sha256sum    : 9ffd7e91db2e6680e89adc9525cad742e539cc194d1b9ec9fe32b844b4cf5e56
signer            : Tranquil IT
signer_fingerprint: 8c5127a75392be9cc9afd0dbae1222a673072c308c14d88ab246e23832e8c6bb
signature         : aWM504gWpugE59jaaallcZLKR3LxA6x7MpZ2hjZe89mcWr4Vp50dii8bvgd4QMoV3kOyFRcdfLg3VL2XU2HSlNJ8NpRSVXtqHZlGonUfrtHeMCAN6xu97+SyF17agRgLbow3xtiqgQ12SQCbimMtK4ASpSSVMALCeE06tKmcGq1UT1uUTNwYVl0dc3Z58S7/ZmiWIcc7EVA8nTRfRC2TXwYAdHSVL0GRKZiYcc+bSu28hJxstJFEwiK8sglP1kxplo4vF/q2LOQjQZXXedx2oAxRkGZdkU+2/EtG7/q5HM0lNGSOXepHoww7iihEDLko303kMOUX/nzGTuV8yciOAA==
signature_date    : 2022-08-02T02:27:26.350853
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

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

# Declaring global variables - Warnings: 1) WAPT context is only available in package functions; 2) Global variables are not persistent between calls
bin_name = "pgadmin3.msi"
app_name = "pgAdmin III"
app_dir = makepath(programfiles32, app_name)
app_path = makepath(app_dir, "1.22", "pgadmin3.exe")


def install():
    # Declaring local variables
    package_version = control.get_software_version()
    bin_name = glob.glob("*%s*.zip" % "pg")[0]
    force = False

    # Uninstalling the software since only portable are usable
    for to_uninstall in installed_softwares(name=app_name):
        if "MsiExec.exe" in to_uninstall["uninstall_string"]:
            print("Removing: %s (%s)" % (to_uninstall["name"], to_uninstall["version"]))
            killalltasks(control.impacted_process.split(","))
            run(uninstall_cmd(to_uninstall["key"]))
            wait_uninstallkey_absent(to_uninstall["key"])
        else:
            force = True  # temp rule

    # Getting installed software version
    if isfile(app_path):
        installed_version = get_version_from_binary(app_path)
    else:
        installed_version = None

    # Installing software
    print("Installing: %s" % app_name)
    if installed_version is None or Version(installed_version) < Version(package_version) or force:
        killalltasks(control.get_impacted_process_list())
        if isdir(app_dir):
            remove_tree(app_dir)
        mkdirs(app_dir)
        print("Extracting: %s to: %s" % (bin_name, app_dir))
        unzip(bin_name, app_dir)

        # Creating shortcuts
        # create_desktop_shortcut(app_name, app_path, icon=icon_path)
        create_programs_menu_shortcut(app_name, app_path)

        # Adding software to "list-registry"
        print("Registering: %s to Windows Registry" % app_name)
        register_windows_uninstall(control, win64app=False)
        register_uninstall(app_name, win64app=False)
    else:
        print("%s is already installed. Skipping" % app_name)


def uninstall():
    # Uninstalling software
    killalltasks(control.get_impacted_process_list())
    if isdir(app_dir):
        remove_tree(app_dir)
    unregister_uninstall(app_name, win64app=False)

    # Removing shortcuts
    # remove_desktop_shortcut(app_name)
    remove_programs_menu_shortcut(app_name)


def audit():
    # Declaring local variables
    package_version = control.version.split("-", 1)[0]

    # Getting installed software version
    if installed_softwares(uninstallkey=app_name):
        installed_version = installed_softwares(uninstallkey=app_name)[0]["version"]
    else:
        installed_version = None

    # Auditing software
    print("Auditing: %s" % control.package)
    if installed_version is None:
        print("%s is not installed" % app_name)
        return "ERROR"
    elif Version(installed_version) != Version(package_version):
        print("%s is installed in version (%s) instead of (%s)" % (app_name, installed_version, package_version))
        return "WARNING"
    else:
        print("%s is installed in correct version (%s)" % (app_name, installed_version))
        return "OK"

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


def update_package():
    # Declaring local variables
    result = False
    download_url = "http://srvtemplates.ad.tranquil.it/binary_cache/pg_1.22.2.zip"
    latest_bin = download_url.split("/")[-1]

    # Downloading binaries
    wget(download_url, latest_bin, sha256="45fd0bbd4709a317d079ec3bee1a2f397256cd77933b9698720b8fb07647df6f")

    # Changing version of the package
    control.set_software_version(control.get_software_version())
    control.save_control_to_wapt()

042470e935a630eb7ceb5ae5639ecedf74152fa70cfff3b6bbfd4077215d1f03 : setup.py
45fd0bbd4709a317d079ec3bee1a2f397256cd77933b9698720b8fb07647df6f : pg_1.22.2.zip
d031702e5145004f1bfc801891ac948107299bea8cf8e414a9cecbac9b26d969 : update_package.py
9ffd7e91db2e6680e89adc9525cad742e539cc194d1b9ec9fe32b844b4cf5e56 : WAPT/icon.png
a5a97261381e1d0ad46ee15916abec9c2631d0201f5cc50ceb0197a165a0bbbf : WAPT/certificate.crt
ba5930e2eb5b7561fcbad37c1a0baa8ef3ff2fa9c7fb4c66e98c0edf7cfc516d : luti.json
73c69e7a8df2d1a1c101e70bc306f91d105c611ebc776b9a7ab610a352e6a32a : WAPT/control

https://www.postgresql.org/message-id/CA%2BOCxoyQDA5dg3L-E2wDzM9HjjtP%3DRbopTOzfhoTEi%3DR_bEbkQ%40mail.gmail.com