Something went wrong. Try again.
Atproto AMA app
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536import { 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();