--merge option deletes all remote items in synced collection during import

cyprian-nziim commented 1 week ago

Describe the Bug

I was able to create a CICD flow to update my local schema an data to my remote instance when I push to my repo, however each time I modify the local data in a specific collection, all data in my remote instance is reset to my local instance data state deleting all the other items in the collection in my remote instance.

To Reproduce

I have a local directus instance (Installed Via NPM) and PostgreSQL. I do all my local work with this instance when I want to deploy I have the following file in my repo.

My Dockerfile

FROM directus/directus:11.2.1

USER root
RUN corepack enable

// Workaround to be able to install extensions with 'node' user, only required in v11.1.1
RUN rm node_modules/.modules.yaml

RUN pnpm install directus-extension-schema-sync@3.0.2

WORKDIR /directus

COPY ./schema-sync ./schema-sync

My docker-compose file

version: "8"
services:
  directus-app:
    build:
      context: .
      dockerfile: ./Dockerfile
    image: directus-app:1.0.6
    volumes:
      - ./schema-sync:/directus/schema-sync
      - ./extensions:/directus/extensions
    command: >
      sh -c "
        npx directus schema-sync import --merge
      "

Directus Version

v11.2.1

Hosting Strategy

Self-Hosted (Docker Image)

Database

PostgreSQL

Export local DB with "npx directus schema-sync export"
Perform an initial Commit and Push to repo
CICD builds the image and pushes to server, on startup runs "npx directus schema-sync import --merge" app is deployed all is good
Add a new item in remote instance to a collection you have marked for sync in "directus-app/schema-sync/directus_config.js"
Update or Add an Item in any collection via the directus interphase on the local instance, make sure its in a collection you have marked for sync in "directus-app/schema-sync/directus_config.js"
Run "npx directus schema-sync export" on local instance to sync changes
Commit and push to repo
CICD builds the image and pushes to server, on startup runs "npx directus schema-sync import --merge" this deletes all items in collection in remote instance and resets collection to local state

Version

3.0.2

Installed Extension Via

Docker file

u12206050 commented 1 week ago

This is as intended. If you wish to exclude certain items from being synced(ie. Created, updated or deleted) then you need to update the filter in the query for that collection in the schema sync config.

cyprian-nziim commented 1 week ago

Hello @u12206050 , In this case, wouldn't you agree that the "--merge" option may not hold any significance?

bcc-code / directus-schema-sync