518 Commits

Author SHA1 Message Date
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
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
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
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
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
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
Olivier Cavadenti
126b84639e
Support for 'is null' in 'order by' (#3667) (#4720) 2021-10-10 22:45:48 +03:00
Igor Savin
07c30bfcb8
Implement truncate method for CockroachDB, refactor and fix some tests (#4714) 2021-10-10 01:33:20 +03:00
Igor Savin
941b660f53
Initial infrastructure for CockroachDB (#4571) 2021-10-02 23:45:17 +03:00
Matt Machuga
01cfa98c2c
Adding support for pg-native (#4327) 2021-09-06 16:04:23 +03:00
Jeremy W. Sherman
a9338208f1
fix(oracledb): withRecursive: omit invalid RECURSIVE keyword, include column list [#4514] (#4652) 2021-09-03 22:27:32 +03:00
wolfcomp
4c79ac1fe6
Fix Analytic orderBy and partitionBy to follow the SQL documentation (#4602) 2021-08-30 20:17:16 +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
Jeremy W. Sherman
40576ce430
fix(mssql): Generate valid SQL for withRecursive() [#4514] (#4639) 2021-08-25 09:36:43 +03:00
Igor Savin
124107e0ec
Fix autoincrement for Oracle with schema (#4594) 2021-07-29 17:07:22 +03:00
zeotuan
45916f97ee
Add deferrable support for constraint (#4584) 2021-07-25 10:23:17 +03:00
zeotuan
55eadcf7ad
Fixing posgres datetime and timestamp column created with wrong format (#4578) 2021-07-21 01:23:20 +03:00
Egor Koldasov
c335fda657
#873 | implement delete with join (#4568) 2021-07-13 09:41:16 +03:00
Nicola Krumschmidt
c1ab23c206
Await asynchronous expect assertions (#4334) 2021-03-03 01:28:42 +02:00
Nicola Krumschmidt
3e6176ac0c
SQLite parser improvements (#4333) 2021-03-03 00:42:43 +02:00
Igor Savin
887a4f606a
Improve join and conflict types v2 (#4318)
Co-authored-by: Jeroen Hermans <jeroen@datacamp.com>
2021-03-02 19:34:04 +02:00
Daniel Hensby
d807832b3b
mssql: schema builder - attempt to drop default constraints when changing default value on columns (#4321) 2021-02-28 19:27:48 +02:00
Daniel Hensby
c0d8c5c247
mssql: schema builder - add predictable constraint names for default values (#4319) 2021-02-28 01:08:15 +02:00
Nicola Krumschmidt
9e28a72aca
Add support for altering columns to SQLite (#4322) 2021-02-26 22:36:46 +02:00
Daniel Hensby
7db2d18877
fix mssql alter column must have its own query (#4317) 2021-02-25 19:34:22 +02:00
Jeremy W. Sherman
3718d647e4
Respect KNEX_TEST, support omitting sqlite3 from DB, and reduce outside mssql test db config (#4313) 2021-02-24 19:27:30 +02:00
Tyler Watson
8c73417de6
events: introduce queryContext on query-error (#4301) 2021-02-18 12:23:12 +02:00
Tolterix
5614c18624
Timestamp UTC Standardization for Migrations (#4245)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-02-15 19:27:41 +02:00
Richard Simko
489934655f
Fix for ES Module detection using npm@7 (#4295) (#4296) 2021-02-15 19:10:45 +02:00
Igor Savin
230845d3c2
Make "first" and "pluck" mutually exclusive (#4280) 2021-02-08 13:45:13 +02:00
Tyler Watson
c860b89184
WIP: Replace MSSQL dialect with Tedious.js implementation (#2857)
Co-authored-by: Tyler Watson <tyler@rapidplatform.com.au>
Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-02-08 08:46:35 +02:00
Nicola Krumschmidt
1ec7a664ea
Recreate indices when altering a table in SQLite (#4277) 2021-02-05 16:35:30 +02:00
Igor Savin
2040bd11a4
Move more logic over from formatter (#4273) 2021-02-03 21:17:20 +02:00