如何使用node；express框架使用postgresql中的数据填充完整日历？

npm init

npm install express pg

const express = require('express');
const { Pool } = require('pg');

const app = express();
const port = 3000;

const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 5432, // 默认PostgreSQL端口号
});

app.get('/fill-calendar', async (req, res) => {
  try {
    // 从数据库中获取日历数据
    const calendarData = await pool.query('SELECT * FROM calendar');

    // 处理日历数据并返回给客户端
    res.json(calendarData.rows);
  } catch (error) {
    console.error('Error retrieving calendar data', error);
    res.status(500).send('Internal Server Error');
  }
});

app.listen(port, () => {
  console.log(`Server is running on port ${port}`);
});

node app.js