import os
import firebase_admin
from firebase_admin import credentials, firestore
from pathlib import Path

# Initialize firebase admin
key_path = Path("firebase-key.json")
if key_path.exists():
    cred = credentials.Certificate(str(key_path))
    _firebase_app = firebase_admin.initialize_app(cred)
else:
    print("firebase-key.json not found!")
    exit(1)

db = firestore.client()

# Query first document in faqs
try:
    docs = list(db.collection("faqs").limit(1).stream())
    if docs:
        doc = docs[0]
        data = doc.to_dict()
        created_at = data.get("created_at")
        print(f"created_at type: {type(created_at)}")
        print(f"created_at value: {created_at}")
        if created_at:
            print(f"has timestamp: {hasattr(created_at, 'timestamp')}")
    else:
        print("No FAQs found")
except Exception as e:
    import traceback
    traceback.print_exc()