Combining Prisma results into a unified object

Question

Combining Prisma results into a unified object

I am currently working on a project using nextjs 13 and prisma ORM with MongoDB. My task involves fetching roles along with their permissions to create an admin role matrix. Here is the schema for the Role model.

model Role {
  id          String   @id @default(auto()) @map("_id") @db.ObjectId
  name        String   @unique
  userIDs     String[] @db.ObjectId
  users       User[]   @relation(fields: [userIDs], references: [id])
  permissions String[]

  @@map("roles")
}

When I fetch the records, I want to manipulate them slightly. Below is the query result I get.

const roles = await prisma.role.findMany({
    select: {
        name: true,
        permissions: true,
    }
})
console.log(roles);

 [
  { name: 'User', permissions: [ 'permissions.user.view.dashboard' ] },
  {
    name: 'Admin',
    permissions: [
      'permissions.admin.view.dashboard',
      'permissions.user.view.dashboard'
    ]
  }
]

I aim to combine the role name with each permission into one object as follows:

{
    'User.permissions.user.view.dashboard',
    'Admin.permissions.user.view.dashboard',
    'Admin.permissions.admin.view.dashboard'
}

Can this be achieved directly in prisma? If not, how can it be done in JavaScript?

javascript mongodb next.js prisma

Answer 1

Answer №1

In order to perform a transformation on this object at the Prisma level, direct manipulation is not possible. However, you can accomplish this transformation by following these steps:

import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

async function main() {
  const roles = await prisma.role.findMany({
    select: {
      name: true,
      permissions: true,
    },
  });
  console.log(roles);

  const updatedRoles = [];

  roles.forEach((role) => {
    role.permissions.forEach((permission) => {
      updatedRoles.push(`${role.name}.${permission}`);
    });
  });

  console.log(updatedRoles);
}

main()
  .catch((e) => {
    throw e;
  })
  .finally(async () => {
    await prisma.$disconnect();
  });

For reference, here is an example response image: https://i.sstatic.net/q8D4g.png

Answer 2

In order to perform a transformation on this object at the Prisma level, direct manipulation is not possible. However, you can accomplish this transformation by following these steps:

import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

async function main() {
  const roles = await prisma.role.findMany({
    select: {
      name: true,
      permissions: true,
    },
  });
  console.log(roles);

  const updatedRoles = [];

  roles.forEach((role) => {
    role.permissions.forEach((permission) => {
      updatedRoles.push(`${role.name}.${permission}`);
    });
  });

  console.log(updatedRoles);
}

main()
  .catch((e) => {
    throw e;
  })
  .finally(async () => {
    await prisma.$disconnect();
  });

For reference, here is an example response image: https://i.sstatic.net/q8D4g.png

Combining Prisma results into a unified object

Answer №1

Similar questions

What steps can I take to design a functional hamburger menu?

MongoDB Stitch retrieves all data fields

Next.js - Vercel deployment unsuccessful- An unanticipated internal issue has arisen

Affixing a navigation bar to the top while scrolling

Enhancing Line Graphs in React Recharts: Implementing Filters for Improved Visualization

Exploring Next.js with getServerSideProps

Guide on correctly aligning a Blender animation export with Three.js

A guide to downloading a file linked to Javascript with the help of Java

Enable the generation of scss.d.ts files with Next.js

Using Jquery ajax, I am interested in storing a single value into a variable for future use in JavaScript

There seems to be a hiccup in the distribution build of Angular grunt, as it is unable to locate the

jQuery is successfully manipulating pagination on CodeIgniter, however, the link is being updated as well

Creating a form that utilizes both jQuery and PHP to send the results, now including the complete code for reference

Obtaining worth from an entity

Having trouble with my code trying to transfer elements back and forth between two unordered lists using an "addEventListener"

Having trouble with Javascript/ajax/php: data is successfully sent from server to client, but client to server communication is not working as

Retrieve data from a different field using an aggregate function

Creating a universal representation of the global object in JavaScript that is not tied to any specific implementation

The issue of incorrect encoding in JavaScript Blob while retrieving a file from the server

NodeJS Error: Attempting to access 'json' property from an undefined source