研发管理工具链选型指南：从 Jira、Confluence 到 GitLab 的全栈方案详解

// Webhook处理器示例 - 自动更新任务状态
const express = require('express');
const app = express();
app.use(express.json());

// 处理代码推送事件
app.post('/webhook/code-push', (req, res) => {
  const { event, project, commit } = req.body;
  
  if (event === 'push' && commit.message) {
    // 解析提交信息中的任务编号
    const taskPattern = /#(\w+-\d+)/g;
    const tasks = commit.message.match(taskPattern);
    
    if (tasks) {
      tasks.forEach(taskId => {
        // 调用项目管理API更新任务状态
        updateTaskStatus(taskId.replace('#', ''), 'in_review');
      });
    }
  }
  
  res.status(200).send('Webhook processed');
});

// 更新任务状态函数
async function updateTaskStatus(taskId, status) {
  const apiUrl = `https://pm-tool-api.example.com/tasks/${taskId}`;
  
  try {
    const response = await fetch(apiUrl, {
      method: 'PATCH',
      headers: {
        'Content-Type': 'application/json',
        'Authorization': 'Bearer YOUR_API_TOKEN'
      },
      body: JSON.stringify({ status })
    });
    
    console.log(`Task ${taskId} status updated to ${status}`);
  } catch (error) {
    console.error('Error updating task:', error);
  }
}

const PORT = process.env.PORT || 3000;
app.listen(PORT, () => {
  console.log(`Webhook server running on port ${PORT}`);
});

// 高可用健康检查服务示例
public class HealthCheckService : BackgroundService
{
    private readonly ILogger _logger;
    private readonly List _servicesToCheck;
    
    public HealthCheckService(ILogger logger, IConfiguration config)
    {
        _logger = logger;
        _servicesToCheck = config.GetSection("Monitoring:Services").Get<>>();
    }
    
    protected override async Task ExecuteAsync(CancellationToken stoppingToken)
    {
        while (!stoppingToken.IsCancellationRequested)
        {
            foreach (var serviceUrl in _servicesToCheck)
            {
                try
                {
                    using var client = new HttpClient();
                    var response = await client.GetAsync($"{serviceUrl}/health", stoppingToken);
                    
                    if (!response.IsSuccessStatusCode)
                    {
                        _logger.LogWarning($"Service {serviceUrl} is unhealthy");
                        // 触发告警或自动恢复逻辑
                    }
                }
                catch (Exception ex)
                {
                    _logger.LogError(ex, $"Health check failed for {serviceUrl}");
                }
            }
            
            await Task.Delay(TimeSpan.FromMinutes(5), stoppingToken);
        }
    }
}

-- 数据库备份和维护计划
USE master;
GO

-- 创建完整备份作业
EXEC msdb.dbo.sp_add_job
    @job_name = N'Daily_Full_Backup',
    @enabled = 1;
GO

EXEC msdb.dbo.sp_add_jobstep
    @job_name = N'Daily_Full_Backup',
    @step_name = N'Backup_Production_DB',
    @subsystem = N'TSQL',
    @command = N'
DECLARE @backupPath NVARCHAR(500);
SET @backupPath = N''E:\Backups\ProductionDB_Full_'' + 
    REPLACE(CONVERT(NVARCHAR, GETDATE(), 120), '':'', '''') + ''.bak'';

BACKUP DATABASE [ProductionDB]
TO DISK = @backupPath
WITH COMPRESSION, STATS = 5;
',
    @retry_attempts = 3,
    @retry_interval = 5;
GO

-- 创建清理旧备份作业
EXEC msdb.dbo.sp_add_job
    @job_name = N'Cleanup_Old_Backups',
    @enabled = 1;
GO

EXEC msdb.dbo.sp_add_jobstep
    @job_name = N'Cleanup_Old_Backups',
    @step_name = N'Delete_Backups_Older_Than_30Days',
    @subsystem = N'TSQL',
    @command = N'
EXEC xp_delete_file 0, N''E:\Backups'', N''bak'', DATEADD(day, -30, GETDATE());
',
    @retry_attempts = 2,
    @retry_interval = 10;
GO