SteveS Comments - Answer Overflow

SteveS

•Created by SteveS on 6/11/2024 in #help

Why is it the case that my IDE says `await` does nothing on pretty much every single function?

I can't figure out any reason this wouldn't work:

import { Database } from "bun:sqlite"
import { $ } from "bun";
import { seedDb } from "./seed";
import { drizzle } from 'drizzle-orm/bun-sqlite';
import { usersTable } from "./src/lib/server/db/schema";

await $`rm -rf dev.db`

const sqlite = new Database("dev.db", {
    readwrite: true,
    create: true,
});

await $`bun drizzle-kit migrate`

const db = drizzle(sqlite);

console.log();

console.log("/n")
console.log("inserting test user");
await db.insert(usersTable).values({ id: "1", username: "test" });

console.log("getting test user");
const data = await db.select().from(usersTable);
await seedDb(sqlite);

import { Database } from "bun:sqlite"
import { $ } from "bun";
import { seedDb } from "./seed";
import { drizzle } from 'drizzle-orm/bun-sqlite';
import { usersTable } from "./src/lib/server/db/schema";

await $`rm -rf dev.db`

const sqlite = new Database("dev.db", {
    readwrite: true,
    create: true,
});

await $`bun drizzle-kit migrate`

const db = drizzle(sqlite);

console.log();

console.log("/n")
console.log("inserting test user");
await db.insert(usersTable).values({ id: "1", username: "test" });

console.log("getting test user");
const data = await db.select().from(usersTable);
await seedDb(sqlite);

2 replies

DTDrizzle Team

•Created by SteveS on 8/16/2023 in #help

Error following push

I really can't remember much of this. Looks like I was pushing changes to a table, like adding a column, and when I did that it would make intermediary tables. In this case it was a table of resume information. I probably had a FK constraint with a user table and then added a column

4 replies

DTDrizzle Team

•Created by SteveS on 10/17/2023 in #help

How to get better errors?

I guess I'm thinking of if the eq() function could compare types to make sure that they are the same it would be really useful.

2 replies

DTDrizzle Team

•Created by SteveS on 10/14/2023 in #help

drizzle-zod: remove ID from insert schema type

So, I have a schema for a db table. I want to create an insert schema. The ID is auto incremented. I therefore do not need the ID field as part of the insert schema.

4 replies

DTDrizzle Team

•Created by Graeme on 6/27/2023 in #help

Unexpected type mismatch for sqlite integer boolean mode

Just running into this myself and I'm not sure I understand the design philosophy. An integer taking "true" or "false" as a value seems like an anti-pattern to me.

9 replies

DTDrizzle Team

•Created by SteveS on 8/16/2023 in #help

Error following push

This error was due to me previously adding a foreign key constraint to one of my tables, then removing/updating the table it was referring to. sqlite doesn't allow foreign keys to be dropped. I had to create a new table without the fk, copy over all the data, drop the old table, and rename the new table to the old one. Now it works.

4 replies

DTDrizzle Team