GenCodify Studio Publisher Prisma Client

Prisma client library for the GenCodify Studio Publisher service.

Installation

``bash
npm install @gencodify-studio/publisher-prisma-client


or

pnpm add @gencodify-studio/publisher-prisma-client

or

yarn add @gencodify-studio/publisher-prisma-client
`

Usage

This package provides the Prisma client and utilities for database operations in the GenCodify Studio Publisher.

$3

The package supports multiple ways to configure the database connection:

#### Option 1: Single DATABASE_URL (default)

`bash
DATABASE_URL="postgresql://user:password@host:5432/database?schema=public"
`

#### Option 2: Individual environment variables

You can use individual environment variables instead of a single connection string:

| Variable | Description | Default |
|----------|-------------|---------|
| DB_HOST | Database host | - |
| DB_PORT | Database port | 5432 |
| DB_USER or DB_USERNAME | Database user | - |
| DB_PASSWORD | Database password | - |
| DB_NAME or DB_DATABASE | Database name | - |
| DB_SCHEMA | Database schema | (optional) |
| DB_SSL | Enable SSL (true/false) | false |

Example:

`bash
DB_HOST=studio-database.gencodify-infra
DB_PORT=5432
DB_USER=postgres
DB_PASSWORD=your-password
DB_NAME=gencodify
DB_SCHEMA=public
DB_SSL=true
`

#### Option 3: Programmatic configuration

`typescript
import { createPrisma } from '@gencodify/publisher-prisma-client';

const prisma = createPrisma({
datasourceUrl: 'postgresql://user:password@host:5432/database',
timeout: 5000,
maxWait: 2000,
});
`

$3

Set DEBUG_DB=true to log connection info (password is masked):

`bash
DEBUG_DB=true node your-app.js


Output: [Prisma] Connecting to: postgresql://user:**@host:5432/database


`

$3

`bash
pnpm generate
`

$3

`bash
pnpm migrations
``

Dependencies

- Prisma 5.12.1
- zod for schema validation
- umzug for migration management
- nanoid for ID generation

License

MIT