test_api.js

Go to the documentation of this file.

const express = require('express');
const pool = require('./db');
 
/**
 *
 */
async function testAPI() {
  try {
    console.log('Testing database connection...');
    
    // Test basic connection
    const result = await pool.query('SELECT NOW()');
    console.log('✓ Database connected at:', result.rows[0].now);
    
    // Check if domains table exists
    const tableCheck = await pool.query(`
      SELECT EXISTS (
        SELECT FROM information_schema.tables 
        WHERE table_name = 'domains'
      )
    `);
    console.log('✓ Domains table exists:', tableCheck.rows[0].exists);
    
    if (tableCheck.rows[0].exists) {
      // Count domains
      const count = await pool.query('SELECT COUNT(*) FROM domains');
      console.log('✓ Total domains:', count.rows[0].count);
      
      // Get sample
      const domains = await pool.query('SELECT * FROM domains LIMIT 3');
      console.log('✓ Sample domains:', domains.rows.length);
      if (domains.rows.length > 0) {
        console.table(domains.rows.map(d => ({
          id: d.domain_id,
          name: d.domain_name,
          registrar: d.registrar,
          tenant: d.tenant_id?.substring(0, 8)
        })));
      }
    } else {
      console.log('⚠ Domains table does not exist!');
      console.log('Run the migration: psql -U rmm_user -d rmm_psa -f ../rmm-psa-database/2026_02_add_domains.sql');
    }
  } catch (error) {
    console.error('✗ Error:', error.message);
  } finally {
    process.exit();
  }
}
 
testAPI();