Skip to main content
Glama

Prisma MCP Server

Official
by prisma
Apache 2.0
4
44,231
  • Linux
  • Apple
upsert-create.ts4.15 kB
import { faker } from '@faker-js/faker' import { setupTestSuite } from './_matrix' // @ts-ignore import type { PrismaClient } from './generated/prisma/client' declare let prisma: PrismaClient setupTestSuite(({ contentProperty }) => { let id: string beforeEach(() => { id = faker.database.mongodbObjectId() }) test('set', async () => { const comment = await prisma.comment.upsert({ where: { id }, update: {}, create: { id, country: 'France', content: { set: { text: 'Hello World', upvotes: { vote: true, userId: '10', }, }, }, }, }) expect(comment).toMatchInlineSnapshot( { id: expect.any(String) }, ` { "content": { "text": "Hello World", "upvotes": [ { "userId": "10", "vote": true, }, ], }, "country": "France", "id": Any<String>, } `, ) }) test('set shorthand', async () => { const comment = await prisma.comment.upsert({ where: { id }, update: {}, create: { id, country: 'France', content: { text: 'Hello World', upvotes: { vote: true, userId: '10', }, }, }, }) expect(comment).toMatchInlineSnapshot( { id: expect.any(String) }, ` { "content": { "text": "Hello World", "upvotes": [ { "userId": "10", "vote": true, }, ], }, "country": "France", "id": Any<String>, } `, ) }) test('set null', async () => { const comment = prisma.comment.upsert({ where: { id }, update: {}, create: { id, country: 'France', content: { // @ts-test-if: contentProperty === 'optional' set: null, }, }, }) if (contentProperty === 'optional') { expect(await comment).toMatchInlineSnapshot( { id: expect.any(String) }, ` { "content": null, "country": "France", "id": Any<String>, } `, ) } else { await expect(comment).rejects.toThrow( expect.objectContaining({ message: expect.stringContaining('Argument `set` must not be null'), }), ) } }) test('set null shorthand', async () => { const comment = prisma.comment.upsert({ where: { id }, update: {}, create: { id, country: 'France', // @ts-test-if: contentProperty === 'optional' content: null, }, }) if (contentProperty === 'optional') { expect(await comment).toMatchInlineSnapshot( { id: expect.any(String) }, ` { "content": null, "country": "France", "id": Any<String>, } `, ) } else { await expect(comment).rejects.toThrow( expect.objectContaining({ message: expect.stringContaining('Argument `content` must not be null.'), }), ) } }) test('set nested list', async () => { const comment = await prisma.comment.upsert({ where: { id }, update: {}, create: { id, country: 'France', content: { set: { text: 'Hello World', upvotes: [ { userId: '10', vote: true }, { userId: '11', vote: true }, ], }, }, }, }) expect(comment).toMatchInlineSnapshot( { id: expect.any(String) }, ` { "content": { "text": "Hello World", "upvotes": [ { "userId": "10", "vote": true, }, { "userId": "11", "vote": true, }, ], }, "country": "France", "id": Any<String>, } `, ) }) })

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/prisma/prisma'

If you have feedback or need assistance with the MCP directory API, please join our Discord server