<?php
try {
    $pdo = new PDO('mysql:host=baroncs.co.kr;port=3306;dbname=baronhomep;charset=utf8mb4', 'baronhomep', 'baron3840!!', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
    $pdo->exec("SET NAMES utf8mb4");

    $sql = file_get_contents(__DIR__ . '/../sample_content_keywords.sql');
    $pdo->exec($sql);

    $cnt = $pdo->query('SELECT COUNT(*) FROM edu_content_keywords')->fetchColumn();
    echo json_encode(['status' => 'ok', 'inserted_total' => (int)$cnt], JSON_UNESCAPED_UNICODE) . PHP_EOL;

    // 키워드별 매핑 건수 확인
    $rows = $pdo->query('SELECT keyword_code, COUNT(*) as cnt FROM edu_content_keywords GROUP BY keyword_code ORDER BY cnt DESC')->fetchAll(PDO::FETCH_ASSOC);
    echo json_encode($rows, JSON_UNESCAPED_UNICODE) . PHP_EOL;

    // recommend_keywords 확인
    $rk = $pdo->query('SELECT * FROM edu_recommend_keywords')->fetchAll(PDO::FETCH_ASSOC);
    echo json_encode($rk, JSON_UNESCAPED_UNICODE) . PHP_EOL;

} catch (Exception $e) {
    echo json_encode(['status' => 'error', 'message' => $e->getMessage()], JSON_UNESCAPED_UNICODE) . PHP_EOL;
}