server.js

const express = require('express');
const cors = require('cors');
const helmet = require('helmet');
const morgan = require('morgan');
require('dotenv').config();

const { testConnection, initializeDatabase } = require('./config/database');
const schoolRoutes = require('./routes/schoolRoutes');

const app = express();
const PORT = process.env.PORT || 3000;

// Middleware
app.use(helmet()); // Security headers
app.use(cors()); // Enable CORS
app.use(morgan('combined')); // Logging
app.use(express.json({ limit: '10mb' })); // Parse JSON bodies
app.use(express.urlencoded({ extended: true, limit: '10mb' })); // Parse URL-encoded bodies

// Health check endpoint
app.get('/health', (req, res) => {
  res.status(200).json({
    success: true,
    message: 'School Management API is running',
    timestamp: new Date().toISOString(),
    environment: process.env.NODE_ENV || 'development'
  });
});

// API documentation endpoint
app.get('/', (req, res) => {
  res.json({
    success: true,
    message: 'School Management API',
    version: '1.0.0',
    endpoints: {
      'POST /addSchool': 'Add a new school',
      'GET /listSchools': 'Get schools sorted by proximity (requires latitude & longitude query params)',
      'GET /school/:id': 'Get a specific school by ID',
      'GET /health': 'Health check'
    },
    documentation: {
      addSchool: {
        method: 'POST',
        url: '/addSchool',
        body: {
          name: 'string (required)',
          address: 'string (required)',
          latitude: 'number (required, -90 to 90)',
          longitude: 'number (required, -180 to 180)'
        }
      },
      listSchools: {
        method: 'GET',
        url: '/listSchools?latitude=12.9716&longitude=77.5946',
        queryParams: {
          latitude: 'number (required, -90 to 90)',
          longitude: 'number (required, -180 to 180)'
        }
      }
    }
  });
});

// Routes
app.use('/', schoolRoutes);

// 404 handler
app.use('*', (req, res) => {
  res.status(404).json({
    success: false,
    message: 'Endpoint not found',
    availableEndpoints: [
      'POST /addSchool',
      'GET /listSchools',
      'GET /school/:id',
      'GET /health'
    ]
  });
});

// Global error handler
app.use((error, req, res, next) => {
  console.error('Global error handler:', error);
  res.status(500).json({
    success: false,
    message: 'Internal server error',
    error: process.env.NODE_ENV === 'development' ? error.message : 'Something went wrong'
  });
});

// Initialize database and start server
const startServer = async () => {
  try {
    // Test database connection
    await testConnection();
    
    // Initialize database tables
    await initializeDatabase();
    
    // Start server
    app.listen(PORT, () => {
      console.log(`🚀 Server is running on port ${PORT}`);
      console.log(`📚 School Management API is ready!`);
      console.log(`🌐 Health check: http://localhost:${PORT}/health`);
      console.log(`📖 API docs: http://localhost:${PORT}/`);
    });
    
  } catch (error) {
    console.error('❌ Failed to start server:', error);
    process.exit(1);
  }
};

// Handle graceful shutdown
process.on('SIGTERM', () => {
  console.log('SIGTERM received, shutting down gracefully');
  process.exit(0);
});

process.on('SIGINT', () => {
  console.log('SIGINT received, shutting down gracefully');
  process.exit(0);
});

// Start the server
startServer();