-
Notifications
You must be signed in to change notification settings - Fork 0
/
fail-watcher.py
60 lines (54 loc) · 1.74 KB
/
fail-watcher.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
import time, datetime, json, os
import requests
import pymysql
from db import JobRepository
from model import Job
def send_to_slack(url, job: Job):
data = {
'text':
'Job failed :ghost:',
'attachments': [
{
"title": 'host',
"text": job.host,
},
{
"title": 'command',
"text": '```\n{}\n```'.format(job.command),
"mrkdwn_in": ["text"],
},
{
"title": 'error',
"text": '```\n{}\n```'.format(job.message),
"mrkdwn_in": ["text"],
"color": 'danger',
},
],
}
requests.post(url, data=json.dumps(data))
if __name__ == '__main__':
import argparse
parser = argparse.ArgumentParser()
parser.add_argument('--host', default='localhost')
parser.add_argument('--user', default='jobmanager')
parser.add_argument('--password', default='jobmanager')
parser.add_argument('--database', default='jobmanage_py')
parser.add_argument('--slack-api-url', default=os.environ.get('SLACK_WEBHOOK_URL'))
args = parser.parse_args()
db = connection = pymysql.connect(
host=args.host,
user=args.user,
password=args.password,
database=args.database,
cursorclass=pymysql.cursors.DictCursor,
autocommit=True,
)
repo = JobRepository(db)
last_time = datetime.datetime.now(tz=repo.tz).isoformat()
while True:
now = datetime.datetime.now(tz=repo.tz).isoformat()
failed_jobs = repo.get_failed_jobs_since(last_time)
for job in failed_jobs:
send_to_slack(args.slack_api_url, job)
last_time = now
time.sleep(30)