def get(self, request):
"""
order_by time = 2 queries
order_by like = 2 quires
order_by comments = 2 queries
order_by editor_choice( channel subs ) = 2 queries
"""
response_data = {}
serializer = AllMediaSerializer(data=request.GET)
if serializer.is_valid():
tags = serializer.validated_data.get("tags")
page = (serializer.validated_data.get("page") - 1) * 18
type = serializer.validated_data.get("type")
orderby = serializer.validated_data.get("orderby")
media_class = self.get_class(type)
response_data["total_length"] = media_class.objects.all().count()
if tags:
main_query = eval("media_class.objects" +
self.get_query_prefix(orderby))
ordered_response = main_query.filter(tags__in=tags)
else:
main_query = eval("media_class.objects" +
self.get_query_prefix(orderby))
ordered_response = main_query
response_data["ordered_response"] = ordered_response[page:page +
18]
response_format = {
"ordered_response": [{
"id": 1,
"title": 1,
"description": 1,
"thumbnail": 1,
}],
"total_length":
1,
}
return return_response(response_data=response_data,
format=response_format)
return return_response(status=False)
def get(self, request):
response_data = {}
response_maxlen = {}
serializer = GetVideosSerializer(data=request.GET)
if serializer.is_valid():
start = (serializer.validated_data["page"] - 1) * 3
channels = (
Channel.objects.prefetch_related("video").all().annotate(
max=Count("video")).order_by("-max")[start:start + 3])
response_data["channels"] = channels
response_maxlen["video"] = 10
response_format = {
"channels": [
{
"name":
1,
"profile_pic":
1,
"video": [
{
"id": 1,
"title": 1,
"description": 1,
"thumbnail": 1,
},
],
},
],
}
return return_response(
response_data=response_data,
format=response_format,
response_maxlen=response_maxlen,
)
return return_response(status=False)
def get(self, request):
response_data = {}
serializer = GetLatestVideoSerializer(data=request.GET)
if serializer.is_valid():
count = serializer.validated_data.get("count")
videos = Video.objects.all().order_by("-created")[:count]
response_data["videos"] = videos
response_format = {
"videos": [
{
"id": 1,
"title": 1,
"description": 1,
"thumbnail": 1,
},
],
}
return return_response(response_data=response_data,
format=response_format)
def get(self, request):
"""
Number of queries run = 1
"""
response_data = {}
response_format = {}
serializer = GetTagSerializer(data=request.GET)
if serializer.is_valid():
type = serializer.validated_data["type"]
media_class = get_media_class(type)
response_data["tags"] = eval(
"Tags.objects.filter(~Q({}=None))".format(type)).values(
"id", "name")
response_format = {
"tags": [{
"id": 1,
"name": 1,
}]
}
return return_response(response_data=response_data,
format=response_format)
def get(self, request):
"""
right now it takes 6 query to return response
"""
response_data = {}
response_format = {}
serializer = MediaPreviewSerializer(data=request.GET)
if serializer.is_valid():
media_id = serializer.validated_data.get("id")
type = serializer.validated_data.get("type")
media_class = get_media_class(type)
media_query = media_class.objects.prefetch_related(
Prefetch(
"comments",
queryset=Comments.objects.annotate(replies_count=Count(
"replies")).order_by("-replies_count"),
to_attr="main_thread",
))
media = media_query.get(id=media_id)
response_data[type] = media
response_data["comments"] = media.main_thread
response_data["likes_count"] = media.likes.filter(val=True).count()
response_data["dislikes_count"] = media.likes.filter(
val=False).count()
response_data["views_count"] = media.views.all().count()
response_data["liked"] = None
if request.user.is_anonymous:
ip, _ = get_client_ip(request)
if ip:
view, is_created = Views.objects.get_or_create(user=None,
ip=ip)
if is_created:
eval("view.{}.add(media)".format(type))
view.save()
else:
view, is_created = Views.objects.get_or_create(
user=request.user)
if is_created:
eval("view.{}.add(media)".format(type))
view.save()
has_responded = media.likes.filter(user=request.user)
if has_responded:
response_data["liked"] = has_responded[0].val
response_format = {
type: {
"id": 1,
"title": 1,
"description": 1,
"thumbnail": 1,
"content": 1,
"body": 1,
},
"comments": [{
"id": 1,
"message": 1,
"replies_count": 1,
}],
"likes_count": 1,
"dislikes_count": 1,
"liked": 1,
"views_count": 1,
}
return return_response(response_data=response_data,
format=response_format)