求助：如何通过teacher_ID关联模型，在表单中展示教师对应课程？

Hey there! Let's walk through how to solve this problem step by step—first making sure our model relationships are solid, then writing the queries you need, and finally integrating this into your form for creating Lecture instances.

First, let's make sure our models are linked correctly using teacher_id as the bridge. I'll assume you're using Django (since you mentioned models/forms), but the logic translates to other ORMs too.

# TeacherData - stores core teacher info (pre-account creation)
class TeacherData(models.Model):
    teacher_id = models.CharField(max_length=50, unique=True)
    name = models.CharField(max_length=100)
    # Add other fields like title, department, etc.

# Teacher - the user account model, linked to TeacherData via teacher_id
class Teacher(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE)  # Link to Django's default User
    # Directly link to TeacherData using its teacher_id field
    teacher_data = models.OneToOneField(
        TeacherData,
        on_delete=models.CASCADE,
        to_field='teacher_id',
        related_name='teacher_account'
    )

# Course - exclusive to one teacher, linked to TeacherData
class Course(models.Model):
    teacher_data = models.ForeignKey(
        TeacherData,
        on_delete=models.CASCADE,
        related_name='courses'  # Lets us fetch courses directly from a TeacherData instance
    )
    course_name = models.CharField(max_length=100)
    # Add other course details like code, description, etc.

Now we can fetch the right courses depending on your use case:

For a Logged-In Teacher (Showing Their Own Courses) #

If the user creating the Lecture is the teacher themselves, grab their associated courses like this:

# In your view
from django.contrib.auth.decorators import login_required

@login_required
def create_lecture(request):
    # Get the logged-in Teacher instance
    current_teacher = Teacher.objects.get(user=request.user)
    # Fetch all courses linked to their TeacherData
    teacher_courses = current_teacher.teacher_data.courses.all()
    # Pass this to your template context
    return render(request, 'create_lecture.html', {'teacher_courses': teacher_courses})

For an Admin (Showing All Teachers & Their Courses) #

If you need to pick any teacher's courses (e.g., admin creating lectures), use prefetch_related to avoid inefficient database queries:

# In your admin view
teachers_with_courses = TeacherData.objects.prefetch_related('courses').all()
# Pass to template: {'teachers_with_courses': teachers_with_courses}

Now let's render these courses in a form so you can select one when creating a Lecture.

For Logged-In Teachers #

In your template (create_lecture.html):

<form method="POST" action="{% url 'create_lecture' %}">
    {% csrf_token %}
    
    <div class="form-group">
        <label for="course">Select Your Course:</label>
        <select name="course_id" id="course" required>
            {% for course in teacher_courses %}
                <option value="{{ course.id }}">{{ course.course_name }}</option>
            {% empty %}
                <option disabled>No courses found for your account.</option>
            {% endfor %}
        </select>
    </div>

    <!-- Add other Lecture fields here (e.g., lecture title, date) -->
    
    <button type="submit">Create Lecture</button>
</form>

For Admins (Select Teacher + Course) #

Group courses by teacher using <optgroup> for clarity:

<form method="POST" action="{% url 'create_lecture' %}">
    {% csrf_token %}
    
    <div class="form-group">
        <label for="course">Select Teacher & Course:</label>
        <select name="course_id" id="course" required>
            {% for teacher in teachers_with_courses %}
                <optgroup label="{{ teacher.name }} (ID: {{ teacher.teacher_id }})">
                    {% for course in teacher.courses.all %}
                        <option value="{{ course.id }}">{{ course.course_name }}</option>
                    {% empty %}
                        <option disabled>No courses for this teacher.</option>
                    {% endfor %}
                </optgroup>
            {% empty %}
                <option disabled>No teachers found in the system.</option>
            {% endfor %}
        </select>
    </div>

    <!-- Other Lecture fields -->
    
    <button type="submit">Create Lecture</button>
</form>

Don't forget to add validation when creating a Teacher account to ensure the teacher_id exists in TeacherData:

from django import forms

class TeacherRegistrationForm(forms.ModelForm):
    teacher_id = forms.CharField(max_length=50, label="Teacher ID")
    # Add other user fields (username, password, etc.)

    class Meta:
        model = Teacher
        fields = ['teacher_id']

    def clean_teacher_id(self):
        teacher_id = self.cleaned_data.get('teacher_id')
        # Check if teacher_id exists in TeacherData
        if not TeacherData.objects.filter(teacher_id=teacher_id).exists():
            raise forms.ValidationError("This Teacher ID does not exist in our records.")
        # Check if an account is already linked to this teacher_id
        if Teacher.objects.filter(teacher_data__teacher_id=teacher_id).exists():
            raise forms.ValidationError("An account is already registered with this Teacher ID.")
        return teacher_id

That should cover everything you need! Let me know if you need tweaks for your specific framework or edge cases.

内容的提问来源于stack exchange，提问作者user9092892