2025零代码时代：基于腾讯云Serverless的全栈项目开发与自动化部署深度实践

taskboard/
├── frontend/          # React 源码
├── backend/           # 云函数代码
│   └── api/           # 函数目录（一个函数包含多个路由）
├── cloudbaserc.json   # CloudBase 配置
└── .env               # 环境变量（敏感信息，gitignore）

const express = require('express');
const { createPool } = require('mysql2/promise');
const app = express();
app.use(express.json());

// 全局数据库连接池（利用容器复用）
let pool;
const initPool = () => {
  if (!pool) {
    pool = createPool({
      host: process.env.DB_HOST,
      user: process.env.DB_USER,
      password: process.env.DB_PWD,
      database: process.env.DB_NAME,
      waitForConnections: true,
      connectionLimit: 10,   // 按云函数并发调整
      queueLimit: 0,
      enableKeepAlive: true,
      keepAliveInitialDelay: 0
    });
  }
  return pool;
};

// 任务列表 API
app.get('/tasks', async (req, res) => {
  const conn = await initPool().getConnection();
  try {
    const [rows] = await conn.query('SELECT * FROM tasks ORDER BY created_at DESC');
    res.json({ code: 0, data: rows });
  } finally {
    conn.release();
  }
});

// 创建任务（带事务示例）
app.post('/tasks', async (req, res) => {
  const { title, priority } = req.body;
  const conn = await initPool().getConnection();
  await conn.beginTransaction();
  try {
    await conn.query('INSERT INTO tasks (title, priority) VALUES (?, ?)', [title, priority]);
    await conn.commit();
    res.json({ code: 0, msg: 'ok' });
  } catch (e) {
    await conn.rollback();
    throw e;
  } finally {
    conn.release();
  }
});

// 其他路由省略...

exports.main_handler = async (event, context) => {
  // 适配腾讯云SCF触发事件（API网关触发器）
  return app(event, context);
};

// frontend/src/api/client.js
import axios from 'axios';
const baseURL = process.env.VITE_API_BASE_URL; // 由CloudBase输出

const client = axios.create({
  baseURL,
  timeout: 8000,
});

client.interceptors.response.use(
  res => res.data,
  err => {
    // 上报日志到腾讯云CLS
    console.error('[API Error]', err);
    return Promise.reject(err);
  }
);

export default client;

{
  "envId": "your-env-id",
  "version": "2.0",
  "framework": {
    "name": "taskboard",
    "plugins": {
      "client": {
        "use": "@cloudbase/framework-plugin-website",
        "inputs": {
          "buildCommand": "npm run build",
          "outputPath": "frontend/dist",
          "cloudPath": "/"
        }
      },
      "server": {
        "use": "@cloudbase/framework-plugin-function",
        "inputs": {
          "functionRootPath": "./backend",
          "functions": [
            {
              "name": "taskApi",
              "handler": "api/index.main_handler",
              "runtime": "Nodejs18.15",
              "installDependency": true,
              "envVariables": {
                "DB_HOST": "{{env.DB_HOST}}",
                "DB_USER": "{{env.DB_USER}}",
                "DB_PWD": "{{env.DB_PWD}}",
                "DB_NAME": "{{env.DB_NAME}}"
              },
              "triggers": [
                {
                  "name": "apiTrigger",
                  "type": "apigw",
                  "config": {
                    "apiId": "custom-api",
                    "path": "/api",
                    "method": "ANY",
                    "enableCORS": true
                  }
                }
              ]
            }
          ]
        }
      }
    }
  }
}

pipeline {
  agent any
  environment {
    TENCENT_CLOUD_SECRET_ID = credentials('TENCENT_CLOUD_SECRET_ID')
    TENCENT_CLOUD_SECRET_KEY = credentials('TENCENT_CLOUD_SECRET_KEY')
    ENV_ID = 'your-env'
  }
  stages {
    stage('Install') {
      steps {
        sh 'npm install -g @cloudbase/cli'
        sh 'cd frontend && npm install'
        sh 'cd backend && npm install'
      }
    }
    stage('Build & Deploy') {
      steps {
        withEnv([
          "DB_HOST=${DB_HOST}",
          "DB_USER=${DB_USER}",
          "DB_PWD=${DB_PWD}",
          "DB_NAME=${DB_NAME}"
        ]) {
          sh 'tcb framework deploy --mode prod'
        }
      }
    }
    stage('Health Check') {
      steps {
        // 调用部署后的API进行冒烟测试
        sh 'curl -f https://your-domain.com/api/tasks || exit 1'
      }
    }
  }
}

console.log(JSON.stringify({ level: 'info', event: 'create_task', taskId: result.insertId }));