330 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
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
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
a9338208f1
fix(oracledb): withRecursive: omit invalid RECURSIVE keyword, include column list [#4514] (#4652) 2021-09-03 22:27:32 +03:00
Jeremy W. Sherman
ce35bd6b64
fix(oracledb): Support setNullable, dropNullable (#4659) 2021-09-03 22:25:22 +03:00
Igor Savin
8d75615524
Implement nullability modification via schema builder (#4657) 2021-08-28 20:41:54 +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
Igor Savin
91bde6021d
Additional fixes for Oracle schema support (#4596) 2021-07-31 19:25:37 +03:00
Igor Savin
124107e0ec
Fix autoincrement for Oracle with schema (#4594) 2021-07-29 17:07:22 +03:00
zeotuan
45916f97ee
Add deferrable support for constraint (#4584) 2021-07-25 10:23:17 +03:00
Dave de Jong
8619d80336
Add mssql trustServerCertificate option. (#4500) 2021-07-21 01:29:53 +03:00
zeotuan
55eadcf7ad
Fixing posgres datetime and timestamp column created with wrong format (#4578) 2021-07-21 01:23:20 +03:00
Egor Koldasov
c335fda657
#873 | implement delete with join (#4568) 2021-07-13 09:41:16 +03:00
Vesa Peltola
f447b3b6eb
Add DPI error codes for Oracle (#4536) 2021-07-12 23:46:38 +03:00
Calvin Metcalf
f78c3618e2
add obility to omit collumns on an onConflict().ignore() (#4557) 2021-07-10 14:54:07 +03:00
Wigger Boelens
267ff3a28b
Add support for file open flags for sqlite3 (#4446) 2021-04-22 00:50:03 +03:00
Jeremy W. Sherman
0d43c1cbb9
mssql: Improve estimate of max comment length (#4362) 2021-03-25 11:24:44 +02:00
martinmacko47
1744c8c265
Fix timeout method (#4324) 2021-03-22 01:33:59 +02:00
Rijk van Zanten
910c009870
Rework dropForeign to use new tokenized structure (#4376)
Fixes #4369
2021-03-15 22:45:28 +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
Daniel Hensby
7db2d18877
fix mssql alter column must have its own query (#4317) 2021-02-25 19:34:22 +02:00
Tyler Watson
6c3e7b5afc
mssql: don't raise query-error twice (#4314) 2021-02-25 12:37:43 +02:00
Igor Savin
61e1046651
Avoid importing entire lodash to ensure tree-shaking is working correctly (#4302) 2021-02-18 12:29:03 +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
Tyler Watson
b530eacd61
mssql: add all mssql options to Knex.ConnectionConfig (#4281)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-02-08 16:57:27 +02:00
Igor Savin
b0d8d831dd
Restore hotfix from #4128 (#4283) 2021-02-08 15:55:16 +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