994 Commits

Author SHA1 Message Date
Daniel Hensby
d807832b3b
mssql: schema builder - attempt to drop default constraints when changing default value on columns (#4321) 2021-02-28 19:27:48 +02:00
Daniel Hensby
c0d8c5c247
mssql: schema builder - add predictable constraint names for default values (#4319) 2021-02-28 01:08:15 +02:00
Nicola Krumschmidt
9e28a72aca
Add support for altering columns to SQLite (#4322) 2021-02-26 22:36:46 +02:00
Daniel Hensby
7db2d18877
fix mssql alter column must have its own query (#4317) 2021-02-25 19:34:22 +02:00
Jeremy W. Sherman
3718d647e4
Respect KNEX_TEST, support omitting sqlite3 from DB, and reduce outside mssql test db config (#4313) 2021-02-24 19:27:30 +02:00
Tyler Watson
8c73417de6
events: introduce queryContext on query-error (#4301) 2021-02-18 12:23:12 +02:00
Tolterix
5614c18624
Timestamp UTC Standardization for Migrations (#4245)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-02-15 19:27:41 +02:00
Richard Simko
489934655f
Fix for ES Module detection using npm@7 (#4295) (#4296) 2021-02-15 19:10:45 +02:00
Nicola Krumschmidt
c43fd7269e
Throw error if the array passed to insert is empty (#4289) 2021-02-15 19:03:48 +02:00
Matt
a4b6db85a9
Added merge strategy to allow selecting columns to upsert. (#4252)
Co-authored-by: Matt Goodson <matt.goodson.business@gmail.com>
2021-02-09 10:04:43 +02:00
Igor Savin
511ea2be0f
Querybuilder cleanup (#4282) 2021-02-08 16:54:00 +02:00
Igor Savin
230845d3c2
Make "first" and "pluck" mutually exclusive (#4280) 2021-02-08 13:45:13 +02:00
Tyler Watson
389b6686b5
mssql: column: json to nvarchar(max) (#4278) 2021-02-08 10:54:51 +02:00
Tyler Watson
c860b89184
WIP: Replace MSSQL dialect with Tedious.js implementation (#2857)
Co-authored-by: Tyler Watson <tyler@rapidplatform.com.au>
Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-02-08 08:46:35 +02:00
Nicola Krumschmidt
1ec7a664ea
Recreate indices when altering a table in SQLite (#4277) 2021-02-05 16:35:30 +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
Ihor Sakailiuk
09e9fa4193
Fix issue with schema usage with FROM clause contain QueryBuilder, function or Raw (#4268) 2021-02-03 19:16:00 +02:00
George Petrov
57184acd63
Primary keys improvements (#4266) 2021-02-03 14:47:32 +02:00
Ihor Sakailiuk
dbcc8a3228
Fix issue with .withSchema usage with joins on a subquery (#4267) 2021-02-03 00:23:50 +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
Igor Savin
5dcdf70066
Clean up destroy logic (#4248) 2021-01-21 20:25:06 +02:00
Igor Savin
9e0bb88e37
Update commander (#4240) 2021-01-17 20:28:39 +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
Igor Savin
c074ec7b9d
Add test for mysql port resolution (#4232) 2021-01-15 04:31:57 +02:00
Gabriel Aumala
79401f7fc8
Allow 'match' operator (#3569) 2021-01-13 18:58:23 +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
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
bf287be13a
Add integration test for specifictype (#4211) 2021-01-06 21:50:13 +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
Lorefnon
e107ceacfc
Make toSQL().toNative() work for Raw to match the API for QueryBuilder (#4058)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-01-02 16:26:29 +02:00
Igor Savin
c16b731fdc
Change default behaviour for transaction rollback (#4195) 2021-01-02 14:23:40 +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
maximelkin
4da221ba4f
whatwg url connection string parsing (#3702) 2020-12-28 00:09:58 +02:00
Igor Savin
6a862e9459
Extract query execution-related code from client (#4175) 2020-12-27 15:19:47 +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
d20131f31d Fix SQLite dialect in CI 2020-12-25 20:39:32 +02:00
Igor Savin
938d5c263a Add more debug output for dialect resolution 2020-12-25 20:33:06 +02:00
Igor Savin
b4f5080097
Add GitHub Actions (#4168) 2020-12-22 10:28:58 +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
704853d605
Improved integration test framework (#4161) 2020-12-14 23:47:02 +02:00
Ivan Starkov
84cee6c445
Fix performance of asyncStackTraces with enable-source-maps node flag (#4154) 2020-12-11 13:19:03 +02:00