Igor Savin
9c390036db
Move "parameter" out of formatter ( #4275 )
2021-02-04 15:54:26 +02:00
Igor Savin
2040bd11a4
Move more logic over from formatter ( #4273 )
2021-02-03 21:17:20 +02:00
Nicola Krumschmidt
edf994d7f7
Simplify reinsert logic when altering a table in SQLite ( #4272 )
2021-02-03 20:49:42 +02:00
George Petrov
57184acd63
Primary keys improvements ( #4266 )
2021-02-03 14:47:32 +02:00
Igor Savin
d89c36ae80
Move more code out of formatter ( #4270 )
2021-02-03 01:13:16 +02:00
maximelkin
b9fb5992b5
Migrate to classes ( #4253 )
2021-01-31 12:40:13 +02:00
martinmacko47
50be910113
Allow optimizer hints ( #4243 )
2021-01-28 01:57:25 +02:00
Morgan Zolob
92907e80e2
Add check to only create native enum once ( #3658 )
...
Co-authored-by: Morgan Zolob <morgan.zolob@ingrooves.com>
2021-01-16 16:16:00 +02:00
bittersweet shimmer
629e1d2423
Fix SQLite foreign on delete when altering a table ( #4225 )
2021-01-13 00:07:07 +02:00
Igor Savin
b111771117
Clean up querybuilder ( #4220 )
2021-01-09 17:59:53 +02:00
Igor Savin
a889a09060
Extract even more formatter stuff into client ( #4219 )
2021-01-09 17:40:30 +02:00
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
