confluence二次开发,开发API & JIRA

youyouran2017  

Confluence是一个专业的企业知识管理与协同软件，一个专业的wiki

1.安装

JDBC的url:

因为mysql版本是5.7，所以要去掉engine部分，这里是大坑，尼玛

jdbc:mysql://192.168.20.211:3306/confluence?useUnicode=true&characterEncoding=utf8

获取space的content
curl -u admin:123456  http://10.208.231.165/rest/api/content?spaceKey=pay&limit=10&start=20 (最多500返回500条)


通过名称获取单个page的信息(可以获取该page的id), confluence里不允许添加重名的文章，所以不用担心重名
 kwargs = {'url' : 'http://192.168.20.211:10019/rest/api/content', 
             'method' : 'GET', 
             'params' : 'spaceKey=FISH&title=fishtest',
             'headers' :  dictHeader} 


获取子contenet(先通过标题获取id)
curl -u admin:123456 http://192.168.20.211:10019/rest/api/content/720903/child?expand=page&start=20&limit=10


获取文章内容
curl -u admin:123456 http://192.168.20.211:10019/rest/api/content/1015810?expand=space,body.view,version,container
curl -u admin:123456 http://192.168.20.211:10019/rest/api/content/1015810?expand=body.view

参考文档

Confluence REST API examples

使用rest api操作conflunce

curl -u admin:123456 -X POST -H 'Content-Type: application/json' -d' { "key":"RAID", "name":"Raider", "type":"global", "description":{"plain": { "value": "Raider Space for raiders","representation": "plain" }}}' http://localhost:8080/rest/api/space

数据库

cwd_user email信息

获取空间管理员tel

err := m.Mysql.QueryRow(`select string_val from OS_PROPERTYENTRY where entity_key =
		    'confluence.user.profile.phone' and entity_id = (  select CONTENTID from CONTENT where USERNAME = ?
		    and CONTENTTYPE = 'USERINFO');`, 
		    user.userId).Scan(&user.Tel)

空间用户权限

VIEWSPACE,REMOVEOWNCONTENT，EDITSPACE, SETSPACEPERMISSIONS, REMOVEPAGE, REMOVECOMMENT,REMOVEBLOG

CREATEATTACHMENT,REMOVEATTACHMENT,EDITBLOG,EXPORTSPACE,REMOVEMAIL,SETPAGEPERMISSIONS

JIRA使用配置

备份恢复

把备份文件从export目录拷贝到import目录,赋予可读取权限 chmod 666 filename

添加后处理的时候选择最后一个类别

JIRA问题状态已关闭，但是解决结果还是未解决

https://www.cnblogs.com/kaola8023/p/8609155.html