How to create index unique for multiple fields in GraphQL FaunaDB

Question

I'm trying to create a TypeDef with two fields unique restriction. I know it's possible to do it in the interface of faunaDB Console as you can see in this image, but I want to do it using a schema.

My current (not working) code, thats only assigns the first variable (in this case "promo") to the created index:

type PromoTemplateVariable {
    promo: Promo! @unique(index: "unique_promo_variable")
    variable: TemplateVariable! @unique(index: "unique_promo_variable")
    value: String!
}

score 2 · Answer 1 · answered Jan 31 '20 at 09:29

Using FaunaDB Shell:

CreateIndex({
  name:   "unique_promo_variable",
  source: Collection("PromoTemplateVariable"),
  terms: [
    {
      field: ["data", "promo"]
    },
    {
      field: ["data", "variable"]
    }
  ],
  unique: true
})

It's the only way I've found to do this until they implement this feature in the @unique directive

How to create index unique for multiple fields in GraphQL FaunaDB

1 Answers1