updateCustomerFacetAndSorting example

use Shopware\Components\Migrations\AbstractMigration;

class Migrations_Migration939 extends AbstractMigration
{
    /** * {@inheritdoc} */
    public function up($modus)
    {
        $this->updateTranslation();
        $this->updateCustomerFacetAndSorting();
    }

    private function updateTranslation(): void
    {
        $shops = $this->connection->query('SELECT id FROM s_core_shops')->fetchAll(PDO::FETCH_ASSOC);

        foreach ($shops as $shop) {
            $translation = $this->getExistingSortingTranslations((int) $shop['id']);

            if (!empty($translation)) {
                $id = $translation['id'];