将整数追加到数组中(使用express和pg-promise)

npm install express pg-promise

const express = require('express');
const app = express();
const pgp = require('pg-promise')();
const db = pgp('postgres://username:password@localhost:5432/database');

app.use(express.json());

app.post('/append', async (req, res) => {
  try {
    const { number } = req.body;
    
    // 查询现有数组
    const existingArray = await db.one('SELECT array_column FROM my_table WHERE id = 1');
    
    // 将整数追加到数组中
    const newArray = [...existingArray.array_column, number];
    
    // 更新数据库中的数组
    await db.none('UPDATE my_table SET array_column = $1 WHERE id = 1', [newArray]);
    
    res.status(200).json({ message: '整数已成功追加到数组中' });
  } catch (error) {
    console.error(error);
    res.status(500).json({ message: '出现错误' });
  }
});

app.listen(3000, () => {
  console.log('服务器已启动，监听端口3000');
});