Alright, I've been struggling with this for a while, so I hope someone
can help me. I'm not even sure if I can ask the question
intelligently enough for a reply. I'll paraphrase the problem using a
subset of my model. I'm familiar with DB programming but not good at
it right now!
I'm developing a membership registration form that is collecting data
for several tables. I also have tables set up to store attributes
about the data I'm collecting (e.g., telephone information can be
"home," "business," "mobile," etc.). In essence, I have foreign keys
set up within several tables. I want to create entries in each of the
tables (user id, person inform, address, contact info, ...) for new
data, and reference the attribute id for the appropriate foreign
keys. The collecting and storing of the new data is straightforward
enough. However, how do I retrieve/store the correct key/id for the
attribute information? I generate a drop-down with the valid
selections "home," "mobile," etc.) and then want to store it's
associated id: Any help/suggestions would be greatly appreciated.
Here's and abridged example:
class Userid(models.Model):
user_id = models.CharField(verbose_name="User ID", maxlength=15,
primary_key=True)
password = models.CharField(verbose_name="Password", maxlength=15)
password_verify = models.CharField(verbose_name="Verify Password",
maxlength=15)
email = models.EmailField(verbose_name="e-mail")
email_verify = models.EmailField(verbose_name="Re-enter e-mail")
class Person(models.Model):
user_id = models.ForeignKey(Userid)
first_name = models.CharField(verbose_name="First Name",
maxlength=50)
middle_name = models.CharField(verbose_name="Middle Initial/
Name",maxlength=50)
last_name = models.CharField(verbose_name="Last Name",maxlength=75)
dob = models.DateField(verbose_name="Birth Date")
ssn = models.CharField(verbose_name="Social Security #", maxlength=9,
blank=True)
gender = models.ForeignKey(GenderType, verbose_name="Gender")
created_at = models.DateTimeField(default=datetime.now)
updated_at = models.DateTimeField(default=datetime.now)
class TelecommunicationNumber(models.Model):
area_code = models.CharField(maxlength=10)
contact_number = models.CharField(maxlength=40)
extension = models.CharField(maxlength=10)
country = models.ForeignKey(Country)
type = models.ForeignKey(TelecommuncationType)
unformatted_number = models.CharField(maxlength=70,editable=False)
created_at = models.DateTimeField(default=datetime.now)
updated_at = models.DateTimeField(default=datetime.now)
class TelecommuncationType(models.Model):
name = models.CharField(maxlength=50)
description = models.CharField(maxlength=100, blank=True)
created_at = models.DateTimeField(auto_now_add=True, editable=False)
updated_at = models.DateTimeField(auto_now=True, editable=False)
class Country(models.Model):
name = models.CharField(maxlength=100)
internet_code = models.CharField(maxlength=2, blank=True)
tele_code = models.CharField(maxlength=10, blank=True)
abbr = models.CharField(maxlength=10, blank=True)
number = models.IntegerField(null=True, blank=True)
created_at = models.DateTimeField(auto_now_add=True, editable=False)
updated_at = models.DateTimeField(auto_now=True, editable=False)
FORM:
class RegistrationForm(forms.Form):
...
phone_type = forms.ChoiceField(choices=[(c.description,
c.name) for c in TelecommuncationType.objects.all()])
...
gender_type = forms.ChoiceField(choices=[(c.description, c.name) for
c in GenderType.objects.all()])
...
country_id = forms.ChoiceField(choices=[(c.abbr, c.name) for c in
Country.objects.all()])
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
