U hV@sJddlZddlZddlZddlmZddlmZmZGdddej Z dS)N)settings) migrationsmodelsc@steZdZdZdeejgZej dde j dddfde j ddd fd e j e jd d dd d fde jddddfde jddddfde jdddfde jdddfde jddejjdejjdgd fd!e jddd"d#fd$e jd%d&d'd(d)d*d+gd,d-d.d/fd0e jd1ejj jjd2ejd3fg d4d5d$dgd6d7ej d8de j dddfde j ddd fd e j e jd d dd d fd9e jd:ejjdejjdgd;fde j dd?dfd@e jdAejjdgd;fdBe jdd dCd#fdDe jdedEdFfdGe jdHejj jjdIdJd3fdKe jdLejj jjdIdMd3fdNe jdOejj jjdPdQd3fg dRdSdTgd6d7ej dUde j dddfde j ddd fd e j e jd d dd d fdVe jdWdXdYfdZe jdWd[dYfd\e jdWd]dYfd^e jdd_dejjdejjdgd`fdae jddbdejjdejjdgd`fdce jddddejjdejjdgd`fdee jddfdejjdgd`fdge j ddhddifdKe jdjejj jjdkdMd3fdNe jdlejj jjdmdQd3fg dndndogd6d7ej dpde j dddfde j ddd fd e j e jd d dd d fdqe jdrdsdtdudvdwdxgddydzd{d|fd}e jd~ddfde jdddgddd.d/fde j ddfde j ddddifde jdddejjdejjdgd`fde jdd dd#fde jdeddFfde jdddfdKe jdejj jjddMd3fde jdddejj jjdddfde jdddejj jjdddfgdddge j dKdgdde j d}dgdde j dgdde j dqgddgdd7ej!de j dgdddej!de j d!gdddej!de j d$gdddej!de j dKd>gdddej!de j dNd>gdddej!de j dBgdddej!de j d9gdddej!de j dKdNgdddej!de j dggdddej"ddhdgZ#dS) MigrationT)streams 0001_initialJingleTemplate created_atz&Timestamp when this record was created) auto_now_add help_text updated_atz,Timestamp when this record was last modified)auto_nowr idFz!Unique identifier for this record)defaulteditabler primary_key serializenamez"Human-readable name for the jingled)r max_lengthuniqueslugz&URL-friendly identifier for the jingle descriptionz-Description of the jingle content and context)blankr image_pathz0Path to the reference image file for this jinglei)r rsimilarity_thresholdg?z5Similarity threshold for positive detection (0.0-1.0)gg?)rr validators is_activez4Whether this jingle template is active for detection)db_indexrr category)ad_startzAdvertisement Start)ad_endzAdvertisement End) program_startz Program Start) program_endz Program End) transition Transition)brandingzChannel Branding)otherOtherr'z'Category classification for this jingle2)choicesrr r created_byz&User who uploaded this jingle templatejingle_templates)r on_delete related_nametozJingle TemplatezJingle Templates) verbose_nameverbose_name_pluralordering)rfieldsoptionsJingleDetectionconfidence_scorez+Confidence level of the detection (0.0-1.0))r r frame_pathz!Path to the extracted frame imagedetection_timez When the detection was processedframe_timestampz5Timestamp within the segment where detection occurred is_confirmedz2Whether this detection has been manually confirmedmetadataz2Additional detection metadata and analysis results)rrr segmentz%HLS segment containing this detectionjingle_detectionszstreams.hlssegmentsessionz,Stream session where this detection occurredzstreams.streamsessiontemplatez Jingle template that was matched detectionszjingles.jingletemplatezJingle DetectionzJingle Detectionsz-detection_timeDetectionStatisticstotal_detectionsrz,Total number of detections for this template)rr confirmed_detectionsz'Number of manually confirmed detectionsfalse_positivesz.Number of identified false positive detectionsavg_confidencez+Average confidence score for all detections)rr nullrmin_confidencez!Minimum confidence score recordedmax_confidencez!Maximum confidence score recordeddetection_ratezNumber of detections per hourlast_detectionz&Timestamp of the most recent detection)rr rFz#Stream session for these statisticsdetection_statisticsz$Jingle template for these statistics statisticszDetection Statisticsz-last_detectionAdBreakstatus)activeActive)inactiveInactive)pendingPending) processing Processing) completed Completed)failedFailed) cancelled CancelledrSzCurrent status of this record)r*rrr r channel_namez/Channel identifier for external API integrationregion) Netherlandsr`)Francera)Globalrbrbz#Geographic region for this ad break start_timez$When the advertisement break started)r end_timez"When the advertisement break endedduration_secondsz#Duration of the ad break in secondsiis_sent_to_apiz3Whether this ad break data was sent to external API api_responsez%Response data from external API callsnotesz4Additional notes or observations about this ad breakz'Stream session containing this ad break ad_breaks end_detectionz5Jingle detection that marked the end of this ad breakad_breaks_endedzjingles.jingledetection)rr rFr-r.r/start_detectionz7Jingle detection that marked the start of this ad breakad_breaks_startedzAdvertisement BreakzAdvertisement Breaksz -start_timeZjingles_adb_session_644a34_idx)r3rZjingles_adb_channel_a8cb4d_idxZjingles_adb_is_sent_b14f94_idxZjingles_adb_status_be1ce1_idx)r0r1r2indexesjingletemplateZjingles_jin_slug_33d2ec_idx) model_nameindexZjingles_jin_is_acti_568562_idxZjingles_jin_categor_7a9b01_idxZjingledetectionZjingles_jin_session_16f260_idxZjingles_jin_templat_1cb2b1_idxZjingles_jin_is_conf_d97304_idxZjingles_jin_confide_a60b7d_idxZdetectionstatisticsZjingles_det_session_8fd830_idxZjingles_det_last_de_1414d7_idx)r>r?)runique_togetherN)$__name__ __module__ __qualname__initialrswappable_dependencyrAUTH_USER_MODEL dependencies CreateModelr DateTimeField UUIDFielduuiduuid4 CharField SlugField TextField FloatFielddjangocorerMinValueValidatorMaxValueValidator BooleanField ForeignKeydbdeletionCASCADE JSONFielddictPositiveIntegerFieldIndexAddIndexAlterUniqueTogether operationsrrI/var/www/html/StreamProcessor/src/apps/jingles/migrations/0001_initial.pyr s          fm           cj               v}             )r) django.core.validatorsrdjango.db.models.deletionr~ django.confr django.dbrrrrrrrs