137 Commits

Author SHA1 Message Date
Mustafa Balila
9659a20753
Fix whereILike issue with sqlite (#5604) (#5687)
Co-authored-by: Raz Luvaton <16746759+rluvaton@users.noreply.github.com>
2024-04-07 17:33:41 +03:00
Timothy Ng
3764ded568
Add migration lifecycle hooks (#5541)
Co-authored-by: Raz Luvaton <16746759+rluvaton@users.noreply.github.com>
2024-01-13 21:16:28 +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
Igor Savin
1d7707e312
Fix master (#5752) 2023-11-28 02:05:15 +02:00
Kyler Nelson
82f43d53ab
Support Object Names Greater than 30 Characters for Oracle DB Versions 12.2 and Greater (#5197)
Co-authored-by: Drew Royster <drew.124@gmail.com>
Co-authored-by: Kendra Bryant <kendraa@utahcounty.gov>
Co-authored-by: Matt Bailey <bailey.matthewr@gmail.com>
2023-10-17 02:31:38 +03:00
Kyler Nelson
5ececd35c9
Fix driver options specified with .options() method being ignored for oracledb dialect (#5123)
Co-authored-by: Matt Bailey <bailey.matthewr@gmail.com>
2023-07-19 23:09:36 +02:00
Ricardo Costa
a37f4f1fb8
Improve linting (#5460)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2023-07-12 22:42:57 +02:00
André Ricardo
440fe50a1e
Add uuid helper function (#5617) 2023-07-08 14:54:15 +02:00
Warren Seymour
61ee5338b3
feat(pg): implement QueryBuilder#updateFrom (#5386) 2023-07-06 13:31:28 +02:00
Linda Xu
2a6c20f27c
fix #3837 so that update with returning * actually returns an object isntead of the number of rows. Also fixes returning * when within a transaction (#5598)
Co-authored-by: Linda Xu <linda_xu2@apple.com>
2023-07-04 21:34:35 +02:00
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
Shean de Montigny-Desautels
5ffe289c33
fix() manually close source stream (#5466) 2023-05-31 17:53: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
Zhang Yidong
ab1f9ae372
[Sqlite3] Fix can not get table sql because of case sensitive (#5509)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2023-03-30 18:15:04 +02:00
Olivier Cavadenti
cba2210fd3 linting 2023-03-29 20:38:55 +02:00
Deirdre Sweeney
4d5ae61bfe
[ISSUE-5350] Create EXCEPT as a valid keyword (#5357) 2023-03-29 14:03:59 +02:00
Omar Abdelkader
570a7eae48
Add readonly transaction access mode (#5445) 2023-03-29 13:59:05 +02:00
Igor Savin
9a6c5ba62f
Additional lint checks before publishing (#5459) 2023-01-22 16:13:24 +02:00
Minh TRINH
5caf526c27
tests(insert): add tests for json, text array, integer array (#5451) 2023-01-18 02:05:36 +02:00
Loren
1f2de49fbe
Fix Postgres Malformed array literal 2.4.0 Regression (#5439) 2023-01-18 01:08:21 +02:00
Suhyeong Cho
72bd1f7396
Fix: orWhereJson (#5361) 2022-11-18 23:23:52 +01:00
abal
864530cd67
feat: support partial unique indexes (#5316) 2022-09-02 00:18:05 +03:00
Nicola Krumschmidt
6bed5e99dd
Fix changing the default value of a boolean column in SQLite (#5319) 2022-09-01 17:31:52 +03:00
Kelly Bourg
e0c0fa9358
Implement mapBinding mssql dialect option (#5292) 2022-08-31 21:25:25 +03:00
Simon Plenderleith
2dadde4214
Support returning with sqlite3 and better-sqlite3 (#5285) 2022-08-03 00:04:34 +03:00
David Garner
f33768ccdd
Fix unclosed stream connections (#5243)
* Destroy should not trigger an error. If there was an error, it is piped by the transform.

* fix: Close the database connection when a stream iterator fails

Co-authored-by: Daniel Cohen Gindi <danielgindi@gmail.com>
2022-07-14 16:14:05 +02:00
Lucas Bickel
8b0dd49700
feat: inline primary key creation for postgres flavours (#5233) 2022-06-30 16:09:25 +03:00
Lucas Bickel
0918bf9bde
fix(postgresql): add primaryKey option for uuid (#5212) 2022-06-08 11:41:43 +03:00
Pedro Ramos
e308184988
MSSQL: Fix .hasTable result when using .withSchema (#5176) 2022-05-22 15:56:53 +03: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
Ferris
ad62d9072f
Fix #4869, oracledb correctlyINSERTS Buffer (#5167) 2022-05-13 21:31:15 +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
Olivier Cavadenti
b8fc16f867
Restore sqlite3 package (#5136) 2022-04-21 19:05:40 +02:00
Olivier Cavadenti
93f94d6410
Async/await in tests : all query integration files (#5075) 2022-03-29 14:04:34 +02:00
Olivier Cavadenti
c3e41e3d78
Wrapped Unions Fixes (#5072) 2022-03-19 13:05:52 +01:00
Olivier Cavadenti
4f7d920daa
Async/await in tests : selects.spec.js (#5073) 2022-03-19 12:42:44 +01:00
Olivier Cavadenti
b5dbe01363
Stringify json value in update (#5063) 2022-03-15 10:47:43 +01:00
Olivier Cavadenti
a906596f06
Rework Union Wrapping (#5030) 2022-03-07 13:45:58 +01:00
Olivier Cavadenti
e0a6e54141
Subquery in on clause missing parenthesis (#5049) 2022-03-04 18:21:35 +01:00
Olivier Cavadenti
106a881e20
Add whereLike functions (#5044) 2022-03-01 20:19:35 +01:00
Olivier Cavadenti
600d3c3755
Fix orWhereJsonPath clause (#5022) 2022-02-13 15:11:39 +01:00
Daniel Lockyer
affb883960
Fixed primary keys being created separately on MySQL (#5017) 2022-02-10 19:06:23 +02:00
stvsh
1461b9b06a
Fix whereJsonPath queries for postgres and cockroachdb (#5011)
Co-authored-by: Jacek Starz <jacek.starz@antsolutions.eu>
2022-02-08 20:15:38 +01: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
Olivier Cavadenti
ffb60191db
Fix Order nulls in PostgreSQL (#4989) 2022-02-01 10:24:48 +01:00
Olivier Cavadenti
2986f8c1c0
Support string json in json values (#4988) 2022-02-01 00:01:57 +02:00
Mitch Jacovetty
f9f6a38a28
Same boolean handling in better-sqlite3 as in sqlite3 (#4982)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-02-01 00:01:00 +02:00
gzq
f50554b4c4
feat: add order and type for uuidtobin and binToUuid (#4969) 2022-01-28 18:34:38 +01:00
Shaun Sharples
4f0f0ab3e0
move deferrable to after on update/on delete (#4976)
Thank you!
2022-01-28 12:34:26 +02:00