merchant-eye/pulse-board

PulseBoard: The Trello Replacement on Dodil

• dodil-challenge
• dodil-challenge-boards

A remix template · 0 remixes · Remix merchant-eye/pulse-board

app/boards/infrastructure/dodil.py

"""The Dodil side: a service-account token, DataK3 on the Postgres wire, and Dodil Models.

The remix generated the service account and put its id and secret into the repo's CI secrets;
.dodil/deploy.yaml hands them to the app as environment variables.
"""
import json
import os
import re
import threading
import time
from typing import List

import httpx
import psycopg

TOKEN_URL = "https://id.dodil.io/realms/dodil/protocol/openid-connect/token"
PG_HOST = os.environ.get("PG_HOST", "pg.uk-lon-1.dodil.io")
MODELS_BASE = os.environ.get("MODELS_BASE", "https://api.dodil.io/v1").rstrip("/")
CHAT_MODEL = os.environ.get("CHAT_MODEL", "kimi-k2.6")

_lock, _tok = threading.Lock(), {"v": None, "exp": 0.0}


def token() -> str:
    """A short-lived service-account token (client_credentials), cached until near expiry.
    It is the DataK3 password AND the Models bearer."""
    with _lock:
        if _tok["v"] and time.time() < _tok["exp"] - 60:
            return _tok["v"]
        r = httpx.post(TOKEN_URL, timeout=15, data={
            "grant_type": "client_credentials",
            "client_id": os.environ["DODIL_SERVICE_ACCOUNT_ID"],
            "client_secret": os.environ["DODIL_SERVICE_ACCOUNT_SECRET"]})
        r.raise_for_status()
        d = r.json()
        _tok.update(v=d["access_token"], exp=time.time() + float(d.get("expires_in", 300)))
        return _tok["v"]


def connect() -> psycopg.Connection:
    """DataK3 speaks Postgres: the database is the bucket, TLS is required."""
    return psycopg.connect(host=PG_HOST, port=5432, dbname=os.environ["BUCKET"], user="token",
                           password=token(), sslmode="require", autocommit=True)


def chat(prompt: str) -> str:
    """One chat call to Dodil Models (OpenAI-compatible). The gateway wraps the OpenAI body as
    {"status": ..., "data": {...}}, so unwrap it before reading choices."""
    r = httpx.post(f"{MODELS_BASE}/chat/completions", timeout=120,
                   headers={"Authorization": f"Bearer {token()}"},
                   json={"model": CHAT_MODEL, "messages": [{"role": "user", "content": prompt}]})
    r.raise_for_status()
    body = r.json()
    inner = body.get("data")
    if isinstance(inner, dict) and "choices" in inner:
        body = inner
    return body["choices"][0]["message"]["content"] or ""


class ModelsAssistant:
    def checklist(self, card_title: str) -> List[str]:
        text = chat("Break this task into a short checklist of 3 to 6 concrete steps. "
                    "One step per line, no numbering, nothing else.\n\nTask: " + card_title)
        return [line.strip("-*• 0123456789.").strip() for line in text.splitlines() if line.strip()][:8]

    def summary(self, board_title: str, cards_summary: str) -> str:
        prompt = (f"Provide a concise daily standup summary for the project board '{board_title}'. "
                  f"Highlight key progress, what's currently in progress, what's overdue or needs urgent attention, "
                  f"and recommendations.\n\nCards:\n{cards_summary}")
        return chat(prompt)

    def find_similar(self, target_title: str, candidate_titles: List[dict]) -> List[dict]:
        candidates_str = "\n".join([f"- ID: {c['id']} | Title: {c['title']} | Status: {c['list_name']}" for c in candidate_titles])
        prompt = (f"Given the task '{target_title}', identify which of the following tasks are conceptually related, "
                  f"similar, or dependent.\n\nCandidates:\n{candidates_str}\n\n"
                  f"Output ONLY a JSON array of objects with keys 'id', 'title', 'reason', e.g. [{{'id': '...', 'title': '...', 'reason': '...'}}]. If none, output [].")
        res = chat(prompt)
        match = re.search(r"\[.*\]", res, re.DOTALL)
        if match:
            try:
                parsed = json.loads(match.group(0))
                if isinstance(parsed, list):
                    return parsed
            except Exception:
                pass
        return []