On Dec 28, 11:48 am, David Zhou <[EMAIL PROTECTED]> wrote:
On Dec 28, 2006, at 10:19 AM, Trey wrote:
> class Post(models.Model):
> postId = models.AutoField(primary_key = True)
> userId = models.ForeignKey(User, db_column = 'userId')
> title = models.CharField(maxlength = 100)
> class User(models.Model):
> userId = models.AutoField(primary_key = True)
> alias = models.CharField(maxlength = 100)AFAIK, Django automtically
creates an auto-incrementing primary key,
so you don't need to explicitly specify one in models unless you want
something else to be a primary key.
> All I want to do is select a Post with a PK and have it return a User
> model as well. If not that, then some way I can get the same
> information. If someone could illuminate the standard way of doing
> this
> I would be very grateful.It should work as indicated in that example in the
doc.
If you have:
class User(models.Model):
alias = models.CharField(maxlength=100)
class Post(models.Model):
title = models.CharField(maxlength=100)
user = models.ForeignKey(User)
You should be able to do:
user1 = User(alias='bob')
user1.save()
post1 = Post(title='blah', user=user1)
post1.save()
And then to access the related user of post1:
post1.user.alias
which should spit out 'bob'
And what's more: you can take the user and do:
user.post_set
which would return all the posts made by that user!
see: http://www.djangoproject.com/documentation/db_api/#backward
(I haven't tested any of this, but it's basically a variation of the
sample page at:http://www.djangoproject.com/documentation/models/
many_to_one/ )
I would recommend reading the DB access API documentation, it's pretty
extensive.
http://www.djangoproject.com/documentation/db_api/
btw, I'm a n00b too.
---
David Zhou
[EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
