如何从Prisma类中获取所有字段

Question

我在Prisma模式中有这两个表：

model Accounts {
id Int @id @default(autoincrement())
name String @db.VarChar(100)
description String? @db.VarChar(255)
timeZone Int @default(0)
tableBusinessApplication AccountsBusinessApplications[]
}
model AccountsBusinessApplications {
id Int @id @default(autoincrement())
account Accounts @relation(fields: [accountId], references: [id])
accountId Int
name String @db.VarChar(100)
identification String @db.VarChar(100)
secretKey String @db.VarChar(32)
}

我有以下代码：

const name = 'Accounts'
prisma[name].findFirst({
where: { id: 1}
}).then(result => { console.log(result) })

结果我有：

{
id: 1,
name: 'test',
description: 'test description',
timeZone: 0
}

但我在里面看不到">tableBusinessApplication"。如果我只知道第一类名称"，我如何获得所有数据帐户"；并且我不能在查询中使用'Include'？

我试图找到如何使用prisma类获得字段列表，但似乎什么都没有。

Answer 1

自棱镜4起：

import { Prisma } from '@prisma/client';
console.log("Account fields:", Prisma.dmmf.datamodel.models.find(model => model.name === "Account").fields)

Answer 2

您可以使用Prisma的DMMF属性来获取模型字段的名称。

import { PrismaClient } from '@prisma/client';
const prisma = new PrismaClient();

// A `main` function so that you can use async/await
async function main() {
// @ts-ignore
console.log('dmmf', prisma._dmmf.modelMap.Accounts.fields);
}
main()
.catch((e) => {
throw e;
})
.finally(async () => {
await prisma.$disconnect();
});

这是的输出

dmmf [
{
name: 'id',
kind: 'scalar',
isList: false,
isRequired: true,
isUnique: false,
isId: true,
isReadOnly: false,
type: 'Int',
hasDefaultValue: true,
default: { name: 'autoincrement', args: [] },
isGenerated: false,
isUpdatedAt: false
},
{
name: 'name',
kind: 'scalar',
isList: false,
isRequired: true,
isUnique: false,
isId: false,
isReadOnly: false,
type: 'String',
hasDefaultValue: false,
isGenerated: false,
isUpdatedAt: false
},
{
name: 'description',
kind: 'scalar',
isList: false,
isRequired: false,
isUnique: false,
isId: false,
isReadOnly: false,
type: 'String',
hasDefaultValue: false,
isGenerated: false,
isUpdatedAt: false
},
{
name: 'timeZone',
kind: 'scalar',
isList: false,
isRequired: true,
isUnique: false,
isId: false,
isReadOnly: false,
type: 'Int',
hasDefaultValue: true,
default: 0,
isGenerated: false,
isUpdatedAt: false
},
{
name: 'tableBusinessApplication',
kind: 'object',
isList: true,
isRequired: true,
isUnique: false,
isId: false,
isReadOnly: false,
type: 'AccountsBusinessApplications',
hasDefaultValue: false,
relationName: 'AccountsToAccountsBusinessApplications',
relationFromFields: [],
relationToFields: [],
isGenerated: false,
isUpdatedAt: false
}
]

请注意，DMMF是内部API，在未来版本中可能会有更改。