python_sql_backup.spec

"""
PyInstaller spec file for python_sql_backup.

This enhanced spec file supports cross-platform building for Windows, macOS, and Linux
with various CPU architectures.
"""
import os
import sys
import platform
import subprocess
from PyInstaller.utils.hooks import collect_data_files, collect_submodules

# Determine the current platform
current_platform = platform.system().lower()
if current_platform == 'darwin':
    current_platform = 'macos'
elif current_platform == 'windows':
    current_platform = 'windows'
else:
    current_platform = 'linux'

# Block cipher for encryption (None = no encryption)
block_cipher = None

# Define additional binary dependencies based on platform
binaries = []

# Add Python shared library for Linux
if current_platform == 'linux':
    python_version = f"{sys.version_info.major}.{sys.version_info.minor}"
    
    # Try to find Python library using ldconfig
    try:
        ldconfig_output = subprocess.check_output(['ldconfig', '-p']).decode()
        for line in ldconfig_output.splitlines():
            if f'libpython{python_version}.so' in line:
                lib_path = line.split('=>')[-1].strip()
                if os.path.exists(lib_path):
                    binaries.append((lib_path, '.'))
                    break
    except:
        pass
    
    # If ldconfig didn't work, try common locations
    if not binaries:
        lib_paths = [
            f"/usr/lib/libpython{python_version}.so",
            f"/usr/lib/aarch64-linux-gnu/libpython{python_version}.so",
            f"/usr/lib/python{python_version}/config-{python_version}-aarch64-linux-gnu/libpython{python_version}.so",
            f"/usr/lib/x86_64-linux-gnu/libpython{python_version}.so",
            f"/usr/local/lib/libpython{python_version}.so",
            os.path.join(sys.prefix, 'lib', f'libpython{python_version}.so'),
        ]
        
        # Add current Python's lib directory
        python_lib_dir = os.path.dirname(os.path.realpath(sys.executable))
        lib_paths.append(os.path.join(python_lib_dir, '..', 'lib', f'libpython{python_version}.so'))
        
        for lib_path in lib_paths:
            if os.path.exists(lib_path):
                binaries.append((lib_path, '.'))
                break

# Define data files to include
data_files = [
    ('config.ini.example', 'config.ini.example'),
    ('README.md', 'README.md'),
]

# Add icons if they exist
icon_paths = {
    'windows': os.path.join('resources', 'icon.ico'),
    'macos': os.path.join('resources', 'icon.icns'),
}

for platform_name, icon_path in icon_paths.items():
    if os.path.exists(icon_path):
        data_files.append((icon_path, icon_path))

# Hidden imports to ensure all necessary modules are included
hidden_imports = [
    'mysql.connector',
    'configparser',
    'click',
    'tabulate',
    'colorama',
    'tqdm',
    'typing',
    'pathlib',
]

# Add all submodules from our package
hidden_imports.extend(collect_submodules('python_sql_backup'))

# Create the Analysis object
a = Analysis(
    ['python_sql_backup/__main__.py'],
    pathex=[os.path.abspath(os.getcwd())],
    binaries=binaries,
    datas=data_files,
    hiddenimports=hidden_imports,
    hookspath=[],
    runtime_hooks=[],
    excludes=[],
    win_no_prefer_redirects=False,
    win_private_assemblies=False,
    cipher=block_cipher,
    noarchive=False,
)

# Create the PYZ archive
pyz = PYZ(
    a.pure, 
    a.zipped_data,
    cipher=block_cipher
)

# Platform-specific options for the executable
exe_args = {
    'name': 'python-sql-backup',
    'debug': False,
    'bootloader_ignore_signals': False,
    'strip': False,
    'upx': True,
    'console': True,
}

# Add platform-specific icon if available
if current_platform == 'windows' and os.path.exists(icon_paths['windows']):
    exe_args['icon'] = icon_paths['windows']
elif current_platform == 'macos' and os.path.exists(icon_paths['macos']):
    exe_args['icon'] = icon_paths['macos']

# Create mode-specific targets based on the build mode
# Onefile mode: Single executable file
exe = EXE(
    pyz,
    a.scripts,
    a.binaries,
    a.zipfiles,
    a.datas,
    [],
    **exe_args,
)

# For macOS, create a .app bundle
if current_platform == 'macos':
    app = BUNDLE(
        exe,
        name='python-sql-backup.app',
        icon=icon_paths['macos'] if os.path.exists(icon_paths['macos']) else None,
        bundle_identifier='com.mysql.backup',
        info_plist={
            'CFBundleShortVersionString': '1.0.0',
            'NSHighResolutionCapable': 'True',
        },
    )