Igor Savin
3c6a1fb852
Fix final tests failing on CockroachDB ( #4741 )
2021-10-15 18:02:55 +03:00
Igor Savin
2b1e37ca44
Fix more tests for CockroachDB ( #4729 )
2021-10-13 01:19:56 +03:00
Igor Savin
d45a8c8607
Implement basic query cancellation for CockroachDB ( #4723 )
2021-10-10 20:15:47 +03:00
Igor Savin
33e8b9fcb9
Fix joins tests for CockroachDB ( #4721 )
2021-10-10 17:16:47 +03:00
Igor Savin
e6d5873cec
Fix migration locking for cockroachdb ( #4717 )
2021-10-10 02:07:56 +03:00
Igor Savin
07c30bfcb8
Implement truncate method for CockroachDB, refactor and fix some tests ( #4714 )
2021-10-10 01:33:20 +03:00
Igor Savin
c2c9446c29
Fix JSON support for CockroachDB ( #4701 )
2021-10-03 21:33:24 +03:00
Igor Savin
941b660f53
Initial infrastructure for CockroachDB ( #4571 )
2021-10-02 23:45:17 +03:00
Igor Savin
40cb7ce105
Minor cleanup around batch-insert ( #4676 )
2021-09-14 10:38:23 +03:00
Matt Machuga
01cfa98c2c
Adding support for pg-native ( #4327 )
2021-09-06 16:04:23 +03:00
Jeremy W. Sherman
a9338208f1
fix(oracledb): withRecursive: omit invalid RECURSIVE keyword, include column list [ #4514 ] ( #4652 )
2021-09-03 22:27:32 +03:00
michaelbrewerdavis
b5225179ce
fix migrate:up for migrations disabling transactions ( #4550 )
2021-08-31 23:05:35 +03:00
Nicola Krumschmidt
00cbd00631
Clean up SQLite DDL handling and move all operations to the parser-based approach ( #4648 )
2021-08-25 17:30:44 +03:00
Jeremy W. Sherman
40576ce430
fix(mssql): Generate valid SQL for withRecursive() [ #4514 ] ( #4639 )
2021-08-25 09:36:43 +03:00
Jeremy W. Sherman
5ac422410b
feat(mssql): Support comments as MS_Description properties ( #4632 )
2021-08-21 21:29:55 +03:00
Jeremy W. Sherman
52950c652b
fix(mssql): columnInfo() support case-sensitive database collations ( #4633 )
2021-08-21 21:26:54 +03:00
Maximilian-Albin Ekström
3a083d9b0e
fix: use sys info function instead of connection db name ( #4623 )
...
Co-authored-by: Maximilian-Albin Ekström <maximilian-albin.ekstrom@instabox.se>
2021-08-20 12:51:21 +03:00
Egor Koldasov
c335fda657
#873 | implement delete with join ( #4568 )
2021-07-13 09:41:16 +03:00
Calvin Metcalf
f78c3618e2
add obility to omit collumns on an onConflict().ignore() ( #4557 )
2021-07-10 14:54:07 +03:00
Ardeshir81
6b420cebdf
Throw an error if negative offset is provided ( #4361 )
2021-03-25 11:30:25 +02:00
martinmacko47
1744c8c265
Fix timeout method ( #4324 )
2021-03-22 01:33:59 +02:00
Matt Machuga
0ab482bcfb
Unify db test helpers ( #4356 )
2021-03-08 14:16:07 +02:00
Nicola Krumschmidt
c1ab23c206
Await asynchronous expect assertions ( #4334 )
2021-03-03 01:28:42 +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
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
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
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
martinmacko47
50be910113
Allow optimizer hints ( #4243 )
2021-01-28 01:57:25 +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
c16b731fdc
Change default behaviour for transaction rollback ( #4195 )
2021-01-02 14:23:40 +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
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
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
Nico Burns
8d43019873
Implement "UPSERT" (Postgres/MySQL/Sqlite) ( #3763 )
2020-10-31 17:22:52 +02:00
Igor Savin
26f3e5d62d
Replace uuid with copied nanoid logic ( #4089 )
2020-10-30 14:21:17 +02:00
torres-federico
69167b6fa9
Oracle: replace user_tab_columns with all_tab_columns ( #4061 )
2020-10-28 22:42:24 +02: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
4a1638bfbe
Fix double merging of config for migrator ( #4040 )
2020-09-25 08:03:17 +02:00
