import os
import sys

sys.path.insert(0, os.path.dirname(os.path.dirname(os.path.abspath(__file__))))

from sqlalchemy import text

from uraas.database import Base, SessionLocal, engine


def inspect():
    session = SessionLocal()
    try:
        # Check if tables exist first
        tables = ["citations", "citation_metrics", "author_metrics"]
        for table in tables:
            try:
                res = session.execute(text(f"SELECT COUNT(*) FROM {table}")).scalar()
                print(f"Table '{table}' has {res} rows")
            except Exception as e:
                print(f"Table '{table}' error: {e}")

    except Exception as e:
        print(f"Error: {e}")
    finally:
        session.close()


if __name__ == "__main__":
    inspect()