Thank you for your response RD
Long live Django :D
On Nov 17, 6:14 pm, Rajesh Dhawan <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
>
> > In my application I'm trying to serialize the following model to json:
>
> > class Node(models.Model):
> > name = models.CharField(db_column="NAME",
> > max_length=30,
> > db_index=True)
> > description = models.CharField(db_column="DESCRIPTION",
> > db_index=True,
> > max_length=255)
> > registrationDate=models.DateField(db_column="REGISTRATION_DATE",
> > db_index=True)
> > parentNodeObject = models.ForeignKey("self", db_column="PARENT",
> > related_name="parent_fk")
>
> > rootNodeObject= models.ForeignKey("self", db_column="ROOT",
> > related_name="root_fk")
>
> > Before I serialize the instances to json I retreived all the nodes:
> > models.Node.objects.select_related
> > ('parentNodeObject','rootNodeObject')
> > The problem is that for all the parentNodeObjects and rootNodeObjects
> > retrieved from DB, in the json string appears only the model's id.
> > I don't know if this is normal or not but I'd like to have access to
> > all the properties of all the objects retrieved,
> > even if the final json string is huge.
>
> This is normal behaviour -- the built-in model serializers traverse
> only over local fields of the model and not over foreign keys.
>
> > Is this possible?
>
> Yes. In two ways:
>
> 1. If you are willing to write your own serializer, take a look at the
> SERIALIZATION_MODULES setting and the interface you will need to
> implement. To implement the interface, you would normally extend the
> abstract base class: django.core.serializers.Serializer defined in
> django/core/serializers/base.py
>
> 2. Create a list of dictionaries for your result set. Where each list
> element represents one row of data and each row contains a dictionary
> of the fields you are interested in. Then use
> django.utils.simplejson.dumps to convert that list to a JSON string.
>
> -RD
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
