Bitbucket Runner CI 대기 문제, AI로 만든 간이 대시보드로 해결하기

flowchart LR
    subgraph Polling["1분 간격 수집"]
        API[Bitbucket API] --> Scheduler[APScheduler]
        Scheduler --> DB[(SQLite)]
    end

    subgraph Dashboard["웹 대시보드"]
        DB --> Stats[사용률 통계]
        DB --> Timeline[타임라인 차트]
        API --> Realtime[실시간 상태]
    end

    Dashboard --> Browser[브라우저]

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22

def record_runner_status():
    url = f"https://api.bitbucket.org/internal/workspaces/{WORKSPACE}/pipelines-config/runners"
    response = requests.get(url, auth=(BITBUCKET_USER, BITBUCKET_TOKEN))
    data = response.json()

    conn = sqlite3.connect(DB_PATH)
    c = conn.cursor()
    now = datetime.now()

    for runner in data.get('values', []):
        is_busy = 1 if runner.get('state', {}).get('step') else 0
        repo_name = None
        if is_busy and runner.get('state', {}).get('repository'):
            repo_name = runner['state']['repository'].get('full_name', '')

        c.execute('''
            INSERT INTO runner_snapshots (timestamp, runner_name, status, is_busy, repo_name)
            VALUES (?, ?, ?, ?, ?)
        ''', (now, runner['name'], runner.get('state', {}).get('status'), is_busy, repo_name))

    conn.commit()
    conn.close()

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

# 전체 러너가 모두 사용 중인 시간 (분)
c.execute('''
    SELECT COUNT(*) FROM (
        SELECT timestamp
        FROM runner_snapshots
        WHERE strftime('%H', timestamp) BETWEEN '09' AND '19'
          AND date(timestamp) = date('now', 'localtime')
        GROUP BY timestamp
        HAVING SUM(is_busy) = ?
    )
''', (runner_count,))

gdoc_arrow_left_alt AI 인프라 자동화 #2 채널이 곧 의도다 AI 인프라 자동화 #3 팀이 함께 쓰는 AI 에이전트 만들기 gdoc_arrow_right_alt