ice cream Comments - Answer Overflow

ice cream

•Created by ice cream on 1/27/2025 in #help

Bad Field Error

My solution was

export const cartView = mysqlView("carts_and_products").as((qb) => {
  return qb
    .select({
      id: usersCart.id,
      user_id: usersCart.user_id,
      variantName: usersCart.variant_name,
      productName: sql<string>`${products.name.getSQL()}`.as("product_name"),
      shopName: sql<string>`${shops.name.getSQL()}`.as("shop_name"),
      // images: products.images, 
      // variants: products.variants,
      quantity: usersCart.quantity,
      // shopId: products.shop_id,
      productId: usersCart.product_id,
      images: sql<string[]>`${products.images.getSQL()}`.as("images"),
      variants: sql<productVariant[]>`${products.variants.getSQL()}`.as(
        "variants",
      ),
      shopId: sql<number>`${products.shop_id.getSQL()}`.as("shop_id"),
    })
    .from(usersCart)
    .innerJoin(products, eq(usersCart.product_id, products.id))
    .innerJoin(shops, eq(products.shop_id, shops.id))
})

export const cartView = mysqlView("carts_and_products").as((qb) => {
  return qb
    .select({
      id: usersCart.id,
      user_id: usersCart.user_id,
      variantName: usersCart.variant_name,
      productName: sql<string>`${products.name.getSQL()}`.as("product_name"),
      shopName: sql<string>`${shops.name.getSQL()}`.as("shop_name"),
      // images: products.images, 
      // variants: products.variants,
      quantity: usersCart.quantity,
      // shopId: products.shop_id,
      productId: usersCart.product_id,
      images: sql<string[]>`${products.images.getSQL()}`.as("images"),
      variants: sql<productVariant[]>`${products.variants.getSQL()}`.as(
        "variants",
      ),
      shopId: sql<number>`${products.shop_id.getSQL()}`.as("shop_id"),
    })
    .from(usersCart)
    .innerJoin(products, eq(usersCart.product_id, products.id))
    .innerJoin(shops, eq(products.shop_id, shops.id))
})

I still don't know what causes this but it works

2 replies

DTDrizzle Team

•Created by ice cream on 1/12/2025 in #help

drizzle-kit generate not generating sql file anymore?

This is the error when I run drizzle-kit migrate

> [email protected] db:migrate
> drizzle-kit migrate

No config path provided, using default 'drizzle.config.ts'
Reading config file '/path/to/drizzle.config.ts'
[⣷] applying migrations...Error: No file ./drizzle/0002_blue_payback.sql found in ./drizzle folder
    at readMigrationFiles (/path/to/node_modules/.pnpm/[email protected]_@[email protected][email protected][email protected]/node_modules/src/migrator.ts:55:10)
    at migrate (/path/to/node_modules/.pnpm/[email protected]_@[email protected][email protected][email protected]/node_modules/src/mysql2/migrator.ts:9:21)
    at migrateFn (/path/to/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:79015:18)
    at Object.handler (/path/to/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:92033:11)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async run (/path/to/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:90501:7)

> [email protected] db:migrate
> drizzle-kit migrate

No config path provided, using default 'drizzle.config.ts'
Reading config file '/path/to/drizzle.config.ts'
[⣷] applying migrations...Error: No file ./drizzle/0002_blue_payback.sql found in ./drizzle folder
    at readMigrationFiles (/path/to/node_modules/.pnpm/[email protected]_@[email protected][email protected][email protected]/node_modules/src/migrator.ts:55:10)
    at migrate (/path/to/node_modules/.pnpm/[email protected]_@[email protected][email protected][email protected]/node_modules/src/mysql2/migrator.ts:9:21)
    at migrateFn (/path/to/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:79015:18)
    at Object.handler (/path/to/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:92033:11)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async run (/path/to/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:90501:7)

2 replies

Gaming

Programming