Source code for pymyinstall.installcustom.install_custom_sqlitespy

Various functions to install `SQLiteSpy <>`_.

from __future__ import print_function
import sys
import re
import os

from ..installhelper.install_cmd_helper import unzip_files
from ..installhelper.link_shortcuts import add_shortcut_to_desktop
from .install_custom import download_page, download_from_sourceforge, DownloadException, download_file

[docs]def IsSQLiteSpyInstalled(dest_folder): """ Checks if :epkg:`SQLiteSpy` was already installed :param dest_folder: where it was installed :return: boolean :githublink:`%|py|21` """ if sys.platform.startswith("win"): file = os.path.join(dest_folder, "SQLiteSpy.exe") return os.path.exists(file) else: raise NotImplementedError("not available on platform " + sys.platform)
[docs]def install_sqlitespy(temp_folder=".", fLOG=print, install=True, version=None, backup=False): """ Installs :epkg:`SQLiteSpy`. It does not do it a second time if it is already installed. :param temp_folder: where to download the setup :param fLOG: logging function :param install: install (otherwise only download) :param version: version to install (unused) :return: temporary file :githublink:`%|py|39` """ if version is not None: raise ValueError("cannot specify a version") if IsSQLiteSpyInstalled(temp_folder): return os.path.join(temp_folder, "SQLiteSpy.exe") link = "" outfile = None try: page = download_page(link) except DownloadException as e: if backup and sys.platform.startswith("win"): link = "" fLOG("[pymy] download ", link) outfile = os.path.join(temp_folder, "") download_file(link, outfile) version = "1.9.12" fLOG("[pymy] SQLiteSpy, version ", version) else: raise e if sys.platform.startswith("win"): if outfile is None: reg = re.compile( "href=[\\\"'](*?[.]zip)[\\\"']") alls = reg.findall(page) if len(alls) == 0: raise Exception( "Unable to find a link on a .zip file on page: " + page) file = alls[0].replace("&amp;", "&") full = file version = file.split("_")[-1].replace(".zip", "") fLOG("[pymy] SQLiteSpy, version ", version) outfile = os.path.join( temp_folder, "{0}_{1}.zip".format("SQLiteSpy", version)) fLOG("[pymy] download ", full) download_from_sourceforge( full, outfile, temp_folder=temp_folder, fLOG=fLOG) if install: files = unzip_files(outfile, temp_folder, fLOG=fLOG) local = [f for f in files if f.endswith(".exe")][0] return local else: return outfile else: raise NotImplementedError("not available on platform " + sys.platform)
[docs]def add_shortcut_to_desktop_for_sqlitespy(exe): """ create a shortcut on your desktop :param exe: exe location (SQLiteSpy.exe) :return: filename :githublink:`%|py|94` """ return add_shortcut_to_desktop(exe, "SQLiteSpy", "SQLiteSpy")