Beekeeper-Studio

package           : tis-beekeeper-studio
version           : 5.4.0-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          : PROD
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      : cafaf1fa-67b3-4526-ac43-46809a5d0ea5
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            : Tranquil IT
signer_fingerprint: 8c5127a75392be9cc9afd0dbae1222a673072c308c14d88ab246e23832e8c6bb
signature_date    : 2025-09-30T07:04:55.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         : BYKbDh5+zecFvh7vTMkAfllN9q2ArpWfbnJ0/yiuhZ2OZqNM+zut1e+cQzF0BInslZHx89Nhq90g1b21eFK4QabXXFEqWpHDUZI7/lllfhEOeqVOJeksveS5OsumJ13vn8Xum5vQTWn42FxCIRBScVfJtPcL7BhPxakcfQAYCvAUTaf2tHIEqXnmmQ27NM4uIekgMskff3PggUWjLjOljgDKV3OylLMQkA5IfkVKpE8yhte+zhVgsdpcJCBjSpZckTntwqIZi9EbW1zxzJixtsC0oTyhQ28DYlwP5RG1LsPTM75y7qsqVnQDEyxkCIT8lyyphduYdo+1Z01zeL1NPQ==

# -*- 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()

44358460c86c6c2e15af4fc39eb3c69246bca8c8f2a4d71b5ba47a006316b68f : Beekeeper-Studio-5.4.0.AppImage
38d056ab130f7bf7c481c12636a4e9959de36561d3dfcbe54c6e3571bc0c1dc3 : WAPT/certificate.crt
49cfb730a5a6e3069b036ece1c4a1dbe1c5760c53bcf1e9a280c109425ffe9ed : WAPT/control
302b4832f45fffe0e15f649aa08e00deb1111aa2960c413b097402a954626581 : WAPT/icon.png
0157250f88325ff5e2e31436514acbc7c171f54751fa62fc7511f5c0bd903e57 : luti.json
223fa6ca0b4ed15f7d1a2e29893619511e043c7907d145e8c8991405677bb4e1 : setup.py
3fe3beb7c8bcc7b7a94a26c5b158c18eb0666c0e5a284bba0bcc069c89db4c05 : update_package.py