Merge pull request 'fix(dump): pass --column-statistics=0 for MySQL 8 mysqldump on MariaDB, release as 0.0.7' (!17 ) from fix/0.0.7-column-statistics into main

Reviewed-on: #17
ci(phpunit): install core patches that have no shopware/production tag
2026-11-02 22:39:41 +00:00 · 2026-11-02 23:33:58 +01:00 · 2026-11-02 23:29:05 +01:00
10 changed files with 86 additions and 78 deletions
@@ -110,6 +110,7 @@ jobs:
          test -n "$VERSION" || { echo "::error::could not resolve a Shopware version for ${CONSTRAINT}"; exit 1; }
          echo "Shopware ${VERSION} (constraint ${CONSTRAINT})"
          echo "version=${VERSION}" >> "$GITHUB_OUTPUT"
+          echo "constraint=${CONSTRAINT}" >> "$GITHUB_OUTPUT"
      # Project (vendor/, phpunit, config) and the installed database as a SQL dump. Neither depends on the plugin.
      - name: Restore Shopware project and database
        id: shopware
@@ -125,8 +126,13 @@ jobs:
        if: steps.shopware.outputs.cache-hit != 'true'
        run: |
          set -e
-          composer create-project "shopware/production:${{ steps.sw.outputs.version }}" shopware --no-interaction --no-scripts
-          composer require --dev phpunit/phpunit:^10 --no-interaction --no-scripts -d shopware
+          # shopware/production pins one exact core version and is not tagged for every core patch
+          # (e.g. core 6.6.10.31, template only up to 6.6.10.30): take the newest template inside the
+          # constraint, then require the resolved core version on top of it.
+          composer create-project "shopware/production:${{ steps.sw.outputs.constraint }}" shopware --no-interaction --no-scripts --no-install
+          composer require "shopware/core:${{ steps.sw.outputs.version }}" --no-update -d shopware
+          composer require --dev phpunit/phpunit:^10 --no-update -d shopware
+          composer update -W --no-interaction --no-scripts -d shopware
      - name: Ensure the MariaDB client
        run: |
          command -v mariadb-dump >/dev/null || command -v mysqldump >/dev/null && exit 0
@@ -14,7 +14,7 @@ composer.phar

 # Frontend
 *.vite/
-**/public/administration/assets/
+**/public/administration/js/
 **/public/static/js/

 # Environment
@@ -7,23 +7,12 @@ and this project adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0

 ## [Unreleased]

-## [0.1.0] - 2026-11-02
-
-### Changed
-
- Requires Shopware 6.7 (`shopware/core ~6.7.0`); 6.6 stays on the 0.0.x line.
- Administration: the list page is registered lazily, uses Meteor components (`mt-button`, `mt-banner`, `mt-progress-bar`) and stops polling on `beforeUnmount` (Vue 3).
+## [0.0.7] - 2026-11-02

 ### Fixed

- The admin build failed on a combined `import type` statement, so the Settings card never appeared.
- Delete did nothing and the create progress modal never showed: both modals sat outside `sw-page`'s named slots, which Vue 3 drops. They now live in `#content`.
 - Creating a dump failed on MariaDB when only MySQL 8's `mysqldump` was installed (`Unknown table 'COLUMN_STATISTICS'`); it now passes `--column-statistics=0` in that case.

-### Removed
-
- The Settings sidebar navigation entry; the plugin is reached through its card in Settings → System, like core settings modules.
-
 ## [0.0.6] - 2026-10-04

 ### Changed
@@ -67,7 +67,7 @@ vendor/bin/phpunit tests/SomeTest.php            # single file

 ## Dependencies

- PHP `^8.2`, `shopware/core` `~6.7.0` (from `composer.json`); `phpunit/phpunit` `^10.0` as the only
+- PHP `^8.2`, `shopware/core` `~6.6.0` (from `composer.json`); `phpunit/phpunit` `^10.0` as the only
  dev dependency.
 - PSR-4 autoload: `AeonDumpManager\` → `src/`, `AeonDumpManager\Tests\` → `tests/`.

@@ -3,7 +3,7 @@
    "description": "Export database dumps for Shopware 6 environments.",
    "type": "shopware-platform-plugin",
    "license": "MIT",
-    "version": "0.1.0",
+    "version": "0.0.7",
    "keywords": [
        "shopware",
        "shopware6",
@@ -26,7 +26,7 @@
    },
    "require": {
        "php": "^8.2",
-        "shopware/core": "~6.7.0"
+        "shopware/core": "~6.6.0"
    },
    "require-dev": {
        "phpunit/phpunit": "^10.0"
@@ -1,6 +1,6 @@
 services:
  shopware:
-    image: dockware/shopware:6.7.14.2
+    image: dockware/shopware:6.6.10.12
    container_name: shopware
    ports:
      - "80:80"       # Shop / Admin / Adminer / Mailcatcher (all served via path on this port)
@@ -13,5 +13,5 @@ check() { # <label> <entry-glob-prefix> <expected path in zip>
  fi
 }

-check admin src/Resources/app/administration/src "Resources/public/administration/assets/"
+check admin src/Resources/app/administration/src "Resources/public/administration/js/"
 check storefront src/Resources/app/storefront/src "Resources/app/storefront/dist/"
@@ -1,10 +1,8 @@
 import './acl';
+import './page/aeon-dump-manager-list';
 import deDE from './snippet/de-DE.json';
 import enGB from './snippet/en-GB.json';

-// Lazy (async) registration, as core does: the page chunk loads on first visit.
-Shopware.Component.register('aeon-dump-manager-list', () => import('./page/aeon-dump-manager-list'));
-
 Shopware.Module.register('aeon-dump-manager', {
    type: 'plugin',
    name: 'DumpManager',
@@ -29,10 +27,27 @@ Shopware.Module.register('aeon-dump-manager', {
        },
    },

-    settingsItem: [{
-        group: 'plugins',
+    // Per https://developer.shopware.com/docs/v6.6/guides/plugins/plugins/administration/routing-navigation/add-menu-entry.html —
+    // plugins can't register a first-level main-menu entry, so this nests
+    // under the core 'sw-settings' navigation node. Clicking Settings in the
+    // main sidebar shows this as a sub-item, landing at #/sw/settings/.
+    navigation: [{
+        id: 'aeon-dump-manager-list',
+        label: 'aeon-dump-manager.general.mainMenuItemGeneral',
+        color: '#ff3d58',
+        path: 'aeon.dump.manager.list',
+        icon: 'regular-database',
+        parent: 'sw-settings',
+        position: 100,
+        privilege: 'aeon_dump_manager.viewer',
+    }],
+
+    // Also shown as a card on the Settings overview page's "System" group,
+    // next to Plugins/Cache — complements the navigation entry above.
+    settingsItem: {
+        group: 'system',
        to: 'aeon.dump.manager.list',
        icon: 'regular-database',
        privilege: 'aeon_dump_manager.viewer',
-    }],
+    },
 });
@@ -1,7 +1,7 @@
 {% block aeon_dump_manager_list %}
 <sw-page class="aeon-dump-manager-list">
    <template #smart-bar-actions>
-        <mt-button
+        <sw-button
            v-if="acl.can('aeon_dump_manager.creator')"
            variant="primary"
            :is-loading="pendingJob !== null"
@@ -9,7 +9,7 @@
            @click="onCreate"
        >
            {{ $tc('aeon-dump-manager.list.buttonCreate') }}
-        </mt-button>
+        </sw-button>
    </template>

    <template #content>
@@ -75,51 +75,50 @@
                </template>
            </sw-data-grid>
        </div>
-
-        <!-- sw-page has no default slot (Vue 3 drops unslotted content): modals must live in #content. -->
-        {% block aeon_dump_manager_list_progress_modal %}
-        <sw-modal
-            v-if="pendingJob !== null"
-            :title="$tc('aeon-dump-manager.list.progressTitle')"
-            variant="small"
-            class="aeon-dump-manager-list__progress-modal"
-            @modal-close="onCloseProgressModal"
-        >
-            <div class="aeon-dump-manager-list__progress-wrapper">
-                <template v-if="pendingJob.status === 'done'">
-                    <mt-banner variant="positive">
-                        {{ $tc('aeon-dump-manager.list.createSuccess') }}
-                    </mt-banner>
-                </template>
-                <template v-else-if="pendingJob.status === 'failed'">
-                    <mt-banner variant="critical">
-                        {{ $tc('aeon-dump-manager.list.createFailed', 0, { error: pendingJob.errorMessage || '' }) }}
-                    </mt-banner>
-                </template>
-                <template v-else>
-                    <mt-progress-bar
-                        :model-value="pendingJob.percent || 0"
-                        :max-value="100"
-                    />
-                    <span class="aeon-dump-manager-list__progress-text">
-                        {{ $tc('aeon-dump-manager.list.progressText') }}
-                    </span>
-                </template>
-            </div>
-        </sw-modal>
-        {% endblock %}
-
-        <sw-confirm-modal
-            v-if="deleteFilenames !== null"
-            :title="$tc('aeon-dump-manager.list.confirmDeleteTitle')"
-            :text="deleteFilenames.length > 1
-                ? $tc('aeon-dump-manager.list.confirmDeleteTextMultiple', 0, { count: deleteFilenames.length })
-                : $tc('aeon-dump-manager.list.confirmDeleteText', 0, { filename: deleteFilenames[0] })"
-            type="delete"
-            @confirm="onConfirmDelete"
-            @cancel="onCancelDelete"
-            @close="onCancelDelete"
-        />
    </template>
+
+    {% block aeon_dump_manager_list_progress_modal %}
+    <sw-modal
+        v-if="pendingJob !== null"
+        :title="$tc('aeon-dump-manager.list.progressTitle')"
+        variant="small"
+        class="aeon-dump-manager-list__progress-modal"
+        @modal-close="onCloseProgressModal"
+    >
+        <div class="aeon-dump-manager-list__progress-wrapper">
+            <template v-if="pendingJob.status === 'done'">
+                <sw-alert variant="success">
+                    {{ $tc('aeon-dump-manager.list.createSuccess') }}
+                </sw-alert>
+            </template>
+            <template v-else-if="pendingJob.status === 'failed'">
+                <sw-alert variant="error">
+                    {{ $tc('aeon-dump-manager.list.createFailed', 0, { error: pendingJob.errorMessage || '' }) }}
+                </sw-alert>
+            </template>
+            <template v-else>
+                <sw-progress-bar
+                    :value="pendingJob.percent || 0"
+                    :max-value="100"
+                />
+                <span class="aeon-dump-manager-list__progress-text">
+                    {{ $tc('aeon-dump-manager.list.progressText') }}
+                </span>
+            </template>
+        </div>
+    </sw-modal>
+    {% endblock %}
+
+    <sw-confirm-modal
+        v-if="deleteFilenames !== null"
+        :title="$tc('aeon-dump-manager.list.confirmDeleteTitle')"
+        :text="deleteFilenames.length > 1
+            ? $tc('aeon-dump-manager.list.confirmDeleteTextMultiple', 0, { count: deleteFilenames.length })
+            : $tc('aeon-dump-manager.list.confirmDeleteText', 0, { filename: deleteFilenames[0] })"
+        type="delete"
+        @confirm="onConfirmDelete"
+        @cancel="onCancelDelete"
+        @close="onCancelDelete"
+    />
 </sw-page>
 {% endblock %}
@@ -1,8 +1,7 @@
 import template from './aeon-dump-manager-list.html.twig';
-import type DumpApiService from '../../../../service/dump-api.service';
-import type { DumpFile, DumpJob } from '../../../../service/dump-api.service';
+import type DumpApiService, { DumpFile, DumpJob } from '../../../../service/dump-api.service';

-const { Mixin } = Shopware;
+const { Component, Mixin } = Shopware;

 interface PendingJob {
    status: string;
@@ -46,7 +45,7 @@ interface ComponentInstance extends ComponentData {
    listFilters: Record<string, unknown>[];
 }

-export default Shopware.Component.wrapComponentConfig({
+Component.register('aeon-dump-manager-list', {
    template,

    mixins: [
@@ -148,7 +147,7 @@ export default Shopware.Component.wrapComponentConfig({
        },
    },

-    beforeUnmount(this: ComponentInstance) {
+    beforeDestroy(this: ComponentInstance) {
        this.stopPolling();
    },
Author	SHA1	Message	Date
haylan	00d959e661	Merge pull request 'fix(dump): pass --column-statistics=0 for MySQL 8 mysqldump on MariaDB, release as 0.0.7' (!17 ) from fix/0.0.7-column-statistics into main release / release (push) Successful in 1m8s Details Reviewed-on: #17	2026-11-02 22:39:41 +00:00
haylanandClaude Bot	fa50fa3343	ci(phpunit): install core patches that have no shopware/production tag plugin-checks / version-changelog (pull_request) Successful in 19s Details plugin-checks / package (pull_request) Successful in 1m3s Details plugin-checks / phpunit (pull_request) Successful in 5m35s Details The newest shopware/core in ~6.6.0 is 6.6.10.31, but shopware/production is only tagged up to 6.6.10.30, so create-project failed. Install the newest template inside the constraint and require the resolved core version on top. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-11-02 23:33:58 +01:00
haylanandClaude Bot	6b7ba3bc47	fix(dump): pass --column-statistics=0 for MySQL 8 mysqldump on MariaDB, release as 0.0.7 plugin-checks / version-changelog (pull_request) Successful in 20s Details plugin-checks / phpunit (pull_request) Failing after 37s Details plugin-checks / package (pull_request) Successful in 1m27s Details Backport for the Shopware 6.6 line. When the server is MariaDB but only MySQL 8's mysqldump is installed (e.g. dockware/web), the dump aborted with "Unknown table 'COLUMN_STATISTICS' in information_schema (1109)". Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-11-02 23:29:05 +01:00