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
- Advanced Queries - In-depth filtering, pagination, and aggregation
- Relations & Joins - One-to-many and many-to-many relations
- Database Providers - Provider dialect specifics
- Client Languages - Complete language runtime specifications