Lift "duplicate column name:"

[Bjoernstjerne]

I tried to reference one model two times. This leads to not correct named fields.

tested with prisma2@0.0.99

extended hello-prisma schema:

datasource db {
  provider = "sqlite"
  url      = "file:dev.db"
  default  = true
}

generator photon {
  provider = "photonjs"
  output   = "node_modules/@generated/photon"
}

generator nexus_prisma {
  provider = "nexus-prisma"
  output   = "node_modules/@generated/nexus-prisma"
}

model User {
  id      String  @default(cuid()) @id @unique
  email   String  @unique
  name    String?
  posts   Post[]
  visited Visit[] @relation(name: "visited")
  visitors Visit[] @relation(name: "visitor")
}

model Post {
  id        String   @default(cuid()) @id @unique
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  published Boolean
  title     String
  content   String?
  author    User?
}

model Visit {
  id      Int  @id
  self    User @relation(name: "visited")
  visitor User @relation(name: "visitor")
}

Lift save created this SQL:

CREATE TABLE "file:dev"."Visit"("id" INTEGER NOT NULL DEFAULT 0 ,"self" TEXT NOT NULL  REFERENCES User(id),"self" TEXT NOT NULL  REFERENCES User(id),PRIMARY KEY ("id"));

[Bjoernstjerne]

I saw that in my project this works on another model so I tried to change some things:

for the example this works

datasource db {
  provider = "sqlite"
  url      = "file:dev.db"
  default  = true
}

generator photon {
  provider = "photonjs"
  output   = "node_modules/@generated/photon"
}

generator nexus_prisma {
  provider = "nexus-prisma"
  output   = "node_modules/@generated/nexus-prisma"
}

model User {
  id      String  @default(cuid()) @id @unique
  email   String  @unique
  name    String?
  posts   Post[]
  visited Visit[] @relation(name: "visited")
  visitor Visit[] @relation(name: "visitor")
}

model Post {
  id        String   @default(cuid()) @id @unique
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  published Boolean
  title     String
  content   String?
  author    User?
}

model Visit {
  id      Int  @id
  visited User @relation(name: "visited")
  visitor User @relation(name: "visitor")
}

Changes:

• remove the s from visitors
• rename self to visited

the related fields must have the same name in both models.

[pantharshit00]

I can confirm this. Related: https://github.com/prisma/photonjs/issues/131

[mavilein]

A fix for this is available on alpha.