This post is a work in progress. Currently, we define what a couple views may look like and in those views, we perform various useful database interactions.

django/projects/my_project/users/models.py
<br /> from django.db import models</p> <p>class User(models.Model):<br /> # username and password are equivalent to “character varying(64)” data type<br /> username = models.CharField(max_length = 64)<br /> password= models.CharField(max_length = 64)<br /> # bio is equivalent to “text” data type<br /> bio = models.TextField(max_length = 2000)</p> <p>class Transaction(models.Model):<br /> # Creates a foreign key relationship between this table’s “user_id”<br /> # column and the User class’s table’s “id” field.<br /> user_id = models.ForeignKey(User)<br /> # quantity equivalent to “integer” data type<br /> quantity = models.IntegerField()<br /> # amount equivalent to “numeric(7,2)” data type<br /> amount = models.DecimalField(max_digits = 7, decimal_places = 2)<br />

django/projects/my_project/users/models.py
<br /> from django.template import Context, loader<br /> from django.http import HttpResponse</p> <p>from users.models import User, Transaction</p> <p>def index(request):<br /> template = loader.get_template(‘users/index.html’)<br /> # Grab a list of all users, and order by username.<br /> # Alternately, we can order in reverse by passing “-username” instead of “username”<br /> all_users = User.objects.all().order_by(‘username’)<br /> # Grab user information based on the primary key, where its value is 1.<br /> user = User.objects.filter(pk = 1)<br /> # Grab transactions associated with a specific user.<br /> # “select_related()” does a join between transaction and user tables.<br /> transactions = Transaction.objects.filter(user_id = 1).select_related()</p> <p> context = Context({<br /> ‘all_users’: all_users,<br /> ‘user’: user,<br /> ‘transactions’: transactions,<br /> })</p> <p> response = template.render(context)<br /> return HttpResponse(response)<br />

django/templates/users/index.html
</p> <h2>Render All Users</h2> <p>{% if all_users %}</p> <ul> {% for user in all_users %}</p> <li>{{ user.username }}</li> <p> {% endfor %} </ul> <p>{% endif %}</p> <h2>Display A Single User’s Information</h2> <p>{{ user.username }}: {{ user.bio }}</p> <h2>Display Transactions Associated With The Above User</h2> <p>{% if transactions %}</p> <table> <tbody> {% for transaction in transactions %}</p> <tr> <td>{{ transaction.id }}</td> <td>${{ transaction.amount }}</td> <td>{{ transaction.user.username }}</td> <td>{{ transaction.user.bio }}</td> </tr> <p> {% endfor %}<br /> </tbody> </table> <p>{% endif %}<br />

This entry was posted on Tuesday, October 4th, 2011 at 8:01 pm and is filed under Django, Python. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.