Drizzle TeamDT
Drizzle Team•16mo ago
rdobovic

DrizzleORM with JSDoc (insert problem)

Hi, I am trying to use drizzle with jsdoc in my project. I created the schema and everything works when I run it but for some reason jsdoc in VSCode is complaining when I try to insert anything besides the fields that must be specified like primary keys and fields with .notNull().unique(). Any ideas why this might happen?

Here is a part of my schema:
// @ts-check

const guilds = mysqlTable('guilds', {
    id: varchar('guild_id', { length: 20 }).primaryKey(),
    whitelisted: boolean('whitelisted').notNull().default(false),
    verifiedRoleId: varchar('verified_role_id', { length: 20 }),
    unverifiedRoleId: varchar('unverified_role_id', { length: 20 }),
});
exports.guilds = guilds;

/**
 * @typedef {typeof guilds.$inferSelect} GuildRecord
 */

And if I try to do something like:
// @ts-check

const mysql = require('mysql2');
const { drizzle } = require('drizzle-orm/mysql2');
const { guilds } = require('./schema.js');

const pool = mysql.createPool({
    // ...
});

const db = drizzle(pool);
db.insert(guilds).values({ id: 'someid', whitelisted: true, });

it underlines .values, I don't understand why. The error it shows is:
No overload matches this call.

Any ideas would be greatly appreciated :)
Was this page helpful?