2026-04-11 18:05:07 - __main__ - INFO - ============================================================
2026-04-11 18:05:07 - __main__ - INFO - ImdbUpdate v2 - Avvio (DuckDB pipeline)
2026-04-11 18:05:07 - __main__ - INFO - ============================================================
2026-04-11 18:05:07 - __main__ - INFO - Base directory: C:\PYTHON\ImdbUpdate
2026-04-11 18:05:07 - __main__ - INFO - Temp directory: C:\PYTHON\ImdbUpdate\Temp
2026-04-11 18:05:07 - __main__ - INFO - Parquet output: C:\PYTHON\ImdbUpdate\parquet\imdb.parquet
2026-04-11 18:05:07 - __main__ - WARNING - Download saltato - uso file esistenti in Temp/
2026-04-11 18:05:07 - __main__ - INFO - ============================================================
2026-04-11 18:05:07 - __main__ - INFO - FASE 3: Transform DuckDB → imdb.parquet
2026-04-11 18:05:07 - __main__ - INFO - ============================================================
2026-04-11 18:05:07 - src.transformer - INFO - Caricamento title_basics: title_basics.txt
2026-04-11 18:05:10 - src.transformer - INFO -   title_basics: 1,264,057 righe (filtrate per titleType)
2026-04-11 18:05:10 - src.transformer - INFO - Caricamento title_akas: title_akas.txt
2026-04-11 18:05:20 - src.transformer - INFO -   title_akas: 5,321,724 righe (solo region=IT)
2026-04-11 18:05:20 - src.transformer - INFO - Caricamento title_ratings: title_ratings.txt
2026-04-11 18:05:20 - src.transformer - INFO -   title_ratings: 1,658,155 righe
2026-04-11 18:05:20 - src.transformer - INFO - Caricamento title_principals: title_principals.txt
2026-04-11 18:05:41 - src.transformer - INFO -   title_principals: 31,768,337 righe (director+actor)
2026-04-11 18:05:41 - src.transformer - INFO - Caricamento name_basics: name_basics.txt
2026-04-11 18:05:44 - src.transformer - INFO -   name_basics: 15,225,343 righe
2026-04-11 18:05:44 - src.transformer - INFO - Costruzione new_imdb (step separati)...
2026-04-11 18:05:44 - src.transformer - INFO -   Step 1/4: titoli italiani
2026-04-11 18:05:46 - src.transformer - INFO -   Step 2/4: registi
2026-04-11 18:05:50 - src.transformer - INFO -   Step 3/4: attori
2026-04-11 18:05:59 - src.transformer - INFO -   Step 4/4: join finale
2026-04-11 18:06:01 - src.transformer - INFO -   new_imdb: 1,264,057 righe
2026-04-11 18:06:01 - src.transformer - INFO - Scrittura parquet: C:\PYTHON\ImdbUpdate\parquet\imdb.parquet
2026-04-11 18:06:02 - src.transformer - INFO -   Parquet scritto: 1,264,057 righe, 51.1 MB
2026-04-11 18:06:02 - __main__ - INFO - Transform completato: 1,264,057 righe in parquet
2026-04-11 18:06:08 - __main__ - INFO -   Parquet copiato in: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\imdb.parquet
2026-04-11 18:06:08 - __main__ - INFO - ============================================================
2026-04-11 18:06:08 - __main__ - INFO - FASE 4: Export Parquet → MS Access
2026-04-11 18:06:08 - __main__ - INFO - ============================================================
2026-04-11 18:06:08 - src.access_exporter - INFO - Copia template Access: db_split_IMDB.accdb -> db_split_IMDB.accdb
2026-04-11 18:06:08 - src.access_exporter - INFO - Database Access creato: C:\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb
2026-04-11 18:06:08 - src.access_exporter - INFO - Export Parquet -> Access: C:\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb
2026-04-11 18:11:27 - src.access_exporter - INFO - Export completato: 1,264,057 record in IMDB
2026-04-11 18:11:27 - src.access_exporter - INFO - Arricchimento OTT_EMESSO via tabella linkata OTT...
2026-04-11 18:11:29 - src.access_exporter - WARNING -   Arricchimento OTT fallito (non bloccante): ('HY000', "[HY000] [Microsoft][Driver ODBC Microsoft Access] Per l'operazione è necessaria una query aggiornabile. (-3035) (SQLExecDirectW)")
2026-04-11 18:11:29 - src.access_exporter - INFO - Copia db_split_IMDB.accdb in 2 destinazioni
2026-04-11 18:12:07 - src.access_exporter - INFO -   Copiato in: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\db_split_IMDB.accdb
2026-04-11 18:12:07 - src.access_exporter - INFO -   Copiato in: C:\IcrMonitor\MonitorLinker\db_split_IMDB.accdb
2026-04-11 18:12:07 - __main__ - INFO - ============================================================
2026-04-11 18:12:07 - __main__ - INFO - FASE 5: Import in GemmaLoader (opzionale)
2026-04-11 18:12:07 - __main__ - INFO - ============================================================
2026-04-11 18:12:07 - src.access_exporter - INFO - Copia IMDB in GemmaLoader: \\mediaset.it\cologno\icr_acquisti\GemmaLoader\GemmaLoader.accdb