Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.12 KB | None | 0 0
  1. original_ids = ClipRestriction.objects.filter(download=0).values_list('clip_id').distinct()
  2. for id in original_ids:
  3. restrictions_list = []
  4. vod_system = ClipRestriction.objects.filter(download=0, clip_id=id[0]).values_list('vod_system').distinct()
  5.  
  6. for system in vod_system:
  7. if len(ClipRestriction.objects.filter(download=1, vod_system=system, clip_id=id[0]).values_list('region_id')) == 0:
  8. regions_ids = ClipRestriction.objects.filter(download=0, vod_system=system, clip_id=id[0]).values_list('region_id')
  9. regions = Region.objects.filter(pk__in=regions_ids)
  10. for region in regions:
  11. legal_from = ClipRestriction.objects.filter(download=0, vod_system=system, clip_id=id[0], region=region).values_list('legal_from')
  12. legal_till = ClipRestriction.objects.filter(download=0, vod_system=system, clip_id=id[0],
  13. region=region).values_list('legal_till')
  14. cr_object = ClipRestriction(
  15. clip=id[0],
  16. vod_system=system,
  17. active=True if (
  18. date.today() >= legal_from[0][0] and date.today() <= legal_till[0][0]) else False,
  19. region=region,
  20. legal_from=legal_from[0][0],
  21. legal_till=legal_till[0][0],
  22. autogenerated=True,
  23. download=True
  24. )
  25. restrictions_list.append(cr_object)
  26. else:
  27. regions_ids = ClipRestriction.objects.filter(download=0, vod_system=system, clip_id=id[0]).values_list(
  28. 'region_id')
  29. regions = Region.objects.filter(pk__in=regions_ids)
  30. for region in regions:
  31. legal_from = ClipRestriction.objects.filter(download=1, vod_system=system, clip_id=id[0],
  32. region=region).values_list('legal_from')
  33. legal_till = ClipRestriction.objects.filter(download=1, vod_system=system, clip_id=id[0],
  34. region=region).values_list('legal_till')
  35. cr_object = ClipRestriction(
  36. clip=id[0],
  37. vod_system=system,
  38. active=True if (
  39. date.today() >= legal_from[0][0] and date.today() <= legal_till[0][0]) else False,
  40. region=region,
  41. legal_from=legal_from[0][0],
  42. legal_till=legal_till[0][0],
  43. autogenerated=True,
  44. download=True
  45. )
  46. restrictions_list.append(cr_object)
  47.  
  48. if restrictions_list:
  49. ClipRestriction.objects.bulk_create(restrictions_list)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement