const mysql = require('mysql2/promise');
require('dotenv').config();

async function viewDB() {
    try {
        const pool = mysql.createPool({
            host: process.env.DB_HOST,
            user: process.env.DB_USER,
            password: process.env.DB_PASSWORD,
            database: process.env.DB_NAME,
        });

        console.log('\n--- Database: ' + process.env.DB_NAME + ' ---\n');

        // List Tables
        const [tables] = await pool.execute('SHOW TABLES');
        const tableNames = tables.map(t => Object.values(t)[0]);

        if (tableNames.length === 0) {
            console.log('No tables found in database.');
        } else {
            console.log('Tables found:', tableNames.join(', '));
            console.log('\n-----------------------------------\n');

            for (const tableName of tableNames) {
                console.log(`Table: ${tableName}`);
                const [rows] = await pool.execute(`SELECT * FROM ${tableName} LIMIT 10`);
                if (rows.length === 0) {
                    console.log(' (Empty table)');
                } else {
                    console.table(rows);
                }
                console.log('\n');
            }
        }

        await pool.end();
        process.exit(0);
    } catch (err) {
        console.error('Error viewing DB:', err);
        process.exit(1);
    }
}

viewDB();