server.js

import express from 'express';
import pool from './db.js';

const app = express();

app.use(express.json());

// 전체조회
app.get('/todos', async (req, res) => {
    try {
        const result = await pool.query('SELECT * FROM todos ORDER BY id');
        res.json(result.rows);
    } catch (err) {
        res.status(500).json({ message: err.message });
    }
});

// 상세조회
app.get('/todos/:id', async (req, res) => {
    try {
        const result = await pool.query('SELECT * FROM todos WHERE id = $1', [req.params.id]);
        if (result.rows.length === 0) {
            return res.status(404).json({ message: 'Todo not found' });
        }
        res.json(result.rows[0]);
    } catch (err) {
        res.status(500).json({ message: err.message });
    }
});

// 생성
app.post('/todos', async (req, res) => {
    try {
        const result = await pool.query(
            'INSERT INTO todos (text) VALUES ($1) RETURNING *',
            [req.body.text]
        );
        res.status(201).json(result.rows[0]);
    } catch (err) {
        res.status(500).json({ message: err.message });
    }
});

// 수정
app.put('/todos/:id', async (req, res) => {
    try {
        const result = await pool.query(
            `UPDATE todos
             SET text = COALESCE($1, text)
             WHERE id = $2
             RETURNING *`,
            [req.body.text ?? null, req.params.id]
        );
        if (result.rows.length === 0) {
            return res.status(404).json({ message: 'Todo not found' });
        }
        res.json(result.rows[0]);
    } catch (err) {
        res.status(500).json({ message: err.message });
    }
});

// 삭제
app.delete('/todos/:id', async (req, res) => {
    try {
        const result = await pool.query('DELETE FROM todos WHERE id = $1 RETURNING *', [req.params.id]);
        if (result.rows.length === 0) {
            return res.status(404).json({ message: 'Todo not found' });
        }
        res.json({ message: 'Todo deleted' });
    } catch (err) {
        res.status(500).json({ message: err.message });
    }
});

app.listen(3000, () => {
  console.log('Server is running on port 3000, http://localhost:3000');
});