893 Commits

Author SHA1 Message Date
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
tharrison4815
452104066b
Add type to typescript knexfile (#4909) 2021-12-30 23:46:22 +02: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
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
Marat Levit
b612cdc0b1
Added support for MSSQL unique constraint (#4887) 2021-12-13 10:41:46 +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
de1122ae2f
ForUpdate array parameter (#4882) 2021-12-07 23:44:17 +01:00
Olivier Cavadenti
d813edfc7b
Add binary uuid option (#4836) 2021-12-07 16:38:03 +01:00
Olivier Cavadenti
84bc2d9177
Set comment size warning limit to 1024 in MySQL (#4867) 2021-12-05 22:09:24 +01:00
Olivier Cavadenti
7abb36507b
Support @vscode/sqlite3 (#4866) 2021-12-05 21:57:47 +01:00
Olivier Cavadenti
540ab8c020
Insert lock row fix during migration (#4865) 2021-12-01 00:41:18 +01:00
Igor Savin
bd1c31a07e
Implement support for custom seed sources (#4842)
Co-authored-by: maximelkin <maxelkin@list.ru>
2021-11-27 02:23:31 +02:00
Marius
44dbbca524
Make view columns optional in create view like (#4829) 2021-11-16 19:31:43 +01:00
Olivier Cavadenti
672c2692b9
Accept Raw on onIn joins (#4830) 2021-11-16 09:25:29 +01:00
Olivier Cavadenti
27ade6f881
Add columns in create table like #4821 2021-11-10 21:24:34 +01:00
Olivier Cavadenti
49e597df85
[CLEAN] Remove duplicate code (#4813) 2021-11-09 09:34:19 +01:00
Olivier Cavadenti
89bd0a034f
Mysql2 validate connection fix #4794 (#4812) 2021-11-08 22:12:34 +01:00
Olivier Cavadenti
fdad316f01
Allow skip binding in limit and offset (#4811) 2021-11-08 10:49:11 +01:00
Olivier Cavadenti
ffd0c101f7
Support Joins and Using syntax for PostgreSQL Delete Statement (#4800) 2021-11-07 14:22:49 +01:00
windupbird144
3aadaead91
Resolves #4583 Add JSDoc (TS flavor) to stub files (#4809) 2021-11-06 10:43:04 +01:00
Olivier Cavadenti
75ece731b2
Fix Union all + first syntax error (#4799) 2021-11-03 22:18:27 +01:00
Will Heslam
b7d9a5d927
Fix overzealous warning on use of whereNot with "in" or "between" (#4780) 2021-10-31 19:54:37 +01:00
Olivier Cavadenti
b97d49b184
Support whereLike and whereILike (#4779) 2021-10-31 19:52:22 +01:00
Olivier Cavadenti
a431485aa6
Zero precision in timestamp/datetime #4784 (#4786) 2021-10-30 23:28:21 +02:00
Olivier Cavadenti
d31dc646c5
Support fromRaw (#4781) 2021-10-30 00:40:57 +03:00
Marceli Wac
22280c23f4
Refactor Migrator code and API to return list of migrations as objects consistently. (#4745) 2021-10-28 00:42:36 +03: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
Ivan Zhuravlev
6840d3f75b
feat(cockroachdb): add support upsert (#4767)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-10-24 16:27:08 +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
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
Igor Savin
bfdece3cdc
Process passed Oracle connection (#4757) 2021-10-20 23:35:51 +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
502ce49fa9
CockroachDB does not support query cancellation yet (#4726) 2021-10-11 19:36:50 +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
Olivier Cavadenti
126b84639e
Support for 'is null' in 'order by' (#3667) (#4720) 2021-10-10 22:45:48 +03:00
Igor Savin
d45a8c8607
Implement basic query cancellation for CockroachDB (#4723) 2021-10-10 20:15:47 +03:00
Igor Savin
e6d5873cec
Fix migration locking for cockroachdb (#4717) 2021-10-10 02:07:56 +03:00
Igor Savin
07c30bfcb8
Implement truncate method for CockroachDB, refactor and fix some tests (#4714) 2021-10-10 01:33:20 +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
Stig-Erland Hansen
a54857ec3c
Avoid inserting multiple locks if a lock already exists (#4694) 2021-09-29 16:57:34 +03:00
Aiden Foxx
c778c82f2f
Added setNullable support to SQLite (#4684) 2021-09-19 18:14:06 +03:00