<?php

declare(strict_types=1);

$config = require '/tmp/zhct-dm-poc-20260928.fcpiiN/store/application/database.php';
$db = new PDO('dm:host=127.0.0.1;port=5237;schema=ZHCT_APP',
    (string)$config['username'], (string)$config['password'], [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_CASE => PDO::CASE_LOWER,
    ]);
$row = $db->query("SELECT SPORT_UUID,SEX FROM YDY_STAFF WHERE IS_SHOW=1 AND SPORT_UUID IS NOT NULL AND ROWNUM=1")
    ->fetch(PDO::FETCH_ASSOC);
if (!is_array($row)) throw new RuntimeException('Natural source absent');
$sql = 'select `name`,`uuid` from ydy_staff where is_show = 1 AND ( sport_uuid = "'
    . (string)$row['sport_uuid'] . '" ) AND sex = ' . (int)$row['sex'];
try {
    $db->query($sql)->fetchAll(PDO::FETCH_ASSOC);
    echo json_encode(['status'=>'unexpected_success']), PHP_EOL;
} catch (Throwable $error) {
    $message = preg_replace('/[A-Fa-f0-9-]{12,64}/', '<redacted-id>', $error->getMessage());
    echo json_encode(['status'=>'expected_dialect_failure','class'=>get_class($error),
        'code'=>(string)$error->getCode(),'sanitized_message'=>$message],
        JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES), PHP_EOL;
}
