5 replies

I'm trying using $count, and it giving me fieldAlias missing. What should I do?

I'm on drizzle-orm 0.36.1 and drizzle-kit 0.28.0.

My schema is something like below. For note, its oversimplified over my project.

export const item = pgTable(
  "items",
  {
    id: text("id").primaryKey().unique().notNull(),
    userId: text("user_id").notNull(),
    name: text("name").notNull(),
  },
);

export const history = pgTable(
  "purchased_items",
  {
    id: text("id").primaryKey().unique().notNull(),
    userId: text("user_id").notNull(),
    itemId: text("item_id")
      .references(() => items.id)
      .notNull(),
    anotherData: text("another_data").notNull()
  },
);

export const historyRelation = relations(history, ({ one }) => ({
  item: one(item, {
    fields: [history.itemId],
    references: [item.id],
  }),
}));

export const itemRelations = relations(item, ({ many }) => ({
  histories: many(history),
}));

export const item = pgTable(
  "items",
  {
    id: text("id").primaryKey().unique().notNull(),
    userId: text("user_id").notNull(),
    name: text("name").notNull(),
  },
);

export const history = pgTable(
  "purchased_items",
  {
    id: text("id").primaryKey().unique().notNull(),
    userId: text("user_id").notNull(),
    itemId: text("item_id")
      .references(() => items.id)
      .notNull(),
    anotherData: text("another_data").notNull()
  },
);

export const historyRelation = relations(history, ({ one }) => ({
  item: one(item, {
    fields: [history.itemId],
    references: [item.id],
  }),
}));

export const itemRelations = relations(item, ({ many }) => ({
  histories: many(history),
}));

And my queries is something like this:

const result = await db.query.item.findMany({
  where: eq(item.userId, requesterId),
  columns: {
    id: true,
    name: true,
  },
  extras: {
    historyCount: db.$count(history, eq(history.itemId, items.id))
  }
});

const result = await db.query.item.findMany({
  where: eq(item.userId, requesterId),
  columns: {
    id: true,
    name: true,
  },
  extras: {
    historyCount: db.$count(history, eq(history.itemId, items.id))
  }
});

Exactly on

historyCount

historyCount

my editor giving me typescript error something like this:

Property 'fieldAlias' is missing in type 'PgCountBuilder<PgSession<any, any, any>>' but required in type 'Aliased<unknown>'.ts(2741)
sql.d.ts(184, 18): 'fieldAlias' is declared here.

(property) purchaseCount: PgCountBuilder<PgSession<any, any, any>>

Property 'fieldAlias' is missing in type 'PgCountBuilder<PgSession<any, any, any>>' but required in type 'Aliased<unknown>'.ts(2741)
sql.d.ts(184, 18): 'fieldAlias' is declared here.

(property) purchaseCount: PgCountBuilder<PgSession<any, any, any>>

I enable logger and my raw query is something like this. I make a little modified below, just so the table name will match my example above, everything else is intact

Query: select "id", "name", select count(*) as count from "history" where "item"."item_id" = "item"."id"; as "undefined" from "item" where ("item"."user_id" = $1 and "item"."id" in (select "item_id" from "history" where "history"."user_id" = $2)) -- params: ["u-rXH4ULxe6d", "u-rXH4ULxe6d"]

Query: select "id", "name", select count(*) as count from "history" where "item"."item_id" = "item"."id"; as "undefined" from "item" where ("item"."user_id" = $1 and "item"."id" in (select "item_id" from "history" where "history"."user_id" = $2)) -- params: ["u-rXH4ULxe6d", "u-rXH4ULxe6d"]

I'm trying using $count, and it giving me fieldAlias missing. What should I do?

I'm on drizzle-orm 0.36.1 and drizzle-kit 0.28.0.

My schema is something like below. For note, its oversimplified over my project.

export const item = pgTable(
  "items",
  {
    id: text("id").primaryKey().unique().notNull(),
    userId: text("user_id").notNull(),
    name: text("name").notNull(),
  },
);

export const history = pgTable(
  "purchased_items",
  {
    id: text("id").primaryKey().unique().notNull(),
    userId: text("user_id").notNull(),
    itemId: text("item_id")
      .references(() => items.id)
      .notNull(),
    anotherData: text("another_data").notNull()
  },
);

export const historyRelation = relations(history, ({ one }) => ({
  item: one(item, {
    fields: [history.itemId],
    references: [item.id],
  }),
}));

export const itemRelations = relations(item, ({ many }) => ({
  histories: many(history),
}));

export const item = pgTable(
  "items",
  {
    id: text("id").primaryKey().unique().notNull(),
    userId: text("user_id").notNull(),
    name: text("name").notNull(),
  },
);

export const history = pgTable(
  "purchased_items",
  {
    id: text("id").primaryKey().unique().notNull(),
    userId: text("user_id").notNull(),
    itemId: text("item_id")
      .references(() => items.id)
      .notNull(),
    anotherData: text("another_data").notNull()
  },
);

export const historyRelation = relations(history, ({ one }) => ({
  item: one(item, {
    fields: [history.itemId],
    references: [item.id],
  }),
}));

export const itemRelations = relations(item, ({ many }) => ({
  histories: many(history),
}));

And my queries is something like this:

const result = await db.query.item.findMany({
  where: eq(item.userId, requesterId),
  columns: {
    id: true,
    name: true,
  },
  extras: {
    historyCount: db.$count(history, eq(history.itemId, items.id))
  }
});

const result = await db.query.item.findMany({
  where: eq(item.userId, requesterId),
  columns: {
    id: true,
    name: true,
  },
  extras: {
    historyCount: db.$count(history, eq(history.itemId, items.id))
  }
});

Exactly on

historyCount

historyCount

my editor giving me typescript error something like this:

Property 'fieldAlias' is missing in type 'PgCountBuilder<PgSession<any, any, any>>' but required in type 'Aliased<unknown>'.ts(2741)
sql.d.ts(184, 18): 'fieldAlias' is declared here.

(property) purchaseCount: PgCountBuilder<PgSession<any, any, any>>

Property 'fieldAlias' is missing in type 'PgCountBuilder<PgSession<any, any, any>>' but required in type 'Aliased<unknown>'.ts(2741)
sql.d.ts(184, 18): 'fieldAlias' is declared here.

(property) purchaseCount: PgCountBuilder<PgSession<any, any, any>>

I enable logger and my raw query is something like this. I make a little modified below, just so the table name will match my example above, everything else is intact

Query: select "id", "name", select count(*) as count from "history" where "item"."item_id" = "item"."id"; as "undefined" from "item" where ("item"."user_id" = $1 and "item"."id" in (select "item_id" from "history" where "history"."user_id" = $2)) -- params: ["u-rXH4ULxe6d", "u-rXH4ULxe6d"]

Query: select "id", "name", select count(*) as count from "history" where "item"."item_id" = "item"."id"; as "undefined" from "item" where ("item"."user_id" = $1 and "item"."id" in (select "item_id" from "history" where "history"."user_id" = $2)) -- params: ["u-rXH4ULxe6d", "u-rXH4ULxe6d"]

I'm trying using $count, and it giving me fieldAlias missing. What should I do?

I'm trying using $count, and it giving me fieldAlias missing. What should I do?

Similar Threads

Similar Threads

Similar Threads