pgAdmin 4

package           : tis-pgadmin4
version           : 9.1-9
architecture      : x64
section           : base
priority          : optional
name              : pgAdmin 4
categories        : Development
maintainer        : WAPT Team,Tranquil IT,Jimmy PELÉ
description       : pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
depends           : 
conflicts         : 
maturity          : PROD
locale            : all
target_os         : windows
min_wapt_version  : 2.0
sources           : https://www.pgadmin.org/download/pgadmin-4-windows/
installed_size    : 
impacted_process  : pgAdmin4
description_fr    : pgAdmin est la plateforme d'administration et de développement Open Source la plus populaire et la plus riche en fonctionnalités pour PostgreSQL, la base de données Open Source la plus avancée au monde
description_pl    : pgAdmin to najpopularniejsza i najbogatsza w funkcje platforma administracyjna i deweloperska Open Source dla PostgreSQL, najbardziej zaawansowanej bazy danych Open Source na świecie
description_de    : pgAdmin ist die beliebteste und funktionsreichste Open-Source-Administrations- und Entwicklungsplattform für PostgreSQL, die fortschrittlichste Open-Source-Datenbank der Welt
description_es    : pgAdmin es la plataforma de administración y desarrollo de código abierto más popular y rica en características para PostgreSQL, la base de datos de código abierto más avanzada del mundo
description_pt    : pgAdmin é a mais popular e possui a mais rica plataforma de administração e desenvolvimento de código aberto para PostgreSQL, a base de dados de código aberto mais avançada do mundo
description_it    : pgAdmin è la piattaforma di amministrazione e sviluppo Open Source più diffusa e ricca di funzionalità per PostgreSQL, il database Open Source più avanzato al mondo
description_nl    : pgAdmin is het meest populaire en functierijke Open Source administratie- en ontwikkelplatform voor PostgreSQL, de meest geavanceerde Open Source database ter wereld
description_ru    : pgAdmin - это самая популярная и многофункциональная платформа администрирования и разработки с открытым исходным кодом для PostgreSQL, самой передовой базы данных с открытым исходным кодом в мире
audit_schedule    : 
editor            : The pgAdmin Development Team
keywords          : pgadmin,pg,admin,sql,lite
licence           : Artistic
homepage          : https://www.pgadmin.org/
package_uuid      : 1f1ec49b-4111-4f29-b0ec-fe9e626da72d
valid_from        : 
valid_until       : 
forced_install_on : 
changelog         : https://www.pgadmin.org/docs/pgadmin4/development/release_notes.html
min_os_version    : 6.3
max_os_version    : 
icon_sha256sum    : 9ffd7e91db2e6680e89adc9525cad742e539cc194d1b9ec9fe32b844b4cf5e56
signer            : Tranquil IT
signer_fingerprint: 8c5127a75392be9cc9afd0dbae1222a673072c308c14d88ab246e23832e8c6bb
signature_date    : 2025-03-08T14:00:24.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         : B/I8TYGWn1MJsb1h2IK5DoTNoGH5zwgww9g03BpiLubrG9Pqz6Z8btkI97ceFg0I8HQS6GMkQ/YH9ZGI9GcpHMh4iWrAa4782c32XVyPs5XJvBxva0YCG4WZRvr+KTB3POnQH1J0dmQRd6tIj4kNWHEZgx7Xfa3Ttx/slCizuhyHt+HqZOFpVyAKGgC97KmRUEmlWRl3JcphS8PrFLhw5T9rpw2a9p83De3ihCJbWU8apJHumWiU8RzAHIWTBW/iIHUZOz7qAQc19YKTNx+E2zaQzPT23TNa9RwsxUnthLnSvRDcgP0lLFUF+oBH7zJKD8oyx0C2lB070XUiCd4eQQ==

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

"""
Usable WAPT package functions: install(), uninstall(), session_setup(), audit(), update_package()

"""
# Declaring global variables - Warnings: 1) WAPT context is only available in package functions; 2) Global variables are not persistent between calls
bin_contains = "pgadmin4-"
silent_args = "/VERYSILENT /SUPPRESSMSGBOXES /NORESTART /SP- /ALLUSERS"


def install():
    # Declaring local variables
    package_version = control.get_software_version()
    bin_name = glob.glob("*%s*.exe" % bin_contains)[0]
    app_uninstallkey = "pgAdmin 4v%s_is1" % package_version.split(".")[0]

    for soft in installed_softwares("pgAdmin 4"):
        if Version(soft["version"]) < Version(package_version):
            run(uninstall_cmd(soft["key"]))

    # Installing the software
    print("Installing: %s" % bin_name)
    install_exe_if_needed(
        bin_name,
        silentflags=silent_args,
        key=app_uninstallkey,
        min_version=package_version,
        timeout=600,
    )

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


def update_package():
    # Declaring local variables
    result = False
    proxies = get_proxies()
    if not proxies:
        proxies = get_proxies_from_wapt_console()
    app_name = control.name
    url = "https://www.pgadmin.org/download/pgadmin-4-windows"
    if control.architecture == "x64":
        sub_bin_name = "pgadmin4-%s-x64.exe"
    else:
        sub_bin_name = "pgadmin4-%s-x86.exe"

    # Getting latest version from official sources
    print("URL used is: %s" % url)
    for bs_search in bs_find_all(url, "a", "class", "dropdown-item", proxies=proxies):
        if bs_search["href"].startswith("/docs/pgadmin4/"):
            version = bs_search["href"].split("/")[-2]
            break

    # https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.23/windows/pgadmin4-4.23-x64.exe
    latest_bin = sub_bin_name % version
    download_url = "https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v%s/windows/%s" % (version, latest_bin)

    print("Latest %s version is: %s" % (app_name, version))
    print("Download URL is: %s" % download_url)

    # Downloading latest binaries
    if not isfile(latest_bin):
        print("Downloading: %s" % latest_bin)
        wget(download_url, latest_bin, proxies=proxies)

        # Checking version from file
        version_from_file = get_product_props(latest_bin)["ProductVersion"]
        if Version(version) != Version(version_from_file) and version_from_file != "":
            print("Changing version to the version number of the binary (from: %s to: %s)" % (version, version_from_file))
            os.rename(latest_bin, sub_bin_name % version_from_file)
            version = version_from_file
        else:
            print("Binary file version corresponds to online version")

    # Changing version of the package
    if Version(version) > Version(control.get_software_version()):
        print("Software version updated (from: %s to: %s)" % (control.get_software_version(), Version(version)))
        result = True
    else:
        print("Software version up-to-date (%s)" % Version(version))
    control.version = "%s-%s" % (Version(version), control.version.split("-", 1)[-1])
    # control.set_software_version(version)
    control.save_control_to_wapt()

    # Deleting outdated binaries
    remove_outdated_binaries(version)

    # Validating or not update-package-sources
    return result

38d056ab130f7bf7c481c12636a4e9959de36561d3dfcbe54c6e3571bc0c1dc3 : WAPT/certificate.crt
7fea0e459929b4348b00e6e79c222484987f2fc9452e2b6b840d4c0b6ab5e5ec : WAPT/control
9ffd7e91db2e6680e89adc9525cad742e539cc194d1b9ec9fe32b844b4cf5e56 : WAPT/icon.png
82f34479d79537295e1766519b249b9d3c2d0e6476d8e6e7562f8f7dfaf0e4ca : luti.json
729c88032303f848cf8eecc673896c896904f138f13103a4b12b689d4369e181 : pgadmin4-9.1-x64.exe
3251d6057fb5fc9c98ec31c5b09501f490395c2e80aa71e186f952283740ab89 : setup.py
4808a9e3da8661ea8b8d52568c8ac5ccdc2685df7d187ffe53237bd5a8ce6c78 : update_package.py