check_domains.js

Go to the documentation of this file.

const pool = require('./db');
 
/**
 *
 */
async function checkDomains() {
  try {
    // 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 total domains
      const countResult = await pool.query('SELECT COUNT(*) FROM domains');
      console.log('Total domains in database:', countResult.rows[0].count);
 
      // Show sample domains
      const domainsResult = await pool.query(`
        SELECT domain_id, domain_name, registrar, status, tenant_id, customer_id
        FROM domains 
        LIMIT 5
      `);
      console.log('\nSample domains:');
      console.table(domainsResult.rows);
 
      // Check tenants
      const tenantsResult = await pool.query(`
        SELECT tenant_id, subdomain, is_msp 
        FROM tenants 
        LIMIT 5
      `);
      console.log('\nSample tenants:');
      console.table(tenantsResult.rows);
    }
  } catch (error) {
    console.error('Error:', error.message);
  } finally {
    process.exit();
  }
}
 
checkDomains();