development_logs/legacy_src/check_db.py

import sqlite3
import pandas as pd

DB_PATH = "data/satellites.db"
conn = sqlite3.connect(DB_PATH)

print("\n==============================")
print("📊 DATABASE STATUS CHECK")
print("==============================")

# -------------------------
# Countries
# -------------------------
countries = pd.read_sql("SELECT * FROM countries", conn)
print("\n🌍 COUNTRIES TABLE")
print("Total countries:", len(countries))
print(countries.head(5))

# -------------------------
# Categories
# -------------------------
categories = pd.read_sql("SELECT * FROM categories", conn)
print("\n📂 CATEGORIES TABLE")
print("Total categories:", len(categories))

print("\nCategories per country:")
print(categories.groupby("country").size())

print("\nPreview:")
print(categories.head(10))

# -------------------------
# Satellites
# -------------------------
satellites = pd.read_sql("SELECT * FROM satellites", conn)
print("\n🛰 SATELLITES TABLE")
print("Total satellites:", len(satellites))

print("\nSatellites per category:")
print(satellites.groupby("category").size())

print("\nSatellites per operator (Top 10):")
print(satellites["operator"].value_counts().head(10))

print("\nPreview:")
print(satellites.head(10))

conn.close()
print("\n✅ Database verification completed")