<?php
declare(strict_types=1);


namespace OneClickFormSync\Database;

if (!defined('ABSPATH')) {
    exit;
}

/**
 * Handles database table version checks and upgrades.
 */
class MigrationManager
{
    /**
     * Option key for storing the database version.
     */
    private const DB_VERSION_OPTION = 'oneclickformsync_db_version';

    /**
     * Current database version code.
     */
    private const CURRENT_DB_VERSION = '1.0.0';

    /**
     * Checks if database schema updates are needed.
     *
     * @return bool
     */
    public function needsMigration(): bool
    {
        $installedVersion = get_option(self::DB_VERSION_OPTION);
        return version_compare($installedVersion ?: '0.0.0', self::CURRENT_DB_VERSION, '<');
    }

    /**
     * Run the schema installation/updates.
     *
     * @param SchemaManager $schemaManager
     * @return void
     */
    public function migrate(SchemaManager $schemaManager): void
    {
        require_once ABSPATH . 'wp-admin/includes/upgrade.php';

        $schemas = $schemaManager->getTablesSchema();
        foreach ($schemas as $schemaSql) {
            dbDelta($schemaSql);
        }

        update_option(self::DB_VERSION_OPTION, self::CURRENT_DB_VERSION);
    }
}