#!/usr/bin/env python3
"""Cancella dev.db e lo ricrea con lo schema corrente."""
from __future__ import annotations
import os
import sqlite3
import sys
from pathlib import Path

ROOT = Path(__file__).resolve().parents[2]
DB = ROOT / "import-tools" / "db" / "dev.db"
SCHEMA = ROOT / "import-tools" / "db" / "schema.sql"

if DB.exists():
    DB.unlink()
    print(f"Rimosso {DB}")

conn = sqlite3.connect(DB)
with open(SCHEMA, "r") as f:
    conn.executescript(f.read())
conn.commit()
n_tables = len(conn.execute(
    "SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'"
).fetchall())
conn.close()
print(f"Creato {DB} con {n_tables} tabelle")