U oԐhl@sdZddlmZddlmZddlmZmZddlm Z ddl m Z ddl m ZddlmZmZmZdd lmZdd lmZmZdd lZdd lmZdd lmZddlmZmZmZddl m!Z!m"Z"m#Z#m$Z$e%e&Z'GdddZ(GdddZ)Gdddej*Z+Gdddej*Z,Gdddej*Z-Gdddej*Z.Gdddej*Z/GdddeZ0Gd d!d!eZ1Gd"d#d#eZ2Gd$d%d%eZ3Gd&d'd'eZ4d(d)Z5d*d+Z6d1d-d.Z7Gd/d0d0Z8d S)2a Django models for broadcast playlist and advertising management system. This module contains models that manage the lifecycle of broadcast playlists, advertising windows, avails, ad spots placement, and verification data for a television/media broadcasting platform. Models hierarchy: Playlists -> Windows -> Avails -> AdspotsInAvail Author: Development Team Created: [Date] Last Modified: [Date] Version: 1.1 - Applied all TODO improvements )default)models)MinValueValidatorMaxValueValidator)ValidationError)timezone) gettext_lazy)QCountSum) ContentType)timedatetimeN) BaseModel)Adspots)Channel ChannelZoneChannelZoneRelation)convert_date_string_to_date#convert_duration_string_to_durationconvert_time_string_to_timeplaylist_xml_upload_pathc@s0eZdZdZdZdZeedfeedfgZdS)PlaylistStatusz%Constants for playlist status values.rDraft PublishedN)__name__ __module__ __qualname____doc__DRAFT PUBLISHED_CHOICESr$r$0/var/www/html/Focus/src/apps/playlists/models.pyr)s   rc@sLeZdZdZdZdZdZdZeedfeedfeedfeed fgZ d S) VerificationStatusz)Constants for verification status values.pendingcompletefailedpartialPendingCompleteFailedZPartialN) rrrrPENDINGZCOMPLETEFAILEDPARTIALr"r#r$r$r$r%r&5s    r&c@s8eZdZdZddZddZddZdd Zd d Zd S) PlaylistManagerz=Custom manager for Playlists model with useful query methods.cCs|jtjdS)zGet only published playlists.is_draft)filterrr!selfr$r$r% publishedIszPlaylistManager.publishedcCs|jtjdS)zGet only draft playlists.r2)r4rr r5r$r$r%draftsMszPlaylistManager.draftscCs |j|dS)z%Get playlists for a specific channel.) channel_idr4)r6r9r$r$r% for_channelQszPlaylistManager.for_channelcCs*|t||dt||dBt||dBS)z+Get playlists within a specific date range.)Zstart_date__gtestart_date__lte) end_date__gteZ end_date__lte)r<r=)r4r )r6 start_dateend_dater$r$r%for_date_rangeUs   zPlaylistManager.for_date_rangecCst}|j||tjdS)z(Get playlists that are currently active.)r<r=r3)rnowr4rr!r6rAr$r$r% active_now]s zPlaylistManager.active_nowN) rrrrr7r8r;r@rCr$r$r$r%r1Fs r1c@s(eZdZdZddZddZddZdS) WindowsManagerz!Custom manager for Windows model.cCs |j|dS)z$Get windows for a specific playlist.) playlist_idr:)r6rEr$r$r% for_playlistjszWindowsManager.for_playlistcCs|jddS)zGet windows that have avails.F)Zavails__isnullr4distinctr5r$r$r% with_availsnszWindowsManager.with_availscCs |dS)zOrder windows by start time. window_startorder_byr5r$r$r% by_start_timerszWindowsManager.by_start_timeN)rrrrrFrIrMr$r$r$r%rDgsrDc@s0eZdZdZddZddZddZdd Zd S) AvailsManagerz Custom manager for Avails model.cCs |j|dS)z!Get avails for a specific window.) window_idr:)r6rOr$r$r% for_windowzszAvailsManager.for_windowcCs|jddS)z%Get avails that have ad spots placed.FZadspots_in_avail__isnullrGr5r$r$r% with_adspots~szAvailsManager.with_adspotscCs |jddS)z;Get avails that have no ad spots (available for placement).TrQr:r5r$r$r% availableszAvailsManager.availablecCs |dS)zOrder avails by start time. avail_startrKr5r$r$r%rMszAvailsManager.by_start_timeN)rrrrrPrRrSrMr$r$r$r%rNws rNc@s0eZdZdZddZddZddZdd Zd S) AdSpotsInAvailManagerz(Custom manager for AdspotsInAvail model.cCs |j|dS)z,Get ad spot placements for a specific avail.)avail_idr:)r6rVr$r$r% for_availszAdSpotsInAvailManager.for_availcCs |j|dS)z&Get placements for a specific ad spot.) adspot_idr:)r6rXr$r$r% for_adspotsz AdSpotsInAvailManager.for_adspotcCs |dS)z&Order placements by position in avail.positioninavailrKr5r$r$r% by_positionsz!AdSpotsInAvailManager.by_positioncCs |j|dS)zGet placements by traffic ID.) trafficidr:r6 traffic_idr$r$r%for_traffic_idsz$AdSpotsInAvailManager.for_traffic_idN)rrrrrWrYr[r_r$r$r$r%rUs rUc@sHeZdZdZddZddZddZdd Zd d Zd d Z ddZ dS) VerifsManagerz Custom manager for Verifs model.cCs |j|dS)z)Get verifications for a specific network.) networknamer:)r6Z network_namer$r$r% for_networkszVerifsManager.for_networkcCs |j|dS)z&Get verifications for a specific zone.)zonenamer:)r6 zone_namer$r$r%for_zoneszVerifsManager.for_zonecCs |j|dS)z0Get verifications for a specific broadcast date.)broadcast_dater:)r6rfr$r$r%for_dateszVerifsManager.for_datecCs|jddddgdS)z!Get only completed verifications.r(yes1trueZvercomplete__inr:r5r$r$r% completedszVerifsManager.completedcCs|jddddgdS)zGet pending verifications.r(rhrirjrk)excluder5r$r$r%r'szVerifsManager.pendingcCs |j|dS)z,Get verifications for a specific traffic ID.) trafficIdr:r]r$r$r%r_szVerifsManager.for_traffic_idcCs |dS)z Order verifications by air time.air_timerKr5r$r$r% by_air_timeszVerifsManager.by_air_timeN) rrrrrbrergrlr'r_rpr$r$r$r%r`sr`c sZeZdZdZejeejddddddZeje ejddddddZ ej d d e d gd Z ejddd ddZejddddZejddddZejeddddZejddddZej de d gdZeZGdddZddZfddZfddZed d!Z ed"d#Z!ed$d%Z"ed&d'Z#ed(d)Z$d*d+Z%d,d-Z&d3d/d0Z'd4d1d2Z(Z)S)5 Playlistsa Model representing broadcast playlists for television channels. A playlist contains the scheduling information for a specific broadcast period, including windows where advertisements can be placed. Each playlist is associated with a channel and potentially a specific zone within that channel. Attributes: channel (ForeignKey): Reference to the broadcasting channel id_zone_channel (ForeignKey): Reference to specific zone within the channel version (str): Version identifier for playlist tracking broadcast_date (DateField): Date when the playlist is scheduled to broadcast start_date (datetime): Start datetime for the playlist broadcast end_date (datetime): End datetime for the playlist broadcast filepath (str): File system path to the playlist file is_draft (bool): Flag indicating if playlist is in draft state draft_version (int): Version number for draft iterations channelTz$The channel this playlist belongs to playlists) on_delete db_columnblanknull help_text related_name zone_channelz+Specific zone within the channel (optional)rz*Version identifier for playlist versioningr)rrx validatorszScheduled broadcast date)rvrwrxdb_indexz%Start datetime for playlist broadcast)rvrwrxz#End datetime for playlist broadcastz-Generated XML schedule file for this playlist) upload_torvrwrxz/Draft status flag (True=draft, False=published))rrxr|z#Version number for draft management)rxr{c@seZdZdZedZedZddgZej ddgddej d d gd dej d d gddej dgddej dgddgZ ej dddgddej e ed de ddBe ddBddgZdS)zPlaylists.MetarqPlaylistz -created_atz-idrrrfZplaylist_channel_date_idxfieldsnamer>r?Zplaylist_datetime_range_idxr3 created_atZplaylist_draft_created_idxversionZplaylist_version_idxrzZplaylist_zone_idxZ(unique_playlist_version_per_channel_date)Zstart_date__ltT)Zstart_date__isnull)Zend_date__isnullZplaylist_valid_date_rangecheckrN)rrrdb_tabler" verbose_nameverbose_name_pluralorderingrIndexindexesUniqueConstraintCheckConstraintr F constraintsr$r$r$r%Meta s& "rcCs>|jr|jjnd}|jrdnd}|d|jd|d|jS)z&String representation of the playlist.z No Channelrr -  (z) - )rr channel_namer3rrf)r6rstatusr$r$r%__str__9szPlaylists.__str__cstt|jr2|jr2|j|jkr2tdtdi|jrVt|jdkrVtdtdit d|j d|jdS) Custom validation for the model.r?z"End date must be after start date.rz0Version identifier cannot exceed 255 characters.zValidating playlist z: N) supercleanr>r?rr"rlenloggerdebugidr5 __class__r$r%r?s zPlaylists.cleancsl|js@|jr@tjj|j|jdjt ddd}|p8dd|_ t d|j d|jtj||d S) )Custom save method with additional logic.)rrrf draft_version) max_draftrrrzSaving playlist z for channel N)pkr3rqobjectsr4rrrf aggregaterMaxrrinforrsave)r6argskwargsrrr$r%rRs zPlaylists.savecCs|j S)z2Check if the playlist is published (not in draft).r2r5r$r$r% is_publisheddszPlaylists.is_publishedcCs:|jr |jsdSt}|j|ko.|jkno8|jS)z*Check if the playlist is currently active.F)r>r?rrArrBr$r$r% is_activeis zPlaylists.is_activecCs.|jr*|jr*|j|j}t|ddSdS)z'Calculate playlist duration in minutes.<N)r>r?round total_seconds)r6deltar$r$r%duration_minutesqs  zPlaylists.duration_minutescCs|j}|rt|ddSdS)z%Calculate playlist duration in hours.rrN)rr)r6minutesr$r$r%duration_hoursyszPlaylists.duration_hourscCs|jr dSdS)zGet human-readable status.rrr2r5r$r$r%status_displayszPlaylists.status_displaycCs |jS)z&Get count of windows in this playlist.)windowscountr5r$r$r%get_windows_countszPlaylists.get_windows_countcCs|jjtdddpdS)z-Get total count of avails across all windows.avails) total_availsrr)rrr r5r$r$r%get_total_avails_countsz Playlists.get_total_avails_countNcCs:|jr6d|_|jdgdtd|jd|dSdS)zPublish a draft playlist.Fr3 update_fields Playlist z published by user T)r3rrrrr6userr$r$r%publishs zPlaylists.publishc Cspt|j|j|p|jd|j|j|j|jddd }||j D]}| |qBt d|jd|j|S)z2Create a copy of this playlist with a new version.rT) rrrzrrfr>r?filepathr3rzCreated copy of playlist z as )rqrrrzrrfr>r?rrrall create_copyrrr)r6Z new_version new_playlistwindowr$r$r%rs    zPlaylists.create_copy)N)N)*rrrrr ForeignKeyr DO_NOTHINGrrrrz IntegerFieldrr DateFieldrf DateTimeFieldr>r? FileFieldrZxml_file BooleanFieldr3rr1rrrrrpropertyrrrrrrrrr __classcell__r$r$rr%rqs          rqc seZdZdZejeejdddeddeddZ ej ddeded dd Z ej dded ed d Z ej ddededd ZeZGdddZddZfddZddZddZddZZS)Windowsau Model representing advertising windows within a playlist. Windows are time segments within a playlist where advertisements can be scheduled. Each window has a defined start time, end time, and duration within the broader playlist timeframe. Attributes: id_window (AutoField): Primary key for the window id_playlist (ForeignKey): Reference to the parent playlist window_start (TimeField): Start time of the advertising window window_end (TimeField): End time of the advertising window window_duration (DurationField): Duration of the advertising window playlistTz#The playlist this window belongs torr~rtrurvrwrxryrz$Start time of the advertising windowz Window Startrvrwrxrr|z"End time of the advertising windowz Window End)rvrwrxrz"Duration of the advertising windowzWindow Durationc@sxeZdZdZedZedZdgZej ddgddej dgddgZ ej e e d d e d d Be d d BddgZdS)z Windows.MetarzAdvertising WindowzAdvertising WindowsrJrZwindow_playlist_start_idxrZwindow_start_idx window_end)Zwindow_start__ltTZwindow_start__isnullZwindow_end__isnullZwindow_valid_time_rangerN)rrrrr"rrrrrrrr rrr$r$r$r%rs"rcCs:|jrd|jjnd}d|jd|d|jd|jS)z0String representation of the advertising window.rz No PlaylistWindow rz): r)rrrrJr)r6Z playlist_infor$r$r%rszWindows.__str__cst|jr2|jr2|j|jkr2tdtdi|jr|jr|jstt |j}tt |j}||krtt t j dd|j}|||_dS)rrz)Window end time must be after start time.rdaysN) rrrJrrr"window_durationrcombinetodayr timedelta)r6Zstart_dtZend_dtrr$r%rs z Windows.cleancCs |jS)z#Get count of avails in this window.)rrr5r$r$r%get_avails_countszWindows.get_avails_countcCs|jjtdddpdS)z=Get total count of ad spots across all avails in this window.adspots_in_avail) total_spotsrr)rrr r5r$r$r%get_total_adspots_countszWindows.get_total_adspots_countcCs<t||j|j|jd}||jD]}||q(|S)z0Create a copy of this window for a new playlist.)rrJrr)rrJrrrrrr)r6r new_windowavailr$r$r%rs zWindows.create_copy)rrrrrrrqCASCADEr"r TimeFieldrJr DurationFieldrrDrrrrrrrrr$r$rr%rsJ  rc @seZdZdZejeejdddeddeddZ ej ddeded dd Z ej d dded ed dZ eZGdddZddZddZddZddZddZdS)Availsa= Model representing available advertising slots within windows. Avails are specific time slots within advertising windows where individual advertisements can be placed. They represent the granular inventory units for ad placement scheduling. Attributes: id_window (ForeignKey): Reference to the parent advertising window avail_start (TimeField): Start time of the available slot availinwindow (str): Position or identifier of avail within the window datetime (datetime): Timestamp associated with the avail rTz,The advertising window this avail belongs torWindowrz,Start time of the available advertising slotz Avail StartrZ availInWindowz1Position or identifier of avail within the windowzAvail in Window)rurvrwrxrc@sJeZdZdZedZedZddgZej ddgddej dgd dgZ d S) z Avails.MetarzAvailable SlotzAvailable SlotsrT availinwindowrZavail_window_start_idxrZavail_position_idxN) rrrrr"rrrrrrr$r$r$r%rYsrcCs2|jrd|jjnd}d|jd|d|jS)z,String representation of the available slot.rz No WindowAvail rz) at )rrrT)r6Z window_infor$r$r%rcszAvails.__str__cCs |jS)z$Get count of ad spots in this avail.rrr5r$r$r%get_adspots_counthszAvails.get_adspots_countcCs|jdkS)z+Check if this avail has no ad spots placed.rrr5r$r$r% is_availablelszAvails.is_availablecCs$|jjtddd}|pddS)z6Get the next available position for ad spot placement.rZ)max_posrrr)rrrr)r6Z max_positionr$r$r%get_next_positionps zAvails.get_next_positioncCs8t||j|jd}||jD]}||q$|S)z-Create a copy of this avail for a new window.)rrTr)rrTrrrrr)r6r new_availZadspot_placementr$r$r%rxs zAvails.create_copyN)rrrrrrrrr"rrrTrrrNrrrrrrrr$r$r$r%r+s@   rc seZdZdZejeejdddeddeddZ eje ej ddded d ed d Z ej d ddedededgddZej dddededddZeZGdddZddZfddZfddZddZZS) AdspotsInAvaila; Model representing the placement of specific ad spots within available slots. This is the junction model that connects advertising spots to specific avails, managing the actual placement and positioning of advertisements within the broadcast schedule. Attributes: id_avail (ForeignKey): Reference to the available slot id_adspot (ForeignKey): Reference to the advertisement spot positioninavail (int): Position of the ad spot within the avail trafficid (int): Traffic system identifier for the placement rTz/The available slot where this ad spot is placedrZAvailradspotz#The advertisement spot being placedZplacements_in_availzAd Spot)rurvrwrxryrZpositionInAvailz2Position of the ad spot within the avail (1-based)zPosition in Availr)rurvrwrxrr{r|rnz+Traffic system identifier for the placement Traffic ID)rurvrwrxrr|c@steZdZdZedZedZddgZej ddgddej d gd dej d gd dgZ ej ddgd e dddgZ dS)zAdspotsInAvail.MetaZAdspots_in_availzAd Spot PlacementzAd Spot PlacementsrZrrZadspot_avail_position_idxrrZadspot_spot_idxr\Zadspot_traffic_idxZ unique_adspot_position_per_availF)Zpositioninavail__isnull)rr conditionN)rrrrr"rrrrrrrr rr$r$r$r%rsrcCsV|jrd|jnd}|jr(d|jnd}|jr>d|jnd}|d|d|S) z/String representation of the ad spot placement.zAdSpot z No AdSpotrzNo Availz Position z No Positionz in z at )rXrVrZ)r6Z adspot_infoZ avail_infoZ position_infor$r$r%rszAdspotsInAvail.__str__cspt|jr*|jdkr*tdtdi|jrl|jrltjj|j|jdj |j d}| rltdtdidS)rdrZzPosition cannot exceed 100.)rrZ)rz0This position is already occupied in this avail.N) rrrZrr"rrrr4rmrexists)r6Z conflictingrr$r%rs$  zAdspotsInAvail.cleancsD|js|jr|j|_td|jd|jtj||dS)rzSaving ad spot placement: z in avail N) rZrrrrrXrVrrr6rrrr$r%rs  zAdspotsInAvail.savecCs"t||j|j|jd}||S)z0Create a copy of this placement for a new avail.)rrrZr\)rrrZr\r)r6rZ new_placementr$r$r%rszAdspotsInAvail.create_copy)rrrrrrrrr"rrrrrrrZr\rUrrrrrrrr$r$rr%rsX      rc seZdZdZejdededddZejdededddZej ed ed dd Z ej ed ed dd Z ejdededddZ ejededdd ZejededdZejdededddZej dedededgddZejddddededddZeZGd d!d!Zd"d#Zfd$d%Zfd&d'Zed(d)Zed*d+Zed,d-Zd7d/d0Z d1d2Z!e"d3d4Z#d5d6Z$Z%S)8Verifsa Model for storing advertisement verification and broadcast confirmation data. This model tracks the actual broadcast verification of advertisements, recording when ads were aired, their duration, status, and other verification metadata for billing and compliance purposes. Attributes: networkname (str): Name of the broadcasting network zonename (str): Name of the broadcasting zone broadcast_date (DateField): Date when the ad was broadcast trafficId (int): Traffic system identifier spotId (str): Unique identifier for the advertisement spot air_time (TimeField): Time when the ad was aired air_length (DurationField): Duration of the aired advertisement airStatuscode (str): Status code indicating broadcast result revision (int): Revision number for the verification record vercomplete (str): Verification completion status rz Name of the broadcasting networkz Network NameT) max_lengthrxrr|zName of the broadcasting zonez Zone Namez)Date when the advertisement was broadcastzBroadcast Date)rxrr|z/Traffic system identifier for the advertisementrz,Unique identifier for the advertisement spotzSpot IDz%Time when the advertisement was airedzAir Timez#Duration of the aired advertisementz Air Length)rxrz'Status code indicating broadcast resultzAir Status Coderz+Revision number for the verification recordZRevision)rrxrr{r|Z verComplete2zVerification completion statuszVerification Complete)rurrvrwrxrr|c @seZdZdZedZedZdddgZej ddgd d ej d d gd d ej ddgdd ej dd gdd ej dgdd ej dgdd gZ ej dddgdd gZ dS)z Verifs.MetarzAdvertisement VerificationzAdvertisement Verificationsz-broadcast_datez -air_time -revisionrarcZverif_network_zone_idxrrfroZverif_broadcast_air_idxrnrevisionZverif_traffic_revision_idxspotIdZverif_spot_date_idx airStatuscodeZverif_status_idx vercompleteZverif_complete_idxZ&unique_verif_per_traffic_spot_revisionN) rrrrr"rrrrrrrrr$r$r$r%rws   rc Cs:|jr dnd}d|jd|jd|jd|jd|d S) z1String representation of the verification record.r,r+ Verification r/ on r))is_verification_completerrarcrf)r6rr$r$r%rszVerifs.__str__csNt|jr&|js&tdtdi|jrJt|jdkrJtdtdidS)rrz0Spot ID is required when Traffic ID is provided.rrz(Status code cannot exceed 50 characters.N)rrrnrrr"rrr5rr$r%rs  z Verifs.cleancs,td|jd|jtj||dS)rzSaving verification for spot rN)rrrrfrrrrr$r%rsz Verifs.savecCs|js dS|jdkS)z,Check if verification is marked as complete.F)r(rhrirj)rlowerr5r$r$r%rszVerifs.is_verification_completecCs*|jrtdS|jr|jStdSdS)z'Get human-readable verification status.r,r+N)rr"rtitler5r$r$r%rs  zVerifs.status_displaycCs"dddddg}|jo |j|kS)z;Check if the broadcast was successful based on status code.successokZ200Zaired broadcast)rr)r6Z success_codesr$r$r%is_successful_broadcastszVerifs.is_successful_broadcastNcCs0d|_|jdgdtd|jd|dS)zMark verification as complete.r(rrrz marked complete by user N)rrrrrrr$r$r% mark_completeszVerifs.mark_completec CsXt|j|j|j|j|j|j|j|j|j ddd }| t d|j d|j|S)z+Create a new revision of this verification.rN) rarcrfrnrro air_lengthrrrzCreated revision z for verification ) rrarcrfrnrror rrrrr)r6Z new_revisionr$r$r%create_revisions zVerifs.create_revisioncCs|jj||ddS)z>Get the latest revision for a specific traffic ID and spot ID.)rnrr)rr4rLfirst)clsr^spot_idr$r$r%get_latest_revisions zVerifs.get_latest_revisionc Cs&|j|j|j|j|j|j|j|jdS)z'Get a summary of broadcast information.)networkzonedater durationrr( successful)rarcrfror rrr r5r$r$r%get_broadcast_summaryszVerifs.get_broadcast_summary)N)&rrrrr CharFieldr"rarcrrfrrnrrrorr rrrrr`rrrrrrrrr r r  classmethodrrrr$r$rr%rs         rcCs2tjtjtjtjdS)z%Get overall statistics for playlists.)Ztotal_playlistsZpublished_playlistsZdraft_playlistsZactive_playlists)rqrrr7r8rCr$r$r$r%get_playlist_statisticss    rcCsFtjtjtjtjttjdddS)z)Get overall statistics for verifications.rr)Ztotal_verificationsZcompleted_verificationsZpending_verificationsZcompletion_rate)rrrrlr'maxr$r$r$r%get_verification_statisticss    rcCsPttj|d}tjjd|d}|}|t d|d|d|S)zClean up old draft playlists.rT)r3Zcreation_at__ltz Cleaned up z old draft playlists older than z days) rrArrqrr4rdeleterr)r cutoff_dateZ old_draftsrr$r$r%cleanup_old_draftssr c@s4eZdZdZeddZeddZeddZdS) DataTypeMigrationHelperz Helper class for migrating data when changing field types. Use this in Django data migrations to convert existing string data to proper field types. c Csjddlm}|Btjjddd}|D]&}t|j}|r*||_|j dgdq*W5QRXt dd S) z;Migrate playlist broadcastdate from CharField to DateField.r transactionTF)broadcast_date__isnullZbroadcastdate__isnullrfrz!Completed playlist date migrationN) django.dbr#atomicrqrr4rZ broadcastdaterfrrr)r#rsrconverted_dater$r$r%migrate_playlist_datess   z.DataTypeMigrationHelper.migrate_playlist_datesc Csddlm}|tjtjddtjddB}|D]x}t|drb|j rbt |j }|rb||_ t|dr|j rt |j }|r||_ t|dr|jrt|j}|r||_|q:W5QRXtd d S) z1Migrate window times from CharField to TimeField.rr"Trrwindow_start_oldwindow_end_oldwindow_duration_oldz Completed window times migrationN)r%r#r&rrr4rr hasattrr)rrJr*rr+rrrrr)r#rrZconverted_startZ converted_endconverted_durationr$r$r%migrate_window_timess(     z,DataTypeMigrationHelper.migrate_window_timesc Csddlm}|tjtjddtjddBtjddB}|D]x}t|drn|j rnt |j }|rn||_ t|dr|j rt |j }|r||_t|d r|jrt|j}|r||_|qFW5QRXtd d S) z=Migrate verification data from string fields to proper types.rr"T)r$)Zair_time__isnull)Zair_length__isnull broadcastDateairTime airLengthz%Completed verification data migrationN)r%r#r&rrr4rr r,r/rrfr0rror1rr rrr)r#ZverifsZverifr'Zconverted_timer-r$r$r%migrate_verification_datas0        z1DataTypeMigrationHelper.migrate_verification_dataN)rrrr staticmethodr(r.r2r$r$r$r%r!s  r!)r)9r email.policyrr%rZdjango.core.validatorsrrdjango.core.exceptionsr django.utilsrdjango.utils.translationrr"django.db.modelsr r r "django.contrib.contenttypes.modelsr rr loggingapps.common.modelsrZapps.campaigns.modelsrapps.channels.modelsrrrZapps.playlists.utilsrrrr getLoggerrrrr&Managerr1rDrNrUr`rqrrrrrrr r!r$r$r$r%sH          !"n}](