<?php
require __DIR__ . '/edu/bbs/db_conn.php';

$pdo = db_conn();

function dumpColumns(PDO $pdo, $table) {
    echo "=== COLUMNS: {$table} ===\n";
    $stmt = $pdo->query("SHOW COLUMNS FROM {$table}");
    foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        echo $row['Field'] . "|" . $row['Type'] . "|" . $row['Null'] . "|" . $row['Key'] . "\n";
    }
    echo "\n";
}

function dumpRows(PDO $pdo, $sql, $title) {
    echo "=== {$title} ===\n";
    $rows = $pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
    foreach ($rows as $row) {
        echo json_encode($row, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES) . "\n";
    }
    echo "\n";
}

dumpColumns($pdo, 'edu_learning_goals');
dumpColumns($pdo, 'edu_contents');

dumpRows($pdo, "SELECT goal_code, title, base_year, quarter, is_active FROM edu_learning_goals ORDER BY base_year DESC, quarter DESC, goal_code ASC LIMIT 20", 'GOALS SAMPLE');
dumpRows($pdo, "SELECT content_id, goal_code, category_code, category_group, title, description1, description2, content_url, thumbnail_url, sort_order, is_active FROM edu_contents ORDER BY base_year DESC, category_group DESC, sort_order ASC, content_id ASC LIMIT 40", 'CONTENTS SAMPLE');