pgAdmin 4

package           : tis-pgadmin4
version           : 5.7-4
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  : 1.5
sources           : https://www.pgadmin.org/download/pgadmin-4-windows/
installed_size    : 
impacted_process  : pgAdmin4
description_fr    : 
description_pl    : 
description_de    : 
description_es    : 
description_pt    : 
description_it    : 
description_nl    : 
description_ru    : 
audit_schedule    : 
editor            : The pgAdmin Development Team
keywords          : pgadmin,pg,admin,sql,lite
licence           : Artistic
homepage          : https://www.pgadmin.org/
package_uuid      : 68d51e4a-eac3-4c48-a1ad-ee45fcd601ad
valid_from        : 
valid_until       : 
forced_install_on : 
changelog         : https://www.pgadmin.org/docs/pgadmin4/development/release_notes.html
min_os_version    : 6.1
max_os_version    : 
icon_sha256sum    : 9ffd7e91db2e6680e89adc9525cad742e539cc194d1b9ec9fe32b844b4cf5e56
signer            : Tranquil IT
signer_fingerprint: 8c5127a75392be9cc9afd0dbae1222a673072c308c14d88ab246e23832e8c6bb
signature         : H64PJOKb6z7MV01hsdvfJTBYRZ1Fvwt6YEJq7O/9PSWbxiATc9IfvA9F+Lvee/eSnnMcpIG6O30yu8ku4uoB//aqt51NhAETINP18bV+bgDRzhKOdg2yvJDKzCKxCXlrgti/RM53bUJQXGiqm0f5krzGWSX65GqWTHA/4mUyp6cIwVZ6JhKKDtGioEOAkLXWnk5y5cFIC3aRKKv8Shrsw6ikmw4jAfhsSLlNhFhlpvi/znB3tdvsSvDeZpjypcpg3LMWRCqXzqJPUOOxej4x/G+PAa714h9inZsC9xeeWPHC+LJdFCjQ8/mMmrgbR2HR1mxgzcw51c32nh/icHLelA==
signature_date    : 2021-10-21T11:50:01.717125
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 *
try:
    import bs4 as BeautifulSoup
except:
    import BeautifulSoup
import requests
import platform

uninstallkey = []

# Defining variables
bin_name_string = 'pgadmin4-%s-x64.exe'
silent_args = '/VERYSILENT /SUPPRESSMSGBOXES /NORESTART /SP- /ALLUSERS'
app_uninstallkey = 'pgAdmin 4v5_is1'


def install():
    # Initializing variables
    package_version = control.version.split('-')[0]
    bin_name = bin_name_string % package_version

    # Installing the package
    install_exe_if_needed(bin_name
        ,silentflags=silent_args
        ,key=app_uninstallkey)


def update_package():
    print('Download/Update package content from upstream binary sources')

    # Getting proxy informations from WAPT settings
    proxy = {}
    if platform.system()=='Windows' and isfile(makepath(user_local_appdata(),'waptconsole','waptconsole.ini')):
        proxywapt = inifile_readstring(makepath(user_local_appdata(),'waptconsole','waptconsole.ini'),'global','http_proxy')
        if proxywapt :
            proxy = {'http':proxywapt,'https':proxywapt}

    # Initializing variables
    app_name = control.name
    url = control.sources

    # Getting latest version from official website
    page = requests.get(url,proxies=proxy).text
    bs = BeautifulSoup.BeautifulSoup(page)
    bs_read = bs.find('div',{'class':'well pga-downloads'})
    url_part = bs_read.find('a')['href']
    version = url_part.split('/')[-3].replace('v','')
    latest_bin = bin_name_string % version
    #https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.23/windows/pgadmin4-4.23-x64.exe
    url_dl = '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" % url_dl)

    # Downloading latest binaries
    if not isfile(latest_bin):
        print('Downloading: %s' % latest_bin)
        wget(url_dl,latest_bin,proxies=proxy)

        # Checking version from file
        version_from_file = get_file_properties(latest_bin)['ProductVersion']
        if version != version_from_file and version_from_file != '':
            version = version_from_file
            old_latest_bin = latest_bin
            latest_bin = bin_name_string % version
            if isfile(latest_bin):
                remove_file(latest_bin)
            os.rename(old_latest_bin,latest_bin)
            print('Verified latest ' + app_name + ' version is: ' + version)

        # Changing version of the package
        control.version = '%s-%s'%(version,int(control.version.split('-')[-1])+1)
        control.save_control_to_wapt()
        print('Changing version to: %s in WAPT\\control' % control.version)

    # Deleting outdated binaries
    for bin_in_dir in glob.glob('*.exe') or glob.glob('*.msi') or glob.glob('*.zip'):
        if bin_in_dir != latest_bin :
            print('Outdated binary: %s Deleted' % bin_in_dir)
            remove_file(bin_in_dir)

edf0bab6031fc06d6b875cb1b76b06bb616d6431373726cc58775f769edb88b9 : pgadmin4-5.7-x64.exe
4a121f95e714eea94e341eb6c09799bf4b777ebd425e8a60f01d03bada5d3b90 : setup.py
a5a97261381e1d0ad46ee15916abec9c2631d0201f5cc50ceb0197a165a0bbbf : WAPT/certificate.crt
9ffd7e91db2e6680e89adc9525cad742e539cc194d1b9ec9fe32b844b4cf5e56 : WAPT/icon.png
d806d2a78b535fc3859040ca7986d990c3d5893e9a390bfff8d6986a310ff5ae : WAPT/control