StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19414405
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2013-10-16T21:39:12.140
FavoriteCount
0
LastActivityDate
2014-06-07T16:50:14.587
LastEditDate
2014-06-07T16:50:14.587
LastEditorUserId
938207
OwnerUserId
938207
ParentId
19408755
PostTypeId
2
Score
36
ViewCount
0
LastEditorDisplayName
text
Body
I have created a simplified mock up of your application. models.py: <pre><code>from django.db import models from django.contrib.auth.models import User class Industry(models.Model): name = models.CharField(max_length=128) class FavoriteIndustry(models.Model): user = models.ForeignKey(User, related_name='favorite_industries') industry = models.ForeignKey(Industry) </code></pre> views.py: <pre><code>from rest_framework import viewsets from models import FavoriteIndustry from serializers import FavoriteIndustrySerializer class FavoriteIndustriesViewSet(viewsets.ModelViewSet): queryset = FavoriteIndustry.objects.all() serializer_class = FavoriteIndustrySerializer </code></pre> serializers.py: <pre><code>from rest_framework import serializers from models import FavoriteIndustry, Industry class FavoriteIndustrySerializer(serializers.HyperlinkedModelSerializer): class Meta: model = FavoriteIndustry fields = ('id', 'user', 'industry') </code></pre> urls.py: <pre><code>from django.conf.urls import patterns, include, url from core.api import FavoriteIndustriesViewSet favorite_industries_list = FavoriteIndustriesViewSet.as_view({ 'get': 'list', 'post': 'create' }) urlpatterns = patterns('', url(r'^favorite_industries/$', favorite_industries_list, name='favorite-industries-list'), url(r'^users/(?P<pk>[0-9]+)/$', favorite_industries_list, name='user-detail'), url(r'^industries/(?P<pk>[0-9]+)/$', favorite_industries_list, name='industry-detail'), ) </code></pre> And here are a few tests: <pre><code>>>> >>> import json >>> from django.test import Client >>> from core.models import Industry >>> >>> industry = Industry(name='candy') >>> industry.save() >>> >>> c = Client() >>> >>> response = c.get('http://localhost:8000/favorite_industries/') >>> response.content '[]' >>> >>> data = { ... 'user': 'http://localhost:8000/users/1/', ... 'industry': 'http://localhost:8000/industries/1/' ... } >>> >>> response = c.post('http://localhost:8000/favorite_industries/', json.dumps(data), 'application/json') >>> response.content '{"id": 1, "user": "http://testserver/users/1/", "industry": "http://testserver/industries/1/"}' >>> >>> response = c.get('http://localhost:8000/favorite_industries/') >>> response.content '[{"id": 1, "user": "http://testserver/users/1/", "industry": "http://testserver/industries/1/"}]' >>> </code></pre> Django REST Framework expects <code>user</code> and <code>industry</code> fields as URLs rather than ids since you are using <code>HyperlinkedModelSerializer</code>. <hr> <h1>Using IDs</h1> In case you need to use object ids instead of URLs, use <code>ModelSerializer</code> instead of <code>HyperlinkedModelSerializer</code> and pass ids to <code>user</code> and <code>industry</code>: serializers.py: <pre><code>from rest_framework import serializers from models import FavoriteIndustry, Industry class FavoriteIndustrySerializer(serializers.ModelSerializer): class Meta: model = FavoriteIndustry fields = ('id', 'user', 'industry') </code></pre> And tests: <pre><code>>>> >>> import json >>> from django.test import Client >>> from core.models import Industry >>> >>> #industry = Industry(name='candy') >>> #industry.save() >>> >>> c = Client() >>> >>> response = c.get('http://localhost:8000/favorite_industries/') >>> response.content '[{"id": 1, "user": 1, "industry": 1}, {"id": 2, "user": 1, "industry": 1}]' >>> >>> data = { ... 'user': 1, ... 'industry': 1 ... } >>> >>> response = c.post('http://localhost:8000/favorite_industries/', json.dumps(data), 'application/json') >>> response.content '{"id": 3, "user": 1, "industry": 1}' >>> >>> response = c.get('http://localhost:8000/favorite_industries/') >>> response.content '[{"id": 1, "user": 1, "industry": 1}, {"id": 2, "user": 1, "industry": 1}, {"id": 3, "user": 1, "industry": 1}]' >>> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODjango-Rest-Framework updating a foreign key BY Id
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAziz Alfoudari
UserOwnerUserId
1. USAziz Alfoudari
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PODjango-Rest-Framework updating a foreign key BY Id
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.