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
Igor Savin
d89c36ae80
Move more code out of formatter ( #4270 )
2021-02-03 01:13:16 +02:00
maximelkin
b9fb5992b5
Migrate to classes ( #4253 )
2021-01-31 12:40:13 +02:00
bittersweet shimmer
629e1d2423
Fix SQLite foreign on delete when altering a table ( #4225 )
2021-01-13 00:07:07 +02:00
Igor Savin
b111771117
Clean up querybuilder ( #4220 )
2021-01-09 17:59:53 +02:00
Igor Savin
a889a09060
Extract even more formatter stuff into client ( #4219 )
2021-01-09 17:40:30 +02:00
Igor Savin
cd6479bf0b
More formatter cleanup ( #4218 )
2021-01-07 23:34:46 +02:00
Igor Savin
0bef361ffd
Reduce amount of parameters needed ( #4217 )
2021-01-07 22:44:03 +02:00
Igor Savin
067a1a0326
Extract more of the formatter logic ( #4214 )
2021-01-07 17:31:56 +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
Igor Savin
936126c0f0
Add analytic functions v2 ( #4188 )
...
Co-authored-by: CorvusCorrax <renaud.cayol@gmail.com>
Co-authored-by: Alexandre Tiertant <alexandre.tiertant@gmail.com>
2020-12-31 14:38:50 +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
Ben Lu
a31f0400e6
Add transaction isolation support ( #4185 )
2020-12-30 18:13:35 +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
Mark Boyd
76c131e2a9
Add support for WHERE clauses to "upsert" queries ( #4148 )
2020-12-09 17:51:29 +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
Nico Burns
8d43019873
Implement "UPSERT" (Postgres/MySQL/Sqlite) ( #3763 )
2020-10-31 17:22:52 +02:00
Bogdan Chadkin
80355e4850
Replace inherits package with builtin utility ( #4059 )
2020-10-05 23:59:12 +03:00
Bogdan Chadkin
6f817a3b6e
Avoid lodash typecheks ( #4056 )
...
* Avoid lodash typecheks
Lodash is quite big project. Even with direct imports it loads [tons](https://github.com/knex/knex/pull/3804 ) of
code and still bloats node_modules. Especially since lodash mostly used
as a polyfill for modern features.
In this diff I attempted to reduce lodash usage by replacing type checks
with `typeof` operator which might be sufficient.
Also replaced lodash/isObject with custom simplified utility which does not
consider functions as objects and allows to simplify code in one place.
2020-10-05 21:29:39 +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
maximelkin
b025aea318
remove dependency on bluebird methods from sources ( #3683 )
...
Co-authored-by: Brian Lauber <constructible.truth@gmail.com>
2020-02-25 22:50:24 +01:00
Lorefnon
589ea747c2
Update QueryCompiler implementation to use classes ( #3647 )
2020-02-01 17:22:00 +01:00
Alexandre BODIN
0214f11663
Make sqlite3 hasColumn case insensitive ( #3435 )
2019-11-14 19:31:59 +01:00
maximelkin
03ecbeef1f
Bluebird remove return, reflect, fromCallback ( #3483 )
2019-10-25 19:59:30 +02: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
maximelkin
f56eaf5cfc
Bluebird remove map mapSeries ( #3474 )
2019-10-11 10:12:56 +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
Sky Morey
7c1120e0e2
in progress
2015-12-08 11:37:31 -06:00
