122 Commits

Author SHA1 Message Date
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