test-stock-price-service.js

// Test for the new stock price service
import { 
  fetchAndStoreLatestPrice,
  fetchAndStoreHistoricalPrices,
  calculatePerformanceFromStoredPrices,
  ensureSufficientHistoricalData,
  cleanupOldStockPrices
} from './server/stockPriceService.ts';

async function runTests() {
  const ticker = 'FOXF';
  console.log(`\n===== Testing stock price service with ticker: ${ticker} =====\n`);
  
  try {
    // Step 1: Fetch and store latest price
    console.log('Step 1: Fetching and storing latest price...');
    const latestPriceResult = await fetchAndStoreLatestPrice(ticker);
    console.log('Latest price stored:', latestPriceResult ? 'Success' : 'Failed');
    
    // Step 2: Ensure we have sufficient historical data for performance calculations
    console.log('\nStep 2: Ensuring we have sufficient historical data...');
    const historicalDataResult = await ensureSufficientHistoricalData(ticker);
    console.log('Historical data check:', historicalDataResult ? 'Sufficient data exists or was fetched' : 'Failed to fetch data');
    
    // Step 3: Calculate performance metrics based on stored data
    console.log('\nStep 3: Calculating performance metrics from stored prices...');
    const performanceMetrics = await calculatePerformanceFromStoredPrices(ticker);
    if (performanceMetrics) {
      console.log('Performance metrics:');
      console.log(`- Current Price: $${performanceMetrics.price.toFixed(2)}`);
      console.log(`- 1 Day Change: ${performanceMetrics.oneDayChange?.toFixed(2)}%`);
      console.log(`- 1 Week Change: ${performanceMetrics.oneWeekChange?.toFixed(2)}%`);
      console.log(`- 1 Month Change: ${performanceMetrics.oneMonthChange?.toFixed(2)}%`);
      console.log(`- 6 Month Change: ${performanceMetrics.sixMonthChange?.toFixed(2)}%`);
      console.log(`- YTD Change: ${performanceMetrics.ytdChange?.toFixed(2)}%`);
      console.log(`- 1 Year Change: ${performanceMetrics.oneYearChange?.toFixed(2)}%`);
      console.log(`- 5 Year Change: ${performanceMetrics.fiveYearChange?.toFixed(2)}%`);
    } else {
      console.log('Failed to calculate performance metrics');
    }
    
    // Step 4: Test cleanup of old stock prices (will not actually delete any recent data)
    // Just testing that the function works
    const cutoffDate = new Date();
    cutoffDate.setFullYear(cutoffDate.getFullYear() - 10); // 10 years ago, shouldn't delete anything
    console.log('\nStep 4: Testing cleanup of very old stock prices (older than 10 years)...');
    const deletedCount = await cleanupOldStockPrices(3650); // 10 years retention
    console.log(`Deleted ${deletedCount} old price records`);
    
    console.log('\n===== Stock price service test completed =====\n');
  } catch (error) {
    console.error('Test failed with error:', error);
  }
}

runTests();