72 Commits

Author SHA1 Message Date
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
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
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
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
27ade6f881
Add columns in create table like #4821 2021-11-10 21:24:34 +01:00
Olivier Cavadenti
ace439d5c7
Implement partial index support (#4768) 2021-10-26 00:37:26 +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
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
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
Nicola Krumschmidt
edf994d7f7
Simplify reinsert logic when altering a table in SQLite (#4272) 2021-02-03 20:49:42 +02:00
bittersweet shimmer
629e1d2423
Fix SQLite foreign on delete when altering a table (#4225) 2021-01-13 00:07:07 +02:00
schmetzyannick
37eab27d98
Sqlite drop composite foreign keys (#4202)
Co-authored-by: Yannick Schmetz <yannick.schmetz@inform-software.com>
2021-01-05 13:58:02 +02:00
Nicola Krumschmidt
b0299f74ef
Use SQLite rename column instead of ddl helper (#4200)
Since SQLite version 3.25.0 renaming columns is supported natively.
2021-01-03 23:49:12 +02:00
Igor Savin
92d8f49724
Return complete list of DDL commands for creating foreign keys in SQLite (#4194) 2021-01-03 04:10:26 +02:00
Igor Savin
6275ea3b08
Migrate columncompiler to classes (#4193) 2021-01-01 20:35:54 +02:00
Igor Savin
a896386f36
Extract DDL operation SQL generation (#4192) 2021-01-01 19:42:19 +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
7opf
2b1fed5434
fallback to json for sqlite3 when using jsonb (#4186)
Co-authored-by: Severin Skillman <sev@skillman.ch>
2020-12-30 22:16:09 +02:00
Rijk van Zanten
9692e36561
Add primary/foreign support to SQLite on alterTable (#4162)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2020-12-26 19:10:40 +02:00
Rijk van Zanten
b7e1ffd7d5
Add support for dropForeign in SQLite (#4092)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2020-12-08 14:49:41 +02:00
Bogdan Chadkin
80355e4850
Replace inherits package with builtin utility (#4059) 2020-10-05 23:59:12 +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
Alexandre BODIN
0214f11663 Make sqlite3 hasColumn case insensitive (#3435) 2019-11-14 19:31:59 +01:00
maximelkin
d01600ba0d refactor(bluebird): remove Bluebird.bind (#3477) 2019-10-15 23:03:35 +02:00
Lorefnon
20bd04b594 Fix bugs in replacement logic used when dropping columns in SQLite. (#3476) 2019-10-11 22:38:01 +02:00
Roland Németh
c1d20270d6 Fix handling of multiline SQL in SQLite3 schema (#3411) 2019-10-06 18:27:52 +02:00
Ricardo Graça
9aa7085b05 Rename src directory to lib (#3338) 2019-07-10 23:48:43 +02:00
Mikael Lepistö
7140a48226 Remove generated lib from repository and run build in prepublish 2016-01-21 09:59:30 +02:00
Mikael Lepistö
fef0a09197 Did npm run build 2015-08-25 10:23:34 +03:00