Property 'arrayBuffer' does not exist on type 'Response'.

Property 'arrayBuffer' does not exist on type 'Response'.

Property 'json' does not exist on type 'Response'.

Property 'json' does not exist on type 'Response'.

Error: All attempts to open a WebSocket to connect to the database failed. Please refer to https://github.com/neondatabase/serverless/blob/main/CONFIG.md#websocketconstructor-typeof-websocket--undefined. Details: fetch failed

Error: All attempts to open a WebSocket to connect to the database failed. Please refer to https://github.com/neondatabase/serverless/blob/main/CONFIG.md#websocketconstructor-typeof-websocket--undefined. Details: fetch failed

import { neonConfig } from '@neondatabase/serverless';
import ws from 'ws';
neonConfig.webSocketConstructor = ws; 

import { neonConfig } from '@neondatabase/serverless';
import ws from 'ws';
neonConfig.webSocketConstructor = ws; 

import { drizzle } from 'drizzle-orm/neon-serverless';
import { Pool } from '@neondatabase/serverless';
import * as schema from "./schema";
import dotenv from "dotenv";
dotenv.config({ path: ".env.local" });

const pool = new Pool({ connectionString: process.env.DB_URL });
export const db = drizzle(pool, { schema })

import { drizzle } from 'drizzle-orm/neon-serverless';
import { Pool } from '@neondatabase/serverless';
import * as schema from "./schema";
import dotenv from "dotenv";
dotenv.config({ path: ".env.local" });

const pool = new Pool({ connectionString: process.env.DB_URL });
export const db = drizzle(pool, { schema })

export async function updateStatusByIds({
  status,
  records,
}: {
  status: Statuses;
  records: SelectRecordWithUserData[];
}) {

  // assemble sql where clause to match id and current lastModified date
  const sqlWhereChunks: SQL[] = [];

  records.forEach((r, i) => {
    sqlWhereChunks.push(
      sql`(${recordTable.id} = ${r.id} AND ${recordTable.lastModified} = ${r.lastModified})`
    );
    if (i < records.length - 1) {
      sqlWhereChunks.push(sql` OR `);
    }
  });

  const sqlWhere = sql.join(sqlWhereChunks);

  try {
    await db.transaction(async (tx) => {
      let update = await tx
        .update(recordTable)
        .set({ statusId: status })
        .where(sqlWhere);

      console.log("update:", update);

      await tx.insert(statusLog).values(
        records.map((r) => ({
          recordId: r.id,
          statusId: status,
          message: "bulk",
        }))
      );
    });
  } catch (error) {
    console.error(error);
    throw new Error(
      `Failed to update status ids: ${
        error instanceof Error ? error.message : "Unknown error"
      }`
    );
  }
}

export async function updateStatusByIds({
  status,
  records,
}: {
  status: Statuses;
  records: SelectRecordWithUserData[];
}) {

  // assemble sql where clause to match id and current lastModified date
  const sqlWhereChunks: SQL[] = [];

  records.forEach((r, i) => {
    sqlWhereChunks.push(
      sql`(${recordTable.id} = ${r.id} AND ${recordTable.lastModified} = ${r.lastModified})`
    );
    if (i < records.length - 1) {
      sqlWhereChunks.push(sql` OR `);
    }
  });

  const sqlWhere = sql.join(sqlWhereChunks);

  try {
    await db.transaction(async (tx) => {
      let update = await tx
        .update(recordTable)
        .set({ statusId: status })
        .where(sqlWhere);

      console.log("update:", update);

      await tx.insert(statusLog).values(
        records.map((r) => ({
          recordId: r.id,
          statusId: status,
          message: "bulk",
        }))
      );
    });
  } catch (error) {
    console.error(error);
    throw new Error(
      `Failed to update status ids: ${
        error instanceof Error ? error.message : "Unknown error"
      }`
    );
  }
}

../../packages/db/utils/index.ts
Module parse failed: Unexpected token (11:1)
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file. See https://webpack.js.org/concepts#loaders

../../packages/db/utils/index.ts
Module parse failed: Unexpected token (11:1)
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file. See https://webpack.js.org/concepts#loaders

'use client'
import { formatStatus } from "db/utils"

const Test = () => {
  return ( 
    <div>
      {formatStatus("accepted-paid")}
    </div>
   );
}

'use client'
import { formatStatus } from "db/utils"

const Test = () => {
  return ( 
    <div>
      {formatStatus("accepted-paid")}
    </div>
   );
}

async function test() {
  await db.transaction(async (tx) => {
    const insertRecord = await tx.insert(record).values({
      foo: "bar",
    });

    await tx
      .insert(user)
      .values({
        foo: "bar",
        recordId: parseInt(insertRecord.insertId)  // is insertId ok on conflict?
       });
  });
}

async function test() {
  await db.transaction(async (tx) => {
    const insertRecord = await tx.insert(record).values({
      foo: "bar",
    });

    await tx
      .insert(user)
      .values({
        foo: "bar",
        recordId: parseInt(insertRecord.insertId)  // is insertId ok on conflict?
       });
  });
}

export const users = mysqlTable("users", {
  id: serial("id").primaryKey(),
  username: varchar("username", { length: 120 }),
});

export const blocks = mysqlTable("blocks", {
  id: serial("id").primaryKey(),
  block_type: int("type"),
  user_id: int("user_id"),
});

export const usersRelations = relations(users, ({ many }) => ({
  pagebuilder: many(blocks),
}));

(async () => {
  const user = await db.query.users.findFirst({
    where: eq(users.username, "johnsmith"),
    with: {
      pagebuilder: true,
    },
  });
  // user.pagebuilder[0].block_type ☑️
})();

export const users = mysqlTable("users", {
  id: serial("id").primaryKey(),
  username: varchar("username", { length: 120 }),
});

export const blocks = mysqlTable("blocks", {
  id: serial("id").primaryKey(),
  block_type: int("type"),
  user_id: int("user_id"),
});

export const usersRelations = relations(users, ({ many }) => ({
  pagebuilder: many(blocks),
}));

(async () => {
  const user = await db.query.users.findFirst({
    where: eq(users.username, "johnsmith"),
    with: {
      pagebuilder: true,
    },
  });
  // user.pagebuilder[0].block_type ☑️
})();

import { mysqlTable, serial, varchar, float, time } from 'drizzle-orm/mysql-core';
 
export const metalPrices = mysqlTable('metals', {
  id: serial('id'),
  metal: varchar('metal',  { length: 5 }).primaryKey(),
  value: float('value'),
  time: time('time'),
});

import { mysqlTable, serial, varchar, float, time } from 'drizzle-orm/mysql-core';
 
export const metalPrices = mysqlTable('metals', {
  id: serial('id'),
  metal: varchar('metal',  { length: 5 }).primaryKey(),
  value: float('value'),
  time: time('time'),
});

    await db.insert(metalPrices).values({
      metal: "FOO",
      time: Date.now(), // type error when adding this line
    });

    await db.insert(metalPrices).values({
      metal: "FOO",
      time: Date.now(), // type error when adding this line
    });

The expected type comes from property 'time' which is declared here on type '{ metal: string | SQL<unknown> | Placeholder<string, any>; value?: number | SQL<unknown> | Placeholder<string, any> | null | undefined; id?: number | SQL<unknown> | Placeholder<...> | undefined; time?: string | ... 3 more ... | undefined; }'

The expected type comes from property 'time' which is declared here on type '{ metal: string | SQL<unknown> | Placeholder<string, any>; value?: number | SQL<unknown> | Placeholder<string, any> | null | undefined; id?: number | SQL<unknown> | Placeholder<...> | undefined; time?: string | ... 3 more ... | undefined; }'

@tailwind base;
@tailwind components;
@tailwind utilities;
 
@layer base {
  :root {
    --background: 0 0% 100%;
    --foreground: 240 10% 3.9%;
 
    --muted: 240 4.8% 95.9%;
    --muted-foreground: 240 3.8% 46.1%;
 
    --popover: 0 0% 100%;
    --popover-foreground: 240 10% 3.9%;
 
    --card: 0 0% 100%;
    --card-foreground: 240 10% 3.9%;
     
    [...]

 

@tailwind base;
@tailwind components;
@tailwind utilities;
 
@layer base {
  :root {
    --background: 0 0% 100%;
    --foreground: 240 10% 3.9%;
 
    --muted: 240 4.8% 95.9%;
    --muted-foreground: 240 3.8% 46.1%;
 
    --popover: 0 0% 100%;
    --popover-foreground: 240 10% 3.9%;
 
    --card: 0 0% 100%;
    --card-foreground: 240 10% 3.9%;
     
    [...]

 

    return await db.insert(widgetItem).values({
    name: "New Widget",
    companyId: db  // using subquery
      .select({ id: company.id })
      .from(company)
      .where(eq(
        company.name,
        userCompany
        )),
    typeId: widgetTypeId,
    slug: generateSlug(),
  });

    return await db.insert(widgetItem).values({
    name: "New Widget",
    companyId: db  // using subquery
      .select({ id: company.id })
      .from(company)
      .where(eq(
        company.name,
        userCompany
        )),
    typeId: widgetTypeId,
    slug: generateSlug(),
  });

  return await db.insert(widgetItem).values({
    name: "New Widget",
    companyId: BigInt(2),  // hardcoded
    typeId: widgetTypeId,
    slug: generateSlug(),
  });

  return await db.insert(widgetItem).values({
    name: "New Widget",
    companyId: BigInt(2),  // hardcoded
    typeId: widgetTypeId,
    slug: generateSlug(),
  });