52 Commits

Author SHA1 Message Date
Igor Savin
3c6a1fb852
Fix final tests failing on CockroachDB (#4741) 2021-10-15 18:02:55 +03:00
Olivier Cavadenti
7c52de9f23
Create table like support (#1373) (#4728) 2021-10-15 16:57:46 +03:00
Igor Savin
2b1e37ca44
Fix more tests for CockroachDB (#4729) 2021-10-13 01:19:56 +03:00
Igor Savin
502ce49fa9
CockroachDB does not support query cancellation yet (#4726) 2021-10-11 19:36:50 +03:00
Jeremy W. Sherman
99e6726df9
mssql: Support table.primary, table.unique variant with options object (#4710) 2021-10-10 22:47:32 +03:00
Olivier Cavadenti
126b84639e
Support for 'is null' in 'order by' (#3667) (#4720) 2021-10-10 22:45:48 +03:00
Igor Savin
d45a8c8607
Implement basic query cancellation for CockroachDB (#4723) 2021-10-10 20:15:47 +03:00
Igor Savin
2361b9a534
Execute all tests (#4722) 2021-10-10 17:23:01 +03:00
Igor Savin
33e8b9fcb9
Fix joins tests for CockroachDB (#4721) 2021-10-10 17:16:47 +03:00
Igor Savin
7add986193
Avoid unnecessary DB rebuild (#4718) 2021-10-10 02:18:30 +03:00
Igor Savin
44ae0ffeb2
Execute all tests (#4716) 2021-10-10 01:40:22 +03:00
Igor Savin
07c30bfcb8
Implement truncate method for CockroachDB, refactor and fix some tests (#4714) 2021-10-10 01:33:20 +03:00
OlivierCavadenti
6892c2c7c0
Add support for 'CASCADE' in PostgreSQL 'DROP SCHEMA' queries (#4713) 2021-10-09 01:23:02 +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
Aiden Foxx
c778c82f2f
Added setNullable support to SQLite (#4684) 2021-09-19 18:14:06 +03:00
Matt Machuga
01cfa98c2c
Adding support for pg-native (#4327) 2021-09-06 16:04:23 +03:00
Jeremy W. Sherman
ce35bd6b64
fix(oracledb): Support setNullable, dropNullable (#4659) 2021-09-03 22:25:22 +03:00
Pete Nykänen
49b05b5c71
Add support for mysql/mariadb-client JSON parameters in connectionURIs (#4629)
Signed-off-by: petetnt <pete.a.nykanen@gmail.com>
2021-08-30 20:19:08 +03:00
Igor Savin
8d75615524
Implement nullability modification via schema builder (#4657) 2021-08-28 20:41:54 +03:00
Nicola Krumschmidt
153d0fbd72
Fix adding a column with a foreign key constraint in SQLite (#4649) 2021-08-25 23:14:14 +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
5ac422410b
feat(mssql): Support comments as MS_Description properties (#4632) 2021-08-21 21:29:55 +03:00
zeotuan
45916f97ee
Add deferrable support for constraint (#4584) 2021-07-25 10:23:17 +03:00
Jeremy W. Sherman
0d43c1cbb9
mssql: Improve estimate of max comment length (#4362) 2021-03-25 11:24:44 +02:00
Matt Machuga
0ab482bcfb
Unify db test helpers (#4356) 2021-03-08 14:16:07 +02:00
Nicola Krumschmidt
ed0e8a53df
Fix SQLite not doing rollback when altering columns fails (#4336) 2021-03-03 20:50:45 +02:00
Nicola Krumschmidt
3e6176ac0c
SQLite parser improvements (#4333) 2021-03-03 00:42:43 +02:00
Thibaut Patel
a98614d55a
Made the constraint detection case-insensitive (#4330) 2021-03-02 21:52:10 +02:00
Nicola Krumschmidt
29b8a3623f
Adjust generateDdlCommands return type (#4326) 2021-03-01 19:11:16 +02:00
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
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
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
Nicola Krumschmidt
1ec7a664ea
Recreate indices when altering a table in SQLite (#4277) 2021-02-05 16:35:30 +02:00
Nicola Krumschmidt
edf994d7f7
Simplify reinsert logic when altering a table in SQLite (#4272) 2021-02-03 20:49:42 +02:00
Igor Savin
5dcdf70066
Clean up destroy logic (#4248) 2021-01-21 20:25:06 +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
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
Igor Savin
92d8f49724
Return complete list of DDL commands for creating foreign keys in SQLite (#4194) 2021-01-03 04:10:26 +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
6a862e9459
Extract query execution-related code from client (#4175) 2020-12-27 15:19:47 +02:00