Prisma Adapter

npm install @prisma/client
npm install -D prisma
npx prisma init

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql" // or "mysql", "sqlite", etc.
  url      = env("DATABASE_URL")
}

model User {
  id        String   @id @default(uuid())
  name      String
  email     String   @unique
  createdAt DateTime @default(now()) @map("created_at")
}

npx prisma generate

import { c15tInstance } from '@c15t/backend';
import { prismaAdapter } from '@c15t/backend/db/adapters/prisma';
import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

const instance = c15tInstance({
  baseURL: 'http://localhost:3000',
  database: prismaAdapter({
    client: prisma,
    // Optional: Configure logging
    logging: process.env.NODE_ENV !== 'production',
  }),
});

// Create a new record
const user = await instance.database.create('User', {
  name: 'John Doe',
  email: 'john@example.com',
});

// Find records
const users = await instance.database.find('User', {
  where: { email: 'john@example.com' },
  orderBy: { createdAt: 'desc' },
  limit: 10,
});

// Update a record
const updatedUser = await instance.database.update(
  'User',
  { where: { id: user.id } },
  { name: 'John Smith' }
);

// Delete a record
await instance.database.delete('User', { where: { id: user.id } });

await instance.database.transaction(async (trx) => {
  const user = await trx.create('User', {
    name: 'Alice',
    email: 'alice@example.com',
  });

  await trx.create('Profile', {
    userId: user.id,
    bio: 'Software engineer',
  });
});

# Create a migration
npx prisma migrate dev --name add-user-model

# Apply migrations in production
npx prisma migrate deploy

// Define your types to match your Prisma schema
type User = {
  id: string;
  name: string;
  email: string;
  createdAt: Date;
};

// Type-safe operations
const users = await instance.database.find<User>('User', {
  where: { email: 'john@example.com' },
});