Daniel Roseman adviced me to use the Shell. This was a fantastic idea, and
one I should have thought of myself! Anyway this helped me realize that I
was referencing related models the wrong way. For some reason I thought
that you should reference the model name and not the foreign key field
name. It might just be me, but the documentation could seem a bit ambiguous
on this point as all field names are lower case model names.
Thanks for the help!
Den tirsdag den 17. september 2013 22.29.38 UTC+2 skrev Johan Bergkvist:
>
> Hi
> I'm quite new to both django and python, and OOP for that matter. I do
> have some embedded programming experience though.
> I have a question regarding querysets and dictionaries, I think.
>
> I was trying to build a model that provides an overview for subscribed
> customers over their services and subscription status, etc.
>
> I have a model like this:
> class Customer (models.Model):
> user_id = models.AutoField( primary_key=True )
> auth_user = models.OneToOneField( User)
> subscription_type = models.ForeignKey( SubscType, related_name='type',
> null = 'true', blank = 'true' )
> first_name = models.CharField( max_length = 64, verbose_name =
> 'Fornavn' )
> last_name = models.CharField( max_length = 64, verbose_name =
> 'Efternavn' )
> email_address = models.EmailField( max_length = 75, verbose_name =
> 'eMail adresse' )
> join_date = models.DateField(auto_now_add = 'True', verbose_name =
> 'Oprettet dato')
> delivery_address = models.ForeignKey( Address,
> related_name='delivery', null = 'true', blank = 'true', verbose_name =
> 'Leveringsadresse')
> address = models.ForeignKey( Address, related_name='home',
> verbose_name = 'Hjemmeadresse' )
> phone_number = models.IntegerField(max_length = 10, verbose_name =
> 'Telefon nummer')
> mobile_number = models.IntegerField(max_length = 10, blank = 'true',
> null = 'true', verbose_name = 'Mobilnummer')
> image = models.ImageField(upload_to = 'Customer_img', blank = 'true',
> verbose_name = 'Billede')
>
> class customerHistory (models.Model):
> customer_id = models.ForeignKey( Customer, related_name ='customer' )
> used_service = models.ManyToManyField(Services,
> related_name='services' )
> action_date = models.DateField(auto_now_add = 'True')
> notes = models.TextField(verbose_name = 'Noter til handling')
>
> views like so:
> class CustomerInfo(TemplateView):
> #info page, displays base info about customer such as address, phone
> number and subscription entries
> template_name = "subscribtions/info.html"
>
>
> def get_context_data(self, **kwargs):
> context = super(CustomerInfo, self).get_context_data(**kwargs)
>
> context = Customer.objects.filter( auth_user = self.request.user
> ).values(
> 'first_name',
> 'last_name',
> 'address',
> 'delivery_address',
> 'phone_number',
> 'mobile_number',
> 'email_address',
> 'join_date',
> 'subscription_type',
> 'image'
> ).get()
> return { 'info' : context }
>
> First of all, when I ommit the .get() method I cannot iterate over the
> above query, I just get an empty queryset when doing this:
> {% for key, value in info.items %}
> <h3>{{ key }}:</h3> <p> {{ value }} </p>
> {% empty %}
> <p> no data </p>
> {% endfor %}
>
> I guess this has something to do with it not being a dictionary without
> the .get() method. But in the documentation it seems that it should return
> a iterable, I might be using it wrong, any suggestions?
>
> Second question is:
> When I try to to a "backwards relation" in the template, like so:
> {% for services in info.customerhistory_set.all %}
> {{ services }}
> {% endfor %}
> It also winds up empty.
> It might be that I'm interpreting the documentation wrong but I've been
> googling on this subject and tried several different combinations. Any help?
>
> Thanks
> Johan
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.
