Beekeeper-Studio

package           : tis-beekeeper-studio
version           : 5.5.6-1
architecture      : x64
section           : base
priority          : optional
name              : Beekeeper-Studio
categories        : Utilities
maintainer        : WAPT Team,Tranquil IT,Jordan ARNAUD
description       : Beekeeper Studio is a cross-platform database manager and SQL GUI
depends           : 
conflicts         : 
maturity          : PREPROD
locale            : all
target_os         : linux
min_wapt_version  : 2.3
sources           : 
installed_size    : 72438272
impacted_process  : Beekeeper-Studio-4.3.4-portable
description_fr    : Beekeeper Studio est un gestionnaire de base de données multiplateforme et une interface graphique SQL
description_pl    : Beekeeper Studio to wieloplatformowy menedżer baz danych i graficzny interfejs użytkownika SQL
description_de    : Beekeeper Studio ist ein plattformübergreifender Datenbankmanager und SQL-GUI
description_es    : Beekeeper Studio es un gestor de bases de datos multiplataforma y una interfaz gráfica de usuario SQL
description_pt    : O Beekeeper Studio é um gestor de bases de dados multiplataforma e uma GUI SQL
description_it    : Beekeeper Studio è un gestore di database multipiattaforma e un'interfaccia grafica SQL
description_nl    : Beekeeper Studio is een cross-platform databasebeheerder en SQL GUI
description_ru    : Beekeeper Studio - это кроссплатформенный менеджер баз данных и графический интерфейс SQL
audit_schedule    : 
editor            : Beekeeper Studio Team
keywords          : database,sql,gui
licence           : opensource_free,cpe:/a:gnu:gpl_v3,wapt_public
homepage          : https://docs.beekeeperstudio.io/
package_uuid      : 48e0b81c-2be5-41c0-83a8-9782d817574d
valid_from        : 
valid_until       : 
forced_install_on : 
changelog         : https://github.com/beekeeper-studio/beekeeper-studio/releases
min_os_version    : 
max_os_version    : 
icon_sha256sum    : 302b4832f45fffe0e15f649aa08e00deb1111aa2960c413b097402a954626581
signer            : test
signer_fingerprint: b82fc8ef4a4475c0f69ac168176c2bfc58f572eb716c4eadd65e4785c155dd8e
signature_date    : 2026-01-31T20:30:06.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         : OSPVcOkv/XpN1O2FtrCozKNbZWS8UUwaAXfipH0EhRuwvX683eECs2jB8/RID3C9jdg5nSwDMgakgCa/rUkcPkyzM9b4O3+/HVZNjkjmR4RXwi/JDaQqWt/UKeCnZa2mr5vePVlje7i/PBK4pfj+0NHnjSnPzMJ9cDqJa9JUma1V8NTz4E0QJhnX8SuQtzXx42JCIcR+loJjByyrRl0rRM0QFXFaxZJxksJXVueQRsIer+w+GY6DdCmjm62O/3WJVvqq05XXe36AeWN7rRYfq+/KGgTBjkdTc+lJRNs3IVvhlSO88UwhT6ktU0uf9eq2U2GsirDYQOi2bcwneYKo8Q==

# -*- coding: utf-8 -*-
##################################################
# This file is part of WAPT Enterprise
# All right reserved, (c) Tranquil IT Systems 2024
# For more information please refer to
# https://wapt.tranquil.it/store/licences.html
##################################################
from setuphelpers import *
from iniparse import ConfigParser
import os


def install():
    install_dir = makepath('/','opt',control.package.split('-',1)[1])
    appimage = glob.glob("*.AppImage")[0]
    install_appimage(appimage,install_dir)

def uninstall():
    install_dir = makepath('/','opt',control.package.split('-',1)[1])
    uninstall_appimage(install_dir)

def install_appimage(appimage,install_dir,binaliasname=None):
    run('chmod a+x ./' + appimage)

    if isdir(install_dir):
        uninstall_appimage(install_dir)

    mkdirs(install_dir)

    name_appimage = appimage.split('/')[-1]
    filecopyto(appimage, makepath(install_dir, name_appimage))
    run('"./%s" --appimage-extract' % appimage)
    

    for desktop in glob.glob(makepath('squashfs-root','*.desktop')):
 
        desktop_cp = ConfigParser()
        desktop_cp.optionxform = str
        desktop_file = open(desktop, encoding="utf-8")
        desktop_cp.readfp(desktop_file)
        bin_path = desktop_cp.get('Desktop Entry',"Exec")

        newbin_path = install_dir + '/' + name_appimage
        if ' %' in bin_path:
            newbin_path = newbin_path + ' %' + bin_path.split(' %',1)[1]

        icon_path = desktop_cp.get('Desktop Entry',"Icon")

        srcicon = makepath('squashfs-root',icon_path +'.svg')
        if not isfile(srcicon):
            srcicon = makepath('squashfs-root',icon_path +'.png')

        if not isfile(srcicon):
            lstglob = glob.glob(makepath('squashfs-root','*.svg'))
            if lstglob :
                srcicon=lstglob[0]

        if not isfile(srcicon):
            lstglob = glob.glob(makepath('squashfs-root','*.png'))
            if lstglob :
                srcicon=lstglob[0]
            else:
                srcicon = None

        if srcicon:            
            new_icon = install_dir + '/' + srcicon.split('/')[-1]
            filecopyto(srcicon,new_icon)
            desktop_cp.set('Desktop Entry',"Icon",new_icon) 

        desktop_cp.set('Desktop Entry',"Exec",newbin_path)
       
        with open(desktop, 'w', encoding="utf-8") as f:
            desktop_cp.write(f)

        pathdesk = makepath(install_dir,desktop.split('/')[-1])
        filecopyto(desktop, pathdesk)
        run('chown root:root "%s" ' % pathdesk)

    for f in glob.glob(makepath(install_dir,'*.desktop')):
        run('ln -sf "%s" "/usr/share/applications/%s"' % (f,f.split('/')[-1]))

    if binaliasname :
        run(f"ln -sf {install_dir}/{name_appimage} /usr/bin/{binaliasname}")

    remove_tree('squashfs-root')

def uninstall_appimage(install_dir):

    if not glob.glob(makepath(install_dir,'*.desktop')):
        error('.desktop not found')

    for f in glob.glob(makepath(install_dir,'*.desktop')):
        deskfile = f.split('/')[-1]
        system_desktop = makepath("/","usr","share","applications",deskfile)
        if isfile(system_desktop):
            remove_file(system_desktop)
    remove_tree(install_dir)

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

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


def update_package():
    result = False
    proxies = get_proxies()

    if not proxies:
        proxies = get_proxies_from_wapt_console()
   
    url_api = "https://api.github.com/repos/beekeeper-studio/beekeeper-studio/releases/latest"  
    # Getting latest version information from official sources
    print("API used is: %s" % url_api)
    json_load = json.loads(wgets(url_api, proxies=proxies))

    for download in json_load["assets"]:
        if download["browser_download_url"].endswith('.AppImage') and not "arm64" in download["browser_download_url"]:
            url_dl = download["browser_download_url"]
            version = download["name"].split("-")[-1].replace(".AppImage", "")
            filename = download["name"]
            break

    if not isfile(filename):
        package_updated = True
        print(f'Downloading ' + filename)
        wget(url_dl,filename,proxies=proxies)

    #nettoyer les fichiers temporaires
    for f in glob.glob('*.AppImage'):
        if f != filename:
            remove_file(f)

    control.set_software_version(version)
    control.save_control_to_wapt()

b24017dfd5e7982cc0cedf05a79d9a2c9f8bfc80edbe24d3a86f6181aef84e6c : Beekeeper-Studio-5.5.6.AppImage
01ca7fe94636e5a08fcb73849d3b5df25d51e2c82f4dd1a08f01798b25899819 : WAPT/certificate.crt
b3b93f96f5d2593d5cf56e8a930d336af28c470c91e058e8f4ab8033961a10dc : WAPT/control
302b4832f45fffe0e15f649aa08e00deb1111aa2960c413b097402a954626581 : WAPT/icon.png
93186c6af11136b981a80fa6a650b9989a0362705864b222b28c094c7ae132e0 : luti.json
223fa6ca0b4ed15f7d1a2e29893619511e043c7907d145e8c8991405677bb4e1 : setup.py
3fe3beb7c8bcc7b7a94a26c5b158c18eb0666c0e5a284bba0bcc069c89db4c05 : update_package.py