Version20250926174000::dryRunTemplatesUpsertAndLink()

Complexity

Conditions	11
Paths	18

Size

Total Lines	70
Code Lines	45

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    private function dryRunTemplatesUpsertAndLink(): void
    {
        $grouped = [];
        try {
            $grouped = (array) SettingsValueTemplateFixtures::getTemplatesGrouped();
        } catch (\Throwable $e) {
            error_log('[WARN] Unable to load SettingsValueTemplateFixtures::getTemplatesGrouped(): ' . $e->getMessage());
            return;
        }

        foreach ($grouped as $category => $items) {
            foreach ((array) $items as $setting) {
                $variable    = (string) ($setting['variable'] ?? $setting['name'] ?? '');
                $jsonExample = $setting['json_example'] ?? null;

                if ($variable === '' || !$this->isValidIdentifier($variable)) {
                    error_log(sprintf('[SKIP] Invalid or empty template variable in category "%s".', (string) $category));
                    continue;
                }

                // Serialize JSON example safely (string for SQL param preview)
                try {
                    $jsonEncoded = json_encode($jsonExample, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
                } catch (\Throwable $e) {
                    error_log(sprintf('[WARN] JSON encoding failed for variable "%s": %s', $variable, $e->getMessage()));
                    $jsonEncoded = 'null';
                }

                // Check if template exists
                try {
                    $templateId = $this->connection->fetchOne(
                        'SELECT id FROM settings_value_template WHERE variable = ?',
                        [$variable]
                    );
                } catch (\Throwable $e) {
                    error_log(sprintf('[ERROR] Failed to check template existence for "%s": %s', $variable, $e->getMessage()));
                    continue;
                }

                if ($templateId) {
                    // UPDATE PREVIEW on existing template
                    $sql    = 'UPDATE settings_value_template SET json_example = ?, updated_at = NOW() WHERE id = ?';
                    $params = [$jsonEncoded, $templateId];
                    $this->addSql($sql, $params);
                } else {
                    // INSERT PREVIEW new template
                    $sql    = 'INSERT INTO settings_value_template (variable, json_example, created_at, updated_at) VALUES (?, ?, NOW(), NOW())';
                    $params = [$variable, $jsonEncoded];
                    $this->addSql($sql, $params);

                    // Try to discover what ID it would be (optional best-effort)
                    try {
                        // We DO NOT insert, so we cannot call lastInsertId().
                        // Instead, try to SELECT id if it exists already after a previous run; otherwise log NULL.
                        $templateId = $this->connection->fetchOne(
                            'SELECT id FROM settings_value_template WHERE variable = ?',
                            [$variable]
                        );
                    } catch (\Throwable $e) {
                        $templateId = false;
                    }
                }

                // Link PREVIEW: settings.value_template_id = $templateId
                if ($templateId) {
                    $sql    = 'UPDATE settings SET value_template_id = ? WHERE variable = ?';
                    $params = [$templateId, $variable];
                    $this->addSql($sql, $params);
                } else {
                    error_log(sprintf('[INFO] Skipping link preview for "%s" (no template id available in dry-run).', $variable));
                }