Type error on insert

I'm trying to do a simple insert

await db.insert(receipt).values({
            userId: locals.user.id,
            typeId: 1,
            date: entry.tanggal,
            name: entry.keterangan,
            nominal: entry.nominal,
            note: entry.catatan || '',
            statusId: 1
        });

await db.insert(receipt).values({
            userId: locals.user.id,
            typeId: 1,
            date: entry.tanggal,
            name: entry.keterangan,
            nominal: entry.nominal,
            note: entry.catatan || '',
            statusId: 1
        });

The schema is like this

export const receipt = mysqlTable('receipt', {
    id: serial('id').primaryKey(),
    userId: int('user_id').notNull(),
    typeId: int('type_id').notNull(),
    name: varchar('name', { length: 100 }),
    date: date('date').notNull(),
    nominal: decimal('nominal', { precision: 10, scale: 2 }).notNull(),
    note: text('note'),
    statusId: int('status_id').notNull(),
    createdAt: timestamp('created_at').defaultNow().notNull()
});

export const receipt = mysqlTable('receipt', {
    id: serial('id').primaryKey(),
    userId: int('user_id').notNull(),
    typeId: int('type_id').notNull(),
    name: varchar('name', { length: 100 }),
    date: date('date').notNull(),
    nominal: decimal('nominal', { precision: 10, scale: 2 }).notNull(),
    note: text('note'),
    statusId: int('status_id').notNull(),
    createdAt: timestamp('created_at').defaultNow().notNull()
});

It shows error

No overload matches this call.
  Overload 2 of 2, '(values: { date: Date | SQL<unknown> | Placeholder<string, any>; userId: number | SQL<unknown> | Placeholder<string, any>; typeId: number | SQL<unknown> | Placeholder<...>; ... 5 more ...; note?: string | ... 3 more ... | undefined; }[]): MySqlInsertBase<...>', gave the following error.
    Object literal may only specify known properties, and 'userId' does not exist in type '{ date: Date | SQL<unknown> | Placeholder<string, any>; userId: number | SQL<unknown> | Placeholder<string, any>; typeId: number | SQL<unknown> | Placeholder<...>; ... 5 more ...; note?: string | ... 3 more ... | undefined; }[]'.

No overload matches this call.
  Overload 2 of 2, '(values: { date: Date | SQL<unknown> | Placeholder<string, any>; userId: number | SQL<unknown> | Placeholder<string, any>; typeId: number | SQL<unknown> | Placeholder<...>; ... 5 more ...; note?: string | ... 3 more ... | undefined; }[]): MySqlInsertBase<...>', gave the following error.
    Object literal may only specify known properties, and 'userId' does not exist in type '{ date: Date | SQL<unknown> | Placeholder<string, any>; userId: number | SQL<unknown> | Placeholder<string, any>; typeId: number | SQL<unknown> | Placeholder<...>; ... 5 more ...; note?: string | ... 3 more ... | undefined; }[]'.

apparently it's because the type provided by drizzle is somehow an Array, or is there something that I didn't know or did wrong?

2 Replies

Angelelz•10mo ago

You have to check the types of the object you're passing entry and locals I just tested this in the typescript playground and I don't see a problem

Angelelz•10mo ago

https://www.typescriptlang.org/play?#code/JYWwDg9gTgLgBAbziAngZwI4BsAqBDAIywFMAaONYqYPLc4AOxnIDc8oBjAC3fIBM8MMnD7EOoWuSEAPZnBihiaGHnBwAvnABmUCCDgAiPtQBeJkgFpoIAPSpMWCx2jEDAKFCRYiEafPENbV19Iz9Lazt0bAAmdzdiaS94ZwZlOCgxYmAweABeZCjcQhIACgByDI4snLLyBDc4RrhgPgAuCioaLHKWsoBKADowahB2FABpYhQSvtIGpoBXSigASTbmpnKlqgB9XsGGCBgAOQWsbtn5xpgUMGI19sYYcpu7vb5+gcOTs4u5prgDFUxHabE4PCg5SBIGItR8JAYAHMYFx2gBGAAMGI0lwBAiE7XxxHKRM+31O5xm-yahxAjFohLEEm6ZVp9KwcKQwyZaGAEAY6Ix5DQHFoILg0RxXyOFL+V0BR3FMmerMV-WpjWUgiWDw2Kq1MCW7zJMt+VPlHAygmIfAAgjB2goYVrwOVLcRrXwdoJPqItHgzicIAB3GbSn6UvpudR9ADcbjcKTSfAIcHyxmAZlKCE0eDQcDwDBQUbceGDeGA8BTA0Yy2elWqMEGbCwCyUJXqAK7i2WuuiGu7TVe93WaIHg5E1vaDGIwbgABFreaJwDoeKDFg8ABrNB8ABWWgM48HbKBWHaBjR0QGAGYACwAViP8on33FZVqL8HBp1o6-jRjWMgA

TS Playground - An online editor for exploring TypeScript and JavaS...

The Playground lets you write TypeScript or JavaScript online in a safe and sharable way.

Gaming

Programming

Type error on insert