search

the-core-studio / vox-issue

MIT License
0 stars 0 forks source link

Statistic for PDF or even more types of Media #122

Open tclzcja opened 2 months ago

tclzcja commented 2 months ago

For PDF it's 0% or 100% for now.

tclzcja commented 1 week ago

Reminder: Now statistic.unwatched/watched_student_view ONLY takes video into consideration, because it's doing:

INNER JOIN public.media ON public.media.section_id = public.section.id
INNER JOIN public.file ON public.file.sha256 = public.media.video_sha256

So ONLY media with video_sha256 will exists in the view, other medias won't event exists.

To add more types we need to modify this view, even modify the logic of watch_time table.