<?php
/**
 * Migration 1: create all tables.
 *
 * @package HostKhata
 */

namespace HostKhata\Database\Migrations;

defined( 'ABSPATH' ) || exit;

use HostKhata\Database\Schema;
use RuntimeException;
use wpdb;

/**
 * Creates every HostKhata table with dbDelta().
 *
 * @since 0.1.0
 */
final class Migration0001CreateTables implements Migration {

	/**
	 * {@inheritdoc}
	 */
	public function version(): int {
		return 1;
	}

	/**
	 * Creates all tables and checks that each one exists.
	 *
	 * @since 0.1.0
	 *
	 * @param wpdb $wpdb WordPress database object.
	 * @return void
	 *
	 * @throws RuntimeException When a table could not be created.
	 */
	public function up( wpdb $wpdb ): void {
		require_once ABSPATH . 'wp-admin/includes/upgrade.php';

		$statements = Schema::statements( $wpdb->prefix, $wpdb->get_charset_collate() );

		foreach ( $statements as $sql ) {
			dbDelta( $sql );
		}

		foreach ( array_keys( $statements ) as $key ) {
			$table = $wpdb->prefix . 'hostkhata_' . $key;
			$found = $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $table ) ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching

			if ( $found !== $table ) {
				throw new RuntimeException( sprintf( 'Table %s could not be created.', $table ) ); // phpcs:ignore WordPress.Security.EscapeOutput.ExceptionNotEscaped
			}
		}
	}
}