Open-source AI coworkers that each get a computer of their own: a browser, files and tools, with every action decided before it happens and recorded after. Bring any AG-UI agent.
import { eq, sql } from "drizzle-orm";
import type { Database } from "../db/client";
import { users } from "../db/schema";
/**
* Where one person is in first-run onboarding.
*
* A null `completedAt` is what gates the app into /onboarding. `step` is stored and served but
* NOTHING RESUMES FROM IT YET: the wizard keeps its step in browser state while its content is
* still being designed, so this stays 0 through a whole run. It exists so resuming is a frontend
* change when the wizard settles, not a migration.
*/
export type OnboardingStatus = {
step: number;
completedAt: string | null;
};
export type OnboardingStore = {
status: (userId: string) => Promise<OnboardingStatus>;
setStep: (userId: string, step: number) => Promise<void>;
complete: (userId: string) => Promise<void>;
};
export function createOnboardingStore(database: Database): OnboardingStore {
return {
async status(userId) {
const [row] = await database
.select({
step: users.onboardingStep,
completedAt: users.onboardingCompletedAt,
})
.from(users)
.where(eq(users.id, userId))
.limit(1);
/*
* No row reads as not started rather than as an error. It should not happen — a session
* cannot outlive its users row (the foreign key cascades) and the single-user actor's row is
* seeded at startup — but a guard that throws here would take /api/me down with it.
*/
return {
step: row?.step ?? 0,
completedAt: row?.completedAt ? row.completedAt.toISOString() : null,
};
},
async setStep(userId, step) {
await database
.update(users)
.set({ onboardingStep: step, updatedAt: new Date() })
.where(eq(users.id, userId));
},
async complete(userId) {
await database
.update(users)
.set({
// Idempotent: finishing again keeps the first timestamp, so "when did they onboard"
// stays one answer.
onboardingCompletedAt: sql`coalesce(${users.onboardingCompletedAt}, now())`,
updatedAt: new Date(),
})
.where(eq(users.id, userId));
},
};
}