普莉丝玛，TS和getServerSideProps，我被困住了

Question

我试图在我的Nextjs应用程序中通过Prisma进行一个简单的查询，没有错误，但是无法得到任何结果，而且console.log不在my: getServerSideProps .

我遗漏了什么？CasinoComment表中有数据(通过axios提交/添加)，我可以通过prisma查看这些数据，而且我没有看到任何错误.

comments.tsx

import { GetServerSideProps, GetStaticProps } from "next";
import { signIn, signOut, useSession } from "next-auth/react";
import { useRef, useState } from "react";

import { CasinoComment } from "@prisma/client";
import prisma from "../../lib/prisma";

type Props = {
  comments?: CasinoComment;
};

export default function Comment({ comments }: Props) {
 
  console.log(comments);
  ...
}


export const getServerSideProps: GetServerSideProps = async ({ params }) => {
  console.log("test222");

  const comments = await prisma.casinoComment.findMany();
  console.log(comments);
  return {
    props: { comments },
  };
};

schema.prisma

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider        = "prisma-client-js"
}

model User {
  id            String    @id @default(cuid())
  name          String?
  email         String?   @unique
  emailVerified DateTime?
  image         String?
  accounts      Account[]
  sessions      Session[]
  casino_comments CasinoComment[]
}


model CasinoComment {
  id          Int         @id @default(autoincrement())
  casinoId    Int
  content     String   @db.VarChar(2000)
  reply       Boolean?
  parentId    Int?
  approved    Boolean
  likes       Int?
  createdAt   DateTime @default(now())
  updatedAt   DateTime @default(now()) @updatedAt
  author      User @relation(fields: [authorId], references: [id])
  authorId    String
}

lib/prma.js

import { Prisma, PrismaClient } from "@prisma/client";

declare global {
  namespace NodeJS {
    interface Global {
      prisma: PrismaClient;
    }
  }
}

let prisma: PrismaClient;

if (typeof window === "undefined") {
  if (process.env.NODE_ENV === "production") {
    prisma = new PrismaClient();
  } else {
    if (!global.prisma) {
      global.prisma = new PrismaClient();
    }

    prisma = global.prisma;
  }
}

export default prisma;

Answer 1

这对我很有用。

export default function Comment(props: any) {
 
  console.log("Props are",  props); // to see data
  ...
}


export async function getServerSideProps() {
    const comments = await prisma.casinoComment.findMany();
    return {
      props: {
        comments: comments
      },
    };
  }

Answer 2

问题是我试图在组件中使用getServerSideProps :/学到的东西！