package           : tis-microsoft-access-2016-runtime
version           : 16.0.4288.1001-21
architecture      : all
section           : base
priority          : optional
name              : Microsoft Access 2016 Runtime
categories        : Office
maintainer        : WAPT Team,Tranquil IT,Pierre COSSON,Jimmy PELÉ
description       : Microsoft Access 2016 Runtime
depends           : 
conflicts         : 
maturity          : PROD
locale            : all
target_os         : windows
min_wapt_version  : 2.0
sources           : https://www.microsoft.com/download/details.aspx?id=50040
installed_size    : 280485120
impacted_process  : 
description_fr    : Microsoft Access 2016 Runtime
description_pl    : Microsoft Access 2016 Runtime
description_de    : Microsoft Access 2016 Laufzeit
description_es    : Tiempo de ejecución de Microsoft Access 2016
description_pt    : Microsoft Access 2016 Runtime
description_it    : Runtime di Microsoft Access 2016
description_nl    : Microsoft Access 2016 Runtime
description_ru    : Microsoft Access 2016 Runtime
audit_schedule    : 
editor            : Microsoft
keywords          : 
licence           : Proprietary
homepage          : https://www.microsoft.com/en-us/microsoft-365/blog/2015/12/16/access-2016-runtime-is-now-available-for-download/
package_uuid      : 62fe3618-7871-432a-9b8e-0e182c44a3aa
valid_from        : 
valid_until       : 
forced_install_on : 
changelog         : 
min_os_version    : 6.1
max_os_version    : 
icon_sha256sum    : 17f31cf2b5a3c5cfe041b21839caf7d8c3bdff23fe3ee8b5f0f70f86f1ab01f0
signer            : Tranquil IT
signer_fingerprint: 8c5127a75392be9cc9afd0dbae1222a673072c308c14d88ab246e23832e8c6bb
signature         : TIQnyIKp76v/NQMs1Yw3zlNPuxx2qGPO1J+T30wRYTzYAluRqDtZhoodiOD82oJRWz0eUGiJpfqCAwE1n7OpK1TjSD2/bBagrp9AC9JimKL0QEM/BFNLtmOTVNTTWTTm444Rz/rE2dxGQXuBk8cb5pbyb1eCPtLJ57JL5X9FklaijBkQkdJfr9m1MdyPC6X4JcDyX96zI0JGNfAGnAP+5GaTgEG8ZWNrOEYgxB6KpNfSHDOHQTlSBs9E0r1CGGzswCkD47H5lZ2ADgUyPDYrDpXYiwOSsBy0i1zw1RBZMZE+EyZwuT4D2LusJe6uqGnJmjxH3DPe9Np6a5PxR849qw==
signature_date    : 2022-08-06T13:18:53.772541
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 *

r"""

UninstallKey                           Software                                                              Version             Uninstallstring
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
HomeBusinessRetail - fr-fr             Microsoft Office Famille et Petite Entreprise 2016 - fr-fr            16.0.9029.2167      "C:\Program Files\Common Files\Microsoft Shared\ClickToRun\OfficeClickToRun.exe" scenario=install scenariosubtype=ARP sourcetype=None productstoremove=HomeBusinessRetail.16_fr-fr_x-none culture=fr-fr version.16=16.0
{90150000-008F-0000-1000-0000000FF1CE} Office 15 Click-to-Run Licensing Component                            15.0.4433.1508      MsiExec.exe /I{90150000-008F-0000-1000-0000000FF1CE}
{90160000-008F-0000-1000-0000000FF1CE} Office 16 Click-to-Run Licensing Component                            16.0.9029.2167      MsiExec.exe /I{90160000-008F-0000-1000-0000000FF1CE}
{90160000-008C-0000-0000-0000000FF1CE} Office 16 Click-to-Run Extensibility Component                        16.0.9029.2167      MsiExec.exe /X{90160000-008C-0000-0000-0000000FF1CE}
{90160000-008C-040C-0000-0000000FF1CE} Office 16 Click-to-Run Localization Component                         16.0.9029.2167      MsiExec.exe /X{90160000-008C-040C-0000-0000000FF1CE}


    <COMPANYNAME Value="Company Name" />

"""
# Declaring global variables - Warnings: 1) WAPT context is only available in package functions; 2) Global variables are not persistent between calls

bin_contains = "accessruntime_4288"
app_uninstallkey = "Office16.AccessRT"
configuration_xml_content = r"""<Configuration Product="AccessRT">
    <Display Level="None" CompletionNotice="no" SuppressModal="yes" AcceptEula="yes" />
    <Logging Type="standard" Path="C:\Windows\Temp" Template="Microsoft_Access_2016_Runtime_Setup(*).log" />
    <Setting Id="SETUP_REBOOT" Value="Never" />
    <Updates Enabled="False" />
</Configuration>"""
error_30066_msg = "Windows Installer and Click-to-Run editions of Office programs don't get along for this version, so you can only have one type installed at a time. Please try installing the Click-to-Run edition of Office instead, or uninstall your other Click-to-Run based Office programs and try this installation again."


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

    # Installing the software
    print("Installing: %s (%s)" % (control.name, package_version))
    run(bin_name + r" /quiet /extract:tmp")

    # write configuration.xml as a file
    with open(r"tmp\configuration.xml", "w") as f:
        f.write(configuration_xml_content)

    if not control.architecture == "x64":
        # Uninstalling conflict office products
        for to_uninstall in installed_softwares(name="Office 16 Click-to-Run Extensibility Component 64-bit Registration"):
            print("Removing: %s (%s)" % (to_uninstall["name"], to_uninstall["version"]))
            run(uninstall_cmd(to_uninstall["key"]))
            wait_uninstallkey_absent(to_uninstall["key"])

    # Avoiding install on MSO Professional Editions since it is already embed
    detect_office_pro = installed_softwares(name=".*Office.*Prof")

    # run installer
    if not detect_office_pro:
        # Detecting Click-to-Run MSO since it avoid install
        for to_uninstall in installed_softwares(name=".*Office.*"):
            if "OfficeClickToRun.exe".lower() in to_uninstall["uninstall_string"].lower():
                error_30066_app = to_uninstall["name"]
                error_30066 = True
        if error_30066:
            print(error_30066_msg)
            print("Impacted product: %s" % error_30066_app)
        else:
            install_exe_if_needed(
                r"tmp\setup.exe",
                silentflags="/config configuration.xml",
                key=app_uninstallkey,
                min_version=package_version,
                timeout=900,
            )

        # Avoiding the usage by WAPT of the app built-in Uninstallstring
        uninstallkey.remove(app_uninstallkey)

    else:
        print("Install skipped since %s is detected" % detect_office_pro[0]["name"])


def uninstall():
    # Uninstalling the software with different UninstallString
    for to_uninstall in installed_softwares(uninstallkey=app_uninstallkey):
        print("Removing: %s (%s)" % (to_uninstall["name"], to_uninstall["version"]))
        killalltasks(control.impacted_process.split(","))

        # write configuration.xml as a file
        setup_uninstall_path = to_uninstall["uninstall_string"].split("/uninstall")[0]
        silent_uninstall_file_path = makepath(systemdrive, "Windows", "Temp", "configuration.xml")
        with open(silent_uninstall_file_path, "w") as f:
            f.write(configuration_xml_content)

        # app_uninstall_cmd = [setup_uninstall_path, "/uninstall  ACCESSRT /config %s" % silent_uninstall_file_path]
        app_uninstall_cmd = '%s /uninstall ACCESSRT /config "%s"' % (setup_uninstall_path, silent_uninstall_file_path)

        run(app_uninstall_cmd, timeout=1200)
        wait_uninstallkey_absent(to_uninstall["key"])

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

bin_contains = "accessruntime_4288"


def update_package():
    # Declaring local variables
    result = False
    proxies = get_proxies()
    if not proxies:
        proxies = get_proxies_from_wapt_console()
    if control.architecture == "x64":
        if control.locale == "fr":
            download_url = "https://download.microsoft.com/download/2/7/F/27F33487-9306-42FA-AC49-55323C7F6A55/accessruntime_4288-1001_x64_fr-fr.exe"
        else:
            download_url = "https://download.microsoft.com/download/D/B/D/DBD20EF9-A945-4768-AEB0-617BCEA2214A/accessruntime_4288-1001_x64_en-us.exe"
    else:
        if control.locale == "fr":
            download_url = "https://download.microsoft.com/download/2/7/F/27F33487-9306-42FA-AC49-55323C7F6A55/accessruntime_4288-1001_x86_fr-fr.exe"
        else:
            download_url = "https://download.microsoft.com/download/D/B/D/DBD20EF9-A945-4768-AEB0-617BCEA2214A/accessruntime_4288-1001_x86_en-us.exe"
    latest_bin = download_url.split("/")[-1]

    # Downloading latest binaries
    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)
    version = get_version_from_binary(latest_bin)

    # 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, filename_contains=latest_bin)

    # Validating or not update-package-sources
    return result