mralexsaavedra/spotiarr/prisma-client-api

import { PrismaClient } from "../generated/client";
import { PrismaPg } from "@prisma/adapter-pg";
const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL,
});
const prisma = new PrismaClient({ adapter });

// Find by unique field
const user = await prisma.user.findUnique({
  where: { email: "alice@prisma.io" },
});
// Find with filter
const users = await prisma.user.findMany({
  where: { role: "ADMIN" },
  orderBy: { createdAt: "desc" },
  take: 10,
});

const user = await prisma.user.create({
  data: {
    email: "alice@prisma.io",
    name: "Alice",
    posts: {
      create: { title: "Hello World" },
    },
  },
  include: { posts: true },
});

const user = await prisma.user.update({
  where: { id: 1 },
  data: { name: "Alice Smith" },
});

await prisma.user.delete({
  where: { id: 1 },
});

const [user, post] = await prisma.$transaction([
  prisma.user.create({ data: { email: "alice@prisma.io" } }),
  prisma.post.create({ data: { title: "Hello", authorId: 1 } }),
]);

references/constructor.md        - PrismaClient constructor options
references/model-queries.md      - CRUD operations
references/query-options.md      - select, include, omit, where, orderBy
references/filters.md            - Filter conditions and operators
references/relations.md          - Relation queries and nested operations
references/transactions.md       - Transaction API
references/raw-queries.md        - $queryRaw, $executeRaw
references/client-methods.md     - $connect, $disconnect, $on, $extends