MUG Knight
DTDrizzle Team
•Created by MUG Knight on 3/8/2025 in #help
db.select() from magic sql`` operator returns array of empty objects
I am generating a set of dates using
generate_series and I can't get it to actually return the dates in drizzle. Here is the query:
db.select().from(sqlgenerate_series(make_date(2024,2,1), make_date(2026,12,1), '1 month'::interval));
When I use drizzle runner in studio, it returns the proper number of results in an array of empty JSON objects. If I run SELECT * FROM generate_series(make_date(2024,2,1), make_date(2026,12,1), '1 month'::interval) in SQL console, it works just fine.
How can I tell db.select() to pull the values out and not return an array of empty objects?1 replies
DTDrizzle Team
•Created by MUG Knight on 2/25/2025 in #help
Migration not setting DB column to NOT NULL
when I update my schema to set a column to use .notNull().Default("whatever") the migration files don't actually update the DB to alter the column to NOT NULL with a DEFAULT set. We are using the standard generate approach in drizzle-kit. Any ideas what we are doing wrong?
3 replies
DTDrizzle Team
•Created by MUG Knight on 11/26/2024 in #help
Unable to create a check constraint for NaN values
I am working to prevent any chance of NaN from being inserted into my DB, so I created a check constraint that looks like the following:
(table) => [
check("fancy_check_name", sql
Any Ideas?
${table.amount} <> NaN),
],
When I run drizzle-kit's push method, I get the following error, "error: column "nan" does not exist"
Any combination of quotes or anything around NaN makes no difference.Any Ideas?
5 replies
DTDrizzle Team
•Created by MUG Knight on 10/7/2024 in #help
Adding record in Drizzle Studio with .generatedAlwaysAsIdentity error.
I have a table with a primary key column, defined as the following:
id: bigint("id", { mode: "number" })
.primaryKey()
.generatedAlwaysAsIdentity({ startWith: 1000 }),
If I try to add an item into the table via Drizzle Studio, I get the following error:
"cannot insert a non-DEFAULT value into column "id""
I can't find a combination of options/data entry to make this work. Any ideas?
2 replies