2026-04-14 16:40:00 - __main__ - INFO - ============================================================
2026-04-14 16:40:00 - __main__ - INFO - ImdbUpdate v2 - Avvio (DuckDB pipeline)
2026-04-14 16:40:00 - __main__ - INFO - ============================================================
2026-04-14 16:40:00 - __main__ - INFO - Base directory: C:\PYTHON\ImdbUpdate
2026-04-14 16:40:00 - __main__ - INFO - Temp directory: C:\PYTHON\ImdbUpdate\Temp
2026-04-14 16:40:00 - __main__ - INFO - Parquet output: C:\PYTHON\ImdbUpdate\parquet\imdb_full.parquet
2026-04-14 16:40:00 - __main__ - WARNING - Download saltato - uso file esistenti in Temp/
2026-04-14 16:40:00 - __main__ - INFO - ============================================================
2026-04-14 16:40:00 - __main__ - INFO - FASE 3: Transform DuckDB → imdb.parquet
2026-04-14 16:40:00 - __main__ - INFO - ============================================================
2026-04-14 16:40:00 - src.transformer - INFO - Caricamento title_basics: title_basics.txt
2026-04-14 16:40:06 - src.transformer - INFO -   title_basics: 1,265,218 righe (filtrate per titleType)
2026-04-14 16:40:06 - src.transformer - INFO - Caricamento title_akas: title_akas.txt
2026-04-14 16:40:21 - src.transformer - INFO -   title_akas: 5,326,342 righe (solo region=IT)
2026-04-14 16:40:21 - src.transformer - INFO - Caricamento title_ratings: title_ratings.txt
2026-04-14 16:40:21 - src.transformer - INFO -   title_ratings: 1,660,809 righe
2026-04-14 16:40:21 - src.transformer - INFO - Caricamento title_principals: title_principals.txt
2026-04-14 16:40:48 - src.transformer - INFO -   title_principals: 31,803,178 righe (director+actor)
2026-04-14 16:40:48 - src.transformer - INFO - Caricamento name_basics: name_basics.txt
2026-04-14 16:40:52 - src.transformer - INFO -   name_basics: 15,242,807 righe
2026-04-14 16:40:52 - src.transformer - INFO - Costruzione new_imdb (step separati)...
2026-04-14 16:40:52 - src.transformer - INFO -   Step 1/4: titoli italiani
2026-04-14 16:40:54 - src.transformer - INFO -   Step 2/4: registi
2026-04-14 16:41:01 - src.transformer - INFO -   Step 3/4: attori
2026-04-14 16:41:12 - src.transformer - INFO -   Step 4/4: join finale
2026-04-14 16:41:14 - src.transformer - INFO -   new_imdb: 1,265,218 righe
2026-04-14 16:41:14 - src.transformer - INFO - Scrittura parquet: C:\PYTHON\ImdbUpdate\parquet\imdb_full.parquet
2026-04-14 16:41:15 - src.transformer - INFO -   Parquet scritto: 1,265,218 righe, 51.2 MB
2026-04-14 16:41:15 - __main__ - INFO - Transform completato: 1,265,218 righe in parquet
2026-04-14 16:41:17 - __main__ - INFO -   Parquet copiato in: I:\SOFTWARE\PYTHON_SRV\parquet_layer1\imdb_full.parquet
2026-04-14 16:41:17 - __main__ - INFO - ============================================================
2026-04-14 16:41:17 - __main__ - INFO - FASE 4: Export Parquet → MS Access
2026-04-14 16:41:17 - __main__ - INFO - ============================================================
2026-04-14 16:41:17 - src.access_exporter - INFO - Copia template Access: db_split_IMDB.accdb -> db_split_IMDB.accdb
2026-04-14 16:41:17 - src.access_exporter - INFO - Database Access creato: C:\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb
2026-04-14 16:41:17 - src.access_exporter - INFO - Export Parquet -> Access: C:\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb
2026-04-14 16:45:32 - src.access_exporter - INFO - Export completato: 1,265,218 record in IMDB
2026-04-14 16:45:32 - src.access_exporter - INFO - Arricchimento OTT_EMESSO via tabella linkata OTT...
2026-04-14 16:45:39 - src.access_exporter - INFO -   Titoli OTT SVOD distinti: 38,263
2026-04-14 16:45:58 - src.access_exporter - INFO -   OTT_EMESSO aggiornato: 38,263 record
2026-04-14 16:45:58 - src.access_exporter - INFO - Copia db_split_IMDB.accdb in 2 destinazioni
2026-04-14 16:46:39 - src.access_exporter - INFO -   Copiato in: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\db_split_IMDB.accdb
2026-04-14 16:46:40 - src.access_exporter - INFO -   Copiato in: C:\IcrMonitor\MonitorLinker\db_split_IMDB.accdb
2026-04-14 16:46:40 - __main__ - INFO - ============================================================
2026-04-14 16:46:40 - __main__ - INFO - FASE 5: Copia IMDB in GemmaLoader (opzionale)
2026-04-14 16:46:40 - __main__ - INFO - ============================================================
2026-04-14 16:46:40 - src.access_exporter - INFO - Copia IMDB in GemmaLoader: \\mediaset.it\cologno\icr_acquisti\GemmaLoader\GemmaLoader.accdb
2026-04-14 16:46:40 - src.access_exporter - INFO -   Download GemmaLoader in locale...
2026-04-14 16:46:51 - src.access_exporter - INFO -   Aggiornamento IMDB locale (csv_transfer)...
2026-04-14 16:47:05 - src.access_exporter - INFO -   Compattamento GemmaLoader locale...
2026-04-14 16:47:10 - src.access_exporter - INFO -   Compattamento completato
2026-04-14 16:47:10 - src.access_exporter - INFO -   Upload GemmaLoader in rete...
2026-04-14 16:47:20 - src.access_exporter - INFO -   Copia GemmaLoader completata
2026-04-14 16:47:20 - __main__ - INFO - ============================================================
2026-04-14 16:47:20 - __main__ - INFO - FASE 6: Scrittura log finale
2026-04-14 16:47:20 - __main__ - INFO - ============================================================
2026-04-14 16:47:20 - __main__ - INFO - Log creato: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\UPDATES\log\UPDATE_IMDB al 14-04-26.txt
2026-04-14 16:47:20 - __main__ - INFO - ============================================================
2026-04-14 16:47:20 - __main__ - INFO - FASE 7: Pulizia file temporanei
2026-04-14 16:47:20 - __main__ - INFO - ============================================================
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: name_basics.tsv.gz (0.28 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_akas.tsv.gz (0.45 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_basics.tsv.gz (0.21 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_crew.tsv.gz (0.08 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_episode.tsv.gz (0.05 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_principals.tsv.gz (0.71 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_ratings.tsv.gz (0.01 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: name_basics.txt (0.88 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_akas.txt (2.63 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_basics.txt (1.00 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_crew.txt (0.38 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_episode.txt (0.23 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_principals.txt (4.12 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: title_ratings.txt (0.03 GB)
2026-04-14 16:47:20 - __main__ - INFO -   Eliminato: db_split_IMDB.accdb (1.21 GB)
2026-04-14 16:47:20 - __main__ - INFO - Spazio liberato totale: 12.26 GB
2026-04-14 16:47:20 - __main__ - INFO - ============================================================
2026-04-14 16:47:20 - __main__ - INFO - Completato con successo in 0:07:20.559969
2026-04-14 16:47:20 - __main__ - INFO - ============================================================