3132 Commits

Author SHA1 Message Date
Rijk van Zanten
034341c5b1 v11.0.1 2024-08-08 13:10:25 -04:00
José Varela
4548893c4d API / Migrations: Fix drop foreign key if have a different name (#23253)
* Fix drop foreign key if have a different name

* Improve memory usage
Variables are only defined within try block

* Add changeset

* Target "role" column
Since users can create custom fields in directus tables and since someone may have tried to create another field to directus_roles, let's specify which column

* Fix formatting

---------

Co-authored-by: Rijk van Zanten <rijkvanzanten@me.com>
2024-08-08 12:52:21 -04:00
Jogchum Koerts
c0df1aa65c Retry transaction also for SQLITE_BUSY (#23243)
Co-authored-by: Pascal Jufer <pascal-jufer@bluewin.ch>
Co-authored-by: Hannes Küttner <kuettner.hannes@gmail.com>
2024-08-08 13:49:30 +02:00
Hannes Küttner
bb1b15a906 Ignore missing foreign key constraint in policies migration (#23251)
* Gracefully handle missing role foreign key constraint in directus_permissions

* Add changeset

* Update changeset
2024-08-08 18:16:01 +08:00
Florian Strasser
338625f894 Add unix socket support (#23150)
* Update server.ts | Issue 23142

Fix Problem on server.ts to only accept integer Values as port. Some hosters require the port to be a string forwarding to a specific file as socket.

* Update contributors.yml

* Update server.ts

* Update server.ts

* Add changset

* Resolve formatting error

* move unix socket to separate variable

* add docs

* update changeset

* do not add protocol to address

* add correct casing for `Unix`

* do not add protocol prefix if listening on socket

* add missing package bumps to changes

* Update server.ts

Changed listenOptions initialization

* formatting

* remove port override note

* update doc wording to be inline with host and add ignore

* add tests

---------

Co-authored-by: Rijk van Zanten <rijkvanzanten@me.com>
Co-authored-by: daedalus <44623501+ComfortablyCoding@users.noreply.github.com>
2024-08-07 15:58:04 -04:00
Pascal Jufer
7dc49e5e44 Adjust the provisioned DB_CLIENT value in init CLI command for mysql2 (#23232)
Co-authored-by: Hannes Küttner <kuettner.hannes@gmail.com>
2024-08-07 16:20:04 +02:00
Pascal Jufer
980f8d0274 Fix the "add-system-fk-triggers" migration for mysql2 (#23233) 2024-08-07 16:19:05 +02:00
Pascal Jufer
15eebdb875 Adjust the init CLI command for new mysql2 package (#23231)
* Adjust driver used for MySQL

* Add changeset
2024-08-07 09:21:19 -04:00
dependabot[bot]
ae9c4f1979 Bump zod-validation-error from 3.3.0 to 3.3.1 (#23221)
Bumps [zod-validation-error](https://github.com/causaly/zod-validation-error) from 3.3.0 to 3.3.1.
- [Release notes](https://github.com/causaly/zod-validation-error/releases)
- [Changelog](https://github.com/causaly/zod-validation-error/blob/main/CHANGELOG.md)
- [Commits](https://github.com/causaly/zod-validation-error/compare/v3.3.0...v3.3.1)

---
updated-dependencies:
- dependency-name: zod-validation-error
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-08-07 07:10:58 +02:00
Rijk van Zanten
aa425a19da v11.0.0 2024-08-06 15:50:40 -04:00
Rijk van Zanten
002a7848c6 Merge branch 'main' into v11-rc 2024-08-06 14:43:52 -04:00
Rijk van Zanten
e5ba369c24 v10.13.2 2024-08-06 14:26:11 -04:00
Rijk van Zanten
57b6dba79f Merge branch 'main' into v11-rc 2024-08-06 14:19:35 -04:00
Hannes Küttner
5f89c07c3f Fix groupBy behavior with relational permissions (#23185)
* Start on a fix for group by

* Don't rely on knex.raw

* "Fix" typing issue

* Move preprocessing to group logic only

* Add changeset
2024-08-06 14:04:11 -04:00
Hannes Küttner
f50e74d802 Rename permissions policy migration to be the most recent version (#23214) 2024-08-06 14:03:54 -04:00
Hannes Küttner
0ac9a5d190 Fix related field permissions (#23199)
Co-authored-by: Pascal Jufer <pascal-jufer@bluewin.ch>
2024-08-06 18:56:19 +02:00
Rijk van Zanten
5d55f3c067 Fix user count (#23184)
Co-authored-by: Hannes Küttner <kuettner.hannes@gmail.com>
Co-authored-by: ian <licitdev@gmail.com>
2024-08-06 18:15:18 +02:00
Hannes Küttner
725dc3ce5b Fix M2A query regression from #23181 (#23195) 2024-08-06 08:05:12 -04:00
Hannes Küttner
e3e33a8299 Fix sorting of aggregated result (#23193)
Co-authored-by: Pascal Jufer <pascal-jufer@bluewin.ch>
2024-08-06 13:47:25 +02:00
Rijk van Zanten
ce6d04708e Fix server error on root m2a query (#23181) 2024-08-06 11:27:31 +02:00
Matthew Rumery
175f654e0c Update filename_disk extension when mimetype changes on overwrite (#23127)
* fix: update filename_disk extension when mimetype changes on overwrite

* updated changeset

---------

Co-authored-by: Jan Arends <jan.arends@mailbox.org>
2024-08-06 11:26:08 +02:00
Jan Arends
1c6481af38 Explicit headings in CSV export (#23140)
* explicit fields for csv parser

* parsed fields and extracted resolved field names

* do not expand o2m relational nodes

* support for m2a relational type

* finalization

* renamed test

* some more comments

* tiny tweaks

* changeset
2024-08-06 10:30:15 +02:00
dependabot[bot]
cba149e16e Bump @types/node from 18.19.42 to 18.19.43 (#23186)
Bumps [@types/node](https://github.com/DefinitelyTyped/DefinitelyTyped/tree/HEAD/types/node) from 18.19.42 to 18.19.43.
- [Release notes](https://github.com/DefinitelyTyped/DefinitelyTyped/releases)
- [Commits](https://github.com/DefinitelyTyped/DefinitelyTyped/commits/HEAD/types/node)

---
updated-dependencies:
- dependency-name: "@types/node"
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-08-06 09:47:21 +02:00
Rijk van Zanten
9faac0164e Merge branch 'main' into v11-rc 2024-08-05 16:21:55 -04:00
dependabot[bot]
3db63e3c30 Bump axios from 1.7.2 to 1.7.3 (#23171)
Bumps [axios](https://github.com/axios/axios) from 1.7.2 to 1.7.3.
- [Release notes](https://github.com/axios/axios/releases)
- [Changelog](https://github.com/axios/axios/blob/v1.x/CHANGELOG.md)
- [Commits](https://github.com/axios/axios/compare/v1.7.2...v1.7.3)

---
updated-dependencies:
- dependency-name: axios
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-08-05 19:48:00 +02:00
ian
c6c6b6895a Bypass dynamic variable processing when migrating down (#23178) 2024-08-05 16:48:53 +02:00
daedalus
b941b8b6cd Fix down migration for v11 erroring on permissions (#23097)
* do not error on v11 down migration

* account for public role additions

* ensure json fields are correctly stored

* add changeset

* Update api/src/database/migrations/20240710A-permissions-policies.ts

Co-authored-by: Hannes Küttner <kuettner.hannes@gmail.com>

* Update api/src/database/migrations/20240710A-permissions-policies.ts

Co-authored-by: Hannes Küttner <kuettner.hannes@gmail.com>

* fix currentprem property access

* prefer lodash `uniq` over set

Co-Authored-By: Hannes Küttner <4376726+hanneskuettner@users.noreply.github.com>

* Update api/src/database/migrations/20240710A-permissions-policies.ts

Co-authored-by: Hannes Küttner <kuettner.hannes@gmail.com>

* Skip merging system permissions

* Fix casting of permissions to string

* Order imports

---------

Co-authored-by: Hannes Küttner <kuettner.hannes@gmail.com>
Co-authored-by: Hannes Küttner <4376726+hanneskuettner@users.noreply.github.com>
Co-authored-by: ian <licitdev@gmail.com>
2024-08-05 21:41:19 +08:00
ian
3ef539d2d2 Add null filtering to equality operators (#23163)
* Add null filtering to equality operators

* Add changeset
2024-08-04 12:43:07 -04:00
ian
2e893f9c57 Merge commit from fork
* Redact `access_token` in the query string when `LOG_STYLE=raw`

* Add changeset

---------

Co-authored-by: Rijk van Zanten <rijkvanzanten@me.com>
2024-08-02 14:05:18 -04:00
dependabot[bot]
5d55382472 Bump tsx from 4.12.0 to 4.16.5 (#23153)
Bumps [tsx](https://github.com/privatenumber/tsx) from 4.12.0 to 4.16.5.
- [Release notes](https://github.com/privatenumber/tsx/releases)
- [Changelog](https://github.com/privatenumber/tsx/blob/master/release.config.cjs)
- [Commits](https://github.com/privatenumber/tsx/compare/v4.12.0...v4.16.5)

---
updated-dependencies:
- dependency-name: tsx
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-08-02 14:27:57 +02:00
dependabot[bot]
fbc2ffdea3 Bump @types/node from 18.19.33 to 18.19.42 (#23121)
Bumps [@types/node](https://github.com/DefinitelyTyped/DefinitelyTyped/tree/HEAD/types/node) from 18.19.33 to 18.19.42.
- [Release notes](https://github.com/DefinitelyTyped/DefinitelyTyped/releases)
- [Commits](https://github.com/DefinitelyTyped/DefinitelyTyped/commits/HEAD/types/node)

---
updated-dependencies:
- dependency-name: "@types/node"
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-08-01 17:05:40 +02:00
José Varela
c4a2f18381 API: Only prevent infinite loop if the schema is not cached (#23141)
* Only prevent loop if the schema is not cached

* Add changeset
2024-07-31 15:22:22 -04:00
Gerard Lamusse
f2930e6ebd Cache column info (#19480)
* Cache column info

* checked if cache is enabled

* formatting

* temp activation of bb tests

* deactivated bb tests again

* used schema cache configuration

* changeset

* changeset wording

* switched to schema cache

---------

Co-authored-by: Jan Arends <jan.arends@mailbox.org>
2024-07-26 12:20:06 +02:00
Gerard Lamusse
bb382c89cb Cache foreign keys (#19391)
* Cache foreign keys

* Formatting

* take cache settings into account

* tmp activation of bb tests

* formatting fix

* used more specific cache configuration

* deactivated bb tests again

* changeset

* changeset wording

* used schema cache instead of system cache

* use local schema cache

---------

Co-authored-by: Brainslug <br41nslug@users.noreply.github.com>
Co-authored-by: Jan Arends <jan.arends@mailbox.org>
2024-07-26 12:14:08 +02:00
dependabot[bot]
bc4fd56861 Bump tar from 7.4.0 to 7.4.2 (#23112)
Bumps [tar](https://github.com/isaacs/node-tar) from 7.4.0 to 7.4.2.
- [Release notes](https://github.com/isaacs/node-tar/releases)
- [Changelog](https://github.com/isaacs/node-tar/blob/main/CHANGELOG.md)
- [Commits](https://github.com/isaacs/node-tar/compare/v7.4.0...v7.4.2)

---
updated-dependencies:
- dependency-name: tar
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-07-26 09:54:12 +02:00
ian
3f26839906 Simplify schema caching (#23098)
* Simplify schema caching

* Add changeset

* Temporarily enable blackbox tests

* Revert "Temporarily enable blackbox tests"

This reverts commit 9cbdaebec4.

---------

Co-authored-by: daedalus <44623501+ComfortablyCoding@users.noreply.github.com>
2024-07-25 09:05:36 -04:00
Pascal Jufer
156bfcb524 Fix "Update Files Date Fields" migration for MySQL (#23094)
* Fix "Update Files Date Fields" migration for MySQL

* Remove unnecessary await
2024-07-24 10:43:44 -04:00
Pascal Jufer
6a59bf2c95 Fix query trace logger for failing queries (#23095)
* Fix query logger for failing queries

* Further optimization

- Use map instead of object for times
- Handle case when time is not available
- Print empty brackets instead of '[undefined]' when no bindings

* Add changeset
2024-07-24 10:42:32 -04:00
Hannes Küttner
9cb927f5c7 Transmit Directus-File-Id when creating TUS upload (#23086) 2024-07-24 15:46:03 +02:00
Pascal Jufer
141b8adbf4 Simplify date generation for uploaded_on files field (#23093)
* Simplify logic for `uploaded_on` files field

* Update & simplify test
2024-07-24 09:08:37 -04:00
dependabot[bot]
632a00feb2 Bump qs from 6.12.2 to 6.12.3 (#23088)
Bumps [qs](https://github.com/ljharb/qs) from 6.12.2 to 6.12.3.
- [Changelog](https://github.com/ljharb/qs/blob/main/CHANGELOG.md)
- [Commits](https://github.com/ljharb/qs/compare/v6.12.2...v6.12.3)

---
updated-dependencies:
- dependency-name: qs
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-07-24 08:50:08 +00:00
dependabot[bot]
5a0f488432 Bump openapi3-ts from 4.3.2 to 4.3.3 (#23090)
Bumps [openapi3-ts](https://github.com/metadevpro/openapi3-ts) from 4.3.2 to 4.3.3.
- [Release notes](https://github.com/metadevpro/openapi3-ts/releases)
- [Changelog](https://github.com/metadevpro/openapi3-ts/blob/master/Changelog.md)
- [Commits](https://github.com/metadevpro/openapi3-ts/commits)

---
updated-dependencies:
- dependency-name: openapi3-ts
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-07-24 10:41:43 +02:00
Pascal Jufer
a9cca2cea6 Introduce created_on date field for files and adjust uploaded_on to be updated with every upload (#23035)
* Update date fields on directus_files

* Add changeset

* Use knex update instead of raw

---------

Co-authored-by: Rijk van Zanten <rijkvanzanten@me.com>
2024-07-23 13:00:25 -04:00
Rijk van Zanten
0f92bdc576 Don't prevent uploads on failure to extract file metadata (#23075) 2024-07-22 16:00:42 -04:00
insomnia.exe
3a69bb7d02 Apply consistent Sharp library configuration (#23064)
* Apply consistent Sharp library configuration (#20995)

* rename useSharp to getSharpInstance

* Update changeset

* Update export style

---------

Co-authored-by: Pascal Jufer <pascal-jufer@bluewin.ch>
Co-authored-by: Rijk van Zanten <rijkvanzanten@me.com>
2024-07-22 15:09:03 -04:00
dependabot[bot]
91e4d60cb1 Bump @types/ws from 8.5.10 to 8.5.11 (#23069)
Bumps [@types/ws](https://github.com/DefinitelyTyped/DefinitelyTyped/tree/HEAD/types/ws) from 8.5.10 to 8.5.11.
- [Release notes](https://github.com/DefinitelyTyped/DefinitelyTyped/releases)
- [Commits](https://github.com/DefinitelyTyped/DefinitelyTyped/commits/HEAD/types/ws)

---
updated-dependencies:
- dependency-name: "@types/ws"
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-07-22 10:31:08 +02:00
dependabot[bot]
82f061558f Bump minimatch from 9.0.4 to 9.0.5 (#23059)
Bumps [minimatch](https://github.com/isaacs/minimatch) from 9.0.4 to 9.0.5.
- [Changelog](https://github.com/isaacs/minimatch/blob/main/changelog.md)
- [Commits](https://github.com/isaacs/minimatch/compare/v9.0.4...v9.0.5)

---
updated-dependencies:
- dependency-name: minimatch
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-07-19 09:59:31 +02:00
José Varela
c816c50e75 Api: Emit filter for email.send (#23024)
Co-authored-by: Pascal Jufer <pascal-jufer@bluewin.ch>
2024-07-16 16:02:12 +02:00
Pascal Jufer
5203ca47cb Update logger import in error-handler test (#23030) 2024-07-16 09:17:39 -04:00
Hannes Küttner
ad0e2c6c1c Fix aggregate[count]=* permission checking (#23022) 2024-07-16 12:08:27 +02:00