daemon.py 2.4 KB
Newer Older
Gregory Martin committed
1 2 3 4 5 6 7 8 9 10 11 12
"""
Youtube Primary Reporting / Callbacks
"""

import os
import sys
import datetime
from datetime import timedelta
import django

from django.utils.timezone import utc

Gregory Martin committed
13
from VEDA_OS01.models import Course, Video, Encode, URL
Gregory Martin committed
14 15 16 17 18 19 20 21

"""
Import Django Shit
"""
project_path = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
if project_path not in sys.path:
    sys.path.append(project_path)

22
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'VEDA.settings.local')
Gregory Martin committed
23 24 25 26 27 28 29

django.setup()

"""
Defaults
"""
data_window = datetime.datetime.utcnow().replace(tzinfo=utc) - \
Gregory Martin committed
30
    timedelta(days=3)
Gregory Martin committed
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102


def get_course(course_id):
    course = Course.objects.get(
        institution=course_id[0:3],
        edx_classid=course_id[3:8]
    )
    return course


def generate_course_list():

    course_list = []

    course_query = Course.objects.filter(
        previous_statechange__gt=data_window,
        yt_proc=True,
    )

    for course in course_query:
        if determine_missing_url(course_object=course) is True:
            if weed_dupes(course_list, course) is True:
                course_list.append(course)
    """
    Review Calls
    """
    review_date = datetime.datetime.utcnow().replace(tzinfo=utc) - \
        timedelta(days=10)
    review_query = Course.objects.filter(
        previous_statechange__gt=review_date,
        review_proc=True
    )
    if len(review_query) > 0:
        review_channel = Course.objects.get(
            institution='EDX',
            edx_classid='RVW01'
        )
        course_list.append(review_channel)

    return course_list


def weed_dupes(course_list, course):
    for c in course_list:
        if c.yt_logon == course.yt_logon:
            return False
    return True


def determine_missing_url(course_object):

    video_query = Video.objects.filter(
        inst_class=course_object,
        video_trans_start__gt=data_window
    )
    for v in video_query:
        salient_video = Video.objects.filter(edx_id=v.edx_id).latest()
        if salient_video.video_trans_status != "Corrupt File" and \
                salient_video.video_trans_status != "Review Hold":
            yt_url_query = URL.objects.filter(
                videoID=salient_video,
                encode_profile=Encode.objects.filter(
                    encode_suffix='100'
                )
            )
            if len(yt_url_query) == 0:
                return True
    return False


if __name__ == "__main__":
    pass