NextJS PostgreSQL Prisma Example

npx create-wundergraph-app my-project -E nextjs-postgres-prisma

cd my-project
npm install
npm run start

datasource db {
  provider = "postgresql"
  url      = "postgresql://admin:admin@localhost:54322/example?schema=public"
}

model Post {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  title     String   @db.VarChar(255)
  content   String?
  published Boolean  @default(false)
  author    User     @relation(fields: [authorId], references: [id])
  authorId  Int
}

model Profile {
  id     Int     @id @default(autoincrement())
  bio    String?
  user   User    @relation(fields: [userId], references: [id])
  userId Int     @unique
}

model User {
  id      Int      @id @default(autoincrement())
  email   String   @unique
  name    String?
  posts   Post[]
  profile Profile?
}

import { createClient } from '../.wundergraph/generated/client';
import fetch from 'node-fetch';

const seed = async () => {
  const client = createClient({
    customFetch: fetch as any,
  });
  const user = await client.query({
    operationName: 'UserByEmail',
    input: {
      email: '[email protected]',
    },
  });
  if (user?.data?.db_findFirstUser) {
    return;
  }
  const out = await client.mutate({
    operationName: 'CreateUser',
    input: {
      name: 'Jens',
      bio: 'Founder@WunderGraph',
      email: '[email protected]',
      title: 'Welcome to WunderGraph!',
      content: 'This is WunderGraph =)',
      published: true,
    },
  });
  console.log('seed:out', JSON.stringify(out));
};

seed();