2026-09-10 14:00:12 - __main__ - INFO - ============================================================
2026-09-10 14:00:12 - __main__ - INFO - ImdbUpdate v2 - Avvio (DuckDB pipeline)
2026-09-10 14:00:12 - __main__ - INFO - ============================================================
2026-09-10 14:00:12 - __main__ - INFO - Base directory: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate
2026-09-10 14:00:12 - __main__ - INFO - Temp directory: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp
2026-09-10 14:00:12 - __main__ - INFO - Parquet output: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\parquet\imdb_full.parquet
2026-09-10 14:00:12 - __main__ - INFO - Pulizia file residui all'avvio...
2026-09-10 14:00:12 - __main__ - INFO - Trovati 1 file residui (0.10 GB)
2026-09-10 14:00:12 - __main__ - INFO -   Eliminato: name_basics.tsv.gz
2026-09-10 14:00:12 - __main__ - INFO - Pulizia completata
2026-09-10 14:00:12 - __main__ - INFO - Preparazione directory temporanea
2026-09-10 14:00:12 - __main__ - INFO - Eliminazione C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp
2026-09-10 14:00:12 - __main__ - INFO - Directory creata: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp
2026-09-10 14:00:12 - __main__ - INFO - ============================================================
2026-09-10 14:00:12 - __main__ - INFO - FASE 2: Download dataset IMDb
2026-09-10 14:00:12 - __main__ - INFO - ============================================================
2026-09-10 14:00:12 - src.downloader - INFO - Download name_basics.tsv.gz da https://datasets.imdbws.com/name.basics.tsv.gz
2026-09-10 14:00:21 - src.downloader - INFO - Download completato: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\name_basics.tsv.gz
2026-09-10 14:00:21 - src.downloader - INFO - Decompressione name_basics.tsv.gz -> name_basics.tsv
2026-09-10 14:00:28 - src.downloader - INFO - Decompressione completata: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\name_basics.tsv
2026-09-10 14:00:28 - src.downloader - INFO - Rinominato name_basics.tsv -> name_basics.txt
2026-09-10 14:00:28 - src.downloader - INFO - Download title_akas.tsv.gz da https://datasets.imdbws.com/title.akas.tsv.gz
2026-09-10 14:00:42 - src.downloader - INFO - Download completato: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_akas.tsv.gz
2026-09-10 14:00:42 - src.downloader - INFO - Decompressione title_akas.tsv.gz -> title_akas.tsv
2026-09-10 14:00:56 - src.downloader - INFO - Decompressione completata: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_akas.tsv
2026-09-10 14:00:56 - src.downloader - INFO - Rinominato title_akas.tsv -> title_akas.txt
2026-09-10 14:00:56 - src.downloader - INFO - Download title_basics.tsv.gz da https://datasets.imdbws.com/title.basics.tsv.gz
2026-09-10 14:01:03 - src.downloader - INFO - Download completato: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_basics.tsv.gz
2026-09-10 14:01:03 - src.downloader - INFO - Decompressione title_basics.tsv.gz -> title_basics.tsv
2026-09-10 14:01:10 - src.downloader - INFO - Decompressione completata: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_basics.tsv
2026-09-10 14:01:10 - src.downloader - INFO - Rinominato title_basics.tsv -> title_basics.txt
2026-09-10 14:01:10 - src.downloader - INFO - Download title_crew.tsv.gz da https://datasets.imdbws.com/title.crew.tsv.gz
2026-09-10 14:01:13 - src.downloader - INFO - Download completato: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_crew.tsv.gz
2026-09-10 14:01:13 - src.downloader - INFO - Decompressione title_crew.tsv.gz -> title_crew.tsv
2026-09-10 14:01:15 - src.downloader - INFO - Decompressione completata: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_crew.tsv
2026-09-10 14:01:15 - src.downloader - INFO - Rinominato title_crew.tsv -> title_crew.txt
2026-09-10 14:01:15 - src.downloader - INFO - Download title_episode.tsv.gz da https://datasets.imdbws.com/title.episode.tsv.gz
2026-09-10 14:01:17 - src.downloader - INFO - Download completato: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_episode.tsv.gz
2026-09-10 14:01:17 - src.downloader - INFO - Decompressione title_episode.tsv.gz -> title_episode.tsv
2026-09-10 14:01:19 - src.downloader - INFO - Decompressione completata: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_episode.tsv
2026-09-10 14:01:19 - src.downloader - INFO - Rinominato title_episode.tsv -> title_episode.txt
2026-09-10 14:01:19 - src.downloader - INFO - Download title_principals.tsv.gz da https://datasets.imdbws.com/title.principals.tsv.gz
2026-09-10 14:01:39 - src.downloader - INFO - Download completato: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_principals.tsv.gz
2026-09-10 14:01:39 - src.downloader - INFO - Decompressione title_principals.tsv.gz -> title_principals.tsv
2026-09-10 14:02:02 - src.downloader - INFO - Decompressione completata: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_principals.tsv
2026-09-10 14:02:02 - src.downloader - INFO - Rinominato title_principals.tsv -> title_principals.txt
2026-09-10 14:02:02 - src.downloader - INFO - Download title_ratings.tsv.gz da https://datasets.imdbws.com/title.ratings.tsv.gz
2026-09-10 14:02:03 - src.downloader - INFO - Download completato: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_ratings.tsv.gz
2026-09-10 14:02:03 - src.downloader - INFO - Decompressione title_ratings.tsv.gz -> title_ratings.tsv
2026-09-10 14:02:03 - src.downloader - INFO - Decompressione completata: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\title_ratings.tsv
2026-09-10 14:02:03 - src.downloader - INFO - Rinominato title_ratings.tsv -> title_ratings.txt
2026-09-10 14:02:03 - src.downloader - INFO - Processati 7/7 file
2026-09-10 14:02:03 - __main__ - INFO - Download completato: 7 file
2026-09-10 14:02:03 - __main__ - INFO - ============================================================
2026-09-10 14:02:03 - __main__ - INFO - FASE 3: Transform DuckDB → imdb.parquet
2026-09-10 14:02:03 - __main__ - INFO - ============================================================
2026-09-10 14:02:03 - src.transformer - INFO - Caricamento title_basics: title_basics.txt
2026-09-10 14:02:12 - src.transformer - INFO -   title_basics: 1,290,119 righe (filtrate per titleType)
2026-09-10 14:02:12 - src.transformer - INFO - Caricamento title_akas: title_akas.txt
2026-09-10 14:02:40 - src.transformer - INFO -   title_akas: 5,474,463 righe (solo region=IT)
2026-09-10 14:02:40 - src.transformer - INFO - Caricamento title_ratings: title_ratings.txt
2026-09-10 14:02:40 - src.transformer - INFO -   title_ratings: 1,712,642 righe
2026-09-10 14:02:40 - src.transformer - INFO - Caricamento title_principals: title_principals.txt
2026-09-10 14:03:33 - src.transformer - INFO -   title_principals: 32,620,286 righe (director+actor)
2026-09-10 14:03:33 - src.transformer - INFO - Caricamento name_basics: name_basics.txt
2026-09-10 14:03:42 - src.transformer - INFO -   name_basics: 15,644,003 righe
2026-09-10 14:03:42 - src.transformer - INFO - Costruzione new_imdb (step separati)...
2026-09-10 14:03:42 - src.transformer - INFO -   Step 1/4: titoli italiani
2026-09-10 14:03:44 - src.transformer - INFO -   Step 2/4: registi
2026-09-10 14:03:57 - src.transformer - INFO -   Step 3/4: attori
2026-09-10 14:04:18 - src.transformer - INFO -   Step 4/4: join finale
2026-09-10 14:04:21 - src.transformer - INFO -   new_imdb: 1,290,119 righe
2026-09-10 14:04:21 - src.transformer - INFO - Scrittura parquet: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\parquet\imdb_full.parquet
2026-09-10 14:04:24 - src.transformer - INFO -   Parquet scritto: 1,290,119 righe, 52.1 MB
2026-09-10 14:04:25 - __main__ - INFO - Transform completato: 1,290,119 righe in parquet
2026-09-10 14:04:29 - __main__ - INFO -   Parquet copiato in: I:\SOFTWARE\PYTHON_SRV\PYTHON_LOCAL\MyICR_Suite\local_db\parquet\imdb_full.parquet
2026-09-10 14:04:29 - __main__ - INFO - ============================================================
2026-09-10 14:04:29 - __main__ - INFO - FASE 4: Export Parquet → MS Access
2026-09-10 14:04:29 - __main__ - INFO - ============================================================
2026-09-10 14:04:29 - src.access_exporter - INFO - Copia template Access: db_split_IMDB.accdb -> db_split_IMDB.accdb
2026-09-10 14:04:29 - src.access_exporter - INFO - Database Access creato: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb
2026-09-10 14:04:29 - src.access_exporter - INFO - Export Parquet -> Access: C:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb
2026-09-10 14:08:55 - src.access_exporter - INFO - Export completato: 1,290,119 record in IMDB
2026-09-10 14:08:55 - src.access_exporter - INFO - Arricchimento OTT_EMESSO via tabella linkata OTT...
2026-09-10 14:09:11 - src.access_exporter - INFO -   Titoli OTT SVOD distinti: 38,943
2026-09-10 14:09:54 - src.access_exporter - INFO -   OTT_EMESSO aggiornato: 38,943 record
2026-09-10 14:09:54 - src.access_exporter - INFO - Compattamento db_split_IMDB.accdb...
2026-09-10 14:09:54 - src.access_exporter - WARNING -   Compattamento fallito (non bloccante): (-2147352567, 'Eccezione.', (0, 'DAO.DbEngine', 'Impossibile usare "C:\\Users\\Mauro Gagliardi\\Dropbox\\adrian\\PYTHON\\ImdbUpdate\\Temp\\db_split_IMDB.accdb". File già in uso.', 'jeterr40.chm', 5003045, -2146825243), None)
2026-09-10 14:09:54 - src.access_exporter - INFO - Copia db_split_IMDB.accdb in 2 destinazioni
2026-09-10 14:10:36 - src.access_exporter - INFO -   Copiato in: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\db_split_IMDB.accdb
2026-09-10 14:10:37 - src.access_exporter - INFO -   Copiato in: C:\IcrMonitor\MonitorLinker\db_split_IMDB.accdb
2026-09-10 14:10:37 - __main__ - INFO - ============================================================
2026-09-10 14:10:37 - __main__ - INFO - FASE 5: Copia IMDB in GemmaLoader (opzionale)
2026-09-10 14:10:37 - __main__ - INFO - ============================================================
2026-09-10 14:10:37 - src.access_exporter - INFO - Copia IMDB in GemmaLoader: \\mediaset.it\cologno\icr_acquisti\GemmaLoader\GemmaLoader.accdb
2026-09-10 14:10:37 - src.access_exporter - INFO -   Download GemmaLoader in locale...
2026-09-10 14:10:49 - src.access_exporter - INFO -   Aggiornamento IMDB locale (csv_transfer)...
2026-09-10 14:11:02 - src.access_exporter - INFO -   Compattamento GemmaLoader locale...
2026-09-10 14:11:10 - src.access_exporter - INFO -   Compattamento completato
2026-09-10 14:11:10 - src.access_exporter - INFO -   Upload GemmaLoader in rete...
2026-09-10 14:11:21 - src.access_exporter - INFO -   Copia GemmaLoader completata
2026-09-10 14:11:21 - __main__ - INFO - ============================================================
2026-09-10 14:11:21 - __main__ - INFO - FASE 6: Scrittura log finale
2026-09-10 14:11:21 - __main__ - INFO - ============================================================
2026-09-10 14:11:21 - __main__ - INFO - Log creato: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\UPDATES\log\UPDATE_IMDB al 10-09-26.txt
2026-09-10 14:11:21 - __main__ - INFO - ============================================================
2026-09-10 14:11:21 - __main__ - INFO - FASE 7: Pulizia file temporanei
2026-09-10 14:11:21 - __main__ - INFO - ============================================================
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: name_basics.tsv.gz (0.29 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_akas.tsv.gz (0.48 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_basics.tsv.gz (0.21 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_crew.tsv.gz (0.08 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_episode.tsv.gz (0.05 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_principals.tsv.gz (0.73 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_ratings.tsv.gz (0.01 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: name_basics.txt (0.90 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_akas.txt (2.80 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_basics.txt (1.03 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_crew.txt (0.39 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_episode.txt (0.24 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_principals.txt (4.23 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: title_ratings.txt (0.03 GB)
2026-09-10 14:11:21 - __main__ - INFO -   Eliminato: db_split_IMDB.accdb (1.23 GB)
2026-09-10 14:11:21 - __main__ - INFO - Spazio liberato totale: 12.70 GB
2026-09-10 14:11:21 - __main__ - INFO - ============================================================
2026-09-10 14:11:21 - __main__ - INFO - Completato con successo in 0:11:09.129558
2026-09-10 14:11:21 - __main__ - INFO - ============================================================