move-to-test-customer.js

Go to the documentation of this file.

/**
 * Create a test customer and move test invoices/contracts to it
 */
require('dotenv').config();
const pool = require('./services/db');
 
const TENANT_ID = '00000000-0000-0000-0000-000000000001';
const TEST_INVOICE_IDS = [503, 504, 505];
const TEST_CONTRACT_ID = 29;
 
async function moveToTestCustomer() {
  try {
    console.log('Creating test customer...\n');
 
    // Create test customer
    const customerResult = await pool.query(
      `INSERT INTO customers (name, email, phone, address, city, state, postal_code, country, tenant_id)
       VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)
       RETURNING customer_id, name, email`,
      [
        'Testing Inc',
        'test@example.com',
        '555-TEST-123',
        '123 Test Street',
        'Test City',
        'TX',
        '12345',
        'US',
        TENANT_ID
      ]
    );
 
    const testCustomerId = customerResult.rows[0].customer_id;
    console.log(`✅ Created test customer: ${customerResult.rows[0].name} (ID: ${testCustomerId})`);
    console.log(`   Email: ${customerResult.rows[0].email}\n`);
 
    // Move invoices to test customer
    console.log('Moving test invoices...');
    for (const invoiceId of TEST_INVOICE_IDS) {
      const result = await pool.query(
        `UPDATE invoices 
         SET customer_id = $1 
         WHERE invoice_id = $2 AND tenant_id = $3
         RETURNING invoice_id, description, total`,
        [testCustomerId, invoiceId, TENANT_ID]
      );
      
      if (result.rows.length > 0) {
        console.log(`  ✅ Invoice #${result.rows[0].invoice_id}: $${result.rows[0].total} - ${result.rows[0].description}`);
      } else {
        console.log(`  ⚠️  Invoice #${invoiceId} not found`);
      }
    }
 
    // Move contract to test customer
    console.log('\nMoving test contract...');
    const contractResult = await pool.query(
      `UPDATE contracts 
       SET customer_id = $1 
       WHERE contract_id = $2 AND tenant_id = $3
       RETURNING contract_id, title, labor_rate`,
      [testCustomerId, TEST_CONTRACT_ID, TENANT_ID]
    );
 
    if (contractResult.rows.length > 0) {
      console.log(`  ✅ Contract #${contractResult.rows[0].contract_id}: ${contractResult.rows[0].title} - $${contractResult.rows[0].labor_rate}/month`);
    } else {
      console.log(`  ⚠️  Contract #${TEST_CONTRACT_ID} not found`);
    }
 
    console.log('\n✅ Test data organized successfully!');
    console.log(`\n📋 Test Customer ID: ${testCustomerId}`);
    console.log('   Name: Testing Inc');
    console.log('   Email: test@example.com');
 
    await pool.end();
    process.exit(0);
 
  } catch (error) {
    console.error('❌ Error:', error.message);
    console.error(error);
    await pool.end();
    process.exit(1);
  }
}
 
moveToTestCustomer();