Ship your next SaaS in days, not months.

import { eq } from "drizzle-orm"

import { db } from "@/lib/db"
import { user } from "@/lib/db/schemas/core"
import { result } from "@/lib/either"
import { logger } from "@/lib/logger"

export async function getActiveUsers() {
    const query = await result.trycatch(
        () => db
            .select({
                id: user.id,
                name: user.name,
                email: user.email,
                createdAt: user.createdAt,
            })
            .from(user)
            .where(eq(user.active, true))
    )

    if (!query.ok) {
        logger.error({ err: query.error }, "Failed to fetch users")
        return result.fail(
            new Error("QUERY_FAILED", { cause: query.error })
        )
    }

    logger.info({ count: query.value.length }, "Fetched users")
    return result.pass(query.value)
}