Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- original_ids = ClipRestriction.objects.filter(download=0).values_list('clip_id').distinct()
- for id in original_ids:
- restrictions_list = []
- vod_system = ClipRestriction.objects.filter(download=0, clip_id=id[0]).values_list('vod_system').distinct()
- for system in vod_system:
- if len(ClipRestriction.objects.filter(download=1, vod_system=system, clip_id=id[0]).values_list('region_id')) == 0:
- regions_ids = ClipRestriction.objects.filter(download=0, vod_system=system, clip_id=id[0]).values_list('region_id')
- regions = Region.objects.filter(pk__in=regions_ids)
- for region in regions:
- legal_from = ClipRestriction.objects.filter(download=0, vod_system=system, clip_id=id[0], region=region).values_list('legal_from')
- legal_till = ClipRestriction.objects.filter(download=0, vod_system=system, clip_id=id[0],
- region=region).values_list('legal_till')
- cr_object = ClipRestriction(
- clip=id[0],
- vod_system=system,
- active=True if (
- date.today() >= legal_from[0][0] and date.today() <= legal_till[0][0]) else False,
- region=region,
- legal_from=legal_from[0][0],
- legal_till=legal_till[0][0],
- autogenerated=True,
- download=True
- )
- restrictions_list.append(cr_object)
- else:
- regions_ids = ClipRestriction.objects.filter(download=0, vod_system=system, clip_id=id[0]).values_list(
- 'region_id')
- regions = Region.objects.filter(pk__in=regions_ids)
- for region in regions:
- legal_from = ClipRestriction.objects.filter(download=1, vod_system=system, clip_id=id[0],
- region=region).values_list('legal_from')
- legal_till = ClipRestriction.objects.filter(download=1, vod_system=system, clip_id=id[0],
- region=region).values_list('legal_till')
- cr_object = ClipRestriction(
- clip=id[0],
- vod_system=system,
- active=True if (
- date.today() >= legal_from[0][0] and date.today() <= legal_till[0][0]) else False,
- region=region,
- legal_from=legal_from[0][0],
- legal_till=legal_till[0][0],
- autogenerated=True,
- download=True
- )
- restrictions_list.append(cr_object)
- if restrictions_list:
- ClipRestriction.objects.bulk_create(restrictions_list)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement