Skip to content

Empower Your Prisma Schema with Camel Case and Customized Mapping! The CLI adds @Map @@Map, @updatedAt and more!!

License

Notifications You must be signed in to change notification settings

RaresAil/prisma-mapper

Repository files navigation

@raresail/prisma-mapper

Web Documentation


CodeQL Node.js CI Yarn Audit CI NPM Package Downloads


A CLI that adds @map and @@map based on a json

Installation

NPM

npm install -g @raresail/prisma-mapper

Yarn

yarn global add @raresail/prisma-mapper

Features

  • Adds @map and @@map
  • Keeps the @db. attributes for fields
  • Adds the @updatedAt for fields with the name updated_at or updatedAt
  • The prisma schema is formatted by the @prisma/internals after generation
  • The cli does not modify the current schema and generates a new one with the information from the current one
  • .pmignore Can be used to avoid adding the @map/@@map for specific fields when running the map command

Node Versions

Version Supported
<= 19.x
20.x
21.x
>= 22.x

Getting Started

If the prisma schema is often pulled you can use the cli like

yarn prisma db pull --force
  && yarn prisma-mapper generate
  && yarn prisma-mapper map
  && yarn prisma generate

or for camelCase by default

yarn prisma db pull --force
  && yarn prisma-mapper map --camel
  && yarn prisma generate

With db pull force you get the latest schema updates and force overwrites the file.

The generate command creates a json called prisma-mapper.json in the root, if the json already exists it adds in it any new fields/models. (NOT FOR --camel option)

yarn prisma-mapper generate

The json looks like the following:

  • The hasMap is added by generate if the prisma model has already a @@map
  • The name is to add @@map for a model name
  • In the fields object is to add @map for each field
{
  "model": {
    "hasMap": false,
    "name": null,
    "fields": {
      "field_name_1": null,
      "field_name_2": null
    }
  }
}

The map command modifies the schema.prisma file and adds the @map and @@map for each field and model, if the field/model-name is in the json file, the field/model will be renamed to the new name.

yarn prisma-mapper map

Options

Both 2 commands have an option --schema "new schema path to use the schema from a different location

For both commands

  • --schema "new schema path
    • is to use the schema from a different location
  • --camel
    • for map it does the mapping without a json file
    • for generate it defaults the namings to camel case in the generated json

Map options

  • -o --output "output schema path"
    • after mapping save the schema to another location

Ignore File

Example for the .pmignore file

enum_ignore_s_contents.someValue
enum_ignore_contents.*
enum_ignore_model

model_ignore_s_contents.updated_at
model_ignore_s_contents.created_at
model_ignore_s_contents.enum_three
model_ignore_contents.*
model_ignore