scripts/insert_area_from_excel.py

Overview

This file contains 3 documented elements.

Functions

insert_area_values(cursor)

Inserisce i valori area dal file Excel con relazioni alle località.

Parameters: - cursor

main()

No description available. Entry point that connects to a hardcoded SQLite database located at /Users/enzo/pyarchinit/pyarchinit_DB_folder/pyarchinitdddd.sqlite and invokes insert_area_values to populate area records, committing the transaction on success or rolling it back on sqlite3.Error. After insertion, it queries the pyarchinit_thesaurus_sigle table to print a summary of inserted area counts grouped by parent_sigla where tipologia_sigla = '10.7'. Returns 0 on success or 1 if the database file is not found or a database error occurs.