CODEWITHSUNDEEP
djangodjango-mptt
sean2000
sean2000

Reputation: 516

How can create a json tree from django-mptt?

I want to use the JavaScript InfoVis Tooljit ( http://thejit.org ) to render a tree of mptt nodes in django. How can i create the required json structure (see http://thejit.org/static/v20/Jit/Examples/Spacetree/example1.code.html for an example) in django?

Thanks

Upvotes: 12

Views: 7499

Answers (6)

Gaurav Nagar
Gaurav Nagar

Reputation: 381

In Django view

from django.core import serializers
import json

json_str = serializers.serialize("json",Categories.objects.all())
json_data = json.loads(json_str)

Upvotes: 0

regiov
regiov

Reputation: 51

If someone is looking for a solution based on templates with the recursetree tag, it is possible to use get_next_sibling to control commas. Adapting the example provided by Chris:

{% load mptt_tags %}
[
{% recursetree nodes %}
{
    "id": "{{ node.id }}",   
    "name": "{{ node.name }}",   
    "data": {},   
    "children": [{{ children }}]
}{% if node.get_next_sibling %},{% endif %}
{% endrecursetree %}
]

Upvotes: 2

JayCrossler
JayCrossler

Reputation: 2129

I found a great solution to rendering children with sub-data in this thread: fastest way to create JSON to reflect a tree structure in Python / Django using mptt (See the accepted answer by craigds). His method also caches results and uses the built in json.dumps to create the structure.

Upvotes: 0

dan-klasson
dan-klasson

Reputation: 14230

If you want to write your own serializer or do this from a view you can do:

from mptt.templatetags.mptt_tags import cache_tree_children

queryset = Foo.objects.all().select_related('bar')
queryset = cache_tree_children(queryset)

Now the queryset is "cached", meaning you can use model API methods like get_children() without it hitting the database again.

Upvotes: 0

Tomasz Karbownicki
Tomasz Karbownicki

Reputation: 785

Create JSON without trailing comma problem:

{% full_tree_for_model YOUR_APP.YOUR_MODEL as nodes %}

var json =  {% for genre,structure in nodes|tree_info %}{% if structure.new_level %} [{ {% else %} },{ {% endif %}
id: "{{ genre.id }}",
children: {% if genre.is_leaf_node %}[]{% endif %}
{% for level in structure.closed_levels %}}]{% endfor %}{% endfor %}

Upvotes: 2

Chris
Chris

Reputation: 2477

If you use the template functionality of django-mptt to generate the JSON data you should be able to do something like the following:

var json =    
{% recursetree nodes %}
{
    id: "{{ node.id }}",   
    name: "{{ node.name }}",   
    data: {},   
    children: [{{ children }}]
},
{% endrecursetree %}

The children tag is brilliant, basically calling recursetree for each child of the node. However there is a little messiness generated around commas with this solution as the mptt example is around list elements where such things aren't a problem.

A slightly larger bit of code solves this:

var json =    
{
    id: "{{ root.id }}",   
    name: "{{ root.name }}",   
    data: {},   
    children: [{% recursetree root.children %}
    {
        id: "{{ node.id }}",   
        name: "{{ node.name }}",   
        data: {},   
        children: [{{ children }}]
    }
    {% endrecursetree %}]
}

By making a distinction between the root node (presuming there is only one) which does not reside within an array but is instead assigned to a variable, compared to other nodes which live within the children of another node, the var x = y, issue is avoided.

There is still a problem with children: [x,y,z,] having a trailing comma. If that final comma is raising errors then in the view that has called the template you can always do a quick string replace to replace ,] with ]

Alternatively you could alter the {{ children }} call of mptt in some way to take a join string, but that would involve much more work.

Upvotes: 7

Related Questions