davidf84
770b2f20ac
Fixed issue with bigincrements not working with composite primary key in MySQL - #5341 ( #5343 )
...
Co-authored-by: David Farrugia <david.farrugia@sagossgroup.com>
2023-11-29 02:10:12 +02:00
ROUL
57419fbbea
Missing comments on delete, update and insert ( #5738 )
...
Co-authored-by: Igor Savin <iselwin@gmail.com>
2023-11-28 02:19:51 +02:00
Alex Vershinin
04642dab63
MySQL dialect: added implementation for upsert ( #5743 )
...
Co-authored-by: Igor Savin <iselwin@gmail.com>
2023-11-28 02:14:36 +02:00
Anton Savchenko
e145322da9
1227: add assertion for basic where clause values ( #5417 )
2023-01-05 23:27:49 +01:00
Connor Tumbleson
b20047bba5
Fixes Maria issue with 'NULL' returned instead of NULL on MariaDB 10.2.6+ ( #5181 )
2022-05-22 14:39:45 +02:00
KlausBai
1525f0f916
fix: mysql hasColumn Error.(hasColumn a_id
but hasColumn('a_Id') is false) ( #5148 )
2022-04-29 11:29:15 +02:00
Daniel Lockyer
affb883960
Fixed primary keys being created separately on MySQL ( #5017 )
2022-02-10 19:06:23 +02:00
David Straub
81d6ffad4a
Fix collation when renaming column in MySQL dialect ( #2666 )
...
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-02-01 15:00:05 +02:00
Lucas Silva
2467db18e9
adding with clause in mysql dialect ( #4508 )
...
Co-authored-by: Lucas Silva <lucas.silva@codeminer42.com>
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-01-25 20:05:19 +01: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
Olivier Cavadenti
84bc2d9177
Set comment size warning limit to 1024 in MySQL ( #4867 )
2021-12-05 22:09:24 +01:00
Olivier Cavadenti
27ade6f881
Add columns in create table like #4821
2021-11-10 21:24:34 +01:00
Olivier Cavadenti
89bd0a034f
Mysql2 validate connection fix #4794 ( #4812 )
2021-11-08 22:12:34 +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
d463284349
Add storage engine index Type support to MySQL index() and unique() schema ( #4756 )
...
Co-authored-by: Elan Ruusamäe <glen@delfi.ee>
2021-10-21 01:20:56 +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
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
martinmacko47
1744c8c265
Fix timeout method ( #4324 )
2021-03-22 01:33:59 +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
230845d3c2
Make "first" and "pluck" mutually exclusive ( #4280 )
2021-02-08 13:45:13 +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
maximelkin
b9fb5992b5
Migrate to classes ( #4253 )
2021-01-31 12:40:13 +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
067a1a0326
Extract more of the formatter logic ( #4214 )
2021-01-07 17:31:56 +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
6275ea3b08
Migrate columncompiler to classes ( #4193 )
2021-01-01 20:35:54 +02:00
Igor Savin
0e09fcd3c1
Refactor to classes (part 2) ( #4191 )
2021-01-01 18:46:16 +02:00
Igor Savin
b43dadbe01
Refactor to classes ( #4190 )
2021-01-01 17:46:10 +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
Igor Savin
2aec21ed5e
Try to introduce some organization into how files are grouped ( #4178 )
2020-12-28 16:55:08 +02:00
Igor Savin
938d5c263a
Add more debug output for dialect resolution
2020-12-25 20:33:06 +02:00
Mark Boyd
76c131e2a9
Add support for WHERE clauses to "upsert" queries ( #4148 )
2020-12-09 17:51:29 +02:00
Nico Burns
8d43019873
Implement "UPSERT" (Postgres/MySQL/Sqlite) ( #3763 )
2020-10-31 17:22:52 +02:00
Igor Savin
20629af916
Fix comment escaping for MySQL and PostgreSQL ( #4084 )
2020-10-27 10:05:21 +02:00
Bogdan Chadkin
80355e4850
Replace inherits package with builtin utility ( #4059 )
2020-10-05 23:59:12 +03: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
Igor Savin
e37aeaa31c
Prepare for 0.21.0 release ( #3811 )
2020-04-19 00:40:23 +02:00
tkalliom
02d94d96b0
Reduce size of lodash in bundle ( #3804 )
2020-04-18 19:41:23 +02:00