knex

knex copied to clipboard

Sqlite3 adding primary key on existing table

1

# Environment Knex version: 1.0.7 Database + version: sqlite3 OS: mac # Feature discussion / request I would love to get the sqlite dialect to run a query to add...

alexandrebodin

Transaction Commit/Rollback events

16

There's been discussion about this in the past, and I believe knex needs a way to support this. Using `query-response` is not only unreliable for this, but also not possible....

wubzz

onConflict -> merge doesn't work without catch

1

Knex 2.1.0 5.5.68-MariaDB ``` knex("convUnread") .insert({ uID: c.uID, convID: convID, n: 1 }) .onConflict() .merge({ n: knex.raw('?? + 1', 'n') }).catch((err) => { console.error(err); }); ``` This code only works...

nightrider77

Implement mapBinding mssql dialect option

1

### Purpose (Fix: Issue #5268) Allow users of knex to define custom mssql parameter value/type mapping through configuration. This is useful when having a mix of varchar/nvarchar types within your...

kellyrbourg

👋 Hi folks, thanks for a great library! I came across what looks like a typing bug to me: --- The first overload of TypePreservingAggregation (taking columnName and options) used...

mrichards42

__knexTxId is inherited from previous transactions

2

# Environment Knex version: 2.2.0 (see it as far back as 0.21.17) Database + version: mysql 5.7 OS: ubunutu # Bug **Expected:** When executing a query outside of a transaction...

Recodify

Wouldn't it be more interesting if the `whereNull` and `orWhereNull` functions receives an array as first parameter? Changing this: ```javascript knex('first_table') .innerJoin('second_table', 'second_table.bar', 'first_table.foo') .whereNull('first_table.deleted_at') .whereNull('second_table.deleted_at') ``` To this: ```javascript...

ricardocastanho

# Environment Knex version: 2.2.0 Database + version: Ver 8.0.30-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu)) OS: Ubuntu 20.04 Node verson: 18.7.0 # Bug Explain what kind of behaviour you are...

azivkovi

Postgres JSONB operator ? interpreted as binding

1

# Environment Knex version: v2.0.0 Database + version: Postgres v12 OS: Linux # Bug 1. What's happening: JSONB operator `?` in where is interpreted as binding `.where('jsonbColumn', '?', 'jsonbKey')` replaces...

llouka

Knex.connection timeouts when providing a mysql2/promise connection + no TS types

4

# Environment Knex version: 2.1.0 Database + version: MySQL 8.0 (docker container) OS: Docker desktop on Mac OSX (12.3.1) Select applicable template from below. If issue is about oracledb support,...

clemgrim