518 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
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
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
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
Luke Stevens
d96bc191e3
fix: handle numeric array elements in .orderBy() (#5551) 2023-07-04 22:23:01 +02:00
Andy Wooldridge
2da5822fe4
fix: creating a unique index in postgres using the index method (#5601) 2023-07-04 12:59:17 +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
Erin Dees
2ed6988d80
Ensure test DB exists at correct path in better-sqlite3 tests (#5608) 2023-06-27 10:26:30 +02:00
Erin Dees
dab051b6da
Add readonly option to Better-SQLite3 (#5530)
Co-authored-by: Adam Haglund <ahaglund@paypal.com>
2023-06-25 21:30:11 +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
ian
8ea5690bac
Use implicit check on json fields for OracleDB (#5478) 2023-03-29 23:45:19 +02:00
Deirdre Sweeney
4d5ae61bfe
[ISSUE-5350] Create EXCEPT as a valid keyword (#5357) 2023-03-29 14:03:59 +02:00
Adam Haglund
ac59ab7bb6
Add nativeBindings option to better-sqlite3 options (#5461) 2023-03-28 22:12:05 +02:00
Anton Savchenko
e145322da9
1227: add assertion for basic where clause values (#5417) 2023-01-05 23:27:49 +01:00
Suhyeong Cho
72bd1f7396
Fix: orWhereJson (#5361) 2022-11-18 23:23:52 +01:00
Jakob Joonas
f7ccde80c9
Make compiling SQL in error message optional (#5282) 2022-09-23 09:39:15 +02:00
abal
864530cd67
feat: support partial unique indexes (#5316) 2022-09-02 00:18:05 +03:00
Hasnae
97fccdff7d
Explicit jsonb support for custom pg clients (#5201)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2022-08-31 22:16:17 +03: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
Dominic Vonk
a4df3e3540
Implement extendable builders (#5041)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-05-17 13:07:26 +03:00
Dmitry Kudryavtsev
e2516cd058
Refresh materialized view concurrently for PostgreSQL (#5166) 2022-05-08 20:15:43 +02:00
Olivier Cavadenti
b8fc16f867
Restore sqlite3 package (#5136) 2022-04-21 19:05:40 +02:00
Olivier Cavadenti
d0c9027a4b
Fix @vscode-sqlite3 error message (#5081) 2022-03-22 23:04:42 +01:00
Olivier Cavadenti
c3e41e3d78
Wrapped Unions Fixes (#5072) 2022-03-19 13:05:52 +01:00
Jürg Lehni
81b7edd115
Fix isModuleType() for yarn (#4447) (#5071) 2022-03-19 13:35:04 +02:00
Olivier Cavadenti
a906596f06
Rework Union Wrapping (#5030) 2022-03-07 13:45:58 +01:00
Olivier Cavadenti
106a881e20
Add whereLike functions (#5044) 2022-03-01 20:19:35 +01:00
Daniel Lockyer
affb883960
Fixed primary keys being created separately on MySQL (#5017) 2022-02-10 19:06:23 +02:00
Olivier Cavadenti
47b96344c2
Fix delete joins with PostgreSQL (#5016) 2022-02-09 23:01:43 +01: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
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
Olivier Cavadenti
2e1016e662
Add alterType and update index.d.ts for alter function (#4967)
Co-authored-by: intech <ru31337@gmail.com>
2022-01-27 13:34:23 +01: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
Igor N. Dultsev
3ee6d0f022
Alter nullable constraint when alterNullable is set to true (#4730) 2022-01-24 20:22:04 +01:00
Olivier Cavadenti
6ee3f94d1a
Add raw support in onConflict clause (#4960) 2022-01-22 14:31:51 +01:00
Olivier Cavadenti
63980987a6
Support of MATERIALIZED and NOT MATERIALIZED with WITH/CTE (#4940) 2022-01-20 22:54:03 +01:00
Igor Savin
4a0d82f2be
Fix tests for RETURNING and enable them for SQLite. (#4934) 2022-01-16 02:20:52 +02:00
Beeno Tung
5e6b3c2d6a
remove outdated warning message (#4928)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-01-14 22:19:31 +02:00
Marek Brenčič
3f0ec9f84e
Fix for createViewOrReplace and its support for sqlite3 (#4856)
Co-authored-by: Marek "foxie" Brenčič <marek@brencic.sk>
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-01-14 11:15:03 +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
Ferris
bb7de096dc
Add CI support for Oracle 18c (resolves #4888) (#4889)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2021-12-15 14:57:23 +02:00
Marat Levit
b612cdc0b1
Added support for MSSQL unique constraint (#4887) 2021-12-13 10:41:46 +01:00