How to get List from Database to html in python - Django?

Question

i have few items/List stored in database stored as ['First Form Field', 'Second input Field']

i want all these items of a column as a list in my front end html page I am getting items as

ff= form_fields.objects.all() return render(request,'user/index.html',{'message': welcome,'ff': ff})

INDEX:

 {% for x in ff%}
        <tr>
            <td>
                {{ x.id}}
            </td>
            <td>
                {{ x.name }}
            </td>
            <td>
                {% for y in x.text_field %}
              <label>{{ y }}</label>

                    {% endfor %}
            </td>
            <td>

models

class form_fields(models.Model):
  id = models.AutoField(primary_key=True)
  form_name = models.CharField(max_length= 50, null=True)
  text_field = models.CharField(max_length=255, null= True)

I want that saved list to be in that table as list.

In which colunm are you storing ['First Form Field', 'Second input Field']? — Piyush S. Wanare
– Piyush S. Wanare, Commented Feb 21, 2017 at 6:20
are you storing ['First Form Field', 'Second input Field'] in charfiled ? — Cadmus
– Cadmus, Commented Feb 21, 2017 at 6:32

Cadmus · Accepted Answer · 2017-02-23 04:19:19Z

create own ListField field for resolving this issue

from django.db import models
import ast

class ListField(models.TextField):
    __metaclass__ = models.SubfieldBase
    description = "form fields"

    def __init__(self, *args, **kwargs):
        super(ListField, self).__init__(*args, **kwargs)

    def to_python(self, value):
        if not value:
            value = []

        if isinstance(value, list):
            return value

        return ast.literal_eval(value)

    def get_prep_value(self, value):
        if value is None:
            return value

        return unicode(value)

    def value_to_string(self, obj):
        value = self._get_val_from_obj(obj)
        return self.get_db_prep_value(value)

class Form_Fields(models.Model):
    id = models.AutoField(primary_key=True) ## id builtin in django models
    form_name = models.CharField(max_length= 50, null=True)
    form_fields = ListField()


[1]:Form_Fields.objects.create(form_name="test", form_field=['First Form Field', 'Second input Field'])


{% for x in ff%}
        <tr>
            <td>
                {{ x.id}}
            </td>
            <td>
                {{ x.form_name }}
            </td>
            <td>
                {% for y in x.form_fields %}
                    <label>{{ y }}</label>
                {% endfor %}
            </td>
            <td>
     </tr>
{% endfor %}

Piyush S. Wanare · Accepted Answer · 2017-02-21 13:13:53Z

1

Change models.py to this:-

from django_mysql.models import JSONField, Model

class form_fields(models.Model):
  id = models.AutoField(primary_key=True)
  form_name = JSONField()
  text_field = models.CharField(max_length=255, null= True)

views.py:-

form_fields.objects.create(id=id, attrs=['First Form Field', 'Second input Field'],text_field='TextField')

form_fields.objects.filter(attrs=['First Form Field', 'Second input Field'])

You are adding array in character fields so you will getting each thing as a character.Other things whatever you have code will work fine.

edited Feb 21, 2017 at 13:13

answered Feb 21, 2017 at 6:50

Piyush S. Wanare

4,9836 gold badges41 silver badges55 bronze badges

3 Comments

Sidharth Over a year ago

This inspection detects names that should resolve but don't. Due to dynamic dispatch and duck typing, this is possible in a limited but useful number of cases. Top-level and class-level items are supported better than instance items.

Sidharth Over a year ago

and i am using mysql database

Sidharth Over a year ago

does't help. it stores the null value

Collectives™ on Stack Overflow

How to get List from Database to html in python - Django?

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related