second_method.py

# Using jenkins jobs.py, jenkins.py, and build.py

from jenkinsapi.jenkins import Jenkins
import sqlite3
from datetime import datetime

# Decalared input for Username and Password
username = input('Your username: ')
password = input('Password: ')

# Initialization and connection
database = 'enkins.sqlite3'
jenkins_url = 'http://localhost:8080'
server = Jenkins(jenkins_url, username, password)
conn = sqlite3.connect(database)
c = conn.cursor()

# A dictionary that holds the jobs name as keys and status as values
dict = {}

for job_name, job_instance in server.get_jobs():
    if job_instance.is_running():
        status = 'RUNNING'
    elif job_instance.get_last_build_or_none() == None:
        status = 'UNBUILT'
    else:
        simple_job = server.get_job(job_instance.name)
        simple_build = simple_job.get_last_build()
        status = simple_build.get_status()

    i = datetime.now()
    checked_time = i.strftime('%Y/%m/%d %H:%M:%S')
    tuple1 = (job_instance.name, status, checked_time)
    c.execute("SELECT id FROM jenkins WHERE job_name = ?", (job_instance.name,))
    data = c.fetchone()
    if data is None:
        c.execute('INSERT INTO jenkins (job_name, status, date_checked) VALUES (?,?,?)', tuple1)
    else:
        tuple2 = (status, checked_time, job_instance.name)
        c.execute('UPDATE jenkins SET status=?, date_checked=? WHERE job_name=?', tuple2)

    # Add to dictionary
    dict[job_instance.name] = status

# Save/commit the changes
conn.commit()

# Close connection
conn.close()