import os
import sys
from pathlib import Path

PROJECT_DIR = Path("/home/skeversu/skever-portal-v1")
os.chdir(PROJECT_DIR)
sys.path.insert(0, str(PROJECT_DIR))
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "config.settings")

import django
django.setup()

from django.apps import apps
from django.db import connection
from django.db.migrations.loader import MigrationLoader

print("=== DATABASE ===")
print("Engine:", connection.settings_dict["ENGINE"])
print("Database:", connection.settings_dict["NAME"])

connection.ensure_connection()
print("Connection: OK")

print("\n=== BUSINESS MODELS ===")
for name in [
    "SystemCheck", "Customer", "Order", "OrderItem",
    "Invoice", "Payment", "Dispatch", "AuditEvent"
]:
    try:
        model = apps.get_model("core", name)
        print(name, "->", model._meta.db_table)
    except LookupError:
        print(name, "-> NOT REGISTERED")

print("\n=== MIGRATION HISTORY ===")
loader = MigrationLoader(connection, ignore_no_migrations=True)

for label in [
    "core", "accounts", "auth", "admin",
    "contenttypes", "sessions"
]:
    files = sorted(
        name for app, name in loader.disk_migrations
        if app == label
    )
    applied = sorted(
        name for app, name in loader.applied_migrations
        if app == label
    )
    print(f"\n{label}")
    print("Files:", files or "NONE")
    print("Applied:", applied or "NONE")

print("\n=== INSPECTION FINISHED ===")
print("No migrations were applied.")