Retrieve all records from a table using Prisma client

Question

Retrieve all records from a table using Prisma client

I need to retrieve all data from a table using Prisma. How can I achieve this? (SELECT * FROM application)

const applications = prisma.application.findMany({
        // Retrieves all fields for the user
        include: {
            posts: {
                select: {
                    age: true,
                    about_section: true,
                    user_id: true
                },
            },
        },
    })
    console.log(applications.age)

This is the structure of my schema:

model application {
  application_id Int     @id @default(autoincrement())
  age            String? @db.VarChar(255)
  about_section  String? @db.VarChar(255)
  user_id        Int?
  users          users?  @relation(fields: [user_id], references: [user_id], onDelete: Restrict, onUpdate: Restrict, map: "application_ibfk_1")

  @@index([user_id], map: "user_id")
}

javascript mysql express orm prisma

Answer 1

Answer №1

When dealing with rows, using findMany() without specifying a where condition will retrieve all rows from the table:

Retrieve all Records
The following findMany query fetches all User records:

const users = await prisma.user.findMany()

For columns/fields, if include or select is not specified, Prisma applies a default selection set:

By default, when a query returns records (rather than just a count), the result includes the default selection set:

All scalar fields defined in the Prisma schema (including enums)

No relations are included

For querying SELECT * FROM application (without including the users relation):

const applications = await prisma.application.findMany();

To additionally include the users relation in the fetched data:

const applications = await prisma.application.findMany({
  include: {
    users: true // will include all fields
  }
});

Answer 2

When dealing with rows, using findMany() without specifying a where condition will retrieve all rows from the table:

Retrieve all Records
The following findMany query fetches all User records:

const users = await prisma.user.findMany()

For columns/fields, if include or select is not specified, Prisma applies a default selection set:

By default, when a query returns records (rather than just a count), the result includes the default selection set:

All scalar fields defined in the Prisma schema (including enums)

No relations are included

For querying SELECT * FROM application (without including the users relation):

const applications = await prisma.application.findMany();

To additionally include the users relation in the fetched data:

const applications = await prisma.application.findMany({
  include: {
    users: true // will include all fields
  }
});

Retrieve all records from a table using Prisma client

Answer №1

Similar questions

How can you protect against XSS when using React server-side rendering and window.initialState?

Error: The value property is undefined and cannot be read at the HTMLButtonElement

Extracting IDs, classes, and elements from a DOM node and converting it into a string format

Facing an issue where WordPress AJAX is not showing the expected content

Issue with resetting Knockout.JS array - unable to make it work

Unable to upload photo using Ajax request

Is it possible to execute PHP without using Ajax when clicking on a Font Awesome icon?

Verify the value of the variable matches the key of the JavaScript object array and retrieve the corresponding value

React Native, state values are stagnant

Finding specific data across multiple tables and displaying results from only one table

Saving a Java byte array into a MySQL database

Using Jquery to Modify Information within HTML Table Cells

Filter JSON data deeply for specific values

Choose an option from a dropdown menu and assign it to a JavaScript variable

Guide to installing angular-ui-bootstrap through npm in angularjs application

Find the variance between the sums of columns 3 and 5 using Angular

What is the best way to stack a canvas box on top of another canvas box?

Is it possible to derive the language code without using the Common Locale Data Repository from a rough Unicode text

When trying to insert JavaScript into the console, a section of the code fails to execute

Utilizing AJAX for passport verification and validation