UUI7 partition generator

uui7_partition_generator.php

<?php
use Ramsey\Uuid\Uuid;

$date = now()->parse("2024-01-01 00:00:00");

while ($date->year < 2039) {
  $dateProcess = (clone $date)
    ->endOfMonth()
    ->hour(23)
    ->minute(59)
    ->second(59);

  $uuid = substr(Uuid::uuid7($dateProcess), 0, 13) . "-0000-0000-000000000000";

  echo "PARTITION `p_{$date->year}_{$date->month}` VALUES LESS THAN ('$uuid'), -- < " .
    $dateProcess->toDateTimeString() .
    "\n";
  $date->addMonth();
}