EPIC: Multi field id criterion (Multi column PKs)

[prisma]

EPIC: Multi field id criterion (Multi column PKs)

[mavilein]

Initial break down of Work Packages

• Datamodel Parser
  • extend Model data structure in dml module to store informations on multi field ids
  • implement new DirectiveValidator for @@id
  • test cases:
    • basic happy path
    • name arg must not be optional
    • the directive must not refer to undefined fields
    • a model must either have @id or @@id
• Migration Engine
  • core: implement new migration steps for indexes (diffing + applying)
  • sql connector:
    • calculation of sql schema
    • diffing of sql schemas
    • add SQL rendering to database step applier
• Query Engine
  • core:
    • adapt Schema so it can accept a combination fields as id criteria=on
    • adapt all places that expect an id to be a single PrismaValue
  • connector:
    • adapt all places that expect an id to be a single PrismaValue
• Introspection Engine:
  • core: no work required
  • connector:
    • verify that the sql-schema-describer can handle compound ids
    • adapt Datamodel calculation so that compound ids are translated to @@id in a model

[mavilein]

Open Questions

• the GraphQL protocol for the communication between photon client and query engine must be defined

[mavilein]

I asked for a spec for the Photon API in this issue.