27:        stmt = stmt.where(SubjectLine.subject.ilike(f"%{q}%"))
30:    return {"total": total, "subjects": [{"id": s.id, "subject": s.subject,
41:    row = SubjectLine(user_id=user.id, subject=payload.subject.strip()[:500])
44:    return {"id": row.id, "subject": row.subject}
81:    existing = set((await db.execute(select(SubjectLine.subject).where(
100:        w.writerow([s.subject, s.use_count])
112:    row.subject = payload.subject.strip()[:500]
24:    subject_hint: str = ""
34:        out.append({"id": t.id, "name": t.name, "subject_hint": t.subject_hint,
54:    row = EmailTemplate(user_id=user.id, name=payload.name[:250], body_html=payload.body_html,
55:                        body_text=payload.body_text, subject_hint=payload.subject_hint[:500],
59:    return {"id": row.id, "name": row.name}
78:    return {"id": row.id, "name": row.name}
108:    return {"id": t.id, "name": t.name, "subject_hint": t.subject_hint,
121:    t.name = payload.name[:250]
