Igor Savin
cd6479bf0b
More formatter cleanup ( #4218 )
2021-01-07 23:34:46 +02:00
Igor Savin
0bef361ffd
Reduce amount of parameters needed ( #4217 )
2021-01-07 22:44:03 +02:00
Igor Savin
d78c65921f
More formatter extraction ( #4215 )
2021-01-07 17:48:14 +02:00
Igor Savin
067a1a0326
Extract more of the formatter logic ( #4214 )
2021-01-07 17:31:56 +02:00
Igor Savin
a9773b79a3
Extract static methods outside of a formatter ( #4213 )
2021-01-07 02:04:10 +02:00
Igor Savin
0b2a2ca4d1
Extract static method _num out of class. Use super-methods ( #4212 )
2021-01-06 23:21:10 +02:00
Igor Savin
41606d799c
Move remaining builders to class ( #4210 )
2021-01-06 20:14:44 +02:00
schmetzyannick
37eab27d98
Sqlite drop composite foreign keys ( #4202 )
...
Co-authored-by: Yannick Schmetz <yannick.schmetz@inform-software.com>
2021-01-05 13:58:02 +02:00
Nicola Krumschmidt
b0299f74ef
Use SQLite rename column instead of ddl helper ( #4200 )
...
Since SQLite version 3.25.0 renaming columns is supported natively.
2021-01-03 23:49:12 +02:00
Igor Savin
92d8f49724
Return complete list of DDL commands for creating foreign keys in SQLite ( #4194 )
2021-01-03 04:10:26 +02:00
Igor Savin
6275ea3b08
Migrate columncompiler to classes ( #4193 )
2021-01-01 20:35:54 +02:00
Igor Savin
a896386f36
Extract DDL operation SQL generation ( #4192 )
2021-01-01 19:42:19 +02:00
Igor Savin
0e09fcd3c1
Refactor to classes (part 2) ( #4191 )
2021-01-01 18:46:16 +02:00
Igor Savin
b43dadbe01
Refactor to classes ( #4190 )
2021-01-01 17:46:10 +02:00
Igor Savin
936126c0f0
Add analytic functions v2 ( #4188 )
...
Co-authored-by: CorvusCorrax <renaud.cayol@gmail.com>
Co-authored-by: Alexandre Tiertant <alexandre.tiertant@gmail.com>
2020-12-31 14:38:50 +02:00
7opf
2b1fed5434
fallback to json for sqlite3 when using jsonb ( #4186 )
...
Co-authored-by: Severin Skillman <sev@skillman.ch>
2020-12-30 22:16:09 +02:00
Ben Lu
a31f0400e6
Add transaction isolation support ( #4185 )
2020-12-30 18:13:35 +02:00
Igor Savin
2aec21ed5e
Try to introduce some organization into how files are grouped ( #4178 )
2020-12-28 16:55:08 +02:00
Igor Savin
5f34fc170a
Documentation cleanup
...
Co-authored-by: Greg Gorlen <ggorlen@users.noreply.github.com>
2020-12-27 16:30:40 +02:00
Rijk van Zanten
9692e36561
Add primary/foreign support to SQLite on alterTable ( #4162 )
...
Co-authored-by: Igor Savin <iselwin@gmail.com>
2020-12-26 19:10:40 +02:00
Igor Savin
938d5c263a
Add more debug output for dialect resolution
2020-12-25 20:33:06 +02:00
Kkmatt11
629909475c
Fix MSSQL with returns on inserts and deletes on tables with triggers ( #4152 )
2020-12-18 01:12:04 +02:00
Igor Savin
3394a02935
Avoid connection getting stuck on socket hangup ( #4157 )
2020-12-11 23:56:14 +02:00
Mark Boyd
76c131e2a9
Add support for WHERE clauses to "upsert" queries ( #4148 )
2020-12-09 17:51:29 +02:00
Rijk van Zanten
b7e1ffd7d5
Add support for dropForeign in SQLite ( #4092 )
...
Co-authored-by: Igor Savin <iselwin@gmail.com>
2020-12-08 14:49:41 +02:00
Igor Savin
c47e00de64
Support non-standard Oracle port ( #4147 )
2020-12-08 00:47:00 +02:00
Nico Burns
8d43019873
Implement "UPSERT" (Postgres/MySQL/Sqlite) ( #3763 )
2020-10-31 17:22:52 +02:00
torres-federico
69167b6fa9
Oracle: replace user_tab_columns with all_tab_columns ( #4061 )
2020-10-28 22:42:24 +02:00
Igor Savin
20629af916
Fix comment escaping for MySQL and PostgreSQL ( #4084 )
2020-10-27 10:05:21 +02:00
Kkmatt11
4edd56f156
MSSQL '?' solution ( #4053 )
...
Escape properly if literal '?' is needed.
2020-10-26 20:39:12 +02:00
Jamie Peabody
8faaf9ce27
fixes apostrophe issue on mssql dialect ( #4077 )
...
Co-authored-by: Jamie Peabody <jpeabody@axway.com>
2020-10-24 17:55:02 +03:00
Bogdan Chadkin
80355e4850
Replace inherits package with builtin utility ( #4059 )
2020-10-05 23:59:12 +03:00
Bogdan Chadkin
6f817a3b6e
Avoid lodash typecheks ( #4056 )
...
* Avoid lodash typecheks
Lodash is quite big project. Even with direct imports it loads [tons](https://github.com/knex/knex/pull/3804 ) of
code and still bloats node_modules. Especially since lodash mostly used
as a polyfill for modern features.
In this diff I attempted to reduce lodash usage by replacing type checks
with `typeof` operator which might be sufficient.
Also replaced lodash/isObject with custom simplified utility which does not
consider functions as objects and allows to simplify code in one place.
2020-10-05 21:29:39 +03:00
hansnull
8029396d2d
Mssql decimal fix ( #3910 )
2020-09-30 10:05:16 +03:00
Igor Savin
55c3787644
Update dependencies ( #3971 )
2020-08-08 18:32:09 +03:00
Keno Medenbach
2bd2ecd91c
MSSQL: Added the removal of a columns default constraint, before dropping the column ( #3855 )
2020-05-15 11:28:34 +02:00
Igor Savin
e37aeaa31c
Prepare for 0.21.0 release ( #3811 )
2020-04-19 00:40:23 +02:00
tkalliom
02d94d96b0
Reduce size of lodash in bundle ( #3804 )
2020-04-18 19:41:23 +02:00
Brian Lauber
31c5b86ec4
Fix: Transaction_OracleDB can use config.connection ( #3731 )
2020-03-15 20:30:40 +01:00
Brian Lauber
6e6b666603
Rewrote Transaction#acquireConnection() methods to use async ( #3707 )
2020-03-07 01:15:23 +01:00
Brian Lauber
51052c52e8
Cleanup/remove dead oracle code ( #3697 )
2020-03-03 00:18:45 +01:00
maximelkin
dc30abf39e
bugfix mysql query errors ignored ( #3690 )
2020-02-29 00:16:07 +01:00
maximelkin
b025aea318
remove dependency on bluebird methods from sources ( #3683 )
...
Co-authored-by: Brian Lauber <constructible.truth@gmail.com>
2020-02-25 22:50:24 +01:00
lando-cal
3bea3f66ec
Add OracleDB handling for buffer type in fetchAsString ( #3685 )
...
As released in [2.3.0](https://github.com/oracle/node-oracledb/blob/master/CHANGELOG.md#node-oracledb-v230-7-jun-2018 ) of node-oracledb, this adds handling to fetchAsString for the `BUFFER` type, allowing fetchAsString to interpret `RAW` fields.
2020-02-25 01:27:33 +01:00
Jake Coffman
d50d00644c
oracledb: commit was a no-op causing race conditions ( #3668 )
...
The underlying issue was that query *always* committed, even during a transaction. The previous fix was to just disable commitAsync in a transaction but then that also disabled explicit commit calls. Instead, this fix disables query's commits during transactions so that explicit commits still work.
2020-02-16 20:26:13 +01:00
Brian Lauber
31e5418eb1
Fixed unresolved promise in cancelQuery(..) ... ( #3666 )
...
cancelQuery(..) was attempting to
"cancel the cancellation" after 100ms. However, it was not
actually achieving this objective. In reality, the cancellation
was still running in the background even though the caller had
already moved on.
Later on, the cancellation would ACTUALLY fail due to a resource
allocation issue (ie: no more connections in the Tarn pool).
This would then result in an unhandled Promise rejection.
2020-02-16 20:05:50 +01:00
maximelkin
88d832cd36
replace Bluebird.timeout ( #3634 )
2020-02-12 21:42:15 +01:00
Lorefnon
589ea747c2
Update QueryCompiler implementation to use classes ( #3647 )
2020-02-01 17:22:00 +01:00
Jake Coffman
22558209d4
dispose Oracle connection on connection error ( #3611 )
...
Co-authored-by: abskmj <abskmj@gmail.com>
2020-01-05 18:47:32 +01:00
Jake Coffman
07997279b7
fix #3605 not releasing connection from pool on disconnect ( #3606 )
2020-01-04 22:56:14 +01:00