84 Commits

Author SHA1 Message Date
Andrés Correa Casablanca
f6ea8122b6
fix(security): avoid password leaks on query logs (#5559)
Signed-off-by: Andres Correa Casablanca <castarco@coderspirit.xyz>
2023-07-03 21:03:27 +02:00
François de Metz
704d12e9ba
Add ability to prepend query comments (#5289)
Co-authored-by: Ryan Fink <ryanjfink@gmail.com>
2023-04-14 06:07:05 +02:00
abal
864530cd67
feat: support partial unique indexes (#5316) 2022-09-02 00:18:05 +03:00
Kelly Bourg
e0c0fa9358
Implement mapBinding mssql dialect option (#5292) 2022-08-31 21:25:25 +03:00
Pedro Ramos
e308184988
MSSQL: Fix .hasTable result when using .withSchema (#5176) 2022-05-22 15:56:53 +03:00
TJ (Thomas J.) Biddle
c4a3abc42d
Do not use sys.tables to find if a table exists (#2328)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-02-01 14:54:46 +01:00
Lucas Silva
b42bc468a0
Inconsistencies between .select and .returning (#4471)
Co-authored-by: Lucas Silva <lucas.silva@codeminer42.com>
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-01-14 00:05:52 +02:00
Olivier Cavadenti
4494113187
Checks Constraints Support (#4874)
Co-authored-by: Ivan Zhuravlev <intech@users.noreply.github.com>
2022-01-06 14:44:16 +01:00
Olivier Cavadenti
b6775d9b00
Create multiple PKs with increments (#4903) 2022-01-03 20:55:24 +01:00
Olivier Cavadenti
8835d22652
Json advanced support (#4859) 2021-12-22 10:47:16 +01:00
Marat Levit
b612cdc0b1
Added support for MSSQL unique constraint (#4887) 2021-12-13 10:41:46 +01:00
Olivier Cavadenti
d813edfc7b
Add binary uuid option (#4836) 2021-12-07 16:38:03 +01:00
Marius
44dbbca524
Make view columns optional in create view like (#4829) 2021-11-16 19:31:43 +01:00
Olivier Cavadenti
27ade6f881
Add columns in create table like #4821 2021-11-10 21:24:34 +01:00
Olivier Cavadenti
49e597df85
[CLEAN] Remove duplicate code (#4813) 2021-11-09 09:34:19 +01:00
Olivier Cavadenti
fdad316f01
Allow skip binding in limit and offset (#4811) 2021-11-08 10:49:11 +01:00
Olivier Cavadenti
b97d49b184
Support whereLike and whereILike (#4779) 2021-10-31 19:52:22 +01:00
Olivier Cavadenti
ace439d5c7
Implement partial index support (#4768) 2021-10-26 00:37:26 +03:00
Olivier Cavadenti
60db2d25a2
View support (#1626) (#4748) 2021-10-20 23:23:29 +03:00
Olivier Cavadenti
7c52de9f23
Create table like support (#1373) (#4728) 2021-10-15 16:57:46 +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
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
Dave de Jong
8619d80336
Add mssql trustServerCertificate option. (#4500) 2021-07-21 01:29:53 +03:00
Egor Koldasov
c335fda657
#873 | implement delete with join (#4568) 2021-07-13 09:41:16 +03:00
Jeremy W. Sherman
0d43c1cbb9
mssql: Improve estimate of max comment length (#4362) 2021-03-25 11:24:44 +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
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
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
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
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
Igor Savin
b111771117
Clean up querybuilder (#4220) 2021-01-09 17:59:53 +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
0b2a2ca4d1
Extract static method _num out of class. Use super-methods (#4212) 2021-01-06 23:21:10 +02:00
Igor Savin
6275ea3b08
Migrate columncompiler to classes (#4193) 2021-01-01 20:35:54 +02:00