Getting syntax error when deploying my own schema.prisma about prisma-appsync HOT 4 CLOSED

I found the tables that was causing the problem but they seem to be simple tables which are similar to my other tables.

`model db_test3 {
id BigInt @default(autoincrement())
function_name String @db.VarChar
frequency Int?
function_priority Int?
customer_priority Int?

@@id([id, function_name])
}
`

`model devops_resource_priority_tags {
id BigInt @default(autoincrement())
key String @db.VarChar
value String @db.VarChar
count Int?
tag_priority Int?
dev_engineer_priority Int?
devops_engineer_priority Int?
dev_lead_priority Int?

@@id([id, key, value])
@@unique([key, value])
}`

from prisma-appsync.

Seems like the issue is due to Prisma-AppSync not being able to extract unique fields from the @@unique API attribute and therefore not being able to generate the associated GraphQL Schema properly.

I'll add the issue to the roadmap, so it can be resolved in the next release. In the meantime, I can suggest adding @unique API attribute on both id fields, such as:

model db_test3 {
    id      BigInt      @unique @default(autoincrement())
}

model devops_resource_priority_tags {
    id      BigInt      @unique @default(autoincrement())
}

It is not perfect, but at least you should be able to generate your GraphQL Schema without errors.

from prisma-appsync.

@unique worked. thanks

from prisma-appsync.

and when I remove and make it 1 primary key and just keep the id as primary key and the other 2 as unique. That also works.

from prisma-appsync.