Count user objects e.g posts

python, Django

class Embed(models.Model):
    url = models.URLField(max_length=255)
    title = models.CharField(max_length=255, verbose_name='Tytuł')
    description = HTMLField(verbose_name='Opis', blank=True, null=True)
    type = models.CharField(blank=True, max_length=200)
    thumbnail_url = models.URLField(max_length=255, blank=True, null=True)
    image = models.ImageField(upload_to='recipes', blank=True)
    html = models.TextField()
    votes = GenericRelation(LikeDislike, related_query_name='embedlikes')
    added_by = models.ForeignKey(User, on_delete=models.CASCADE)
    created_at = models.DateTimeField(auto_now_add=True)
    category = TreeManyToManyField(RecipeCategory, blank=True, null=True, related_name='embeds', verbose_name='Kategoria')
    slug = AutoSlugField(populate_from='title', unique=True)

Рекомендуємо хостинг TIMEWEB

Stabiles Hosting des sozialen Netzwerks EVILEG. Wir empfehlen VDS-Hosting für Django-Projekte.

Hello,

Try this

from django.db.models import Count
embeds = Embed.objects.annotate(total=Count('added_by'))
embeds[0].total

Hmm this count every recipes. Not only one user.

I try something like that from stackoverflow:

def recipedetail(request, slug):
    recipe = get_object_or_404(Embed, slug=slug)
    num_embed = recipe.objects.filter(added_by=added_by).count()
    return render(request, 'recipes/detail.html', {'recipe': recipe,
                                                    'num_embed': num_embed}

But then error appear:

Manager isn't accessible via Embed instances

I have this from there: https://stackoverflow.com/questions/50393455/count-the-number-of-posts-by-a-user-django

May be, because, you don`t have field "author" in your model... ?

And in this code you get object of model

recipe = get_object_or_404(Embed, slug=slug)

Therefore you cannot use objects in this row

num_embed = recipe.objects.filter(author=author).count()

Because of objects can be used only in this situation

Embed.objects.all() # only for model class, not for instance

And I don`t see author instance in your code.

You can write something else like this

def recipedetail(request, slug):
    recipe = get_object_or_404(Embed, slug=slug)
    # missed author instance, need to add code for getting author instance
    num_embed = Embed.objects.filter(added_by=author).count()
    return render(request, 'recipes/detail.html', {'recipe': recipe,
                                                    'num_embed': num_embed}

But you should get author instance from anywhere, for example request.user

Yeah I edit my answer and change to added_by. But still this don't work.

added_by must be some author instance, some object. You should get this object from anywhere. In your code you don`t make any actions for getting author instance.

Ok, try this

def recipedetail(request, slug):
    recipe = get_object_or_404(Embed, slug=slug)
    num_embed = recipe.objects.filter(added_by=request.user).count()
    return render(request, 'recipes/detail.html', {'recipe': recipe,
                                                    'num_embed': num_embed}

or this

def recipedetail(request, slug):
    recipe = get_object_or_404(Embed, slug=slug)
    num_embed = recipe.objects.filter(added_by=recipe.added_by).count()
    return render(request, 'recipes/detail.html', {'recipe': recipe,
                                                    'num_embed': num_embed}

Thank you! Now works, and this is solution.

num_embed = Embed.objects.filter(added_by=recipe.added_by).count()