38 lines
725 B
Markdown
38 lines
725 B
Markdown
|
# @the-order/database
|
||
|
|
|
||
|
|
PostgreSQL database client and utilities for The Order.
|
||
|
|
|
||
|
|
## Usage
|
||
|
|
|
||
|
|
```typescript
|
||
|
|
import { getPool, query, healthCheck } from '@the-order/database';
|
||
|
|
|
||
|
|
// Initialize pool
|
||
|
|
const pool = getPool({
|
||
|
|
connectionString: process.env.DATABASE_URL,
|
||
|
|
max: 20,
|
||
|
|
});
|
||
|
|
|
||
|
|
// Execute query
|
||
|
|
const result = await query('SELECT * FROM users WHERE id = $1', [userId]);
|
||
|
|
|
||
|
|
// Health check
|
||
|
|
const isHealthy = await healthCheck();
|
||
|
|
```
|
||
|
|
|
||
|
|
## Migrations
|
||
|
|
|
||
|
|
Migrations are handled by `node-pg-migrate`:
|
||
|
|
|
||
|
|
```bash
|
||
|
|
# Create a new migration
|
||
|
|
pnpm --filter @the-order/database migrate:create migration-name
|
||
|
|
|
||
|
|
# Run migrations
|
||
|
|
pnpm --filter @the-order/database migrate up
|
||
|
|
|
||
|
|
# Rollback migrations
|
||
|
|
pnpm --filter @the-order/database migrate down
|
||
|
|
```
|
||
|
|
|