Un regard sur le cloud computing

/my-nextjs-app
├── /app
│   ├── /api
│   │   ├── /nextjs
│   │   │   └── route.js       # API route gérée par Next.js
│   ├── /page.js              # Page d'accueil
├── /backend                  # Application Express + Sequelize
│   ├── /config               # Configuration Sequelize
│   │   └── index.js
│   ├── /models               # Modèles Sequelize
│   │   └── User.js
│   ├── /routes               # Routes Express
│   │   └── userRoutes.js
│   ├── app.js                # Configuration Express
│   └── server.js             # Point d'entrée pour Express
├── /lib
│   └── db.js                 # Connexion à la base de données
├── /public                   # Fichiers statiques
├── .env                      # Variables d'environnement
├── next.config.js            # Configuration Next.js
├── package.json              # Dépendances
└── README.md                 # Documentation

// backend/config/index.js
const { Sequelize } = require('sequelize');
require('dotenv').config();

const sequelize = new Sequelize(process.env.DB_NAME, process.env.DB_USER, process.env.DB_PASSWORD, {
  host: process.env.DB_HOST,
  dialect: 'postgres', // Changez selon votre SGBD : mysql, sqlite, etc.
});

module.exports = sequelize;

// backend/models/User.js
const { DataTypes } = require('sequelize');
const sequelize = require('../config/index');

const User = sequelize.define('User', {
  name: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  email: {
    type: DataTypes.STRING,
    allowNull: false,
    unique: true,
  },
});

module.exports = User;

// backend/routes/userRoutes.js
const express = require('express');
const User = require('../models/User');
const router = express.Router();

// Obtenir tous les utilisateurs
router.get('/users', async (req, res) => {
  try {
    const users = await User.findAll();
    res.json(users);
  } catch (err) {
    res.status(500).json({ error: err.message });
  }
});

module.exports = router;

// backend/app.js
const express = require('express');
const bodyParser = require('body-parser');
const userRoutes = require('./routes/userRoutes');

const app = express();
app.use(bodyParser.json());

// Routes
app.use('/api/express', userRoutes);

module.exports = app;

// backend/server.js
const app = require('./app');
const sequelize = require('./config/index');

const PORT = process.env.EXPRESS_PORT || 4000;

sequelize.sync().then(() => {
  console.log('Database connected');
  app.listen(PORT, () => {
    console.log(`Express API running on http://localhost:${PORT}`);
  });
});

// app/api/nextjs/route.js
import db from '@/lib/db';
import User from '@/backend/models/User';

export async function GET() {
  try {
    const users = await User.findAll();
    return new Response(JSON.stringify(users), { status: 200 });
  } catch (err) {
    return new Response(JSON.stringify({ error: err.message }), { status: 500 });
  }
}

// app/page.js
async function fetchData(apiPath) {
  const res = await fetch(apiPath);
  return res.json();
}

export default async function Home() {
  const expressUsers = await fetchData('http://localhost:4000/api/express/users');
  const nextjsUsers = await fetchData('http://localhost:3000/api/nextjs');

  return (
    <div>
      <h1>API Express</h1>
      <pre>{JSON.stringify(expressUsers, null, 2)}</pre>

      <h1>API Next.js</h1>
      <pre>{JSON.stringify(nextjsUsers, null, 2)}</pre>
    </div>
  );
}

// lib/db.js
const sequelize = require('@/backend/config/index');
export default sequelize;

DB_NAME=your_database_name
DB_USER=your_username
DB_PASSWORD=your_password
DB_HOST=localhost
EXPRESS_PORT=4000

// next.config.js
module.exports = {
  experimental: {
    appDir: true,
  },
  webpack: (config) => {
    config.resolve.alias['@/backend'] = require('path').resolve(__dirname, './backend');
    return config;
  },
};