<?php
declare(strict_types=1);
$path='/Users/wiscourper/Documents/workspace/zhct/zhctproject/ai_api/.env.local';
$ini=parse_ini_file($path,true,INI_SCANNER_RAW);
$results=[];
foreach(['DATABASE','DATABASE_ZHCT'] as $section){
    $c=$ini[$section];$pdo=new PDO('mysql:host='.$c['HOSTNAME'].';port='.$c['HOSTPORT'].';dbname='.$c['DATABASE'].';charset=utf8',
        $c['USERNAME'],$c['PASSWORD'],[PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION]);
    $version=(string)$pdo->query('SELECT VERSION()')->fetchColumn();
    $schema=(string)$pdo->query('SELECT DATABASE()')->fetchColumn();
    $results[$section]=['mysql_version'=>$version,'configured_schema_matches'=>$schema===$c['DATABASE']];
    if(strpos($version,'5.6.')!==0||$schema!==$c['DATABASE'])throw new RuntimeException('Local MySQL identity drift');
}
echo json_encode(['code_local_env_verified'=>true,'connections'=>$results]),"\n";