Coverage for app/backend/src/couchers/helpers/discussions.py: 100%
7 statements
« prev ^ index » next coverage.py v7.17.3, created at 2026-11-16 22:03 +0000
« prev ^ index » next coverage.py v7.17.3, created at 2026-11-16 22:03 +0000
1from sqlalchemy import select
2from sqlalchemy.sql.selectable import Exists
4from couchers.context import CouchersContext
5from couchers.models import Comment, Discussion
6from couchers.sql import where_moderated_content_visible, where_users_column_visible
9def has_visible_comments(context: CouchersContext) -> Exists:
10 return (
11 where_moderated_content_visible(
12 where_users_column_visible(
13 select(Comment.thread_id)
14 .select_from(Comment)
15 .where(Comment.thread_id == Discussion.thread_id)
16 .where(Comment.deleted == None),
17 context,
18 Comment.author_user_id,
19 ),
20 context,
21 Comment,
22 is_list_operation=True,
23 )
24 .correlate(Discussion)
25 .exists()
26 )