11 replies

No overload matches this call

I'm sorry that I'm already the 4th person with this sort of post, but the other posts didn't really help me out. I'm having an issue where it's sayig a certain attribute isn't in the type generated, but I don't see why not, and when I run the code it does work

await db.insert(clients).values({
            name: faker.person.fullName(),
            nif: faker.number.int({min: 100000000, max: 999999999}).toString(),
            password: faker.internet.password(),
            email: faker.internet.email(),
            activity: client_activity[faker.number.int({min: 0, max: 2})],
            obs: faker.helpers.arrayElement(['', faker.lorem.sentence()]),
            services: faker.number.int({min: 1, max: services.length})
        })

await db.insert(clients).values({
            name: faker.person.fullName(),
            nif: faker.number.int({min: 100000000, max: 999999999}).toString(),
            password: faker.internet.password(),
            email: faker.internet.email(),
            activity: client_activity[faker.number.int({min: 0, max: 2})],
            obs: faker.helpers.arrayElement(['', faker.lorem.sentence()]),
            services: faker.number.int({min: 1, max: services.length})
        })

Here's the schema:

//Clients table
export const clients = pgTable("clients",{
    id: serial("id").primaryKey(),
    name: varchar("name", { length: 256 }).notNull(),
    nif: char("nif", { length: 9}).unique().notNull(),
    password: bytea("password").unique().notNull(),
    email: varchar("email", { length: 256}).unique(),
    rf_taxrep: rfEnum("rf_taxrep"),
    activity: activityEnum("activity").notNull(),
    obs: text("obs"),
    services: serial("services").references(() => service.id, {onDelete: "cascade"}),
})

//Clients table
export const clients = pgTable("clients",{
    id: serial("id").primaryKey(),
    name: varchar("name", { length: 256 }).notNull(),
    nif: char("nif", { length: 9}).unique().notNull(),
    password: bytea("password").unique().notNull(),
    email: varchar("email", { length: 256}).unique(),
    rf_taxrep: rfEnum("rf_taxrep"),
    activity: activityEnum("activity").notNull(),
    obs: text("obs"),
    services: serial("services").references(() => service.id, {onDelete: "cascade"}),
})

Here's the error:
No overload matches this call.
Overload 2 of 2, '(values: { name: string | SQL<unknown> | Placeholder<string, any>; nif: string | SQL<unknown> | Placeholder<string, any>; password: SQL<unknown> | Buffer | Placeholder<...>; ... 5 more ...; services?: number | ... 2 more ... | undefined; }[]): PgInsertBase<...>', gave the following error.
Object literal may only specify known properties, and 'name' does not exist in type '{ name: string | SQL<unknown> | Placeholder<string, any>; nif: string | SQL<unknown> | Placeholder<string, any>; password: SQL<unknown> | Buffer | Placeholder<...>; ... 5 more ...; services?: number | ... 2 more ... | undefined; }[]'.

No overload matches this call

await db.insert(clients).values({
            name: faker.person.fullName(),
            nif: faker.number.int({min: 100000000, max: 999999999}).toString(),
            password: faker.internet.password(),
            email: faker.internet.email(),
            activity: client_activity[faker.number.int({min: 0, max: 2})],
            obs: faker.helpers.arrayElement(['', faker.lorem.sentence()]),
            services: faker.number.int({min: 1, max: services.length})
        })

await db.insert(clients).values({
            name: faker.person.fullName(),
            nif: faker.number.int({min: 100000000, max: 999999999}).toString(),
            password: faker.internet.password(),
            email: faker.internet.email(),
            activity: client_activity[faker.number.int({min: 0, max: 2})],
            obs: faker.helpers.arrayElement(['', faker.lorem.sentence()]),
            services: faker.number.int({min: 1, max: services.length})
        })

Here's the schema:

//Clients table
export const clients = pgTable("clients",{
    id: serial("id").primaryKey(),
    name: varchar("name", { length: 256 }).notNull(),
    nif: char("nif", { length: 9}).unique().notNull(),
    password: bytea("password").unique().notNull(),
    email: varchar("email", { length: 256}).unique(),
    rf_taxrep: rfEnum("rf_taxrep"),
    activity: activityEnum("activity").notNull(),
    obs: text("obs"),
    services: serial("services").references(() => service.id, {onDelete: "cascade"}),
})

//Clients table
export const clients = pgTable("clients",{
    id: serial("id").primaryKey(),
    name: varchar("name", { length: 256 }).notNull(),
    nif: char("nif", { length: 9}).unique().notNull(),
    password: bytea("password").unique().notNull(),
    email: varchar("email", { length: 256}).unique(),
    rf_taxrep: rfEnum("rf_taxrep"),
    activity: activityEnum("activity").notNull(),
    obs: text("obs"),
    services: serial("services").references(() => service.id, {onDelete: "cascade"}),
})

No overload matches this call

No overload matches this call

Similar Threads

Similar Threads

Similar Threads