U ]0h7@stdZddlmZddlmZddlmZddlm Z ddl m Z ddl m Z mZGdd d e ZGd d d e Zd S) a Channel Audio Management Models This module contains models for managing channel jingles, station IDs, and audio detection: - Jingle: Audio content played during broadcasts - JingleDetection: Detection logs for jingles in live streams These models handle audio fingerprinting, scheduling, and automatic detection of jingles in broadcast streams for compliance and monitoring purposes. )models)timezone) gettext_lazy) BaseModel)Channel)jingle_upload_pathmd5_upload_pathcseZdZdZdedfdedfdedfded fd ed fd ed fdedfdedfdedfdedfdedfg Zdedfdedfdedfdedfd ed!fd"ed#fd$ed%fd&ed'fd(ed)fd*ed+fd,ed-fd.ed/fd0ed1fg Zd2ed3fd4ed5fd6ed7fd8ed9fd:ed;fded?ed@dAdAdBZ ej dCedDedEdFZej dGeedHedIdJdKZej dGed.edLedMdJdNZejed6edOedPdQZejeedRedSdTZejeedUedVdJdJdWZejedXedYdJdJdZZejed[ed\dJdJdZZejedJed]ed^d_ZejdJed`edadbZ ejdJedcedddbZ!ej"dJedeedfdgZ#ej$dJdJedhedidjZ%ej$dJdJedkedldjZ&eje'dJedmednd_Z(ejdoedpedqdgZ)ej*dJdJedredsdjZ+GdtduduZ,dvdwZ-dxdyZ.dzd{Z/d|d}Z0fd~dZ1ddZ2ddZ3fddZ4ddZ5ddZ6ddZ7e8ddZ9e8ddZ:e8ddZ;e8ddZddZ?Z@S)Jinglea Channel jingles and station IDs with enhanced placement types. Represents audio content that is played during broadcasts including station identifications, bumpers, promos, and transition sounds. Supports scheduling, audio fingerprinting, and usage tracking. Attributes: channel: Foreign key to the channel this jingle belongs to name: Human-readable name for the jingle jingle_type: Type of jingle (station_id, bumper, promo, etc.) placement_type: When the jingle should be played in the broadcast file: Audio file for the jingle duration: Length of the jingle in seconds audio_fingerprint: Audio fingerprint data for automatic detection frames_fingerprint: I-Frame fingerprint data for automatic detection is_active: Whether this jingle is currently active priority: Priority level for jingle selection start_date: Optional start date for jingle validity end_date: Optional end date for jingle validity time_slots: JSON field with time ranges when jingle can play play_count: Number of times this jingle has been played last_played: Timestamp of last play Related Models: - Channel: One-to-many relationship (channel can have multiple jingles) - JingleDetection: One-to-many relationship (jingle can have multiple detections) Z station_idz Station IDZbumperZBumperZpromoZPromoZ transitionZ TransitionZcommercial_breakzCommercial BreakZ news_introz News IntroZ weather_introz Weather IntroZ sports_introz Sports IntroZ music_introz Music IntroZ show_openerz Show OpenerZ show_closerz Show Closerstartz Start of Showendz End of Showcommercial_startzStart of Commercial Breakcommercial_endzEnd of Commercial BreakZprogram_transitionzProgram TransitionZsegment_transitionzSegment TransitionhourlyZHourlyZ half_hourlyz Half HourlyZquarter_hourlyzQuarter HourlyZ top_of_hourz Top of HourZbottom_of_hourzBottom of HourrandomzRandom Placementmanualz Manual OnlyzVery LowZLowZNormalZHighz Very HighCriticaljinglesrzChannel this jingle belongs toF) on_delete related_name verbose_name help_textblanknullz Jingle Namez#Human-readable name for this jingle) max_lengthrrz Jingle TypezType of jingle contentT)r choicesrrdb_indexzPlacement Typez2When this jingle should be played in the broadcast)r r"defaultrrr#zPriority LevelzEPriority level for jingle selection (higher number = higher priority))r"r$rrz Audio FilezHAudio file for this jingle (automatically organized by channel and date)) upload_torrzMD5 Checksum Filez>MD5 checksum file (automatically generated after audio upload))r%rrrrzDuration (seconds)z!Duration of the jingle in seconds)rrrrzFile Size (bytes)zSize of the audio file in byteszAudio Metadataz@Additional audio metadata (bitrate, sample rate, channels, etc.)r$rrrAudio Fingerprintz9Audio fingerprint data for automatic detection in streams)rrrzFrames Fingerprintz:Frames fingerprint data for automatic detection in streamsz Is Activez'Whether this jingle is currently active)r$rrz Start Datez7Optional start date for when this jingle becomes active)rrrrzEnd Datez7Optional end date for when this jingle becomes inactivez Time Slotsz2JSON list of time ranges when this jingle can playrz Play Countz+Number of times this jingle has been playedz Last Playedz-Timestamp of when this jingle was last playedc@seZdZedZedZdZdddgZej ddgdej d dgdej d dd gdgZ ej ej d d ddej ej d dddgZ dS)z Jingle.Metar Jinglesrchannelz -created_atname is_activefieldsplacement_typepriority created_atr)Z duration__gteZpositive_duration)checkr*)Zfile_size__gteZpositive_file_sizeN)__name__ __module__ __qualname___rverbose_name_pluraldb_tableorderingrIndexindexesCheckConstraintQ constraintsr>r>7/var/www/html/Focus/src/apps/channels/models/jingles.pyMetas"   r@cCs |jd|jr|jjnddS)Nz (z No Channel))r*r)selfr>r>r?__str__szJingle.__str__c Cs|js dSt}|jr*||jkr*dS|jrB||jkrBdS|jr|}|jD]r}zPtj |dd}tj |dd}||kr|krnnWdSWqVt t fk rYqVYqVXqVdSdS)aP Check if jingle can be played at the current time. Returns: bool: True if jingle can be played now, False otherwise Checks: - Jingle is active - Current date is within start/end date range - Current time is within allowed time slots Fr z%H:%Mr T) r+rnow start_datedateend_date time_slotstimedatetimestrptimeKeyError ValueError)rCrEZ current_timeslot start_timeend_timer>r>r? can_play_nows&    zJingle.can_play_nowcCs,|jd7_t|_|jddgddS)z Mark jingle as played and update usage statistics. Updates: - Increments play_count - Sets last_played to current timestamp r play_count last_played update_fieldsN)rSrrErTsaverBr>r>r? mark_played s zJingle.mark_playedcCs|j|j|j|dS)z Get usage statistics for this jingle. Returns: dict: Dictionary containing usage statistics rSrTr+rRrYrBr>r>r?get_usage_stats,s zJingle.get_usage_statscsd}|jrHz tjj|jd}|j|jk}WqLtjk rDd}YqLXnd}tj|||r|jr|| tjdddgddS) zb Enhanced save method with automatic MD5 generation and file metadata extraction. F)pkTmd5_fileduration file_sizerUN) r[r(objectsgetfile DoesNotExistsuperrW_generate_md5_file_extract_file_metadata)rCargskwargsZ is_new_fileZ old_instance __class__r>r?rW:s  z Jingle.savec s js dSzt}jdtfdddD]}||q2|}tj jj }|d|d}tj |dd}t |}dd l m}jj|||d d d WnRtk r} z2ddl} | t} | d jdt| W5d} ~ XYnXdS)zI Generate MD5 checksum file for the uploaded audio file. Nrcs jdSNirareadr>rBr>r?az+Jingle._generate_md5_file..rnz  z.md5) ContentFileutf-8F)rWz"Failed to generate MD5 for jingle : )rahashlibmd5seekiterupdate hexdigestospathbasenamer*splitextrdjango.core.files.baserpr\rWencode Exceptionlogging getLoggerr2error id_jinglestr) rCmd5_hashchunkZ md5_checksumZoriginal_filenameZ md5_contentZ md5_filenameZmd5_pathrperloggerr>rBr?rdTs,       zJingle._generate_md5_filec Cs|js dSddl}|t}z |jj|_d}zddlm}t|jdrR|jj n|jjj }||}|rffmpeg/ffprobe not found. Install ffmpeg for audio processing.z4pydub not installed. Install with: pip install pydubz'Failed to extract metadata with pydub: )rzz,Extracted metadata using librosa for jingle z8librosa not installed. Install with: pip install librosaz)Failed to extract metadata with librosa: .wavrz)Extracted metadata using wave for jingle z&Failed to extract metadata with wave: z-vquietz -print_formatjsonz -show_formatz -show_streams)capture_outputtexttimeoutformatr]streamsZ codec_typeaudioz,Extracted metadata using ffprobe for jingle z)Failed to extract metadata with ffprobe: zUnexpected error with ffprobe: z&Could not extract duration for jingle z). Setting default duration to 30 seconds.zInvalid duration z for jingle z. Setting to 30 seconds.z&Failed to extract metadata for jingle rrr^)5rarrr2sizer^Zmutagenrhasattrrzr*rintrr]rrrrrrrmetadata ImportErrorwarningrZpydubrZ pydub.utilsr from_filelenlibrosaZ get_durationlowerendswithwaveopenZ getnframesZ getframerate subprocessrrun returncodeloadsstdoutfloatr`TimeoutExpiredCalledProcessErrorFileNotFoundErrorJSONDecodeErrorr)rCrrZmetadata_extractedZ MutagenFile file_pathZ audio_fileZadditional_metadatarrrrrduration_secondsrZwav_fileframesrrrcmdresultdatar]streamr>r>r?re|s           &    &    & *&          $& zJingle._extract_file_metadatacs`t|jr\ddddddg}tj|jjd}||kr\tdt d  d |id S) z# Model validation. z.mp3rz.aacz.m4az.oggz.flacrraz3Only audio files are allowed. Supported formats: {}z, N) rccleanraryrzr|r*rValidationErrorr5rjoin)rCallowed_extensionsZfile_extensionrhr>r?r-s z Jingle.cleancCs|jr|jjSdS)z0 Get the URL of the audio file. N)raurlrBr>r>r? get_file_url?szJingle.get_file_urlcCs|jr|jjSdS)z7 Get the URL of the MD5 checksum file. N)r\rrBr>r>r? get_md5_urlEszJingle.get_md5_urlcsjr jsdSzxjdjd}|d}t}jdtfdddD]}| |q`| }| | kWSt k rYdSXdS)z Verify the integrity of the audio file using the stored MD5 checksum. Returns: bool: True if file integrity is verified, False otherwise Frrqcs jdSrjrkr>rBr>r?rm^rnz.Jingle.verify_file_integrity..rnN) rar\rurldecodesplitrsrtrvrwrxrr)rCZstored_md5_contentZ stored_md5rrZ current_md5r>rBr?verify_file_integrityKs     zJingle.verify_file_integritycCs0|js dS|jd}|jd}|dd|dS)z2 Get duration formatted as MM:SS. z00:00<02d:)r])rCminutessecondsr>r>r?formatted_durationgs   zJingle.formatted_durationcCsN|js dSt|j}dD](}|dkr8|dd|S|d}q|ddS)zC Get file size formatted in human-readable format. z0 B)BKBMBGBg@z.1f z TB)r^r)rCrunitr>r>r?formatted_file_sizess  zJingle.formatted_file_sizecCs|jr|jdSdS)zGet bitrate from metadata.rNrr`rBr>r>r?rszJingle.bitratecCs|jr|jdSdS)zGet sample rate from metadata.rNrrBr>r>r?rszJingle.sample_ratecCs|jr|jdSdS)z%Get number of channels from metadata.rNrrBr>r>r?rszJingle.channelscCs*|jr&tj|jjdddSdS)z%Get audio format from file extension.r.N)raryrzr|r*upperreplacerBr>r>r? audio_formats zJingle.audio_formatcCs~|j|j|jd}|jrz|jr.|jd|d<|jrD|jd|d<|jrz|jdkrXdn|jdkrfd n |jd }||d <|S) z Get formatted metadata for display purposes. Returns: dict: Formatted metadata information )r]r^rz kbpsrz HzrrZMonorZStereoz channelsr)rrrrrrr)rCZ display_infoZ channel_textr>r>r?get_metadata_displays(zJingle.get_metadata_display)Ar2r3r4__doc__r5Z JINGLE_TYPESZPLACEMENT_TYPESZPRIORITY_LEVELSr ForeignKeyrCASCADEr) CharFieldr*Z jingle_typer.PositiveSmallIntegerFieldr/ FileFieldrrarr\PositiveIntegerFieldr]PositiveBigIntegerFieldr^ JSONFielddictr TextFieldaudio_fingerprintframes_fingerprint BooleanFieldr+ DateFieldrFrHlistrIrS DateTimeFieldrTr@rDrRrXrZrWrdrerrrrpropertyrrrrrrr __classcell__r>r>rhr?r sR                                  &  (2       r c@seZdZdZdedfdedfdedfgZded fd ed fd ed fdedfgZeje ej dededdZ eje ej dededdZ ejdededdZejededdZejededdZejd d!ed"ed#d$Zejd%eded&ed'd(Zejed)ed*dZejd+eded,ed-d(Zejeded.ed/d0ZGd1d2d2Zd3d4Zed5d6Zed7d8Z ed9d:Z!d;d<Z"dDd>d?Z#dEd@dAZ$dBdCZ%d=S)FJingleDetectiona Log of detected jingles in live streams. Records when jingles are automatically detected in broadcast streams using audio/video fingerprinting. Used for compliance monitoring, ad break detection, and broadcast analysis. Attributes: channel: Foreign key to the channel where detection occurred jingle: Foreign key to the detected jingle detected_at: Timestamp when detection was recorded start_timestamp: When the jingle started playing in the stream end_timestamp: When the jingle ended playing in the stream confidence_score: Detection confidence from 0.0 to 1.0 detection_method: Method used for detection stream_position: Position in stream where jingle was detected status: Validation status of the detection metadata: Additional detection metadata Related Models: - Channel: Many-to-one relationship - Jingle: Many-to-one relationship detectedZDetected confirmedZ Confirmedfalse_positivezFalse Positiverr'rzI-Frame FingerprintcombinedzCombined Audio/FramerzManual Detectionjingle_detectionsrz%Channel where the jingle was detected)rrrrZ detectionsr zThe jingle that was detectedTz Detected Atz-When the detection was recorded in the system) auto_now_addrrz Start Timez-When the jingle started playing in the stream)rrzEnd Timez+When the jingle ended playing in the streamrrzConfidence Scorez*Detection confidence score from 0.0 to 1.0) max_digitsdecimal_placesrr2zDetection MethodzMethod used for detection)r r"r$rrzStream PositionzAPosition in stream where jingle was detected (seconds from start)r!Statusz#Validation status of this detectionMetadataz,Additional detection metadata and parametersr&c@sneZdZdZdgZedZedZej ddgdej ddgdej d d gdej d dgdej d gdgZ d S)zJingleDetection.Metarz -detected_atzJingle DetectionzJingle Detectionsr) detected_atr,jinglestart_timestamp end_timestampstatusconfidence_scoreN) r2r3r4r7r8r5rr6rr9r:r>r>r>r?r@s r@cCs|jjd|jjd|jS)Nz detected on z at )rr*r)rrBr>r>r?rD)szJingleDetection.__str__cCs |jr|jr|j|jSdS)z Get detection duration in seconds. Returns: float: Duration of the detected jingle in seconds r)rr total_secondsrBr>r>r?r],s zJingleDetection.durationcCs |jdkS)z&Check if detection has been confirmed.rrrBr>r>r? is_confirmed8szJingleDetection.is_confirmedcCs |jdkS)z/Check if detection is marked as false positive.rrrBr>r>r?is_false_positive=sz!JingleDetection.is_false_positivecCsv|jjdkrnzJtjj|jd|j|jtjddddgd }|rT|j|j  WSWntj k rlYnX|jj S)aO Infer ad break duration based on jingle placement. For jingles that mark the start of commercial breaks, attempts to find the corresponding end-of-break jingle to calculate the actual ad break duration. Returns: int: Estimated ad break duration in seconds r r )rrr)r)Zjingle__placement_typeZstart_timestamp__gtZstart_timestamp__ltZ status__in)rr.rr_filterr)rr timedeltafirstrrrbZmax_ad_duration)rCZ end_detectionr>r>r?infer_ad_break_durationBs  z'JingleDetection.infer_ad_break_durationNcCsHd|_|r4d|jkr"t||jd<t|jd<|jddgddS)z Mark detection as confirmed. Args: confirmed_by: Optional user who confirmed the detection r confirmed_byZ confirmed_atrrrUNrrrrrE isoformatrW)rCr r>r>r?confirm_detection`s  z!JingleDetection.confirm_detectioncCsHd|_|r4d|jkr"t||jd<t|jd<|jddgddS)z Mark detection as false positive. Args: marked_by: Optional user who marked this as false positive r marked_byZmarked_false_positive_atrrrUNr )rCr r>r>r?mark_false_positivens  z#JingleDetection.mark_false_positivec Cs.|jj|jj|jt|j|j|j|j|j dS)z Get a summary of this detection. Returns: dict: Summary information about the detection )Z jingle_name channel_namer]Z confidencemethodrrstream_position) rr*r)r]rrdetection_methodrrrrBr>r>r?get_detection_summary|sz%JingleDetection.get_detection_summary)N)N)&r2r3r4rr5ZDETECTION_STATUSZDETECTION_METHODSrrrrr)r rrrrr DecimalFieldrrrrrrrrrr@rDrr]rrrr rrr>r>r>r?rs                rN)r django.dbr django.utilsrdjango.utils.translationrr5apps.common.modelsrapps.channels.models.channelsrZapps.channels.utilsrrr rr>r>r>r?s     "