server.js

const express = require('express');
const path = require('path');
const sqlite3 = require('sqlite3').verbose();

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

// Middleware to parse JSON
app.use(express.json());

// Serve static files from the current directory
app.use(express.static(__dirname));

// Initialize SQLite database
const db = new sqlite3.Database('./clickcount.db', (err) => {
    if (err) {
        console.error('Error opening database:', err.message);
    } else {
        console.log('✅ Connected to SQLite database');
        
        // Create clicks table if it doesn't exist
        db.run(`CREATE TABLE IF NOT EXISTS clicks (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            count INTEGER DEFAULT 0,
            created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
            updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
        )`, (err) => {
            if (err) {
                console.error('Error creating table:', err.message);
            } else {
                console.log('✅ Database table ready');
                
                // Initialize with count 0 if no records exist
                db.get('SELECT COUNT(*) as count FROM clicks', (err, row) => {
                    if (err) {
                        console.error('Error checking records:', err.message);
                    } else if (row.count === 0) {
                        db.run('INSERT INTO clicks (count) VALUES (0)', (err) => {
                            if (err) {
                                console.error('Error initializing count:', err.message);
                            } else {
                                console.log('✅ Initialized click count to 0');
                            }
                        });
                    }
                });
            }
        });
    }
});

// Route for the main page
app.get('/', (req, res) => {
    res.sendFile(path.join(__dirname, 'index.html'));
});

// API route to get current click count
app.get('/api/click-count', (req, res) => {
    db.get('SELECT count FROM clicks ORDER BY id DESC LIMIT 1', (err, row) => {
        if (err) {
            console.error('Error getting click count:', err.message);
            res.status(500).json({ error: 'Failed to get click count' });
        } else {
            res.json({ count: row ? row.count : 0 });
        }
    });
});

// API route to increment click count
app.post('/api/click', (req, res) => {
    db.get('SELECT count FROM clicks ORDER BY id DESC LIMIT 1', (err, row) => {
        if (err) {
            console.error('Error getting current count:', err.message);
            res.status(500).json({ error: 'Failed to get current count' });
            return;
        }
        
        const currentCount = row ? row.count : 0;
        const newCount = currentCount + 1;
        
        db.run('INSERT INTO clicks (count) VALUES (?)', [newCount], function(err) {
            if (err) {
                console.error('Error updating click count:', err.message);
                res.status(500).json({ error: 'Failed to update click count' });
            } else {
                console.log(`✅ Click count updated to ${newCount}`);
                res.json({ count: newCount });
            }
        });
    });
});

// Handle 404 errors
app.use((req, res) => {
    res.status(404).sendFile(path.join(__dirname, 'index.html'));
});

// Start the server
app.listen(PORT, () => {
    console.log(`🚀 Server is running on http://localhost:${PORT}`);
    console.log(`📁 Serving files from: ${__dirname}`);
    console.log(`🌐 Open your browser and visit: http://localhost:${PORT}`);
});

// Graceful shutdown
process.on('SIGINT', () => {
    console.log('\n🛑 Shutting down server...');
    db.close((err) => {
        if (err) {
            console.error('Error closing database:', err.message);
        } else {
            console.log('✅ Database connection closed');
        }
        process.exit(0);
    });
});