todos.js

const express = require('express');
const router = express.Router();
const db = require('../database/db');

// Get all todos
router.get('/', (req, res) => {
    db.all('SELECT * FROM todos', (err, rows) => {
        if (err) {
            res.status(500).json({ error: err.message });
            return;
        }
        res.json(rows);
    });
});

// Add new todo
router.post('/', (req, res) => {
    const { task } = req.body;
    db.run('INSERT INTO todos (task) VALUES (?)', [task], function(err) {
        if (err) {
            res.status(400).json({ error: err.message });
            return;
        }
        res.json({ id: this.lastID, task, completed: 0 });
    });
});

// Update todo
router.put('/:id', (req, res) => {
    const { task, completed } = req.body;
    db.run(
        'UPDATE todos SET task = ?, completed = ? WHERE id = ?',
        [task, completed, req.params.id],
        function(err) {
            if (err) {
                res.status(400).json({ error: err.message });
                return;
            }
            res.json({ changes: this.changes });
        }
    );
});

// Delete todo
router.delete('/:id', (req, res) => {
    db.run('DELETE FROM todos WHERE id = ?', req.params.id, function(err) {
        if (err) {
            res.status(400).json({ error: err.message });
            return;
        }
        res.json({ deleted: this.changes });
    });
});

module.exports = router;