60 Commits

Author SHA1 Message Date
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
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
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
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
Daniel Lockyer
affb883960
Fixed primary keys being created separately on MySQL (#5017) 2022-02-10 19:06:23 +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
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
Rafael Perches Pierri
dec8438ed8
Change skip tests (#4930)
Co-authored-by: Pedro Ramos <pedroramos.contato@outlook.com>
Co-authored-by: Igor Savin <iselwin@gmail.com>
Co-authored-by: Pedro Ramos <pedroramos.contato@outlook.com>
2022-01-14 22:03:32 +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
Nicola Krumschmidt
e2a425e4e3
Revert "Fix SQLite not doing rollback when altering columns fails (#4336)" (#4896) 2021-12-15 20:49:53 +02: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
Nicola Krumschmidt
157e27d0e3
Fix SQLite foreign key constraints when altering a table (#4189) 2021-12-13 19:59:01 +01:00
Olivier Cavadenti
2763e47129
Add camel case to timestamps method (#4803) 2021-12-09 15:24:32 +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
e06a2c20c6
Add missing ints typings (#4832) 2021-11-18 01:06:59 +01:00
Marius
44dbbca524
Make view columns optional in create view like (#4829) 2021-11-16 19:31:43 +01:00
Olivier Cavadenti
27ade6f881
Add columns in create table like #4821 2021-11-10 21:24:34 +01:00
Igor Savin
50cfa5f22f
Add geometry column building (#4776) 2021-10-28 00:10:33 +03: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
Igor Savin
3c6a1fb852
Fix final tests failing on CockroachDB (#4741) 2021-10-15 18:02:55 +03:00
Olivier Cavadenti
7c52de9f23
Create table like support (#1373) (#4728) 2021-10-15 16:57:46 +03:00
Igor Savin
2b1e37ca44
Fix more tests for CockroachDB (#4729) 2021-10-13 01:19:56 +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
OlivierCavadenti
6892c2c7c0
Add support for 'CASCADE' in PostgreSQL 'DROP SCHEMA' queries (#4713) 2021-10-09 01:23:02 +03:00
Igor Savin
c2c9446c29
Fix JSON support for CockroachDB (#4701) 2021-10-03 21:33:24 +03:00
Igor Savin
941b660f53
Initial infrastructure for CockroachDB (#4571) 2021-10-02 23:45:17 +03:00
Aiden Foxx
c778c82f2f
Added setNullable support to SQLite (#4684) 2021-09-19 18:14:06 +03:00
Jeremy W. Sherman
ce35bd6b64
fix(oracledb): Support setNullable, dropNullable (#4659) 2021-09-03 22:25:22 +03:00
Igor Savin
8d75615524
Implement nullability modification via schema builder (#4657) 2021-08-28 20:41:54 +03:00
Nicola Krumschmidt
153d0fbd72
Fix adding a column with a foreign key constraint in SQLite (#4649) 2021-08-25 23:14:14 +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
Matt Machuga
0ab482bcfb
Unify db test helpers (#4356) 2021-03-08 14:16:07 +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