hPISrSSKJr SSKJr SSKJr SSKJrJ r SSK J r J r J r SSKJrJr SSKJrJrJrJrJr SS KrSS Kr"S S \ \ 5r"S S \ \ 5r"SS\ \ \ 5r"SS\ \ 5rg )a# Jingle Detection Models for Stream Processor Application This module contains Django models for managing jingle detection, ad break analysis, and related functionality. These models handle the storage and management of jingle templates, detection results, and ad break timing information. )models)User)timezone)MinValueValidatorMaxValueValidator)TimestampedModel UUIDModel StatusModel) StreamSession HLSSegment)validate_file_pathvalidate_slug_formatvalidate_name_formatvalidate_confidence_scorevalidate_template_contentNc\rSrSrSr\R "SS\/SS9r\R"SS\ /SS9r \R"SSS 9r \R "S \/S S 9r\R "S \/SS9r\R&"SSSS9r\R "S/SQSSS9r\R,"S\R.SSS9r\R,"\\R.SSS9r"SS5rSrSrS rS!rS"r g#)$JingleTemplatea Model representing a jingle template for detection. Jingle templates are reference images or video frames that are used to identify specific jingles in stream content. Each template represents a unique jingle that can be detected during stream processing. Attributes: name (CharField): Human-readable name for the jingle slug (SlugField): URL-friendly identifier description (TextField): Description of the jingle content image_path (CharField): Path to the reference image file similarity_threshold (FloatField): Threshold for detection matching is_active (BooleanField): Whether this template is active category (CharField): Category classification for the jingle created_by (ForeignKey): User who uploaded this template dTz"Human-readable name for the jingle) max_lengthunique validators help_textz&URL-friendly identifier for the jinglez-Description of the jingle content and contextblankrz0Path to the reference image file for this jingle)rrrg?z5Similarity threshold for positive detection (0.0-1.0))defaultrrz4Whether this jingle template is active for detectionrdb_indexr2))ad_startzAdvertisement Start)ad_endzAdvertisement End) program_startz Program Start) program_endz Program End) transition Transition)brandingzChannel Branding)otherOtherr(z'Category classification for this jinglerchoicesrrzstreams.Channeljingle_templatesz'Channel this jingle template belongs to on_delete related_namerz&User who uploaded this jingle templatec\rSrSrSrSrSS/r\R"S/S9\R"S/S9\R"S/S9/r S r g ) JingleTemplate.MetaszJingle TemplatezJingle Templatescategorynameslugfields is_activeN __name__ __module__ __qualname____firstlineno__ verbose_nameverbose_name_pluralorderingrIndexindexes__static_attributes__r9?C:\Users\brahi\OneDrive\Desktop\Code\src\apps\jingles\models.pyMetar1ssH( 0' LL ) LL . LL - rErGc:URSURS3$)z-String representation of the jingle template. ())r4r3selfs rF__str__JingleTemplate.__str__}s))Bt}}oQ//rEcT[RRUR5$)z1Check if the reference image file exists on disk.)ospathexists image_pathrKs rF image_existsJingleTemplate.image_existsww~~doo..rEcv[RRUR5$![a gf=f)z)Get the size of the reference image file.N)rPrQgetsizerSOSErrorrKs rFget_image_sizeJingleTemplate.get_image_sizes0 77??4??3 3  s (+ 88c[RRUR5(a![R"UR5 gg![ a gf=f)z*Delete the reference image file from disk.TF)rPrQrRrSremoverYrKs rF delete_imageJingleTemplate.delete_imageR ww~~doo.. $//*/    AA A A r9N)!r;r<r=r>__doc__r CharFieldrr4 SlugFieldrr5 TextField descriptionr rS FloatFieldrsimilarity_threshold BooleanFieldr8r3 ForeignKeyCASCADEchannelr created_byrGrMrTrZr^rDr9rErFrrs=&   ()6  D   ():  D""AK !!&'DJ",,-.I##HI  ; H ..'; G"" ..': J  0/rErc\rSrSrSr\R "\\RSSS9r \R "\ \RSSS9r \R "\ \RSSS9r \R"\"S 5\"S 5/S S 9r\R$"S SS9r\R("SSS9r\R"\"S 5/SS 9r\R."SSSS9r\R2"\SSS9r"SS5rSrSrSrSr Sr!g )!JingleDetectiona  Model representing a detected jingle instance. This model records when a jingle has been detected in a stream, including the confidence score, frame information, and associated segment data. Attributes: session (ForeignKey): Stream session where detection occurred segment (ForeignKey): HLS segment containing the detection template (ForeignKey): Jingle template that was matched confidence_score (FloatField): Confidence level of the detection frame_path (CharField): Path to the extracted frame image detection_time (DateTimeField): When the detection occurred frame_timestamp (FloatField): Timestamp within the segment is_confirmed (BooleanField): Whether detection has been confirmed metadata (JSONField): Additional detection metadata jingle_detectionsz,Stream session where this detection occurredr-z%HLS segment containing this detection detectionsz Jingle template that was matched?z+Confidence level of the detection (0.0-1.0))rrrz!Path to the extracted frame imagerrTz When the detection was processed) auto_now_addrz5Timestamp within the segment where detection occurredFz2Whether this detection has been manually confirmedrz2Additional detection metadata and analysis resultsrrrc\rSrSrSrSrS/r\R"SS/S9\R"SS/S9\R"S /S9\R"S /S9/r S r g ) JingleDetection.MetazJingle DetectionzJingle Detections-detection_timesessiondetection_timer6template is_confirmedconfidence_scorer9Nr:r9rErFrGrys_) 1%& LL,< = > LL-= > ? LL 0 1 LL!3 4 5  rErGcjURRSURSSURS3$)z.String representation of the jingle detection. - z.3frIrJ)r~r4rr}rKs rFrMJingleDetection.__str__s7--$$%S)>)>s(C2dFYFYEZZ[\\rEcT[RRUR5$)z1Check if the extracted frame file exists on disk.)rPrQrR frame_pathrKs rF frame_existsJingleDetection.frame_existsrVrEcZS[RRUR53$)z*Get URL for accessing the extracted frame.z/media/frames/)rPrQbasenamerrKs rF get_frame_urlJingleDetection.get_frame_urls%  0 0 ABCCrEc[RRUR5(a![R"UR5 gg![ a gf=f)z*Delete the extracted frame file from disk.TF)rPrQrRrr]rYrKs rF delete_frameJingleDetection.delete_framer`rar9N)"r;r<r=r>rbrrjr rkr|r segmentrr~rgrrrrcr DateTimeFieldr}frame_timestamprir JSONFielddictmetadatarGrMrrrrDr9rErFroros<(..(@ G..(9 G  ..!4 H((%c*,=c,BC? !!5J ))4N ''%c*+IO &&FLFH   ]/D rEroc D^\rSrSrSr\R "\\RSSS9r \R"SSS9r \R"S /S QS S S 9r \R "\ \RSSSSS9r\R "\ \RSSSSS9r\R "SS9r\R "SSSS9r\R&"SS\"S5\"S5/SS9r\R."SSSS9r\R2"\SSS 9r\R8"SS!S"9r"S#S$5rS%rS&r S'r!U4S(jr"S)r#U=r$$)*AdBreaki az Model representing a detected advertisement break. Ad breaks are identified by pairs of jingle detections (start and end) and represent commercial interruptions in the stream content. Attributes: session (ForeignKey): Stream session containing the ad break channel_name (CharField): Channel identifier for external APIs region (CharField): Geographic region for the ad break start_detection (ForeignKey): Jingle detection marking the start end_detection (ForeignKey): Jingle detection marking the end start_time (DateTimeField): When the ad break started end_time (DateTimeField): When the ad break ended duration_seconds (PositiveIntegerField): Duration in seconds is_sent_to_api (BooleanField): Whether data was sent to external API api_response (JSONField): Response from external API notes (TextField): Additional notes about the ad break ad_breaksz'Stream session containing this ad breakr-rz/Channel identifier for external API integrationrur )) Netherlandsr)Francer)Globalrrz#Geographic region for this ad breakr*ad_breaks_startedTz7Jingle detection that marked the start of this ad break)r.r/nullrrad_breaks_endedz5Jingle detection that marked the end of this ad breakz$When the advertisement break started)rz"When the advertisement break endedrrriz#Duration of the ad break in secondsrrrrFz3Whether this ad break data was sent to external APIrz%Response data from external API callsrwz4Additional notes or observations about this ad breakrc\rSrSrSrSrS/r\R"SS/S9\R"SS /S9\R"S /S9\R"S /S9/r S r g ) AdBreak.MetaiozAdvertisement BreakzAdvertisement Breaksz -start_timer| start_timer6 channel_nameregionis_sent_to_apistatusr9Nr:r9rErFrGros[, 4!? LLL 9 : LL : ; LL!1 2 3 LL +  rErGcUR(aSURS3OSnURSURRS5U3$)z&String representation of the ad break.rIzs)rz%H:%M:%S)duration_secondsrrstrftime)rL duration_strs rFrMAdBreak.__str__zsN9=9N9ND112"5TV ##$C(@(@(L'Ml^\\rEcUR(aCUR(a2URUR- n[UR55$g)z'Calculate the duration of the ad break.N)rend_timeint total_seconds)rLdeltas rFcalculate_durationAdBreak.calculate_durations8 ??t}}MMDOO3Eu**,- -rEcHURSL=(a URSL$)z3Check if the ad break has both start and end times.N)rrrKs rF is_completeAdBreak.is_completesd*Ht}}D/HHrEc>UR5(a&UR(dUR5Ul[TU]"U0UD6 g)z2Override save to automatically calculate duration.N)rrrsupersave)rLargskwargs __class__s rFr AdBreak.saves<     d&;&;$($;$;$=D !  d%f%rE)r)%r;r<r=r>rbrrjr rkr|rcrrrostart_detection end_detectionrrrPositiveIntegerFieldrrrrirrr api_responserenotesrGrMrrrrD __classcell__)rs@rFrr s*.. ; G##CL    7 F''..( K O%%..& I M%%8J## 6H 22 %a(*;D*AB7 ((GN ##9L   H E   ] I&&rErc<\rSrSrSr\R "\\RSSS9r \R "\ \RSSS9r \R"SS S 9r \R"SS S 9r\R"SS S 9r\R "S S \"S5\"S5/SS9r\R "S S \"S5\"S5/SS9r\R "S S \"S5\"S5/SS9r\R "S S \"S5/SS9r\R."S S SS9r"SS5rSrSrSrSrSrg)DetectionStatisticsiaX Model for tracking jingle detection statistics and metrics. This model aggregates detection data for reporting and analysis, providing insights into detection accuracy, frequency, and performance. Attributes: session (ForeignKey): Stream session for these statistics template (ForeignKey): Jingle template for these statistics total_detections (PositiveIntegerField): Total number of detections confirmed_detections (PositiveIntegerField): Number of confirmed detections false_positives (PositiveIntegerField): Number of false positive detections avg_confidence (FloatField): Average confidence score min_confidence (FloatField): Minimum confidence score max_confidence (FloatField): Maximum confidence score detection_rate (FloatField): Detections per hour last_detection (DateTimeField): Time of last detection detection_statisticsz#Stream session for these statisticsr- statisticsz$Jingle template for these statisticsrz,Total number of detections for this template)rrz'Number of manually confirmed detectionsz.Number of identified false positive detectionsTrsrtz+Average confidence score for all detectionsrz!Minimum confidence score recordedz!Maximum confidence score recordedzNumber of detections per hourz&Timestamp of the most recent detectionrcp\rSrSrSrSrSS/rS/r\R"SS/S9\R"S/S9/r Sr g ) DetectionStatistics.MetaizDetection Statisticsr|r~z-last_detectionr6last_detectionr9N) r;r<r=r>r?r@unique_togetherrArrBrCrDr9rErFrGrsG- 4$j1%& LLJ 7 8 LL!1 2 3 rErGcNURRSURS3$)z2String representation of the detection statistics.rz detections)r~r4total_detectionsrKs rFrMDetectionStatistics.__str__s'--$$%S)>)>(?{KKrEc\URS:aURUR- S-$g)zBCalculate the accuracy rate as percentage of confirmed detections.rr)rconfirmed_detectionsrKs rF accuracy_rate!DetectionStatistics.accuracy_rates/  1 $--0E0EEL LrEc\URS:aURUR- S-$g)z0Calculate the false positive rate as percentage.rr)rfalse_positivesrKs rFfalse_positive_rate'DetectionStatistics.false_positive_rates/  1 $((4+@+@@CG GrEc[RRURURS9nUR 5UlURSS9R 5UlUR S:aURSSS9n[U5[U5- Ul [U5Ul [U5UlUR!S5R#5nU(aUR$UlUR)5 g) z7Recalculate statistics based on current detection data.)r|r~T)rrr)flatr{N)roobjectsfilterr|r~countrr values_listsumlenavg_confidenceminmin_confidencemaxmax_confidenceorder_byfirstr}rr)rLrrconfidence_scoreslatest_detections rFupdate_statistics%DetectionStatistics.update_statisticss$,,33LL]]4 !+ 0 0 2$.$5$54$5$H$N$N$P!  1 $ * 6 67IPT 6 U "%&7"83?P;Q"QD "%&7"8D "%&7"8D )223DEKKM &6&E&E# rE)rrrrrrN)r;r<r=r>rbrrjr rkr|rr~rrrrrgrrrrrdetection_raterrrGrMrrrrDr9rErFrrs(..+7 G  ..!8 H22@ "66; 11BO && %c*,=c,BC? N&& %c*,=c,BC5 N&& %c*,=c,BC5 N&& %c*+1 N)) :N   L  rEr)rb django.dbrdjango.contrib.auth.modelsr django.utilsrdjango.core.validatorsrrapps.core.modelsrr r apps.streams.modelsr r apps.core.validatorsr rrrrrPjsonrrorrr9rErFrs|+!GEE9 |%y|~o& odE& ;E&PE*IErE