API Scaffold — Quick Endpoint Starter

Inspired by: wshobson/commands api-scaffold — adapted for Fuji-master / PlusOne stack

Route Template (create in server/routes/)

// server/routes/items.js
const express = require('express');
const router = express.Router();
const { pool } = require('../db');
const auth = require('../middleware/auth'); // JWT check

// GET /api/items — list
router.get('/', auth, async (req, res) => {
  try {
    const userId = req.user.id;
    const { rows } = await pool.query(
      'SELECT * FROM items WHERE user_id = $1 ORDER BY created_at DESC',
      [userId]
    );
    res.json(rows);
  } catch (err) {
    console.error('GET /items error:', err);
    res.status(500).json({ error: 'Server error' });
  }
});

// POST /api/items — create
router.post('/', auth, async (req, res) => {
  try {
    const { name, description } = req.body;
    if (!name) return res.status(400).json({ error: 'name is required' });

    const { rows } = await pool.query(
      'INSERT INTO items (name, description, user_id) VALUES ($1, $2, $3) RETURNING *',
      [name, description, req.user.id]
    );
    res.status(201).json(rows[0]);
  } catch (err) {
    console.error('POST /items error:', err);
    res.status(500).json({ error: 'Server error' });
  }
});

// PUT /api/items/:id — update
router.put('/:id', auth, async (req, res) => {
  try {
    const { id } = req.params;
    const { name, description } = req.body;

    const { rows } = await pool.query(
      'UPDATE items SET name=$1, description=$2, updated_at=NOW() WHERE id=$3 AND user_id=$4 RETURNING *',
      [name, description, id, req.user.id]
    );
    if (!rows.length) return res.status(404).json({ error: 'Not found' });
    res.json(rows[0]);
  } catch (err) {
    console.error('PUT /items error:', err);
    res.status(500).json({ error: 'Server error' });
  }
});

// DELETE /api/items/:id — delete
router.delete('/:id', auth, async (req, res) => {
  try {
    const { id } = req.params;
    const { rowCount } = await pool.query(
      'DELETE FROM items WHERE id=$1 AND user_id=$2',
      [id, req.user.id]
    );
    if (!rowCount) return res.status(404).json({ error: 'Not found' });
    res.json({ success: true });
  } catch (err) {
    console.error('DELETE /items error:', err);
    res.status(500).json({ error: 'Server error' });
  }
});

module.exports = router;

Register in index.js

const itemsRouter = require('./routes/items');
app.use('/api/items', itemsRouter);

SQL Migration for a New Entity

CREATE TABLE IF NOT EXISTS items (
  id          SERIAL PRIMARY KEY,
  user_id     INTEGER REFERENCES users(id) ON DELETE CASCADE,
  name        VARCHAR(255) NOT NULL,
  description TEXT,
  created_at  TIMESTAMP DEFAULT NOW(),
  updated_at  TIMESTAMP DEFAULT NOW()
);

CREATE INDEX IF NOT EXISTS idx_items_user_id ON items(user_id);

Pattern Without Auth (Public API)

// Simply remove the auth middleware from router.get('/', async ...)
router.get('/public', async (req, res) => { ... });

Response Codes