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!
}

Lenik · Accepted Answer · 2020-01-31 09:29:05Z

3

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

answered Jan 31, 2020 at 9:29

Lenik

736 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create index unique for multiple fields in GraphQL FaunaDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related