3 replies

insert query in kysely, typerror

Hi, I try to migrate from prisma to kysely, only use Prisma for generating the types. Currently I have a insert into db like this with prisma api

ts await ctx.prisma.voteAnime.create({
          data: {
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          },
        });

ts await ctx.prisma.voteAnime.create({
          data: {
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          },
        });

I tried to do it like this with Kysely

ts const result = await ctx.db
          .insertInto("VoteAnime")
          .values({
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          })
          .executeTakeFirst();

ts const result = await ctx.db
          .insertInto("VoteAnime")
          .values({
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          })
          .executeTakeFirst();

but it gives me errors: Object literal may only specify known properties, and 'votedAgainstId' does not exist in type 'InsertObjectOrListFactory<Database, "VoteAnime">'. Anyone maybe know how to fix this?

TTC

Theo's Typesafe Cult•3y ago•

3 replies

noctate

insert query in kysely, typerror

Hi, I try to migrate from prisma to kysely, only use Prisma for generating the types. Currently I have a insert into db like this with prisma api

ts await ctx.prisma.voteAnime.create({
          data: {
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          },
        });

ts await ctx.prisma.voteAnime.create({
          data: {
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          },
        });

I tried to do it like this with Kysely

ts const result = await ctx.db
          .insertInto("VoteAnime")
          .values({
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          })
          .executeTakeFirst();

ts const result = await ctx.db
          .insertInto("VoteAnime")
          .values({
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          })
          .executeTakeFirst();

insert query in kysely, typerror

Similar Threads

insert query in kysely, typerror

Similar Threads

Similar Threads

Similar Threads