refer:
https://docs.djangoproject.com/en/2.2/topics/db/examples/many_to_many/
On Sat, 13 Nov 2021 at 00:08, Madhav Dhungana
wrote:
> *What I want?*
>
> 1 ) I want to add pages and pull the page meta data from pagemeta table.
> One page will have more than on pagemeta.
>
>1.
>
>PageMeta Table , will have section(many to many relationship) and key
>and value like: Keyname: _contact_collapse Value: People usually ask these
>2.
>
>Section Table name: _contact_us_fax
>3.
>
>ModelsMeta Table This table will have: sectionname( foreign key)
>model_key : choices , for example: _heading_title, _heading_paragraph
>meta_vale ( this is for charfield) meta_content: HTML Field
>
> What I want to achieve from this? I want to make my own kind of simple CMS
> where I can create dynamic pages and assign fields to pages by establishing
> relationship with other tables via many to many or foreign key relationship
> when required.
>
> Whats the problem?
>
> To publish the specific page content, I need to know the pagemeta id's of
> that page from that pagemeta table id's, I need to find section table
> related to each and from the section id I will need to find information
> from ModelsMeta table. From this I hope I will be able to create a cms
> system where I can call the other tables data from keyvalue pair.
>
> My table structure code:
>
>
> class SectionKey(models.Model):
>
> model_name =models.CharField(max_length=200)
>
>
>
> class Meta:
>
>
>
> verbose_name = "Section"
>
> verbose_name_plural = "Section"
>
>
>
> def __str__(self):
>
> return self.model_name
>
>
>
>
>
>
>
> class Models(models.Model):
>
> model_name =models.CharField(max_length=200)
>
>
>
>
>
> class Meta:
>
>
>
> verbose_name = "Models"
>
> verbose_name_plural = "Models"
>
>
>
> def __str__(self):
>
> return self.model_name
>
>
>
> class ModelsMeta(models.Model):
>
> model_meta_name =models.ForeignKey(SectionKey, on_delete=
> models.CASCADE,related_name='sectionKey')
>
> modelkey = models.ForeignKey(Models, on_delete=
> models.CASCADE,related_name='Models', default=0)
>
> meta_value = models.CharField(max_length=200)
>
> meta_content = HTMLField()
>
> class Meta:
>
>
>
> verbose_name = "Models Meta"
>
> verbose_name_plural = "Models Meta"
>
>
>
> def __str__(self):
>
> return self.meta_value
>
>
>
> class PageMeta(models.Model):
>
> section = models.ManyToManyField(SectionKey)
>
> name = models.CharField(max_length=500, blank=True)
>
> title = models.CharField(max_length=500, blank=True)
>
> """key=models.CharField(max_length=500)
>
> value=models.CharField(max_length=500)"""
>
>
>
> class Meta:
>
>
>
> verbose_name = "Page Meta"
>
> verbose_name_plural = "Page Meta"
>
>
>
> def __str__(self):
>
> return self.name
>
>
>
> class Page(models.Model):
>
> name=models.CharField(max_length=500)
>
> title = models.CharField(max_length=500)
>
> content = models.CharField(max_length=500)
>
> author = models.ForeignKey(User, on_delete=
> models.CASCADE,related_name='page')
>
> updated_on = models.DateTimeField(auto_now= True)
>
> content = HTMLField()
>
> page_meta = models.ManyToManyField(PageMeta)
>
> created_on = models.DateTimeField(auto_now_add=True)
>
> slug = models.SlugField(max_length=200, unique=True, default=0)
>
> status = models.IntegerField(choices=STATUS, default=0)
>
>
>
> class Meta:
>
>
>
> verbose_name = "Page"
>
> verbose_name_plural = "Pages"
>
>
>
> def __str__(self):
>
> return self.title
>
>
>
> What I have done:
>
>
> def contact(request, slug):
>
> page = get_object_or_404(Page, slug=slug)
>
> meta = page.page_meta.values_list('id', flat=True)
>
> page_meta = Page.objects.filter(id__in=meta)
>
> section = PageMeta.objects.prefetch_related('section', id__in=meta)
>
> models = ModelsMeta.objects.prefetch_related('section', id__in=section)
>
>
> I tried to achieve the goal with this way but I am unable to move ahead
> and get required information on managed way. I can get the page meta id of
> each page but now, how can I get the *section* of each (desired)
> *pagemeta*, and how can I get the *modelsmeta id* of each section
> obtained from *pagemeta*?
>
> *Long story short, I want to retrieve Page model related data from all the
> tables and print on template for each page.*
>
> --
> 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/4a6e48cf-d1d5-4441-9753-f60da383c430n%40googlegroups.com
>
> .
>
--
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
