3个步骤搭建Confluence测试知识库，团队效率提升200%_千锋教育

# 页面标题：登录模块测试环境搭建
- 环境地址：http://test-login.xxx.com  
- 数据库：MySQL 8.0，schema: login_test  
- 测试账号：admin / test123  
- 前置条件：执行`docker-compose up -d`  
- 注意事项：端口8080已被占用时，修改docker-compose.yml中的映射

# 测试方案：[模块名称]
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">1. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">测试范围</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">2. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">测试环境</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">3. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">测试数据</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">4. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">测试用例列表（链接到用例页面）</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">5. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">风险与依赖</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">6. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">历史版本</span></div><div style="padding:16px 20px;"><div style="margin:16px 0;border-radius:8px;overflow:hidden;border:1px solid #E0E0E0;"><div style="background:#263238;color:#B0BEC5;padding:6px 16px;font-size:12px;font-family:Consolas,monospace;"><span style="text-transform:uppercase;letter-spacing:1px;">text</span></div><pre style="background:#1E272E;color:#E0E0E0;padding:16px 20px;margin:0;overflow-x:auto;font-size:14px;line-height:1.7;font-family:Consolas,"Courier New",monospace;"><code>
**bug根因分析模板**：</code></pre></div></div></div>
# Bug根因分析：[Bug ID]
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">1. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">现象描述</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">2. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">复现步骤</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">3. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">根因分析</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">4. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">修复方案</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">5. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">验证结果</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">6. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">同类问题预防措施</span></div><div style="padding:16px 20px;"><div style="margin:16px 0;border-radius:8px;overflow:hidden;border:1px solid #E0E0E0;"><div style="background:#263238;color:#B0BEC5;padding:6px 16px;font-size:12px;font-family:Consolas,monospace;"><span style="text-transform:uppercase;letter-spacing:1px;">text</span></div><pre style="background:#1E272E;color:#E0E0E0;padding:16px 20px;margin:0;overflow-x:auto;font-size:14px;line-height:1.7;font-family:Consolas,"Courier New",monospace;"><code>
**环境配置模板**：</code></pre></div></div></div>
# 环境配置：[环境名称]
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">1. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">硬件要求</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">2. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">软件依赖</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">3. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">部署步骤</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">4. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">验证方法</span></div><div style="padding:16px 20px;"></div></div>
<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">5. </span><span style="font-size:17px;font-weight:700;color:#1565C0;">常见问题</span></div><div style="padding:16px 20px;"></div></div>
### 第三体：自动化——让知识自己动起来

Confluence的宏和插件让知识库“活”起来。  
**动态目录宏**：自动生成当前页面的目录，长文档秒变导航图。  
**Jira宏**：在知识库页面内直接嵌入Jira issue，bug状态实时更新。  
**图表宏**：用SQL查数据库，自动生成测试覆盖率饼图。

代码示例：用Jira宏嵌入bug列表

效果：页面显示实时bug列表，点击直接跳转Jira。

**自动化工作流**：  
- 新人加入，自动发送“新手必读”页面链接  
- bug关闭后，自动创建根因分析页面  
- 每周五，自动生成“本周知识贡献排行榜”

## 03 从0到1：30分钟搭建你的测试知识库

别被“搭建”两个字吓到。  
30分钟，三步走。

<div style="margin:24px 0;border:1px solid #E3F2FD;border-radius:8px;background:#FAFAFA;overflow:hidden;"><div style="display:flex;align-items:center;gap:12px;padding:12px 20px;background:linear-gradient(135deg,#E3F2FD,#BBDEFB);"><span style="width:36px;height:36px;background:#2196F3;color:#fff;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-weight:bold;font-size:16px;flex-shrink:0;">前列步：</span><span style="font-size:17px;font-weight:700;color:#1565C0;">创建空间（5分钟）</span></div><div style="padding:16px 20px;"><p>Confluence顶部菜单 → 创建空间 → 选择“团队空间” → 命名“测试知识库”</p>
<p>空间权限：测试团队读写，其他团队只读。</p>
<h3 id="第二步建立骨架15分钟" style="color:#1976D2;margin-top:24px;">第二步：建立骨架（15分钟）</h3>
<p>在空间里创建四个优秀页面：</p>
<p>1. <strong>首页</strong>：放导航图、新手必读、最新动态</p>
<p>2. <strong>测试方案</strong>：放所有模块的测试方案模板和实例</p>
<p>3. <strong>bug根因分析</strong>：按模块或版本分类</p>
<p>4. <strong>环境与工具</strong>：环境配置、工具安装、常见问题</p>
<p>每个页面下，用“子页面”功能创建具体内容。</p>
<p>比如“测试方案”下：登录模块、支付模块、报表模块。</p>
<h3 id="第三步填充内容10分钟" style="color:#1976D2;margin-top:24px;">第三步：填充内容（10分钟）</h3>
<p>别追求完美，先填“最痛的点”：</p>
<ul style="list-style:none;padding-left:0;margin:12px 0;">
<li style="position:relative;padding:4px 0 4px 24px;line-height:1.8;"><span style="color:#2196F3;font-weight:bold;position:absolute;left:4px;">&#9658;</span>团队最近踩的最大的坑</li>
<li style="position:relative;padding:4px 0 4px 24px;line-height:1.8;"><span style="color:#2196F3;font-weight:bold;position:absolute;left:4px;">&#9658;</span>新人问得最多的问题</li>
<li style="position:relative;padding:4px 0 4px 24px;line-height:1.8;"><span style="color:#2196F3;font-weight:bold;position:absolute;left:4px;">&#9658;</span>环境配置的“雷区”</li>
</ul>
<p>用模板快速写一个页面，比如：</p></div></div>
# 常见问题：环境部署失败
## 问题1：Docker容器启动报错
- 原因：端口被占用  
- 解决：`netstat -tulpn | grep 8080` 找到进程，kill掉
- 预防：使用`docker-compose.yml`中的端口映射变量

import requests
from datetime import datetime, timedelta

# Confluence API配置
base_url = "https://your-domain.atlassian.net/wiki/rest/api"
auth = ("your-email", "your-api-token")

# 获取30天未更新的页面
thirty_days_ago = datetime.now() - timedelta(days=30)
response = requests.get(
    f"{base_url}/content/search",
    params={
        "cql": f"lastModified < '{thirty_days_ago.isoformat()}'",
        "limit": 100
    },
    auth=auth
)

# 输出待更新页面列表
for page in response.json()["results"]:
    print(f"需要更新：{page['title']} (最后更新：{page['version']['when']})")

import requests
import json
from bs4 import BeautifulSoup

# 获取Confluence页面内容
page_id = "123456"
response = requests.get(
    f"https://your-domain.atlassian.net/wiki/rest/api/content/{page_id}?expand=body.storage",
    auth=("email", "api-token")
)

# 解析页面内容，提取测试用例
soup = BeautifulSoup(response.json()["body"]["storage"]["value"], "html.parser")
test_cases = []
for table in soup.find_all("table"):
    rows = table.find_all("tr")
    for row in rows[1:]:  # 跳过表头
        cols = row.find_all("td")
        test_cases.append({
            "name": cols[0].text.strip(),
            "steps": cols[1].text.strip(),
            "expected": cols[2].text.strip()
        })

# 生成pytest脚本
with open("test_login.py", "w") as f:
    f.write("import pytest\n\n")
    for tc in test_cases:
        f.write(f"""
def test_{tc['name'].replace(' ', '_')}():
    \"\"\"{tc['name']}\"\"\"
    # {tc['steps']}
    # 断言：{tc['expected']}
    assert True
""")
print(f"生成 {len(test_cases)} 个测试用例")