CRUD Operations

AN5 ORM provides a clean, type-safe API for all CRUD operations tailored for Typescript.


Client Setup

import { createAn5Adapter } from '@an5/adapters';

const db = createAn5Adapter({
  connectionString: process.env.DATABASE_URL!,
});

1. Create

Create a Single Record

const user = await db.user.create({
  data: {
    email: 'john@example.com',
    name: 'John Doe'
  }
});
console.log(user);

Create Many Records

const result = await db.user.createMany({
  data: [
    { email: 'alice@example.com', name: 'Alice' },
    { email: 'bob@example.com', name: 'Bob' },
  ]
});
console.log(`Created ${result.count} users`);

2. Read

Find by Primary Key or Unique Field

const user = await db.user.findUnique({
  where: { email: 'john@example.com' }
});

Find Many Records with Filter & Sort

const users = await db.user.findMany({
  where: {
    isActive: true,
    email: { contains: '@example.com' }
  },
  orderBy: { createdAt: 'desc' },
  skip: 0,
  take: 10
});

3. Update

Update Single Record

const updated = await db.user.update({
  where: { id: user.id },
  data: { name: 'Johnny Doe' }
});

4. Delete

Delete Single Record

await db.user.delete({
  where: { id: user.id }
});

Next Steps