<?php

namespace ABeCe\Booking\Infrastructure\Database;

use RuntimeException;

final class OperatingScheduleMigration implements Migration {
	public function version(): int { return 2; }

	public function apply( \wpdb $wpdb ): void {
		require_once ABSPATH . 'wp-admin/includes/upgrade.php';
		$previous = $wpdb->suppress_errors( true );
		try {
			foreach ( Schema::operatingSchedule( $wpdb ) as $table => $sql ) {
				$exists = $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $table ) ) );
				if ( $wpdb->last_error ) { throw new RuntimeException( __( 'ABeCe Booking database migration failed. Existing data has been retained.', 'abece-booking' ) ); }
				// A retry verifies already-created tables rather than altering them.
				if ( null === $exists ) {
					dbDelta( $sql );
					if ( $wpdb->last_error ) { throw new RuntimeException( __( 'ABeCe Booking database migration failed. Existing data has been retained.', 'abece-booking' ) ); }
				}
				Schema::verify( $wpdb, $table, $sql );
			}
		} finally { $wpdb->suppress_errors( $previous ); }
	}
}