Drizzle Team•2mo ago

What does .all() do?

Half of the examples here: https://orm.drizzle.team/docs/joins use .all() at the end and half don't. There is no doc or anything mentioning .all() - Can someone please tell me?

Drizzle ORM - Joins

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

3 Replies

Coaster•2mo ago

Hey, I belive .all() returns every record from the query, which is the default, but can be switched out for .get() to only return the first record. All is only available for SQLite as far as I can tell. Not sure what you are using but if it's not SQLite there should be no all available to you.

const postsJoin = await db
  .select()
  .from(usersTable)
  .leftJoin(postsTable, eq(postsTable.ownerId, usersTable.id))
  .all();

const postsJoin = await db
  .select()
  .from(usersTable)
  .leftJoin(postsTable, eq(postsTable.ownerId, usersTable.id))
  .all();

returns:

[
  {
    users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
    posts_table: { id: 2, ownerId: 1, content: 'Hello form post 2' }
  },
  {
    users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
    posts_table: { id: 1, ownerId: 1, content: 'Hello from post 1' }
  }
]

[
  {
    users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
    posts_table: { id: 2, ownerId: 1, content: 'Hello form post 2' }
  },
  {
    users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
    posts_table: { id: 1, ownerId: 1, content: 'Hello from post 1' }
  }
]

whereas

const postsJoin = await db
  .select()
  .from(usersTable)
  .leftJoin(postsTable, eq(postsTable.ownerId, usersTable.id))
  .get();

const postsJoin = await db
  .select()
  .from(usersTable)
  .leftJoin(postsTable, eq(postsTable.ownerId, usersTable.id))
  .get();

returns:

{
  users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
  posts_table: { id: 2, ownerId: 1, content: 'Hello form post 2' }
}

{
  users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
  posts_table: { id: 2, ownerId: 1, content: 'Hello form post 2' }
}

lmk if that makes sense

cosbgnOP•2mo ago

so it's the default and can be skipped? why it's there in the first place? (I use sqlite) I'm SO confused about this. I also use .limit(1) never .get()

Coaster•2mo ago

As far as I can tell, it won't change anything from the default and is just there for explicitness. This is the only comment from the drizzle team I can find on the topic: https://discord.com/channels/1043890932593987624/1120660739510779924/1121093480136048660

Gaming

Programming

What does .all() do?

Did you find this page helpful?