<?php
declare(strict_types=1);
// Read only the user's selected local configuration; never output connection values.
$repo = getenv('TERMINAL_TEST_REPO') ?: '/Users/wiscourper/Documents/workspace/zhct/zhctproject/ai_api';
$config = parse_ini_file($repo . '/.env.local', true, INI_SCANNER_RAW)['DATABASE'];
$pdo = new PDO('mysql:host=' . $config['HOSTNAME'] . ';port=' . $config['HOSTPORT']
    . ';dbname=' . $config['DATABASE'], $config['USERNAME'], $config['PASSWORD'], [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
]);
$statement = $pdo->prepare('SELECT TABLE_NAME,COLUMN_NAME,DATA_TYPE,NUMERIC_PRECISION,NUMERIC_SCALE '
    . 'FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=? '
    . 'AND TABLE_NAME IN ("yoshop_foods","yoshop_dishes","yoshop_dishes_foods") '
    . 'AND DATA_TYPE IN ("decimal","double","float") ORDER BY TABLE_NAME,ORDINAL_POSITION');
$statement->execute([$config['DATABASE']]);
echo json_encode(['source'=>'code .env.local default connection, read-only INFORMATION_SCHEMA',
    'columns'=>$statement->fetchAll(PDO::FETCH_ASSOC)], JSON_PRETTY_PRINT), "\n";