creating relationship between two apps in django

Question

I have a post and a category app in my django project. I have user authentication and users can create categories as well as posts. I am at a point where I am out of ideas and help would be appreciated. I want users to be able to reference only their own category and create posts in their categories not in another persons own. That is if a user creates more that one category he should be able to select from the list of his created category and not see another persons own.

category model

class Category(models.Model):
    name = models.CharField(max_length = 120)
    slug = models.SlugField(unique= True)
    timestamp = models.DateTimeField(auto_now=False, auto_now_add=True)

post model

class Post(models.Model):
     user = models.ForeignKey(settings.AUTH_USER_MODEL, default=1,related_name='posts_created') #blank=True, null=True)
     title = models.CharField(max_length = 120)
     slug = models.SlugField(unique= True)
     category = models.ForeignKey(Category, on_delete=models.CASCADE, related_name='category_created', null= True) 

addition codes would be provided immediately on request. Thanks

View.py in post app

def create(request):
    if not request.user.is_authenticated():
        messages.error(request, "Kindly confirm Your mail")
        #or raise Http404
    form = PostForm(request.POST or None, request.FILES or None)
    user = request.user
    categories = Category.objects.filter(category_created__user=user).distinct()
    if form.is_valid():
        instance = form.save(commit=False)
        instance.user = request.user
        instance.save()
        create_action(request.user, 'Posts', instance)
        messages.success(request, "Post created")
        return HttpResponseRedirect(instance.get_absolute_url())
    context = {
        "form": form,
        "categories": categories,
    }
    template = 'create.html'
    return render(request,template,context)

Form

class PostForm(forms.ModelForm):
    class Meta:
        model = Post
        fields = [
            "title",
            "content",
            "category",
        ]

html

{% if form %}

  <form method="POST" action="" enctype="multipart/form-data">{% csrf_token %}
    {{ form|crispy|safe }}
      <input type="submit" name="submit" value="Publish">
  </form>
      {% endif %}

Answer 1

category = models.ForeignKey(Category, on_delete=models.CASCADE, related_name='category_created', null= True) 

related_name='category_created' means that to access your post from a category you need to use 'category_created':

categories = Category.objects.filter(category_created__user=user).distinct()

or you can rename it to related_name='post' and then migrate.

Edit

View.py in post app

def create(request):
    if not request.user.is_authenticated():
        messages.error(request, "Kindly confirm Your mail")
        #or raise Http404
    form = PostForm(request, request.POST or None, request.FILES or None, )
    user = request.user
    if form.is_valid():
        instance = form.save(commit=False)
        instance.user = request.user
        instance.save()
        create_action(request.user, 'Posts', instance)
        messages.success(request, "Post created")
        return HttpResponseRedirect(instance.get_absolute_url())
    context = {
        "form": form,
        "categories": categories,
    }
    template = 'create.html'
    return render(request,template,context)

forms.py

class PostForm(forms.ModelForm):

    def __init__(self, request, *args, **kwargs):
        super (PostForm,self ).__init__(*args,**kwargs) # populates the post
        self.fields['category'].queryset = Category.objects.filter(
            category_created__user=request.user
        ).distinct()

Answer 2

You probably want to list all the Categories to which a user has contributed on some view.

You can get all the Categories to which a user contributed in the following way:

user = request.user  # assuming you're in a view
categories = Category.objects.filter(post__user=user).distinct()