1 reply

mapWith doesn't look to work with extras columns

By chance, do anyone have clue why the mapWith is never called in this small code example :

const users = await ctx.db.query.users.findMany({
  orderBy: desc(schema.users.createdAt),
  extras: {
    followersCount:
      sql`(SELECT COUNT(*) FROM ${schema.following} WHERE ${schema.following.userId} = ${schema.users.id})`
        .mapWith(Number)
        .as("followersCount"),
  },
});

console.log(
  users?.[0]?.followersCount, // "0"
  typeof users?.[0]?.followersCount, // "string"
);

const users = await ctx.db.query.users.findMany({
  orderBy: desc(schema.users.createdAt),
  extras: {
    followersCount:
      sql`(SELECT COUNT(*) FROM ${schema.following} WHERE ${schema.following.userId} = ${schema.users.id})`
        .mapWith(Number)
        .as("followersCount"),
  },
});

console.log(
  users?.[0]?.followersCount, // "0"
  typeof users?.[0]?.followersCount, // "string"
);

I tried to add an extras followersCount column which should map to a Number but it's never called and the runtime result type is a string even if the Typescript type for followersCount is number.

Drizzle Team•2y ago•

1 reply

Jigglytoine

mapWith doesn't look to work with extras columns

By chance, do anyone have clue why the mapWith is never called in this small code example :

const users = await ctx.db.query.users.findMany({
  orderBy: desc(schema.users.createdAt),
  extras: {
    followersCount:
      sql`(SELECT COUNT(*) FROM ${schema.following} WHERE ${schema.following.userId} = ${schema.users.id})`
        .mapWith(Number)
        .as("followersCount"),
  },
});

console.log(
  users?.[0]?.followersCount, // "0"
  typeof users?.[0]?.followersCount, // "string"
);

const users = await ctx.db.query.users.findMany({
  orderBy: desc(schema.users.createdAt),
  extras: {
    followersCount:
      sql`(SELECT COUNT(*) FROM ${schema.following} WHERE ${schema.following.userId} = ${schema.users.id})`
        .mapWith(Number)
        .as("followersCount"),
  },
});

console.log(
  users?.[0]?.followersCount, // "0"
  typeof users?.[0]?.followersCount, // "string"
);

I tried to add an extras followersCount column which should map to a Number but it's never called and the runtime result type is a string even if the Typescript type for followersCount is number.

mapWith doesn't look to work with extras columns

Similar Threads

mapWith doesn't look to work with extras columns

Similar Threads

Similar Threads

Similar Threads