rbravo
rbravo
Explore posts from servers
RRailwayKKyselyTTCTheo's Typesafe CultXXataDTDrizzle Team
PostsComments
DTDrizzle Team
Created by nk on 1/19/2024 in #help
Recursive category/subcategories, can't infer relation
Yeah, this is exactly my use case where I'm also seeing the error. And btw, this case that you described: "you could easily delete a category and have a null subcategory, since you can't put a notNull on it". Could be fixed with onDelete: 'cascade'. https://www.answeroverflow.com/m/1110915016959475743 IMO your initial relation is ok and should work without "workarounds"
6 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
(And please correct me if I'm wrong, maybe I'm missing something)
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
Maybe what @nk suggested is a way to do this, but ideallly I wouldn't need to change the current schema, which is something like this: 
model Message {
  reactions      Reaction[]
  replies        Message[]     
  replyTo        Message?
model Message {
  reactions      Reaction[]
  replies        Message[]     
  replyTo        Message?
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
It's a bit different, you're going from users > follows & follows and follows > users & users. In my case: I'm going from messages > messages & messages 
export const messagesRelations = relations(messages, ({ one, many }) => ({
  replies: many(messages, { relationName: "messageReplies" }),
  replyTo: one(messages, {
    fields: [messages.replyToId],
    references: [messages.id],
    relationName: "messageReplyTo",
  }),
export const messagesRelations = relations(messages, ({ one, many }) => ({
  replies: many(messages, { relationName: "messageReplies" }),
  replyTo: one(messages, {
    fields: [messages.replyToId],
    references: [messages.id],
    relationName: "messageReplyTo",
  }),
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
It's this one? https://github.com/drizzle-team/drizzle-orm/issues/674#issuecomment-1859009143
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
Yeah, that's the problem!
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
Thank you for sending this @nk! But my case here is that I'm declaring the relations of the table "A", and I stablish 2 relations to itselft
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
This is what I'm using and I'm still seeing the error when starting the Drizzle Studio: 
export const messagesRelations = relations(messages, ({ one, many }) => ({
  reactions: many(reactions),
  replies: many(messages, { relationName: "messageReplies" }),
  replyTo: one(messages, {
    fields: [messages.replyToId],
    references: [messages.id],
    relationName: "messageReplyTo",
  }),
  conversation: one(conversations, {
    fields: [messages.conversationId],
    references: [conversations.id],
  }),
  user: one(users, {
    fields: [messages.userId],
    references: [users.id],
  }),
}));
export const messagesRelations = relations(messages, ({ one, many }) => ({
  reactions: many(reactions),
  replies: many(messages, { relationName: "messageReplies" }),
  replyTo: one(messages, {
    fields: [messages.replyToId],
    references: [messages.id],
    relationName: "messageReplyTo",
  }),
  conversation: one(conversations, {
    fields: [messages.conversationId],
    references: [conversations.id],
  }),
  user: one(users, {
    fields: [messages.userId],
    references: [users.id],
  }),
}));
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
The thing is that here, it's all related to the same table, the Message table.
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
  replies: many(messages, { relationName: "messageReplies" }),
  replyTo: one(messages, {
    fields: [messages.replyToId],
    references: [messages.id],
    relationName: "messageReplyTo",
  }),
  replies: many(messages, { relationName: "messageReplies" }),
  replyTo: one(messages, {
    fields: [messages.replyToId],
    references: [messages.id],
    relationName: "messageReplyTo",
  }),
Like this?
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
Wow, that was fast haha In this case, what would be the other "side"? Since it's all "messages" (i.e replies also refers to messages)
38 replies
DTDrizzle Team
Created by rbravo on 1/19/2024 in #help
Error: There is not enough information to infer relation
Here's the relation code: 
export const messagesRelations = relations(messages, ({ one, many }) => ({
  reactions: many(reactions),
  replies: many(messages, { relationName: "messageReplies" }),
  replyTo: one(messages, {
    fields: [messages.replyToId],
    references: [messages.id],
    relationName: "messageReplyTo",
  }),
  conversation: one(conversations, {
    fields: [messages.conversationId],
    references: [conversations.id],
  }),
  user: one(users, {
    fields: [messages.userId],
    references: [users.id],
  }),
}));
export const messagesRelations = relations(messages, ({ one, many }) => ({
  reactions: many(reactions),
  replies: many(messages, { relationName: "messageReplies" }),
  replyTo: one(messages, {
    fields: [messages.replyToId],
    references: [messages.id],
    relationName: "messageReplyTo",
  }),
  conversation: one(conversations, {
    fields: [messages.conversationId],
    references: [conversations.id],
  }),
  user: one(users, {
    fields: [messages.userId],
    references: [users.id],
  }),
}));
38 replies