153 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
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
Omar Abdelkader
570a7eae48
Add readonly transaction access mode (#5445) 2023-03-29 13:59:05 +02: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
Simon Plenderleith
2dadde4214
Support returning with sqlite3 and better-sqlite3 (#5285) 2022-08-03 00:04:34 +03:00
Pedro Ramos
19c007901d
Add warning for undefined connection file (#5223) 2022-06-14 20:27:11 +02:00
Vítor Marques de Almeida
29ba203839
chore: update docs reference in sqlite3 warning (#5207) 2022-06-03 20:37:32 +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
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
Pedro Ramos
40eef5c634
Enable wrapIdentifier for SQLite .hasTable (#4915) 2022-01-10 21:10:32 +01:00
Nicola Krumschmidt
4c589a3bfa
Fix executing sqlite ddl comands when the table name is a substring of "CREATE TABLE" (#4923) 2022-01-06 23:40:14 +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
Nicola Krumschmidt
e2a425e4e3
Revert "Fix SQLite not doing rollback when altering columns fails (#4336)" (#4896) 2021-12-15 20:49:53 +02:00
Nicola Krumschmidt
157e27d0e3
Fix SQLite foreign key constraints when altering a table (#4189) 2021-12-13 19:59:01 +01:00
Ben Lambert
2bd181171b
Support for better-sqlite3 Driver (#4871)
Signed-off-by: blam <ben@blam.sh>

Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-12-09 16:19:37 +02:00
Olivier Cavadenti
7abb36507b
Support @vscode/sqlite3 (#4866) 2021-12-05 21:57:47 +01:00
Olivier Cavadenti
27ade6f881
Add columns in create table like #4821 2021-11-10 21:24:34 +01:00
Olivier Cavadenti
fdad316f01
Allow skip binding in limit and offset (#4811) 2021-11-08 10:49:11 +01:00
Olivier Cavadenti
ace439d5c7
Implement partial index support (#4768) 2021-10-26 00:37:26 +03:00
Dominik Krejcik
a17cc3214a
Support SELECT .. FOR NO KEY UPDATE / KEY SHARE row level locking clauses in Postgres (#4755) 2021-10-23 16:01:36 +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
07c30bfcb8
Implement truncate method for CockroachDB, refactor and fix some tests (#4714) 2021-10-10 01:33:20 +03:00
Aiden Foxx
c778c82f2f
Added setNullable support to SQLite (#4684) 2021-09-19 18:14:06 +03:00
Igor Savin
8d75615524
Implement nullability modification via schema builder (#4657) 2021-08-28 20:41:54 +03:00
Nicola Krumschmidt
00cbd00631
Clean up SQLite DDL handling and move all operations to the parser-based approach (#4648) 2021-08-25 17:30:44 +03:00
Calvin Metcalf
f78c3618e2
add obility to omit collumns on an onConflict().ignore() (#4557) 2021-07-10 14:54:07 +03:00
Wigger Boelens
267ff3a28b
Add support for file open flags for sqlite3 (#4446) 2021-04-22 00:50:03 +03:00
Rijk van Zanten
910c009870
Rework dropForeign to use new tokenized structure (#4376)
Fixes #4369
2021-03-15 22:45:28 +02:00
Nicola Krumschmidt
ed0e8a53df
Fix SQLite not doing rollback when altering columns fails (#4336) 2021-03-03 20:50:45 +02:00
Nicola Krumschmidt
3e6176ac0c
SQLite parser improvements (#4333) 2021-03-03 00:42:43 +02:00
Thibaut Patel
a98614d55a
Made the constraint detection case-insensitive (#4330) 2021-03-02 21:52:10 +02:00
Nicola Krumschmidt
29b8a3623f
Adjust generateDdlCommands return type (#4326) 2021-03-01 19:11:16 +02:00
Nicola Krumschmidt
9e28a72aca
Add support for altering columns to SQLite (#4322) 2021-02-26 22:36:46 +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
Nicola Krumschmidt
1ec7a664ea
Recreate indices when altering a table in SQLite (#4277) 2021-02-05 16:35:30 +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
Nicola Krumschmidt
edf994d7f7
Simplify reinsert logic when altering a table in SQLite (#4272) 2021-02-03 20:49:42 +02:00