msy
msy
Explore posts from servers
RReactifluxCCConvex CommunityBABetter Auth
PostsComments
BABetter Auth
Created by msy on 4/27/2025 in #help
Cant get listUsers in the admin plugin to work
const usersQuery = useQuery({ queryKey: ["users"], queryFn: async () => { return await authClient.admin.listUsers({ query: { limit: 10 }, }); }, }); im just trying to do this. But it doesnt return anything at all. Im using it within a client component
5 replies
CCConvex Community
Created by msy on 4/26/2025 in #support-community
Type instantiation is excessively deep and possibly infinite.
const current = new Date(now - i * dayInMs); current.setUTCHours(0, 0, 0, 0); const dayStart = current.getTime(); const dayEnd = dayStart + dayInMs; const dayOfWeek = new Date(dayStart).getUTCDay(); const dailySum = await durationByUserAggregate.sum(ctx, { namespace: [userId, true], bounds: { lower: { key: dayStart, inclusive: true }, upper: { key: dayEnd, inclusive: false }, }, }); trying to use aggregate and getting "Type instantiation is excessively deep and possibly infinite" for the bounds, I have no idea how to fix this.
2 replies
CCConvex Community
Created by msy on 4/25/2025 in #support-community
Aggregating by userId and creationTime
Hi im using the Aggregate Convex component. I'm having trouble trying to figure out how I might implement these functions. Right now I believe they are aggregating all tasks. I was wondering how i could further filter to specific userIds? 
import { TableAggregate } from "@convex-dev/aggregate";
import { v } from "convex/values";
import { components } from "../_generated/api";
import { DataModel } from "../_generated/dataModel";
import { query } from "../_generated/server";
import { getDocumentOrThrow } from "../utils/db";

const durationAggregate = new TableAggregate<{
  Key: number;
  DataModel: DataModel;
  TableName: "tasks";
}>(components.aggregate, {
  sortKey: (doc) => doc._creationTime,
  sumValue: (doc) => doc.duration,
});

export const totalFocusTimeByUser = query({
  args: {
    userId: v.id("users"),
  },
  handler: async (ctx, args) => {
    await getDocumentOrThrow(ctx, "users", args.userId);
    const totalFocusTime = await durationAggregate.sum(ctx);
    return totalFocusTime;
  },
});

export const totalFocusTimeByUserForWeek = query({
  args: {
    userId: v.id("users"),
  },
  handler: async (ctx, args) => {
    await getDocumentOrThrow(ctx, "users", args.userId);
    const totalFocusTimeByWeek = await durationAggregate.sum(ctx);
    return totalFocusTimeByWeek;
  },
});
import { TableAggregate } from "@convex-dev/aggregate";
import { v } from "convex/values";
import { components } from "../_generated/api";
import { DataModel } from "../_generated/dataModel";
import { query } from "../_generated/server";
import { getDocumentOrThrow } from "../utils/db";

const durationAggregate = new TableAggregate<{
  Key: number;
  DataModel: DataModel;
  TableName: "tasks";
}>(components.aggregate, {
  sortKey: (doc) => doc._creationTime,
  sumValue: (doc) => doc.duration,
});

export const totalFocusTimeByUser = query({
  args: {
    userId: v.id("users"),
  },
  handler: async (ctx, args) => {
    await getDocumentOrThrow(ctx, "users", args.userId);
    const totalFocusTime = await durationAggregate.sum(ctx);
    return totalFocusTime;
  },
});

export const totalFocusTimeByUserForWeek = query({
  args: {
    userId: v.id("users"),
  },
  handler: async (ctx, args) => {
    await getDocumentOrThrow(ctx, "users", args.userId);
    const totalFocusTimeByWeek = await durationAggregate.sum(ctx);
    return totalFocusTimeByWeek;
  },
});
7 replies
BABetter Auth
Created by msy on 2/21/2025 in #help
Trying to use Drizzle and SingleStore in Next.js
import { db } from "@/lib/db";
import { betterAuth } from "better-auth";
import { drizzleAdapter } from "better-auth/adapters/drizzle";

const auth = betterAuth({
  database: drizzleAdapter(db, {
    provider: "mysql",
  }),
});

export default auth;
import { db } from "@/lib/db";
import { betterAuth } from "better-auth";
import { drizzleAdapter } from "better-auth/adapters/drizzle";

const auth = betterAuth({
  database: drizzleAdapter(db, {
    provider: "mysql",
  }),
});

export default auth;
This is my auth.ts which is under lib/auth.ts When running: npx @better-auth/cli generate im getting a ERROR [Better Auth]: [#better-auth]: Couldn't read your auth config.
3 replies