bun
bun
Explore posts from servers
CDCloudflare DevelopersKKyselyTtamaguiDTDrizzle Team
PostsComments
DTDrizzle Team
Created by bun on 4/1/2024 in #help
dates in sqlite not being evaluated, causing "Invalid Date"
    expiresAt: int("expires_at", { mode: "timestamp" })
      .notNull()
      .$defaultFn(() => new Date(Date.now() + 1000 * 60 * 60 * 24 * 365)),
    createdAt: int("created_at", { mode: "timestamp" })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP`),
  
    expiresAt: int("expires_at", { mode: "timestamp" })
      .notNull()
      .$defaultFn(() => new Date(Date.now() + 1000 * 60 * 60 * 24 * 365)),
    createdAt: int("created_at", { mode: "timestamp" })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP`),
I have the following columns in my sqlite table, for some reason the expiresAt column works fine, when being read, its being evaluated as an actual date, and is saved in the database as an UNIX timestamp, however, the createdAt column is being saved as an actual ISO string date, but upon quering it shows INVALID DATE, why is it?
4 replies
KKysely
Created by bun on 2/15/2024 in #help
Why does `.stream()` return a single result when I pass in a `chunkSize` option ?
I'm guessing it returns chunkSize mount of rows for each iteration, but shouldn't it be an array instead?
2 replies
KKysely
Created by bun on 12/20/2023 in #help
why does `fn.countAll` return `bigint` ?
need it to return a number
4 replies
KKysely
Created by bun on 9/20/2023 in #help
what is this error, i started getting it randomly
error: syntax error at or near ")"
    at /Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/pg/lib/client.js:526:17
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async PostgresConnection.executeQuery (file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:69:28)
    at async file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
    at async #run (file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/driver/single-connection-provider.js:25:16)
    at PostgresConnection.executeQuery (file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:88:41)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
    at async #run (file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/driver/single-connection-provider.js:25:16) {
  length: 90,
  severity: 'ERROR',
  code: '42601',
  detail: undefined,
  hint: undefined,
  position: '22',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'scan.l',
  line: '1248',
  routine: 'scanner_yyerror'
}
error: syntax error at or near ")"
    at /Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/pg/lib/client.js:526:17
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async PostgresConnection.executeQuery (file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:69:28)
    at async file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
    at async #run (file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/driver/single-connection-provider.js:25:16)
    at PostgresConnection.executeQuery (file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:88:41)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
    at async #run (file:///Users/username/Workspace/company/project/node_modules/.pnpm/[email protected]/node_modules/kysely/dist/esm/driver/single-connection-provider.js:25:16) {
  length: 90,
  severity: 'ERROR',
  code: '42601',
  detail: undefined,
  hint: undefined,
  position: '22',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'scan.l',
  line: '1248',
  routine: 'scanner_yyerror'
}
4 replies
KKysely
Created by bun on 9/4/2023 in #help
How to return last inserted ID ?
export async function createCommands(deviceId: number, commands: string[]) {
  return db
    .insertInto("commands")
    .values(commands.map((c) => ({ deviceId, content: c })))
    .returning("id")
    .executeTakeFirstOrThrow()
}
export async function createCommands(deviceId: number, commands: string[]) {
  return db
    .insertInto("commands")
    .values(commands.map((c) => ({ deviceId, content: c })))
    .returning("id")
    .executeTakeFirstOrThrow()
}
For this example, how do I only return the last inserted ID ?
8 replies
KKysely
Created by bun on 8/30/2023 in #query-showcase
how to sort `db.updateTable` returning values?
await db
    .updateTable("users")
    .where("id", "in", ({ selectFrom }) =>
      selectFrom("users")
        .where("users.status", "=", "PREPARED")
        .where("profileId", "=", profileId)
        .select("id")
        .limit(100),
    )
    .set({ status: "SENT" })
    .returningAll()
    .orderBy("id", "asc") // why does this not exist?
    .execute()
await db
    .updateTable("users")
    .where("id", "in", ({ selectFrom }) =>
      selectFrom("users")
        .where("users.status", "=", "PREPARED")
        .where("profileId", "=", profileId)
        .select("id")
        .limit(100),
    )
    .set({ status: "SENT" })
    .returningAll()
    .orderBy("id", "asc") // why does this not exist?
    .execute()
why cant i .orderBy("id", "asc") ?
7 replies
KKysely
Created by bun on 7/1/2023 in #help
is this uuid() correct in mysql?
export async function up(db: Kysely<any>): Promise<void> { await db.schema .createTable("Payment") .addColumn("id", "char", (col) => col.defaultTo(raw("UUID()")).primaryKey())
3 replies
KKysely
Created by bun on 6/29/2023 in #help
What's the pattern for writing migrations exactly?
I'm not familiar with SQL migrations, so my question is how do we create the migration files, what rules should it follow ? As seen in the kysely's GitHub repo example, the migration files have dates, but those files aren't generated, so where did the dates come from ? Well, let's say I don't want the migration files to have dates then I just create separate files for migrations and name them whatever? Ok, then how do I run them? Do I run them everytime the program starts ? Just help me out here, the docs doesn't mention anything about migrations I think it just assumes you are familiar with them already..
16 replies
CDCloudflare Developers
Created by bun on 6/11/2023 in #general-help
can't install wrangler CLI, node gyp error on macos
I'm doing npm i -g wrangler running macos 13, node v18 I'm getting this error
1 replies