<?php

declare(strict_types=1);

defined('WP_UNINSTALL_PLUGIN') || exit;
defined('ABSPATH') || exit;

// Uninstall intentionally drops only the plugin's fixed allowlist of custom tables.
// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange

if (
    !get_option('crocoai_dbridge_remove_data_on_uninstall', false)
    && !get_option('wpi_remove_data_on_uninstall', false)
) {
    return;
}

global $wpdb;
$crocoai_dbridge_tables = ['media_assets', 'attribute_ops', 'remote_releases', 'media_queue', 'jobs', 'aliases', 'changes', 'links', 'records', 'runs', 'profiles', 'sources'];
foreach ($crocoai_dbridge_tables as $crocoai_dbridge_table) {
    $crocoai_dbridge_current_table = $wpdb->prefix . 'crocoai_dbridge_' . $crocoai_dbridge_table;
    $crocoai_dbridge_legacy_table = $wpdb->prefix . 'wpi_' . $crocoai_dbridge_table;
    $wpdb->query($wpdb->prepare('DROP TABLE IF EXISTS %i', $crocoai_dbridge_current_table));
    $wpdb->query($wpdb->prepare('DROP TABLE IF EXISTS %i', $crocoai_dbridge_legacy_table));
}

foreach (
    [
        'crocoai_dbridge_db_version',
        'crocoai_dbridge_settings',
        'crocoai_dbridge_api_key',
        'crocoai_dbridge_legacy_sources_retired',
        'crocoai_dbridge_remove_data_on_uninstall',
        'crocoai_dbridge_worker_lock',
        'crocoai_dbridge_attribute_lookup_rebuild',
        'crocoai_dbridge_migration_lock',
        'crocoai_dbridge_identifiers_migrated',
        'wpi_db_version',
        'wpi_settings',
        'wpi_api_key',
        'wpi_legacy_sources_retired',
        'wpi_remove_data_on_uninstall',
        'wpi_worker_lock',
        'wpi_attribute_lookup_rebuild',
        'wpi_migration_lock',
    ] as $crocoai_dbridge_option
) {
    delete_option($crocoai_dbridge_option);
}