表“skills”的外键链接字段“author”在数据库中始终为空

Question

我正在构建一个web应用程序，学生可以看到导师发布的工作岗位。导师可以登录网站发布工作。我创建了一个“我的帖子”页面，让导师看到他们所有的帖子，编辑，删除他们。似乎一个外键字段“author”在发布一个作业后，在数据库中是空的，这使得该帖子不显示在我的帖子中。请帮帮忙。

下面是我的models.py技能：

class Skill(models.Model):
    author = models.ForeignKey(User, on_delete=models.CASCADE)
    teacher_name = models.CharField(max_length=50)
    skill_type = models.CharField(
        max_length=30,
        choices=SKILL_CHOICES,
    )
    name = models.CharField(max_length=65)
    duration = models.IntegerField()
    cost = models.IntegerField()
    location = models.CharField(max_length=65)

    def __str__(self):
        return str(self.skill_type + " " + self.name)

这是我的urls.py

urlpatterns = [
    path('', views.index, name='index'),
    path('home', views.index, name='home'),
    path('signup', views.signup, name='signup'),
    path('postskill', views.postskill, name='postskill'),
    path('profile', views.profile, name='profile'),
    path('post/<int:id>', views.post, name='post'),
]

postskill和post的views.py（postskill是一个模型

@login_required
def postskill(request):
    if request.method == 'POST':
        print(request.user.id)
        print(request.user.username)
        form = PostRecord(request.POST)
        if form.is_valid():
            data = form.cleaned_data
            s = Skill(
                # author = request.user.id,
                teacher_name = request.user.username,
                skill_type = data.get('skill_type'),
                name = data.get('name'),
                duration = data.get('duration'),
                cost = data.get('cost'),
                location = data.get('location'),
            )
            s.save()

        allskills = Skill.objects.all().order_by('name')
        return render(request, 'home.html', {'skills': allskills})
    else:
        form = PostRecord()
        return render(request, 'postskill.html', {'form': form})

def post(request,id):
    logged_in_user_posts = Skill.objects.filter(author=id)
    return render(request, 'post.html', {'posts': logged_in_user_posts})

post.html模板：

{% extends "base_generic.html" %}
{% block content %}

{% for post in posts %}

    Username: {{ post.author.username }}
    <ul>
    <li>Subject Type: {{post.skill_type}}</li>
    <li>Subject Name: {{post.name}}</li>
    <li>Duration: {{post.duration}} months</li>
    <li>Cost: Rs. {{post.cost}}</li>
    <li>Location: {{post.location}}</li>
    </ul>
    <br>

{% endfor %}


{% endblock %}

Answer 1

尝试取消对行得注释：

#author=request.user.id

并使之：

author=request.user

你说：“是的。则会抛出CSRF丢失错误“

你必须登录请求一个用户的id是为什么。