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

1from sqlalchemy import select 

2from sqlalchemy.sql.selectable import Exists 

3 

4from couchers.context import CouchersContext 

5from couchers.models import Comment, Discussion 

6from couchers.sql import where_moderated_content_visible, where_users_column_visible 

7 

8 

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 )