import { db } from "../src/lib/db";
import { questions, users, answers } from "../src/lib/schema";
import { eq, isNull } from "drizzle-orm";

async function main() {
  const alice = await db.query.users.findFirst({ where: eq(users.handle, "alice.test") });
  console.log("alice:", JSON.stringify(alice, null, 2));
  const bob = await db.query.users.findFirst({ where: eq(users.handle, "bob.test") });
  console.log("bob:", JSON.stringify(bob, null, 2));

  const qs = alice
    ? await db.query.questions.findMany({ where: eq(questions.targetDid, alice.did) })
    : [];
  console.log("questions for alice:", qs.length);
  for (const q of qs) {
    const ans = await db.query.answers.findFirst({
      where: eq(answers.questionId, q.id),
      with: { answerContent: true },
    });
    console.log(
      "  atUri:",
      q.atUri,
      "| content:",
      q.content?.slice(0, 40),
      "| answer:",
      ans?.answerContent?.content?.slice(0, 30),
    );
  }

  const nullUri = await db.select().from(questions).where(isNull(questions.atUri));
  console.log("null atUri questions:", nullUri.length);
  process.exit(0);
}

main();