""" Models for Video Pipeline """ import uuid from django.db import models def _createHex(): return uuid.uuid1().hex class Institution (models.Model): institution_code = models.CharField(max_length=4) institution_name = models.CharField(max_length=50) def __unicode__(self): return u'%s %s'.format(self.institution_name, self.institution_code) or u'' class Course (models.Model): course_name = models.CharField('Course Name', max_length=100) # TODO: Change Name (this is reversed) course_hold = models.BooleanField('Course Active', default=False) institution = models.CharField('Inst. Code', max_length=4) edx_classid = models.CharField('Class ID', max_length=5) # TODO: Create Default for 'this year' (e.g. 2017) semesterid = models.CharField('Semester', max_length=4) parent_ID = models.CharField( 'Parent Project', max_length=8, null=True, blank=True ) previous_statechange = models.DateTimeField( 'Previous Data Statechange', null=True, blank=True ) proc_loc = models.BooleanField('Mediateam Export', default=False) review_proc = models.BooleanField('Producer Review', default=False) last_vid_number = models.IntegerField('Last Video ID', default=0) # Youtube yt_proc = models.BooleanField('Process for Youtube', default=True) yt_logon = models.CharField( 'Youtube SFTP U/N', max_length=50, null=True, blank=True ) yt_channel = models.CharField( 'Youtube Channel ID', max_length=150, null=True, blank=True ) # 3Play Media (Transcription) tp_proc = models.BooleanField('Process for 3Play', default=False) tp_username = models.CharField( '3Play Username', max_length=50, null=True, blank=True ) tp_password = models.CharField( '3Play Password', max_length=50, null=True, blank=True ) EX = 'extended_service' DF = 'default' ES = 'expedited_service' RS = 'rush_service' SD = 'same_day_service' TP_SPEED_CHOICES = ( (EX, '10-Day/Extended'), (DF, '4-Day/Default'), (ES, '2-Day/Expedited'), (RS, '24 hour/Rush'), (SD, 'Same Day'), ) tp_speed = models.CharField( '3Play Turnaround', max_length=20, choices=TP_SPEED_CHOICES, default=DF ) tp_apikey = models.CharField( '3Play API Key', max_length=100, null=True, blank=True ) # Cielo24 c24_proc = models.BooleanField('Process for Cielo24', default=False) c24_username = models.CharField( 'Cielo24 Username', max_length=50, null=True, blank=True ) c24_password = models.CharField( 'Cielo24Password', max_length=50, null=True, blank=True ) STD = 'STANDARD' PRT = 'PRIORITY' C24_SPEED_CHOICES = ( (STD, 'Standard, 48h'), (PRT, 'Priority, 24h'), ) c24_speed = models.CharField( 'Cielo24 Turnaround', max_length=20, choices=C24_SPEED_CHOICES, default=STD ) MCH = 'MECHANICAL' PRM = 'PREMIUM' PRO = 'PROFESSIONAL' C24_FIDELITY_CHOICES = ( (MCH, 'Mechanical, 75%'), (PRM, 'Premium, 95%'), (PRO, 'Professional, 99%'), ) c24_fidelity = models.CharField( 'Cielo24 Fidelity', max_length=20, choices=C24_FIDELITY_CHOICES, default=PRO ) c24_hours = models.IntegerField( 'C24 Turnaround Override', null=True, blank=True ) c24_apikey = models.CharField( 'Cielo24 API Key', max_length=100, null=True, blank=True ) # TODO: Change field name s3_proc = models.BooleanField('Process for AWS S3/Mobile?', default=True) # TODO: Deprecate (HLS) Replace mobile_override = models.BooleanField( 'Low Bandwidth Override', default=False ) # TODO: Deprecate s3_dir = models.CharField( 'S3 Directory', max_length=50, null=True, blank=True ) # TODO: Change field name xue = models.BooleanField('Submit to VAL', default=False) # TODO: Change field name local_storedir = models.CharField( 'edX Studio URL (VAL)', max_length=5000, null=True, blank=True ) xuetang_proc = models.BooleanField('Submit to XuetangX', default=True) sg_projID = models.IntegerField('Shotgun Project ID', default=0) studio_hex = models.CharField( 'Studio Hex ID', max_length=50, default=_createHex, unique=True ) def __unicode__(self): return u'%s %s %s'.format( self.institution, self.edx_classid, self.course_name ) or u'' class Video (models.Model): # TODO: Change field name inst_class = models.ForeignKey(Course) video_active = models.BooleanField('Video Active?', default=True) client_title = models.CharField( 'Video (Client) Title', max_length=180, null=True, blank=True ) edx_id = models.CharField('VEDA Video ID', max_length=20) studio_id = models.CharField( 'Studio Upload ID', max_length=100, null=True, blank=True ) # Master File Properties video_orig_filesize = models.BigIntegerField( 'Master Filesize', null=True, blank=True ) video_orig_duration = models.CharField( 'Duration (Original)', max_length=50, null=True, blank=True ) video_orig_bitrate = models.CharField( 'Orig. Bitrate', max_length=15, null=True, blank=True ) video_orig_extension = models.CharField( 'Orig. File Extension', max_length=5, null=True, blank=True ) video_orig_resolution = models.CharField( 'Orig. Resolution', max_length=50, null=True, blank=True ) # Status video_trans_start = models.DateTimeField('Process Start', null=True, blank=True) video_trans_end = models.DateTimeField('Process Complete', null=True, blank=True) """ TODO: STATUS REMODEL: Change to 'Ingest', 'Queued', 'In Progress', 'Corrupt', 'Complete', 'Error', 'Duplicate', 'Review', 'Reject' Possile: 'Invalid' (for ingest detected) 'Retry' 'Delivery' (for celery states?) """ SI = 'Ingest' TQ = 'Transcode Queue' AT = 'Active Transcode' TR = 'Transcode Retry' TC = 'Transcode Complete' DU = 'Deliverable Upload' FC = 'File Complete' CF = 'Corrupt File' RH = 'Review Hold' RR = 'Review Reject' RP = 'Final Publish' YD = 'Youtube Duplicate' TRANS_STATUS_OPTIONS = ( (SI, "System Ingest"), (TQ, "Transcode Queue"), (AT, "Active Transcode"), (TR, "Transcode Retry"), (TC, "Transcode Complete"), (DU, "Deliverable Upload"), (FC, "File Complete"), ('Transcode Error', "Transcode Error"), (CF, "Corrupt File on Ingest"), (RH, "Review Hold"), (RR, "Review Rejected"), (RP, "Review to Final Publish"), (YD, "Youtube Duplicate"), ('Queue', "In Encode Queue"), ('Progress', "In Progress"), ('Complete', "Complete") ) video_trans_status = models.CharField( 'Transcode Status', max_length=100, choices=TRANS_STATUS_OPTIONS, default=SI ) video_glacierid = models.CharField('Glacier Archive ID String', max_length=200, null=True, blank=True) abvid_serial = models.CharField('VEDA Upload Process Serial', max_length=20, null=True, blank=True) stat_queuetime = models.FloatField('Video Avg. Queuetime (sec)', default=0) class Meta: get_latest_by = 'video_trans_start' def __unicode__(self): return u'%s'.format(self.edx_id) or u'' class Destination (models.Model): destination_name = models.CharField('Destination', max_length=200, null=True, blank=True) destination_active = models.BooleanField('Destination Active', default=False) destination_nick = models.CharField('Nickname (3 Char.)', max_length=3, null=True, blank=True) def __unicode__(self): return u'%s'.format(self.destination_name) or u'' class Encode (models.Model): encode_destination = models.ForeignKey(Destination) encode_name = models.CharField('Encode Name', max_length=100, null=True, blank=True) profile_active = models.BooleanField('Encode Profile Active', default=False) encode_suffix = models.CharField( 'Encode Suffix (No underscore)', max_length=10, null=True, blank=True ) MP4 = 'mp4' SRT = 'srt' WEBM = 'webm' MP3 = 'mp3' HLS = 'HLS' ProductFiletype = ( (MP4, "mpeg-4"), (SRT, "srt file"), (WEBM, "webm"), (MP3, "mp3"), (HLS, "HLS"), ) encode_filetype = models.CharField( 'Encode Filetype', max_length=50, choices=ProductFiletype, default=MP4 ) encode_bitdepth = models.CharField( 'Target Bit Depth / Rate Factor', max_length=50, null=True, blank=True ) encode_resolution = models.CharField( 'Target Resolution (Vert)', max_length=50, null=True, blank=True ) # TODO: Change field name product_spec = models.CharField( 'VAL Profile Name', max_length=300, null=True, blank=True) xuetang_proc = models.BooleanField('Submit to XuetangX', default=False) def __unicode__(self): return u'%s'.format(self.encode_name) class URL (models.Model): encode_profile = models.ForeignKey(Encode) videoID = models.ForeignKey(Video) encode_url = models.CharField('Destination URL', max_length=500, null=True, blank=True) url_date = models.DateTimeField('URL Updated', null=True, blank=True) encode_duration = models.CharField('Duration (sec)', max_length=50, null=True, blank=True) encode_bitdepth = models.CharField( 'Encoded Avg. Bitdepth', max_length=50, null=True, blank=True ) encode_size = models.IntegerField('File Size (bytes)', default="0", null=True, blank=True) val_input = models.BooleanField('Inputted to EDX-VAL?', default=False) xuetang_input = models.BooleanField('Inputted to XuetangX?', default=False) md5_sum = models.CharField('MD5 Sum', max_length=100, null=True, blank=True) class Meta: get_latest_by = 'url_date' def __unicode__(self): return u'%s : %s : %s'.format(self.videoID, self.encode_profile.encode_name, self.url_date) or u'' class VedaUpload (models.Model): """ Internal Upload Tool """ video_serial = models.CharField('Upload Process Serial', max_length=20) edx_studio_url = models.CharField( 'edX Studio URL (VAL)', max_length=500, null=True, blank=True ) client_information = models.CharField( 'Client Information Field', max_length=500, null=True, blank=True ) status_email = models.CharField( 'Status Target Email', max_length=100, null=True, blank=True ) upload_filename = models.CharField( 'Video (Client) Title', max_length=180, null=True, blank=True ) upload_date = models.DateTimeField( 'Upload Datetime', null=True, blank=True ) edx_id = models.CharField('VEDA Video ID', max_length=20) file_valid = models.BooleanField('Valid', default=False) final_report = models.BooleanField('Reported', default=False) file_complete = models.BooleanField('Complete', default=False) youtube_id = models.CharField( 'Youtube ID', max_length=100, null=True, blank=True ) comment = models.CharField( 'Comment/Info', max_length=500, null=True, blank=True ) class Meta: get_latest_by = 'upload_date' def __unicode__(self): return u'%s %s %s %s'.format( self.client_information, self.upload_filename, self.status_email, self.file_complete )