Mohammad Orabi 🇱🇧 Comments

Mohammad Orabi 🇱🇧

Explore posts from servers

•Created by Mohammad Orabi 🇱🇧 on 11/22/2024 in #help-and-questions

TypedSql generating wrong types from the query

Thank you very much appreciate it yes I think its an important issue , as I was forced to cast my type when querying it for typescript to shutup so that defeats the whole purpose of typedSQL haha

5 replies

PPrisma

•Created by Mohammad Orabi 🇱🇧 on 11/22/2024 in #help-and-questions

TypedSql generating wrong types from the query

here is my related schemas

model Chest {
  id          String          @id @default(cuid()) @map("id")
  name        String          @map("name")
  imageUrl    String?         @map("image_url")
  description String?         @map("description")
  rarity      Rarity          @map("rarity")
  amount      Int?            @map("amount")
  gameId      String          @map("game_id")
  game        Game            @relation(fields: [gameId], references: [id], onDelete: Cascade)
  currencies  ChestCurrency[]
  cosmetics   ChestCosmetic[]
  createdAt   DateTime        @default(now()) @map("created_at")
  updatedAt   DateTime        @updatedAt @map("updated_at")

  @@unique([gameId, rarity])
  @@index([gameId])
  @@map("chests")
}

model ChestKeys {
  id        String   @id @default(cuid()) @map("id")
  basic     Int      @default(0) @map("basic")
  premium   Int      @default(0) @map("premium")
  userId    String   @map("user_id")
  user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  gameId    String   @map("game_id")
  game      Game     @relation(fields: [gameId], references: [id], onDelete: Cascade)
  createdAt DateTime @default(now()) @map("created_at")
  updatedAt DateTime @updatedAt @map("updated_at")

  @@unique([userId, gameId])
  @@index([userId])
  @@index([gameId])
  @@map("chest_keys")
}

model Chest {
  id          String          @id @default(cuid()) @map("id")
  name        String          @map("name")
  imageUrl    String?         @map("image_url")
  description String?         @map("description")
  rarity      Rarity          @map("rarity")
  amount      Int?            @map("amount")
  gameId      String          @map("game_id")
  game        Game            @relation(fields: [gameId], references: [id], onDelete: Cascade)
  currencies  ChestCurrency[]
  cosmetics   ChestCosmetic[]
  createdAt   DateTime        @default(now()) @map("created_at")
  updatedAt   DateTime        @updatedAt @map("updated_at")

  @@unique([gameId, rarity])
  @@index([gameId])
  @@map("chests")
}

model ChestKeys {
  id        String   @id @default(cuid()) @map("id")
  basic     Int      @default(0) @map("basic")
  premium   Int      @default(0) @map("premium")
  userId    String   @map("user_id")
  user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  gameId    String   @map("game_id")
  game      Game     @relation(fields: [gameId], references: [id], onDelete: Cascade)
  createdAt DateTime @default(now()) @map("created_at")
  updatedAt DateTime @updatedAt @map("updated_at")

  @@unique([userId, gameId])
  @@index([userId])
  @@index([gameId])
  @@map("chest_keys")
}

5 replies

PPrisma

•Created by Mohammad Orabi 🇱🇧 on 11/22/2024 in #help-and-questions

Bug in TypedSQL in version 5.22

will do a new one

9 replies

PPrisma

•Created by Mohammad Orabi 🇱🇧 on 11/22/2024 in #help-and-questions

Bug in TypedSQL in version 5.22

and if you responded , I have another issue that I was not able to fix which is different than this but also TypedSql related , may I share it , or do a new thread?

9 replies

PPrisma

•Created by Mohammad Orabi 🇱🇧 on 11/22/2024 in #help-and-questions

Bug in TypedSQL in version 5.22

yes but I fixed it and it worked correctly with explicitly stating if primary or replica

9 replies

PPrisma

•Created by Mohammad Orabi 🇱🇧 on 11/22/2024 in #help-and-questions

Bug in TypedSQL in version 5.22

maybe worth adding as a warning in the documentation

9 replies

PPrisma

•Created by Mohammad Orabi 🇱🇧 on 11/22/2024 in #help-and-questions

Bug in TypedSQL in version 5.22

okay I fixed it like this

 const result = await db.$replica().$queryRawTyped(test());

 const result = await db.$replica().$queryRawTyped(test());

9 replies

PPrisma

•Created by Mohammad Orabi 🇱🇧 on 11/22/2024 in #help-and-questions

Bug in TypedSQL in version 5.22

I think I found the root cause if I remove extending replicas it works

const prisma = new PrismaClient().$extends(
  readReplicas({
    url: databaseUrlReplicas,
  }),
);

const prisma = new PrismaClient().$extends(
  readReplicas({
    url: databaseUrlReplicas,
  }),
);

9 replies

PPrisma

•Created by Mohammad Orabi 🇱🇧 on 10/29/2024 in #help-and-questions

Live events with prisma pulse for games

Yes I am on AWS with kubernates with postgres 16 okay is their a way I can test it and see if it fits the needs before paying or so?

4 replies

PPrisma