Hi all
Im trying to write my first djano app. It's for a lab where users will have a
list of
experiments each experiment consists of several procedures in order. Very much
like
the Pizzas and Toppings in the documentation but procedures are ordered - as
toppings
should be for pizzas :-)
I want to have a list of experimnents and for each experiment all the details
like
the procedures for that exp.
My problem is that I'm a bit confused as to what objects I should be passing as
context to the templates and in the templates how I should be referencing what
I pass
in. Im passing both a list from Experiment.objects.all() and
Procedures.objects.all()
into experiments.html but really I should be able to get the procedures list
from a
query of the experiment object. The tutes and wiki are good but I still haven't
get
got over the first hill of conceptually what I'm doing.
In urls.py I have:
from django.conf.urls.defaults import *
from proteomics_dev.lab.models import Experiment, Procedure
info_dict = {
'queryset': Experiment.objects.all(),
}
urlpatterns = patterns('',
# This will invoke methods defined in views.py and gives a list of
experiments.
(r'^exps/', 'proteomics_dev.lab.views.experiments'),
# This is for a generic view which shows the detail for a specific
experiment.
(r'^detail/(?P\d+)', list_detail.object_detail, info_dict),
MODELS
# An Experiment consists of a number of procedures in a specified order.
# There will be many procedures in an experiment and a procedure can be in
several
# experiments.
class Procedure(models.Model):
name = models.CharField(maxlength=255, core=True)
description = models.CharField(maxlength=255, core=True)
def __str__(self):
return self.name
class Experiment(models.Model):
name = models.CharField(maxlength=255)
description = models.CharField(maxlength=255)
def __str__(self):
return "%s: %s" % (self.name, self.description)
# I'm using an intermediary table experiment_procedure to implement the
many-to-many
# with an additional field, sequence, to implement the ordering of the
procedures.
class Experiment_Procedure:
experiment = models.ForeignKey(Experiment, core=True)
procedure = models.ForeignKey(Procedure)
sequence = models.PositiveSmallIntegerField()
def __str__(self):
return "%s %s %s" % (self.sequence, self.experiment, self.procedure)
Here is an example of the table lab_experiment_procedure and what data it might
contain:
+-------------------
id exp_id proc_id sequence
1 1 10 1
2 1 15 2
3 1 9 3
4 2 10 1
5 2 9 2
+-------------------------
As you can see it relates procedures to experiments i.e. what procedures and
the
order of those that are in each experiment. The id field would not really be
used at
all - django just adds it.
VIEWS
def experiments(request):
experiment_list = Experiment.objects.all()
procedure_list = Procedure.objects.all()
return render_to_response('lab/experiments.html',
{'experiment_list': experiment_list,
'procedure_list': procedure_list,
})
def procedures(request):
procedure_list = Procedure.objects.all()
return render_to_response('lab/procedures.html',
{'procedure_list': procedure_list})
TEMPLATES
templates/lab/experiments.html
------------------------------
<h2>List of Lab Experiments</h2>
{% if experiment_list %}
<table border=1 width=70%>
<tr><th>ID</th><th>Name</th><th>Description</th></tr>
{% for exp in experiment_list %}
<tr>
<td>{{ exp.id}}</td>
<td><a href="/exps/{{ exp.id }}/edit/">{{ exp.name }}</a></td>
<td>{{ exp.description }}</td>
<!-- INCLUDE HERE A COUNT OF THE PROCEDURES -->
</tr>
{% endfor %}
</table>
{% else %}
<p>Sorry, no experiments available.</p>
{% endif %}
<br>
Testing this is a list of dictionary entries.<br>
0 {{ filtered_experiment_list.0 }}<br>
1 {{ filtered_experiment_list.1 }}<br>
Testing {% for proc in procedure_list %}
<br> {{ proc.name }}
{% endfor %}
templates/lab/experiment_detail.html
------------------------------------
<h2>Experiment Detail</h2>
<b>ID:</b> {{ object.id }}<br>
<b>Name</b>: {{ object.name }}<br>
<b>Description</b>: {{ object.description}}
<br>
List of procedures for this experiment.
{{ ??? procedure_list.name }}
INCLUDE HERE A LIST OF THE PROCEDURES NAMES AND DESCRIPTIONS FOR THIS EXP.
--
Michael Lake
Computational Research Support Unit
Science Faculty, UTS
Ph: 9514 2238
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
