Luke Comments - Convex Community

projects: defineTable({
    title: v.string(),
    user: v.id("users"),
    isArchived: v.boolean(),
    parentProject: v.optional(v.id("projects")),
    icon: v.optional(v.string()),
    isFavorited: v.boolean(),
  })
    .index("by_user", ["user"])
    .index("by_user_parent", ["user", "parentProject"]),
notes: defineTable({
    title: v.string(),
    content: v.optional(v.string()),
    user: v.id("users"),
    project: v.optional(v.id("projects")),
    isArchived: v.boolean(),
  })
    .index("by_user", ["user"])
    .index("by_project", ["project"]),

46 replies

CCConvex Community

•Created by Luke on 10/16/2023 in #support-community

Best practices for joining data in query

So this is the raw query without any wrappers/anything special

46 replies

CCConvex Community

•Created by Luke on 10/16/2023 in #support-community

Best practices for joining data in query

export const getById = query({
  args: { projectId: v.id("projects") },
  handler: async (ctx, args) => {
    const identity = await ctx.auth.getUserIdentity();

    const project = await ctx.db.get(args.projectId);

    if (!project) {
      throw new Error("Not found");
    }

    if (!project.isArchived) {
      return project;
    }

    if (!identity) {
      throw new Error("Not authenticated");
    }

    const userId = identity.subject;

    if (project.user !== userId) {
      throw new Error("Unauthorized");
    }

    const notes = await ctx.db
      .query("notes")
      .withIndex("by_project", (q) => q.eq("project", project._id))
      .collect();

    const x = {
      ...project,
      notes: notes,
    };

    return x;
  },
});

46 replies

CCConvex Community

•Created by Luke on 10/16/2023 in #support-community

Best practices for joining data in query

I'll try removing withUser and using the intermediate variable

46 replies

CCConvex Community

•Created by Luke on 10/16/2023 in #support-community

Best practices for joining data in query

Same issue

46 replies

CCConvex Community

•Created by Luke on 10/16/2023 in #support-community

Best practices for joining data in query

(property) getById: FunctionReference<"query", "public", {
    projectId: Id<"projects">;
}, {
    _id: Id<"projects">;
    _creationTime: number;
    parentProject?: Id<"projects"> | undefined;
    icon?: string | undefined;
    title: string;
    user: Id<"users">;
    isArchived: boolean;
    isFavorited: boolean;
} | {
notes: {
        _id: Id<"notes">;
        _creationTime: number;
        project?: Id<"projects"> | undefined;
        content?: string | undefined;
        title: string;
        user: Id<"users">;
        isArchived: boolean;
    }[];
_id: Id<"projects">;
    _creationTime: number;
    parentProject?: Id<"projects"> | undefined;
    icon?: string | undefined;
    title: string;
    user: Id<"users">;
    isArchived: boolean;
    isFavorited: boolean;
}>

46 replies

CCConvex Community

•Created by Luke on 10/16/2023 in #support-community

Best practices for joining data in query

I'll change both

46 replies