* Expose schema endpoints
* respond with 204
* fix payload for export flag
* allow export as YAML
* use SchemaService
* move getStringFromStream to utils
* clearer exceptions with logs
* check empty request body
* specs
* add bypassCache flag and remove flushCaches calls
* Identify integer typed fields in Oracle
* Fix uuid foreign keys type for Oracle
* Detect autoincrement for CockroachDB
* Bypass cache for fields and relations services
* Add same DB tests
* Test if working for all vendors
* Add schema snapshot testing into sequential flow
* Fix schema re-apply attempts when it's a different database vendor (#14816)
* prevent diffing on certain properties
* fix apply-snapshot test
* prevent updates to autoincrement fields' schema
* sanitize relations
* remove `colleciton.schema.sql` parsing in test
It is now being sanitized by `sanitizeCollection()` function in get-snapshot-diff.ts
* Change concurrency group to not cancel test running on main
* remove multipart for apply & add hash checking
* check incoming version & add force query param
* refine error message & stub for nested hash
* add `vendor` top-level property
as an additional safety net for cross db vendor applies
* sanitize generated schema snapshots
* snapshot joi validation
* diff joi validation
* minor cleanup
* extract applyDiff & use deep-diff applyChange
* use applyDiff in schema service
* Mark vendor as optional
* Update tests to apply diffs
* move force flag check into service
* Patch mssql vendor typo
* Set relation no action in cyclic relations
* Update mysql timestamp default value
* Oracle cannot define no action
* Update oracle timestamp type default values
* add hash checking for outdated diffs
* fix diff service & endpoint
* Add hashes when returning after
* Fix self referencing relations for Oracle
* Add temp fix for CURRENT_TIMESTAMP defaults in Oracle
* clean up driver and database client types
* only require diff hash if not kind N
* update hash comparison logic for create/delete
* Set no action constraint for self referencing M2M in MSSQL
* Add basic hash check tests
* omit default value when hashing auto increments
Specifically for CockroachDB with differing sequences
* add vendor check
* update specs
* Validate vendors with type definition
* Spread the vendors input array
* re-add Export component
* re-add js-yaml to root
* Propagate mutation options for schema apply
* Verify that snapshots differ and clear cache before hash tests
* Fix unit test
* Revert temp fix for CURRENT_TIMESTAMP defaults in Oracle
* Define and reuse type for export format
* Define and reuse list of database clients
* change `were` to `was`
* change `where` to `were`
* add some empty lines for readability
* tweak exception message
* fix test
* use object-hash
* use boolean to check whether file is included
* simplify request content type check
* throw error when multiple files were uploaded
* use nullish coalesce instead of short circuit
* Update api/src/services/schema.ts
Co-authored-by: Rijk van Zanten <rijkvanzanten@me.com>
* Remove unnecessary `Omit` on `SnapshotWithHash` type
* Revert "Remove unnecessary `Omit` on `SnapshotWithHash` type"
This reverts commit d22ac771ec.
* check empty snapshot earlier
* use allow-list logic via pick instead of omit
* Update api/src/services/schema.ts
Co-authored-by: Pascal Jufer <pascal-jufer@bluewin.ch>
* Move to own /schema endpoint controller
* Fix refs to schema endpoint
* move streamToString to utils package
* move get-versioned-hash and add test
* extract kind into an enum
* Fix mysql5 timestamp value
* Fix test collection existing on rerun
* resolve TODO comment in blackbox test
* Drop deep level hashes in diff
These hashes are used only for more accurate error reporting
but are otherwise superfluous, since changes are already
detected by the top level hash.
Therefore we remove them in favor of a simpler diff format and
implementation.
* Revert schema "fix" for createItem, add comment
* Strict diff schema validation
* Revert CrDB auto-increment detection patch in 816c998
* Clear systemCache to expose newly added fields
* Use DiffKind constants
* Extract diff & snapshot validation into own tested utils
* Apply suggestions from @azrikahar
* Update knex-schema-inspector to 3.0.1
Includes the fix for CrDB auto-increment detection (knex/knex-schema-inspector#135)
* Update knex-schema-inspector in packages
* Update lock file
* add test for schema service
* add test for export service
* add relevant tests to modified util functions
* fix csv test to account for os end of line
* fix files controller test
* dedupe test data for schema service
* Align schema specs with docs
* Update api/src/controllers/schema.ts
* Revert testing for all vendors
---------
Co-authored-by: Rijk van Zanten <rijkvanzanten@me.com>
Co-authored-by: ian <licitdev@gmail.com>
Co-authored-by: Pascal Jufer <pascal-jufer@bluewin.ch>
* Add migration to remove default value from project_color
* Upgrade the default theme
* Do a pass over the header buttons
* Do another pass over --warning uses
* Little things
* Tweak smoke
* Use updated map
* Use dark system elements in dark mode
* Remove outdated files, update toasts
* Use correct delete button style for role
* Use primary for created point
* Tweak spacing in revisions section
* Use primary for sidebar sections
* Various color tweaks and changes
* Update base color palette
* Update "css reset" code
* Remove splashscreens, add default favicon
* Add primary highlight to datamodel page
* dark mode color update
* fix sign out hover color
* Does this help?!
* This fixes some loading issues
Fixes https://github.com/directus/directus/issues/10707
* Calculate default pretty background?
* Fix public view with logo
* Fix responsiveness of login page
* adjust notification group width to be equal
* Do an absolute pointless task that doesn't do anything
It was suggested that it could fix the stylelint error in tests, but alas
* Remove stylelint
Doesn't seem to play nice with script setup and other changes
Co-authored-by: Ben Haynes <ben@rngr.org>
* Refactor action value from authenticate to login in directus_activity
* Fix incorrect where clause in migration
* Add missing authenticate uses
Co-authored-by: rijkvanzanten <rijkvanzanten@me.com>
* Move module bar setup to project settings
* Add system modules interface to dnd configure module bar
* Cleanup order
* Crucially important typo
* Add ability to add custom links
* Show correct initial value marker
* Allow set folder for imported files
* Allow passing folder in file/files component; Allow pick folder for file/files/image interfaces.
* Added folder system component for picking folders; Move folder picker the field from data to interface (file, files, image).
* Add custom folder interface; use props for interfaces file/files/image in upload component
* Allow set folder for imported files
* Allow passing folder in file/files component; Allow pick folder for file/files/image interfaces.
* Added folder system component for picking folders; Move folder picker the field from data to interface (file, files, image).
* Add custom folder interface; use props for interfaces file/files/image in upload component
* Update after rebase
* Add storage_default_folder setting, use folder when deploy file
* Fix files options; Add default label option for folder interface.
* Fix set folder for file
* UX
* Add migration for column, undo seed change
* Update nomanclature
* Make sure file library always submits folder, cleanup setting retrieval
* Use indexName on down migrate
* Fix import default folder, rename customPresets->folderPreset
* Rename interface import
* Use undefined as default folder
* Remove deprecated lang file
* Fix display of folder interface, treat null as value
* Move shared composable
* Remove unused ref
Co-authored-by: rijkvanzanten <rijkvanzanten@me.com>
* Allow custom transformations of assets
This exposes one query parameter `transforms`, which is a JSON array of
shard transformation operations.
It also updates the asset presets. The UX for this still needs some work
* Rename options to arguments for presets
More explicit
* options -> arguments in setting spec
* Better errors for invalid JSON in asset presets
* Add limit to transforms query parameter
* Use flattened option for extra transforms
* Fix placeholder color of code input
* Allow "simple mode" aliases
* Add documentation
Co-authored-by: rijkvanzanten <rijkvanzanten@me.com>
* Unique operationIds for users/me methods
* Fix specs for /users/invite/accept and rename files
* Add missing parameters definition for /utils/sort
* Add .yaml to lint-staged and format cmd
* Format .yaml files
* Fix small linting issue
Co-authored-by: rijkvanzanten <rijkvanzanten@me.com>
* Added icon_color to directus_collections
Added migrations
Added color property to select-icon
Fixed select-icon placeholder
* Use icon color in collection header bar.
* Set `collection` and `note` fields to hald witdh
* Rename icon_color->color
Co-authored-by: rijkvanzanten <rijkvanzanten@me.com>