XandoR
XandoR
Explore posts from servers
DIAdiscord.js - Imagine a botDTDrizzle Team
PostsComments
DTDrizzle Team
Created by XandoR on 1/19/2024 in #help
Difference between query modes
Heyo everyone ! 👋 Is there anyway I can get same result than result1 query using result2 syntax with db.select() ? 
const result1 = await db.query.notifications.findMany({
  where: eq(notifications.guild_id, interaction.guildId),
  with: {
    group: true,
  },
});

const result2 = await db
  .select()
  .from(notifications)
  .limit(1)
  .where(eq(notifications.guild_id, interaction.guildId))
  .innerJoin(groups, eq(notifications.group_id, groups._id))
  .execute();
const result1 = await db.query.notifications.findMany({
  where: eq(notifications.guild_id, interaction.guildId),
  with: {
    group: true,
  },
});

const result2 = await db
  .select()
  .from(notifications)
  .limit(1)
  .where(eq(notifications.guild_id, interaction.guildId))
  .innerJoin(groups, eq(notifications.group_id, groups._id))
  .execute();
Or should I keep using db.query if I want to retrieve notifications with group inside of it ?
4 replies