Hi guys,
I need your assistance, so I have an external database with a particular
table on it and I want to migrate that table into a new database that I
have. Kindly direct me on how to achieved this.
Thank you...
On Thu, 16 Mar 2023, 19:23 nef, <frncse...@gmail.com> wrote:
> Hi all,
> I am facing problem to display a sub-list.
> In my model, I ahave a Student and Parent models. A prent can have one or
> more students.
> I want to list all the student in the parent page, but it is not showing.
> Please see here my code.
> Models
>
> class Student(models.Model):
> #std_matricule = models.CharField(verbose_name='Student matricule',
> max_length=6, null=False, unique=True, primary_key=True)
> std_matricule = models.CharField(verbose_name='Matricule', unique=True,
> max_length=16, null=False, blank=False, help_text='Matricule of the
> student')
> std_parents = models.ForeignKey(Parents, on_delete=models.DO_NOTHING,
> related_name='Parents', unique=False, null=True, blank=True,
> verbose_name='Student
> parents')
> std_email = models.EmailField(verbose_name='Email', null=False, blank=
> True, help_text='Enter the email of the student or leave blank if not
> exist')
> std_password = models.CharField(verbose_name='Password', max_length=
> 512, null=False, blank=True, help_text='Type the password with 6
> characters minimum')
> std_surname = models.CharField(verbose_name='Surname', null=False,
> blank=False, max_length=128, help_text='Type the Surname of the student
> as in the birth certificate')
> std_firstname = models.CharField(verbose_name='First name', null=False,
> blank=True, max_length=128, help_text='Type the student first name')
> std_midlename = models.CharField(verbose_name='Midle name', null=False,
> blank=True, max_length=128, help_text='Type the student first name')
> std_nickname = models.CharField(verbose_name='Student Nickname',
> max_length=64, null=False, blank=True, help_text='If exist, type student
> nickname here')
>
> lass Parents(models.Model):
> father_surname = models.CharField(verbose_name='Father surname',
> max_length=128, null=False, blank=True, help_text='Student Father surname
> as in the birth certificate')
> father_firstName = models.CharField(verbose_name='Father name',
> max_length=128, null=False, blank=True)
> father_phone = models.CharField(verbose_name='Father phone number',
> max_length=24, null=False, blank=True, help_text='Phone number of the
> Father')
> father_dateOfBirth = models.DateField(verbose_name='Father date of
> birth', null=True, blank=True)
> father_placeOfBirth = models.CharField(verbose_name='Father place of
> birth', max_length=512, null=True, blank=True)
> father_nationality = models.CharField('Father nationality', max_length
> =256, null=False, blank=True)
> father_adress = models.CharField(verbose_name='Father resident adress',
> max_length=512, null=False, blank=True)
> father_occupation = models.CharField(verbose_name='Father occupation',
> max_length=512, null=False, blank=True)
> mother_surname = models.CharField(verbose_name='Mother surname', null=
> False, max_length=128, help_text='Student Father name as in the birth
> certificate')
> mother_firstName = models.CharField(verbose_name='Mother name',
> max_length=128, null=False, blank=True)
> mother_phone = models.CharField(verbose_name='Mother phone number',
> max_length=64, null=False, blank=True, help_text='Phone number of the
> mother')
> mother_dateOfBirth = models.DateField(verbose_name='Mother date of
> birth', null=True, blank=True)
> mother_placeOfBirth = models.CharField(verbose_name='Mother place of
> birth', max_length=512, null=False, blank=True)
> mother_nationality = models.CharField('Mother nationality', max_length
> =512, null=False, blank=True)
> mother_adress = models.CharField(verbose_name='Mother resident adress',
> max_length=512, null=False, blank=True)
> mother_occupation = models.CharField(verbose_name='Mother occupation',
> max_length=512, null=False, blank=True)
>
>
> View
> def parentsDetails(request, pk):
> parentObj = Parents.objects.get(parent_id=pk)
> context = {'parentObj': parentObj}
> return render(request, "students_management_app/parents-single.html",
> context)
>
> Template
> {% extends 'main.html' %}
>
> {% block content %}
>
> <h1>A parent page for more details </h1>
> <!-- <img src= "{{ buildingObj.buildingIMG1.url }}"> -->
> <h1>{{parentObj.std_matricule}}</h1>
> <br>
> <h2>Father full name: {{parentObj.father_firstName}}
> {{parentObj.father_surname}}</h2>
> <br>
> <h2>Mother full name: {{parentObj.mother_firstName}}
> {{parentObj.mother_surname}}</h2>
> <p>
> Register date: {{parentObj.parent_createDate}}
> </p>
> <p><a href="{% url 'parents-list' %}">Add parents</a><br/></p>
> <br/>
>
> {% if parentObj.student_set.all %}
> {% for student in parentObj.students_set.all %}
>
> <h2>List of students</h2>
> <p>{{student.std_matricule}}</p>
> <p>{{student.std_firstname}} {{student.std_midlename}}
> {{student.std_surname}}</p>
> <p>{{student.std_sex}}</p>
>
> {% endfor %}
> {% endif %}
> <p>No Student found in the database</p>
>
> {% endblock content %}
>
> <p>Footer</p>
>
> The page is displaying well with all the information for the parent, but
> not student data.
> Thank you
> Eric
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/7e44e886-b51b-4478-b1b5-dfd5924a5822n%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/7e44e886-b51b-4478-b1b5-dfd5924a5822n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CA%2BGpPKyzi1uj__8p8CgQr39H36Tnz7KZGdknNUAPdW_%3D5Rg0jg%40mail.gmail.com.
