package           : tis-firebird
version           : 4.0.2.2816-3
architecture      : x86
section           : base
priority          : optional
name              : Firebird
categories        : System and network
maintainer        : WAPT Team,Tranquil IT,Hubert TOUVET,Gaëtan SEGAT
description       : Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, MacOS and a variety of Unix platforms
depends           : 
conflicts         : 
maturity          : PROD
locale            : 
target_os         : windows
min_wapt_version  : 2.0
sources           : https://github.com/FirebirdSQL/firebird/releases
installed_size    : 68448256
impacted_process  : isql
description_fr    : Firebird est une base de données relationnelle offrant de nombreuses fonctionnalités standard ANSI SQL et fonctionnant sur Linux, Windows, MacOS et une variété de plateformes Unix
description_pl    : 
description_de    : 
description_es    : 
description_pt    : 
description_it    : 
description_nl    : 
description_ru    : 
audit_schedule    : 
editor            : Projet Firebird
keywords          : database
licence           : Interbase Public Licence
homepage          : https://firebirdsql.org/
package_uuid      : f126ec84-8f26-4d29-8f1f-593e526f55b0
valid_from        : 
valid_until       : 
forced_install_on : 
changelog         : https://github.com/FirebirdSQL/firebird/releases
min_os_version    : 
max_os_version    : 
icon_sha256sum    : a5ff5ab2391e5fa9f441b9bc658720e00e7f38df9fd5cef5b905d85311717327
signer            : Tranquil IT
signer_fingerprint: 8c5127a75392be9cc9afd0dbae1222a673072c308c14d88ab246e23832e8c6bb
signature         : ZvhOvAvuAzBIZQprUo4ua1Nof0/Pb7/VYdG7zoiNiouqem2PTctJ0ZNgQcMJs9cI6sbnzRwOtMd80HFrXvFaXtexv8JYJvNhuAdZ2qVk8cG2RNfpTqEBGohynfn5Ttgwk7zWwOCmKhe0YP+m7sD9mjRMJXPP4TUelDmAwRNylFcZ8YhkxHABl/NmJwJFtjmItPs7fi6XusGJc+8qYsA7TQq7W6Opsc54hG6yuPJvQ98py54Or1OZmIAG41OA7ekI39blYGpms/9D2kE+7D3bk82Fdu1VkEJanlsBU8wDTBtwXWkejrSleU7UXMvmoIifCVs6lCH98T41XcC1XdSw0w==
signature_date    : 2022-08-28T19:02:05.737399
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 *


def install():
    # Declaring local variables
    bin_name = glob.glob("Firebird*.exe")[0]
    version = control.get_software_version()
    version_key = "_".join([version.split(".")[0], version.split(".")[1]])

    # Installing the software
    install_exe_if_needed(
        bin_name,
        silentflags="/SILENT /VERYSILENT /SP-",
        key=f"FBDBServer_{version_key}_is1",
        min_version=version,
    )


def uninstall():
    # Remove CRT librairies
    for uninstall in installed_softwares("MSI"):
        if "Firebird" in uninstall["publisher"]:
            print("Uninstall %s" % uninstall["name"])
            cmd = uninstall_cmd(uninstall["key"])
            run(cmd)

    # Remove Firebird tree
    for tree in glob.glob(makepath(programfiles, "*")):
        if "Firebird" in tree:
            remove_tree(tree)

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


def update_package():
    # Declaring local variables
    package_updated = False
    proxies = get_proxies()
    if not proxies:
        proxies = get_proxies_from_wapt_console()
    app_name = control.name
    api_url = "https://api.github.com/repos/FirebirdSQL/firebird/releases/latest"
    bin_contains = "Firebird-"
    bin_ends = "Win32.exe"

    # Getting latest version information from official sources
    print("API used is: %s" % api_url)
    json_load = json.loads(wgets(api_url, proxies=proxies))
    for download in json_load["assets"]:
        if bin_contains in download["name"] and bin_ends in download["name"]:
            download_url = download["browser_download_url"]
            version = json_load["tag_name"].split("-")[-1].replace("v", "")
            latest_bin = download["name"]
            break

    # Downloading latest binaries
    print("Latest %s version is: %s" % (app_name, version))
    print("Download URL is: %s" % download_url)
    if not isfile(latest_bin):
        print("Downloading: %s" % latest_bin)
        wget(download_url, latest_bin, proxies=proxies)
    else:
        print("Binary is present: %s" % latest_bin)

    # Checking version from file
    version_from_file = get_version_from_binary(latest_bin).split("-")[0]
    if Version(version_from_file) != Version(version) and 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)))
        package_updated = True
    else:
        print("Software version up-to-date (%s)" % Version(version))
    control.set_software_version(version)
    control.save_control_to_wapt()

    # Deleting outdated binaries
    remove_outdated_binaries(version)

    # Validating update-package-sources
    return package_updated