python抓取jenkins slave总数、online数、offline数写道mysql并展现

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了python抓取jenkins slave总数、online数、offline数写道mysql并展现，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1247字，纯文字阅读大概需要2分钟。

内容图文

python抓取jenkins slave总数、online数、offline数写道mysql并展现到grafana：

mysql -u root -p'xxxx'

create database jenkins default character set utf8;
create table slaves(time datetime,online float,offline float,total float);
grant all on ming.* to aa@'10.0.0.2' identified by 'xxxx';
exit

apt-get install python-jenkins

apt-get install python-pymysql

vi aa.py

#!/usr/bin/python

#coding:utf-8

import jenkins
import collections
import pymysql
import time

server = jenkins.Jenkins('http://10.0.0.2:8080/jenkins', username="ming", password="xxxxx")

nodes = server.get_nodes()

To = len(nodes)

on = collections.Counter(str(nodes))['F']

off = collections.Counter(str(nodes))['T']

ti = time.localtime()

conn = pymysql.connect(host="10.0.0.3",port=3306,database='jenkins',user='ming',password='xxxxx',charset='utf8')
cur = conn.cursor()
cur.execute("insert into slaves (time,online,offline,total) values (%s,%s,%s,%s)", [ti,on,off,To])
conn.commit()
conn.close();
print ('Data has been inserted')

:wq

python aa.py

grafa:

select UNIX_TIMESTAMP(time) as time_sec, total-1 as total from slaves group by time_sec;

select UNIX_TIMESTAMP(time) as time_sec, online-1 as online from slaves group by time_sec;

select UNIX_TIMESTAMP(time) as time_sec, offline as offline from slaves group by time_sec;

内容总结

以上是互联网集市为您收集整理的python抓取jenkins slave总数、online数、offline数写道mysql并展现全部内容，希望文章能够帮你解决python抓取jenkins slave总数、online数、offline数写道mysql并展现所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端