=== Job Execution Log ===
Job: MyICRSuite daily
Execution ID: 129
Start Time: 2026-02-10 14:30:00
Command: C:\PYTHON\MyICR_Workspace\daily_update_gemma_test.bat
Working Directory: None
==================================================

========================================
Daily Gemma Sync to TEST Environment
========================================

Start: 10/02/2026 14:30:00,56
Log file: C:\PYTHON\MyICR_Workspace\logs\gemma_sync\gemma_20260210_143000.log

Press Ctrl+C to abort...

Running: deploy_bootstrap.py TEST

Traceback (most recent call last):
  File "C:\PYTHON\MyICR_Workspace\deploy_bootstrap.py", line 373, in sync_gemma_table_only
    cur_datahub.execute("SELECT sql FROM sqlite_master WHERE type='table' AND name='gemma'")
sqlite3.DatabaseError: database disk image is malformed

======================================================================
  Deploy Bootstrap to TEST Environment
======================================================================

Target: TEST
Server: \\mediaset.it\share\Indirizzo_controllo_risorse\SOFTWARE\ProcedureICR\Python_Applications\MyICR_Suite_TEST

Using: Pure Python Bootstrap (No PyInstaller)
       Environment-agnostic installer

======================================================================
  Checking server access
======================================================================

Server: \\mediaset.it\share\Indirizzo_controllo_risorse\SOFTWARE\ProcedureICR\Python_Applications\MyICR_Suite_TEST
Server reachable

======================================================================
  Deploy: Environment Configuration
======================================================================

Environment: TEST
Source: environment_test.json
Destination: \\mediaset.it\share\Indirizzo_controllo_risorse\SOFTWARE\ProcedureICR\Python_Applications\MyICR_Suite_TEST\environment.json
Deployed environment.json for TEST

======================================================================
  Setup Shared Database Directory
======================================================================

Directory: \\mediaset.it\share\Indirizzo_controllo_risorse\SOFTWARE\ProcedureICR\Python_Applications\MyICR_Suite_TEST\shared_db
Source: DEV database (shared_db/mediatrack.db)
Database exists: mediatrack.db (not overwritten)
  Size: 26.35 MB
  Use --force-db to overwrite with DEV database


======================================================================
  Verifica Accessibilità DataHub
======================================================================

DataHub path: \\Mediaset.it\share\Indirizzo_Controllo_Risorse\SOFTWARE\DataHub\DataHub.db

✅ DataHub accessibile (2905.1 MB)
   Il builder potrà leggere i dati correttamente


======================================================================
  Deploy: app
======================================================================

Calculating hash: app
  Hash: 83b281e24e16267546d07d051f36f781 (118 files)
app already up-to-date (skip)

======================================================================
  Deploy: local_db
======================================================================

Calculating hash: local_db
  Hash: 7d7a6df498b6e561c066b6198052e81d (3 files)
local_db already up-to-date (skip)

======================================================================
  Deploy: python_embeddable
======================================================================

Calculating hash: PythonRuntime_Unified.zip
  Hash: 1a7cb28d339a2299ce1ef11083b48459 (173.8 MB)
python_embeddable already up-to-date (skip)

======================================================================
  GEMMA SYNC + IMPORT (Server-side operations)
======================================================================


======================================================================
  Sincronizzazione Gemma da DataHub al Server
======================================================================

DataHub: \\Mediaset.it\share\Indirizzo_Controllo_Risorse\SOFTWARE\DataHub\DataHub.db
Target: \\mediaset.it\share\Indirizzo_controllo_risorse\SOFTWARE\ProcedureICR\Python_Applications\MyICR_Suite_TEST\shared_db\mediatrack.db

Records in DataHub: 50,806
Removing old gemma table...
Error syncing gemma: database disk image is malformed
Warning: Gemma sync failed
  MediaTrack will use outdated gemma data
  Deploy continues anyway...


======================================================================
  Save Metadata
======================================================================

Metadata saved

======================================================================
  Deploy: Bootstrap Launcher
======================================================================

Deploying bootstrap files to: \\mediaset.it\share\Indirizzo_controllo_risorse\SOFTWARE\ProcedureICR\Python_Applications\MyICR_Suite_TEST

  MyICR_Suite_installer.bat (4.2 KB) - BAT launcher (main entry point)
  bootstrap.py (22.9 KB) - Bootstrap Python script

Bootstrap launcher deployed successfully
  Location: \\mediaset.it\share\Indirizzo_controllo_risorse\SOFTWARE\ProcedureICR\Python_Applications\MyICR_Suite_TEST

======================================================================
  Verification
======================================================================

  Application ZIP
  Local database ZIP
  Python Embeddable ZIP
  MediaTrack shared database
  Metadata file
  BAT launcher
  Bootstrap launcher

All required files present

======================================================================
  DEPLOYMENT COMPLETED!
======================================================================

Deployed structure:
   \\mediaset.it\share\Indirizzo_controllo_risorse\SOFTWARE\ProcedureICR\Python_Applications\MyICR_Suite_TEST
   ├── client_distribution\
   │   ├── app.zip
   │   ├── local_db.zip
   │   └── python_embeddable.zip
   ├── shared_db\
   │   └── mediatrack.db
   ├── launcher_cache\
   │   └── metadata.json
   ├── MyICR_Suite_installer.bat       ← Main launcher (double-click to run)
   └── bootstrap.py                    ← Bootstrap script (called by BAT)

To test:

   Navigate to: \\mediaset.it\share\Indirizzo_controllo_risorse\SOFTWARE\ProcedureICR\Python_Applications\MyICR_Suite_TEST
   Run: MyICR_Suite_installer.bat

   The BAT launcher will:
     1. Check for Python embedded (install on first run)
     2. Launch bootstrap.py
     3. Show progress window
     4. Check for updates and download if needed
     5. Launch MyICR Suite

Benefits:
   - User-friendly installation messages
   - Professional progress indicators
   - NO PyInstaller warnings
   - Simple and maintainable
   - Easy to debug


========================================
End: 10/02/2026 14:31:47,49
========================================

Status: SUCCESS

Gemma synchronized successfully to TEST environment.
Log saved to: C:\PYTHON\MyICR_Workspace\logs\gemma_sync\gemma_20260210_143000.log
========================================