backend
    Preparing search index...

    Class PrismaService

    Hierarchy

    • PrismaClient
      • PrismaService

    Implements

    • OnModuleInit

    Indexable

    • [K: symbol]: {
          types: {
              operations: {
                  $executeRaw: {
                      args: [query: TemplateStringsArray | Sql, ...values: any[]];
                      result: any;
                  };
                  $executeRawUnsafe: {
                      args: [query: string, ...values: any[]];
                      result: any;
                  };
                  $queryRaw: {
                      args: [query: TemplateStringsArray | Sql, ...values: any[]];
                      result: any;
                  };
                  $queryRawUnsafe: { args: [query: string, ...values: any[]]; result: any };
              };
              payload: any;
          };
      }
    Index

    Constructors

    constructor

    Properties

    $extends

    Accessors

    author book bookGenres bookIsbn bookStatistics comment commentLike favoriteAuthor favoriteBook favoriteGenre genres haveReadIt rating user

    Methods

    $connect $disconnect $executeRaw $executeRawUnsafe $on $queryRaw $queryRawUnsafe $transaction onModuleInit

    Constructors

    • Type-safe database client for TypeScript & Node.js

      Parameters

      • OptionaloptionsArg: Subset<PrismaClientOptions, PrismaClientOptions>

      Returns PrismaService

      const prisma = new PrismaClient()
      // Fetch zero or more Users
      const users = await prisma.user.findMany()

      Read more in our docs.

    Properties

    $extends: ExtendsHook<
        "extends",
        TypeMapCb<PrismaClientOptions>,
        DefaultArgs,
        TypeMap<InternalArgs & DefaultArgs, {}>,
    >

    Accessors

    • get author(): AuthorDelegate<ExtArgs, ClientOptions>

      prisma.author: Exposes CRUD operations for the Author model.

      • Example usage:
      •
      • // Fetch zero or more Authors
      • const authors = await prisma.author.findMany()
      •

      Returns AuthorDelegate<ExtArgs, ClientOptions>

    • get book(): BookDelegate<ExtArgs, ClientOptions>

      prisma.book: Exposes CRUD operations for the Book model.

      • Example usage:
      •
      • // Fetch zero or more Books
      • const books = await prisma.book.findMany()
      •

      Returns BookDelegate<ExtArgs, ClientOptions>

    • get bookGenres(): BookGenresDelegate<ExtArgs, ClientOptions>

      prisma.bookGenres: Exposes CRUD operations for the BookGenres model.

      • Example usage:
      •
      • // Fetch zero or more BookGenres
      • const bookGenres = await prisma.bookGenres.findMany()
      •

      Returns BookGenresDelegate<ExtArgs, ClientOptions>

    • get bookIsbn(): BookIsbnDelegate<ExtArgs, ClientOptions>

      prisma.bookIsbn: Exposes CRUD operations for the BookIsbn model.

      • Example usage:
      •
      • // Fetch zero or more BookIsbns
      • const bookIsbns = await prisma.bookIsbn.findMany()
      •

      Returns BookIsbnDelegate<ExtArgs, ClientOptions>

    • get bookStatistics(): BookStatisticsDelegate<ExtArgs, ClientOptions>

      prisma.bookStatistics: Exposes CRUD operations for the BookStatistics model.

      • Example usage:
      •
      • // Fetch zero or more BookStatistics
      • const bookStatistics = await prisma.bookStatistics.findMany()
      •

      Returns BookStatisticsDelegate<ExtArgs, ClientOptions>

    • get comment(): CommentDelegate<ExtArgs, ClientOptions>

      prisma.comment: Exposes CRUD operations for the Comment model.

      • Example usage:
      •
      • // Fetch zero or more Comments
      • const comments = await prisma.comment.findMany()
      •

      Returns CommentDelegate<ExtArgs, ClientOptions>

    • get commentLike(): CommentLikeDelegate<ExtArgs, ClientOptions>

      prisma.commentLike: Exposes CRUD operations for the CommentLike model.

      • Example usage:
      •
      • // Fetch zero or more CommentLikes
      • const commentLikes = await prisma.commentLike.findMany()
      •

      Returns CommentLikeDelegate<ExtArgs, ClientOptions>

    • get favoriteAuthor(): FavoriteAuthorDelegate<ExtArgs, ClientOptions>

      prisma.favoriteAuthor: Exposes CRUD operations for the FavoriteAuthor model.

      • Example usage:
      •
      • // Fetch zero or more FavoriteAuthors
      • const favoriteAuthors = await prisma.favoriteAuthor.findMany()
      •

      Returns FavoriteAuthorDelegate<ExtArgs, ClientOptions>

    • get favoriteBook(): FavoriteBookDelegate<ExtArgs, ClientOptions>

      prisma.favoriteBook: Exposes CRUD operations for the FavoriteBook model.

      • Example usage:
      •
      • // Fetch zero or more FavoriteBooks
      • const favoriteBooks = await prisma.favoriteBook.findMany()
      •

      Returns FavoriteBookDelegate<ExtArgs, ClientOptions>

    • get favoriteGenre(): FavoriteGenreDelegate<ExtArgs, ClientOptions>

      prisma.favoriteGenre: Exposes CRUD operations for the FavoriteGenre model.

      • Example usage:
      •
      • // Fetch zero or more FavoriteGenres
      • const favoriteGenres = await prisma.favoriteGenre.findMany()
      •

      Returns FavoriteGenreDelegate<ExtArgs, ClientOptions>

    • get genres(): GenresDelegate<ExtArgs, ClientOptions>

      prisma.genres: Exposes CRUD operations for the Genres model.

      • Example usage:
      •
      • // Fetch zero or more Genres
      • const genres = await prisma.genres.findMany()
      •

      Returns GenresDelegate<ExtArgs, ClientOptions>

    • get haveReadIt(): HaveReadItDelegate<ExtArgs, ClientOptions>

      prisma.haveReadIt: Exposes CRUD operations for the HaveReadIt model.

      • Example usage:
      •
      • // Fetch zero or more HaveReadIts
      • const haveReadIts = await prisma.haveReadIt.findMany()
      •

      Returns HaveReadItDelegate<ExtArgs, ClientOptions>

    • get rating(): RatingDelegate<ExtArgs, ClientOptions>

      prisma.rating: Exposes CRUD operations for the Rating model.

      • Example usage:
      •
      • // Fetch zero or more Ratings
      • const ratings = await prisma.rating.findMany()
      •

      Returns RatingDelegate<ExtArgs, ClientOptions>

    • get user(): UserDelegate<ExtArgs, ClientOptions>

      prisma.user: Exposes CRUD operations for the User model.

      • Example usage:
      •
      • // Fetch zero or more Users
      • const users = await prisma.user.findMany()
      •

      Returns UserDelegate<ExtArgs, ClientOptions>

    Methods

    • Connect with the database

      Returns Promise<void>

    • Disconnect from the database

      Returns Promise<void>

    • Executes a prepared raw query and returns the number of affected rows.

      Type Parameters

      • T = unknown

      Parameters

      • query: TemplateStringsArray | Sql
      • ...values: any[]

      Returns PrismaPromise<number>

      const result = await prisma.$executeRaw`UPDATE User SET cool = ${true} WHERE email = ${'user@email.com'};`

      Read more in our docs.

    • Executes a raw query and returns the number of affected rows. Susceptible to SQL injections, see documentation.

      Type Parameters

      • T = unknown

      Parameters

      • query: string
      • ...values: any[]

      Returns PrismaPromise<number>

      const result = await prisma.$executeRawUnsafe('UPDATE User SET cool = $1 WHERE email = $2 ;', true, 'user@email.com')

      Read more in our docs.

    • Type Parameters

      • V extends never

      Parameters

      • eventType: V
      • callback: (event: V extends "query" ? QueryEvent : LogEvent) => void

      Returns PrismaClient

    • Performs a prepared raw query and returns the SELECT data.

      Type Parameters

      • T = unknown

      Parameters

      • query: TemplateStringsArray | Sql
      • ...values: any[]

      Returns PrismaPromise<T>

      const result = await prisma.$queryRaw`SELECT * FROM User WHERE id = ${1} OR email = ${'user@email.com'};`

      Read more in our docs.

    • Performs a raw query and returns the SELECT data. Susceptible to SQL injections, see documentation.

      Type Parameters

      • T = unknown

      Parameters

      • query: string
      • ...values: any[]

      Returns PrismaPromise<T>

      const result = await prisma.$queryRawUnsafe('SELECT * FROM User WHERE id = $1 OR email = $2;', 1, 'user@email.com')

      Read more in our docs.

    • Allows the running of a sequence of read/write operations that are guaranteed to either succeed or fail as a whole.

      Type Parameters

      • P extends PrismaPromise<any>[]

      Parameters

      • arg: [...P[]]
      • Optionaloptions: { isolationLevel?: TransactionIsolationLevel }

      Returns Promise<UnwrapTuple<P>>

      const [george, bob, alice] = await prisma.$transaction([
        prisma.user.create({ data: { name: 'George' } }),
        prisma.user.create({ data: { name: 'Bob' } }),
        prisma.user.create({ data: { name: 'Alice' } }),
      ])

      Read more in our docs.

    • Allows the running of a sequence of read/write operations that are guaranteed to either succeed or fail as a whole.

      Type Parameters

      • R

      Parameters

      • fn: (prisma: Omit<PrismaClient, runtime.ITXClientDenyList>) => Promise<R>
      • Optionaloptions: {
            isolationLevel?: TransactionIsolationLevel;
            maxWait?: number;
            timeout?: number;
        }

      Returns Promise<R>

      const [george, bob, alice] = await prisma.$transaction([
        prisma.user.create({ data: { name: 'George' } }),
        prisma.user.create({ data: { name: 'Bob' } }),
        prisma.user.create({ data: { name: 'Alice' } }),
      ])

      Read more in our docs.

    Settings

    Member Visibility

    On This Page

    Constructors
    Properties
    Accessors
    Methods