Thank you Eric for the pointers!
But I think Django is complaining about me having too many Relationships in
table Altword, or perhaps I have typed syntax wrong and missunderstand the
error message?
Exception Value:
<class 'navi_polls.models.Altword'> has more than 1 ForeignKey to <class
'navi_polls.models.Word'>
#_______________________________________________________________________________
class Word(models.Model):
rosword = models.CharField(max_length=200)
direct_transl_word = models.CharField(max_length=120, blank=True,
null=True)
pub_date = models.DateTimeField('date published')
def __unicode__(self):
return self.rosword
#_______________________________________________________________________________
class Altword(models.Model):
#class Altword(Word):
rosword = models.*ForeignKey*(Word)
alt_ros_word = models.CharField(max_length=200)
alt_transl_word = models.CharField(max_length=200)
articulate = models.CharField(max_length=200)
wordy = models.*OneToOneField*(Word, related_name='altword_wordy',
primary_key=True)
votes = models.IntegerField(default=0)
pub_date = models.DateTimeField('date published')
def __unicode__(self):
return self.alt_ros_word
#_______________________________________________________________________________
First I tried to follow this example but then above error showed up:
https://docs.djangoproject.com/en/1.5/topics/db/examples/one_to_one/
Second time I tried this but I couldn't make it work:
http://catherinetenajeros.blogspot.se/2013/04/django-error-one-or-more-models-did-not.html
Third time I tried to play with "Multi-table inheritance". But it only
lead to Django complaining about duplicate fields which suggested that I
needed to change field names in several files. I didn't go down that path.
And it seemed "Multi-table inheritance" also complained about my first
error message about having too many relationships in Altword table.
https://docs.djangoproject.com/en/1.0/topics/db/models/#id7
How should I proceed in order to find the solution to this problem?
On Saturday, August 10, 2013 10:32:37 AM UTC+2, Eric Cheung wrote:
>
> 1) The model Word does not have the votes field, you cannot order the
> field it's not possessed.
>
> 2) You have to build a relation between the models first, check the
> relationships from Django Doc
> https://docs.djangoproject.com/en/dev/topics/db/models/#relationships
>
> On Friday, August 9, 2013 10:04:47 PM UTC+8, Pepsodent Cola wrote:
>>
>> 1.)
>> How can I order my list based on a field in a different table?
>>
>> return Word.objects.filter(direct_transl_word='')
>>
>> The above I want to do something like this where the field ('-votes') is
>> located at table Altword.
>> Nothing happens when I use this though, don't understand why?
>>
>> #return
>> Word.objects.filter(direct_transl_word='').order_by('-votes')
>>
>>
>> 2.)
>> My *altword_list.html* viewpage breaks whenever I try to use query for
>> my other table Altword.
>>
>> #return Altword.objects.filter(rosword__direct_transl_word='')
>> #return Altword.objects.filter(word__direct_transl_word='')
>>
>> #_______________________________________________________________________________
>>
>> *AltwordlistView*
>> class AltwordlistView(generic.DetailView):
>> model = Word
>> #model = Altword
>> template_name = 'navi_polls/altword_list.html'
>> context_object_name = 'poll'
>>
>> def get_queryset(self):
>> # Filter 5
>> return Word.objects.filter(direct_transl_word='')
>> #return
>> Word.objects.filter(direct_transl_word='').order_by('-votes')
>> #return Altword.objects.filter(rosword__direct_transl_word='')
>> #return Altword.objects.filter(word__direct_transl_word='')
>>
>> #_______________________________________________________________________________
>>
>> *Models*
>> class Word(models.Model):
>> rosword = models.CharField(max_length=200)
>> direct_transl_word = models.CharField(max_length=120, blank=True,
>> null=True)
>> pub_date = models.DateTimeField('date published')
>>
>> def __unicode__(self):
>> return self.rosword
>>
>> #_______________________________________________________________________________
>>
>> *Models*
>> class Altword(models.Model):
>> rosword = models.ForeignKey(Word)
>> alt_ros_word = models.CharField(max_length=200)
>> alt_transl_word = models.CharField(max_length=200)
>> articulate = models.CharField(max_length=200)
>> *votes* = models.IntegerField(default=0)
>> pub_date = models.DateTimeField('date published')
>>
>> def __unicode__(self):
>> return self.alt_ros_word
>>
>>
>>
>>
>>
--
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 post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.
