codecret | Software Engineer Posts

codecret | Software Engineer

Explore posts from servers

CC#JCHJava Community | Help. Code. Learn.TtRPC DTDrizzle Team BABetter Auth

•Created by codecret | Software Engineer on 3/21/2025 in #help

update many to many relationship

I'm working with Drizzle ORM and have a many-to-many relationship between projects and users using a projectUsers join table. When updating a project's members, I see two possible approaches: 1- Delete all existing members and reinsert the new ones 2-Selectively update the members - Add new members, remove missing ones, and keep unchanged ones. i have prepared schemas and relations:

export const projects = pgTable("project", {
  id: uuid("id").defaultRandom().primaryKey(),
  title: text("name").notNull(),
  description: text("description"),
  icon: iconStatusEnum("icon").default("globe").notNull(),
  status: projectStatusEnum("status").default("in-progress").notNull(),
  createdBy: text("created_by").references(() => users.id),
  createdAt: timestamp("created_at").notNull().defaultNow(),
});

export const projectUsers = pgTable("project_user", {
  id: uuid("id").defaultRandom().primaryKey(),
  projectId: uuid("project_id")
    .notNull()
    .references(() => projects.id),
  userId: text("user_id")
    .notNull()
    .references(() => users.id),
});

export const projectRelations = relations(projects, ({ many }) => ({
  members: many(projectUsers),
}));

export const userRelations = relations(users, ({ many }) => ({
  members: many(projectUsers),
}));

export const projectUserRelations = relations(projectUsers, ({ one }) => ({
  project: one(projects, {
    fields: [projectUsers.projectId],
    references: [projects.id],
  }),
  user: one(users, {
    fields: [projectUsers.userId],
    references: [users.id],
  }),
}));

export const projects = pgTable("project", {
  id: uuid("id").defaultRandom().primaryKey(),
  title: text("name").notNull(),
  description: text("description"),
  icon: iconStatusEnum("icon").default("globe").notNull(),
  status: projectStatusEnum("status").default("in-progress").notNull(),
  createdBy: text("created_by").references(() => users.id),
  createdAt: timestamp("created_at").notNull().defaultNow(),
});

export const projectUsers = pgTable("project_user", {
  id: uuid("id").defaultRandom().primaryKey(),
  projectId: uuid("project_id")
    .notNull()
    .references(() => projects.id),
  userId: text("user_id")
    .notNull()
    .references(() => users.id),
});

export const projectRelations = relations(projects, ({ many }) => ({
  members: many(projectUsers),
}));

export const userRelations = relations(users, ({ many }) => ({
  members: many(projectUsers),
}));

export const projectUserRelations = relations(projectUsers, ({ one }) => ({
  project: one(projects, {
    fields: [projectUsers.projectId],
    references: [projects.id],
  }),
  user: one(users, {
    fields: [projectUsers.userId],
    references: [users.id],
  }),
}));

existing query to update project (without updating projectUsers):

 const { projectId, ...updateFields, projectUsers } = input;

      const project = await db.query.projects.findFirst({
        where: eq(projects.id, projectId),
      });

      const updatedProject = await db
        .update(projects)
        .set(updateFields)
        .where(eq(projects.id, projectId))
        .returning();

      return updatedProject;

 const { projectId, ...updateFields, projectUsers } = input;

      const project = await db.query.projects.findFirst({
        where: eq(projects.id, projectId),
      });

      const updatedProject = await db
        .update(projects)
        .set(updateFields)
        .where(eq(projects.id, projectId))
        .returning();

      return updatedProject;

1 replies

BABetter Auth

•Created by codecret | Software Engineer on 3/18/2025 in #help

403 error when listing user from superadmin role

auth.ts

 user: {
    deleteUser: {
      enabled: true,
    },
    additionalFields: {
      role: {
        type: ["user", "admin", "superadmin"],
      },
    },
  },
  plugins: [
    username(),
    admin({
      ac: ac,
      roles,
      adminRoles: ["admin", "superadmin"],
      defaultRole: "admin",
    }),
    nextCookies(),
  ],

 user: {
    deleteUser: {
      enabled: true,
    },
    additionalFields: {
      role: {
        type: ["user", "admin", "superadmin"],
      },
    },
  },
  plugins: [
    username(),
    admin({
      ac: ac,
      roles,
      adminRoles: ["admin", "superadmin"],
      defaultRole: "admin",
    }),
    nextCookies(),
  ],

authclient.ts

export const authClient = createAuthClient({
  baseURL: env.NEXT_PUBLIC_BETTER_AUTH_URL,
  plugins: [
    usernameClient(),
    adminClient({
      ac,
      roles,
      adminRoles: ["admin", "superadmin"],
      defaultRole: "admin",
    }),
    inferAdditionalFields<typeof auth>(),
  ],
});

export const authClient = createAuthClient({
  baseURL: env.NEXT_PUBLIC_BETTER_AUTH_URL,
  plugins: [
    usernameClient(),
    adminClient({
      ac,
      roles,
      adminRoles: ["admin", "superadmin"],
      defaultRole: "admin",
    }),
    inferAdditionalFields<typeof auth>(),
  ],
});

error ?

 const newData = await auth.api.listUsers({
        query: {
          limit: 10,
          sortBy: "createdAt",
          sortDirection: "desc",
        },
      });

 const newData = await auth.api.listUsers({
        query: {
          limit: 10,
          sortBy: "createdAt",
          sortDirection: "desc",
        },
      });

returning

 
Error fetching users: [Error [APIError]: ] {
  status: 'UNAUTHORIZED',
  body: undefined,
  headers: {},
  statusCode: 401
}

 
Error fetching users: [Error [APIError]: ] {
  status: 'UNAUTHORIZED',
  body: undefined,
  headers: {},
  statusCode: 401
}

6 replies

BABetter Auth

•Created by codecret | Software Engineer on 3/18/2025 in #help

you are not allowed to list users 403 error

i want to create superadmin for the owner of sas project, auth

    additionalFields: {
      role: {
        type: ["user", "admin", "superadmin"],
      },
    },
  },
  plugins: [
    username(),
    admin({
      ac,
      roles: {
        admin: adminRole,
        superadmin,
      },
    }),

    additionalFields: {
      role: {
        type: ["user", "admin", "superadmin"],
      },
    },
  },
  plugins: [
    username(),
    admin({
      ac,
      roles: {
        admin: adminRole,
        superadmin,
      },
    }),

and for authClient.tsx

 adminClient({
      ac,
      roles: {
        admin: adminRole,
        superadmin,
      },
    }),

 adminClient({
      ac,
      roles: {
        admin: adminRole,
        superadmin,
      },
    }),

and its still showing "code": "YOU_ARE_NOT_ALLOWED_TO_LIST_USERS", here is my permissions:

const statement = {
  ...defaultStatements,
} as const;

export const ac = createAccessControl(statement);

const adminRole = ac.newRole({
  ...adminAc.statements,
});

const superadmin = ac.newRole({
  ...adminAc.statements,
});

export { adminRole, superadmin };

const statement = {
  ...defaultStatements,
} as const;

export const ac = createAccessControl(statement);

const adminRole = ac.newRole({
  ...adminAc.statements,
});

const superadmin = ac.newRole({
  ...adminAc.statements,
});

export { adminRole, superadmin };

15 replies

TtRPC

•Created by codecret | Software Engineer on 2/15/2025 in #❓-help

correct way to handle errors run time errors

7 replies

TtRPC

•Created by codecret | Software Engineer on 2/13/2025 in #❓-help

invalidate query

whenever i add a user my user list is not updating

 const mutation = trpc.user.addUser.useMutation();

  async function onSubmit(values: z.infer<typeof formSchema>) {
    await mutation.mutateAsync(values);
    router.push("/admin/all-employees");
  }

 const mutation = trpc.user.addUser.useMutation();

  async function onSubmit(values: z.infer<typeof formSchema>) {
    await mutation.mutateAsync(values);
    router.push("/admin/all-employees");
  }

does not get updated

 const { data: users, isLoading } = trpc.user.getUsers.useQuery(undefined, {
    refetchOnMount: false,
    refetchOnReconnect: false,
  });

 const { data: users, isLoading } = trpc.user.getUsers.useQuery(undefined, {
    refetchOnMount: false,
    refetchOnReconnect: false,
  });

what i have tried :

const mutation = trpc.user.addUser.useMutation(["addUser"]);

const mutation = trpc.user.addUser.useMutation(["addUser"]);

searched for invalidate query but couldn't know how to setup a mutation key and invalidate it caused an error

Type 'string[]' has no properties in common with type 'UseTRPCMutationOptions<{ name: string; email: string; username: string; password: string; role: string; }, TRPCClientErrorLike<{ input: { name: string; email: string; username: string; password: string; role: string; }; output: { user: { name: string; ... 9 more ...; | undefined;...'.ts(2559)

Type 'string[]' has no properties in common with type 'UseTRPCMutationOptions<{ name: string; email: string; username: string; password: string; role: string; }, TRPCClientErrorLike<{ input: { name: string; email: string; username: string; password: string; role: string; }; output: { user: { name: string; ... 9 more ...; | undefined;...'.ts(2559)

16 replies

BABetter Auth

•Created by codecret | Software Engineer on 2/12/2025 in #help

How to create new user using drizzle to better-auth users schema

41 replies

BABetter Auth

•Created by codecret | Software Engineer on 2/12/2025 in #help

3 replies

CC#

•Created by codecret | Software Engineer on 10/15/2023 in #help

❔ my string event click isn't working

im trying to include this div inside my gridData, but once i store it in shareBtnvariable it doesnot work but once i get it out of the Scripts it works normally ((all the idea is to trigger

data-kt-menu-trigger="click"

data-kt-menu-trigger="click"

which will automatically do everything) which is not triggering what is the problem

@section Scripts {
    <partial name="_GridViewResourcesScript" />
    <partial name="_ValidationScriptsPartial" />

    <script>
        $(document).ready(function () {
const dt = $('#gridData').DataTable({
                "createdRow": function (row, data, index) {
                    // actions column
                    var shareBtn = `
                        <div class="d-flex align-items-center mx-1 mx-lg-3">
                            <div onclick=showShareMenu() class=" btn btn-icon  web-br-circle headerImage-box p-3 w-40px h-30px w-md-40px h-md-40px"
                                    data-kt-menu-trigger="click"
                                    data-kt-menu-attach="parent"
                                    data-kt-menu-placement="bottom-end"
                                    data-kt-menu-flip="bottom">
                                <?xml version="1.0" encoding="UTF-8" ?>
                                <here is svg > 
                            </div>
                            <!--begin::Menu sub (this menu should appear when clicking into svg >
                            <div class="menu menu-sub  data-kt-menu="true">
                                <button id="fb" class="btn w-full">
                                    Share Facebook
                                </button>
                                    </div>
                                </div>`;

                    var btnGroup = `<div class="btn-group"> ${shareBtn} </div>`;
                    var table = $('#gridData').DataTable();
                    var cell = table.cell(index, 5);
                    cell.data(btnGroup);
}
                },

@section Scripts {
    <partial name="_GridViewResourcesScript" />
    <partial name="_ValidationScriptsPartial" />

    <script>
        $(document).ready(function () {
const dt = $('#gridData').DataTable({
                "createdRow": function (row, data, index) {
                    // actions column
                    var shareBtn = `
                        <div class="d-flex align-items-center mx-1 mx-lg-3">
                            <div onclick=showShareMenu() class=" btn btn-icon  web-br-circle headerImage-box p-3 w-40px h-30px w-md-40px h-md-40px"
                                    data-kt-menu-trigger="click"
                                    data-kt-menu-attach="parent"
                                    data-kt-menu-placement="bottom-end"
                                    data-kt-menu-flip="bottom">
                                <?xml version="1.0" encoding="UTF-8" ?>
                                <here is svg > 
                            </div>
                            <!--begin::Menu sub (this menu should appear when clicking into svg >
                            <div class="menu menu-sub  data-kt-menu="true">
                                <button id="fb" class="btn w-full">
                                    Share Facebook
                                </button>
                                    </div>
                                </div>`;

                    var btnGroup = `<div class="btn-group"> ${shareBtn} </div>`;
                    var table = $('#gridData').DataTable();
                    var cell = table.cell(index, 5);
                    cell.data(btnGroup);
}
                },

8 replies

Gaming

Programming