herbsjs / herbs2knex

Create repositories using Knex to retrieve and store Entities
Other
7 stars 13 forks source link

node-sqlite3 does not currently support RETURNING clause #58

Closed jhomarolo closed 2 years ago

jhomarolo commented 2 years ago

Describe the bug The method insert used inside herbs2knex has the returningclause wich is not supported by sqllite3. So calling the insert method the inserted id not returns

Expected behavior The id of the inserted objects should return

I'm using this config:

 client: 'sqlite3',
    connection: { filename: "file:memDb1?mode=memory&cache=shared" },
    useNullAsDefault: true,
    migrations: {
      directory: './src/infra/db/migrations',
      tableName: 'knex_migrations'
    }
herbsjs-robot commented 2 years ago

:tada: This issue has been resolved in version 1.5.3 :tada:

The release is available on:

Your semantic-release bot :package::rocket: