Forem: Borhan Tipu

Django: How to show a user liked a post or not in List View without Duplicate Queries.

Borhan Tipu — Fri, 07 Jan 2022 21:30:14 +0000

Create a model if you don’t have:

class PostLike(models.Model):
    user = models.ForeignKey('users.User', on_delete=models.CASCADE, related_name='post_likes')
    post = models.ForeignKey('posts.Post', on_delete=models.CASCADE, related_name='likes')

    created = models.DateTimeField(auto_now_add=True)

Code for Rest Framework

Create a Model Serializer for Post Model. is_liked will be Boolean field and read only.

class PostSerializer(serializers.ModelSerializer):
    is_liked = serializers.BooleanField(read_only=True)
    class Meta:
      model = Post
      fields = '__all__'

Create a Rest ListAPIView PostListAPIView. Use authentication class to get the request.user.

from django.db.models import Prefetch, Exists, OuterRef

class PostListAPIView(ListAPIView):
    serializer_class = PostSerializer
    queryset = Post.objects.none()

    def get_queryset(self):
        return Post.objects \
            .annotate(is_liked=Exists(PostLike.objects.filter(
            user=self.request.user, post_id=OuterRef('pk')))) \
            .order_by('title')

That’s it.

You can contact me to talk about your projects, build new applications, etc.

Visit Me: https://imtipu.me
Linked In: https://www.linkedin.com/in/borhantipu

Django Debug Toolbar, not showing/appearing, Fix it & Bring it Back.

Borhan Tipu — Tue, 30 Mar 2021 07:17:55 +0000

Are you facing the problem with Django Debug Toolbar showing up?
I faced too…
Here I will show you how I fixed it….

Install Debug Toolbar…
For virtual env: pip install django-debug-toolbar
For Pipenv: pipenv install django-debug-toolbar

Link: https://pypi.org/project/django-debug-toolbar/

Docs: https://django-debug-toolbar.readthedocs.io/en/latest/

Go to settings.py and add to INSTALLED_APPS

INSTALLED_APPS = [
 # …
 'django.contrib.staticfiles',
 # … not for debug mode
 'debug_toolbar',
]
STATIC_URL = '/static/'

The Debug Toolbar should have appeared only in Debug mode. So, the rest of the settings will be for DEBUG mode only.

# debug_toolbar moved here. 
if DEBUG:
    MIDDLEWARE += [
        'debug_toolbar.middleware.DebugToolbarMiddleware',
    ]
    INSTALLED_APPS += [
        'debug_toolbar',
    ]
    INTERNAL_IPS = ['127.0.0.1', ]

    # this is the main reason for not showing up the toolbar
    import mimetypes
    mimetypes.add_type("application/javascript", ".js", True)

    DEBUG_TOOLBAR_CONFIG = {
        'INTERCEPT_REDIRECTS': False,
    }

Update your {project}/urls.py file.

from django.conf import settings
from django.urls import path, include
urlpatterns = [
  path("admin/", admin.site.urls),
]
# add debug toolbar in urlpatterns
if settings.DEBUG:
    import debug_toolbar
    urlpatterns += [
        path('__debug__/', include(debug_toolbar.urls)),
    ]

The main reason for not showing up the toolbar is because of the javascript mime-types error when you connect the debug_toolbar
If the already added to your application then just add two lines of code in your settings.py file.

import mimetypes
mimetypes.add_type("application/javascript", ".js", True)

Now the debug toolbar should be visible in Debug mode.

Medium Link: Django Debug Toolbar Fix

If you need any help with Full-Stack Development with Django and Shopify, feel free to contact me anytime.
Visit: imtipu.me
Contact if you need any help with Django and Shopify
Thanks!

Nuxt SSR head meta attributes Correct Format

Borhan Tipu — Mon, 11 Jan 2021 18:26:43 +0000

Wrong Format

data: () => {
    return {
      title: 'Page Title',
    }
  },
  head: () => {
    return {
      title: this.title
    }
  },

Correct Format

data: () => {
    return {
      title: 'Page Title',
    }
  },
  head() {
    return {
      title: this.title
    }
  },

Django Shopify Webhook HMAC Verify

Borhan Tipu — Tue, 07 Jul 2020 00:13:49 +0000

In this article, I will show you how you can verify Shopify Webhook Hmac in a Django Application.

In Shopify:
Go to Settings > Notifications > Webhook

Create a Webhook
Add Webhook URL

Create Webhook

You can use ngrok for development and testing purpose

SHOPIFY_WEBHOOK_SIGNED_KEY

After adding the webhook URL you will find a Signed Key for webhook just below of the Webhook URL list.
In Django:

Add a variable in settings.py file

SHOPIFY_WEBHOOK_SIGNED_KEY = env.str('SHOPIFY_WEBHOOK_SIGNED_KEY', '')

Then in your views.py file,

I used django-rest-framework views, response, and status

from django.views.decorators.csrf import csrf_exempt  
from rest_framework import status  
from rest_framework.decorators import api_view  
from rest_framework import status  
from rest_framework.response import Response
import hmac  
import hashlib  
import base64

def computed_hmac(secret, body):  
    hash_code = hmac.new(secret.encode('utf-8'), body, hashlib.sha256)  
    return base64.b64encode(hash_code.digest()).decode()

def verify_hmac(secret, body, shopify_hmac):  
    return computed_hmac(secret, body) == shopify_hmac

@csrf_exempt
@api_view(['POST'])  
def api_view_webhook(request):
    # get hmac from shopify webhook request  
    shopify_hmac = request.headers.get('X-Shopify-Hmac-Sha256')  
    if verify_hmac(settings.SHOPIFY_WEBHOOK_SIGNED_KEY, request.body, shopify_hmac):  
        print('valid')  
        return Response(status=status.HTTP_200_OK) else:  
    else:
        print('invalid')  
        return Response(status=status.HTTP_400_BAD_REQUEST)

In your urls.py file,

from .views import_ api_view_webhook
urlpatterns = [  
    path('webhook/', api_view_webhook, name='api_view_webhook'),  
]

If verify_hmac is True then it will print “valid” in terminal console otherwise it will print **“invalid”.

**That’s it.

Thanks.

You can find this article in medium also

Did anyone integrate Smart2pay in Django and react native?

Borhan Tipu — Tue, 21 Jan 2020 10:56:02 +0000

I want to integrate Smart2pay with django and react native. I couldn't find any package or module for django/python. They just provide global API for that. I can do with API in the backend.
I need suggestion how I can do it and what will be the proper way to implement it with django ans react native. You are all open to give suggestions.
Thanks!

Did anyone set Filterset with Django rest Framework?

Borhan Tipu — Sun, 01 Dec 2019 06:37:07 +0000

I added a JSONField in a model.
I want to set fileterset with django filter backend for rest Framework.
Any ideas?

Django Password Reset Done Template not loading

Borhan Tipu — Sat, 02 Nov 2019 12:38:44 +0000

Iam using django.contrib.auth.views.
When I submit an email for the exist user on the password reset form, it throws me an error that "TemplateDoesNotExist".
If I submit an email which is not in the database the reset done view is working.

can you please tell me why same month showing twice with same data?

Borhan Tipu — Mon, 05 Aug 2019 21:00:19 +0000

can you please tell me why same month showing twice with same data?
models.py

class Event(models.Model):
    title = models.CharField(max_length=255, default=None, unique=True)
    link = models.URLField(default=None, null=True)
    description = models.TextField()
    date = models.DateField(default=None, null=True)
    is_published = models.BooleanField(default=False)
    created = models.DateTimeField(auto_now_add=True)
    updated = models.DateTimeField(auto_now=True)

    def __str__(self):
        return self.title

    class Meta:
        db_table = 'events'
        verbose_name = 'event'
        verbose_name_plural = 'events'

class EventGroup(models.Model):
    event = models.ForeignKey(Event, related_name='events', on_delete=models.CASCADE)
    date = models.DateField()
    created = models.DateTimeField(auto_now_add=True)
    updated = models.DateTimeField(auto_now=True)
    class Meta:
        db_table = 'event_group'

serializer.py

class EventGroupSerializer(serializers.ModelSerializer):
    events = serializers.SerializerMethodField(method_name='get_events')
    month_year = serializers.SerializerMethodField(method_name='get_month_year')

    total = serializers.SerializerMethodField(method_name='get_count_events')
    class Meta:
        model = EventGroup
        fields = ('month_year', 'total', 'events',)

    def get_count_events(self, instance):
        org_date = str(instance['date'])
        date = datetime.datetime.strptime(org_date, "%Y-%m-%d")
        month = date.month
        year = date.year
        count = Event.objects.filter(date__month=month, date__year=year).count()
        return count

    def get_month_year(self, instance):
        org_date = str(instance['date'])
        date = datetime.datetime.strptime(org_date, "%Y-%m-%d").date()
        month_year = str(date.month)+'-'+str(date.year)
        return str(month_year)

    def get_events(self, instance):
        org_date = str(instance['date'])
        date = datetime.datetime.strptime(org_date, "%Y-%m-%d")
        month = date.month
        year = date.year
        events = Event.objects.filter(date__month=month, date__year=year)
        event_serializer = EventSerializer(events, many=True)
        return event_serializer.data

views.py

class EventGroupData(ListAPIView):
    queryset = EventGroup.objects.all()

    serializer_class = EventGroupSerializer


    def get_queryset(self):
        queryset = self.queryset

        return queryset.annotate(month=TruncMonth('date')).values('date').annotate(c=Count('id')).order_by()

if I change the queryset to queryset.annotate(month=TruncMonth('date')).values('month').annotate(c=Count('id')).order_by() ... it shows key error with 'date'.
results

{
    "count": 4,
    "next": null,
    "previous": null,
    "results": [
        {
            "month_year": "6-2019",
            "events": [
                {
                    "id": 30,
                    "title": "Event 2",
                    "description": "Event 2",
                    "date": "2019-06-02"
                },
                {
                    "id": 31,
                    "title": "Event 3",
                    "description": "Event 3",
                    "date": "2019-06-04"
                }
            ]
        },
        {
            "month_year": "6-2019",
            "events": [
                {
                    "id": 30,
                    "title": "Event 2",
                    "description": "Event 2",
                    "date": "2019-06-02"
                },
                {
                    "id": 31,
                    "title": "Event 3",
                    "description": "Event 3",
                    "date": "2019-06-04"
                }
            ]
        },
        {
            "month_year": "9-2019",
            "events": [
                {
                    "id": 32,
                    "title": "Event 4",
                    "description": "Event 4",
                    "date": "2019-09-04"
                },
                {
                    "id": 29,
                    "title": "Event 1",
                    "description": "Event 1",
                    "date": "2019-09-25"
                }
            ]
        },
        {
            "month_year": "9-2019",
            "events": [
                {
                    "id": 32,
                    "title": "Event 4",
                    "description": "Event 4",
                    "date": "2019-09-04"
                },
                {
                    "id": 29,
                    "title": "Event 1",
                    "description": "Event 1",
                    "date": "2019-09-25"
                }
            ]
        }
    ]
}

it should be like this

{
    "count": 4,
    "next": null,
    "previous": null,
    "results": [
        {
            "month_year": "6-2019",
            "events": [
                {
                    "id": 30,
                    "title": "Event 2",
                    "description": "Event 2",
                    "date": "2019-06-02"
                },
                {
                    "id": 31,
                    "title": "Event 3",
                    "description": "Event 3",
                    "date": "2019-06-04"
                }
            ]
        },
        {
            "month_year": "9-2019",
            "events": [
                {
                    "id": 32,
                    "title": "Event 4",
                    "description": "Event 4",
                    "date": "2019-09-04"
                },
                {
                    "id": 29,
                    "title": "Event 1",
                    "description": "Event 1",
                    "date": "2019-09-25"
                }
            ]
        },

    ]
}

How can I make a list of group data by month-year in rest Framework with json output?

Borhan Tipu — Thu, 01 Aug 2019 09:38:50 +0000

The json data format I want like this:

[
  {
    monthName: "AUG 2019",
    items: [
      {
        day: "03",
        description: "Baseball",
      },
      {
        day: "08",
        description: " Baseball 2"
      },

    ]
  },
  {
    monthName: "Sep 2019",
    items: [
      {
        day: "03",
        description: "Baseball",
      },
      {
        day: "08",
        description: " Baseball 2"
      },

    ]
  }
]