<?php

declare(strict_types=1);

$storePassword = getenv('POC_PASSWORD');
$aiPassword = getenv('POC_AI_PASSWORD');
if (!$storePassword || !$aiPassword) exit(2);
$targets = [
    'store' => ['dsn' => 'dm:host=127.0.0.1;port=5237;schema=ZHCT_APP', 'user' => 'ZHCT_APP', 'password' => $storePassword,
        'tables' => ['YDY_MEAL_ORDER', 'YDY_MEAL_ORDER_REFUND', 'YDY_CASH_REFUND_ORDER']],
    'ai_api' => ['dsn' => 'dm:host=127.0.0.1;port=5238;schema=AIZHCT_APP', 'user' => 'AIZHCT_APP', 'password' => $aiPassword,
        'tables' => ['YOSHOP_RECHARGE_ORDER', 'YOSHOP_CASHOUT_ORDER_DETAIL']],
];
$result = [];
foreach ($targets as $name => $target) {
    $pdo = new PDO($target['dsn'], $target['user'], $target['password'], [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
    $stmt = $pdo->prepare('SELECT COUNT(*) FROM USER_TABLES WHERE TABLE_NAME=?');
    foreach ($target['tables'] as $table) {
        $stmt->execute([$table]);
        $result[$name][$table] = (int)$stmt->fetchColumn() === 1;
    }
}
echo json_encode($result) . PHP_EOL;