Re: Help about models

[Zeynel]

Hello Greg and Jirka,

Thanks for the help.

I was rereading the tutorial to understand the ForeignKey. It says
that ForeignKey "tells  Django each Choice is related to a single
Poll."

In my case, each lawyer is associated with 1 law school; and each law
school is associated with 1 or more lawyers. Considering this I
thought that ForeignKey should tell Django that "each lawyer is
related to a single School" so I put ForeignKey under Lawyer:

class Education(models.Model):
school = models.CharField(max_length=200)

class Lawyer(models.Model):
first = models.CharField(max_length=20)
initial = models.CharField(max_length=2)
last = models.CharField(max_length=20)
year_graduated = models.DateTimeField('Year graduated')
education = models.ForeignKey(Education)

Does this make sense? And, can you explain why this is needed in terms
of searching the database? What happens if I don't use a foreign key?

Thanks again.

On Nov 9, 7:36 am, Jirka Vejrazka  wrote:
> > I commented out the ForeignKey because it caused an error.
>
> Just a small coding note - it was causing an error because you did not
> specify the model name exactly (compare the character case)
>
>    Jirka
--~--~-~--~~~---~--~~
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 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---

Re: Help about models

[Jirka Vejrazka]

> I commented out the ForeignKey because it caused an error.

Just a small coding note - it was causing an error because you did not
specify the model name exactly (compare the character case)

   Jirka

--~--~-~--~~~---~--~~
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 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---

Re: Help about models

[Greg Brown]

What you need is to keep your Education model as is (with no Lawyer
Foreignkey) and add a ManyToManyField on your Lawyer class pointing to
Education. Then you can go

Lawyer.objects.filter(education__school='...')

I think that will solve your problem

Greg



2009/11/9 Zeynel :
>
> Hello,
>
> I decided to start my own project with what I learned from part 1 of
> the tutorial.
>
> I have the project in C:\sw\sw\wkw
>
> The app sw.wkw is a prototype for a "who-knows-who" database for legal
> profession. I wanted to start with a really simple model:
>
> class Lawyer(models.Model):
>    first = models.CharField(max_length=20)
>    initial = models.CharField(max_length=2)
>    last = models.CharField(max_length=20)
>    year_graduated = models.DateTimeField('Year graduated')
>
> class Education(models.Model):
> #    lawyer = models.ForeignKey(lawyer)
>    school = models.CharField(max_length=200)
>
> I commented out the ForeignKey because it caused an error.
>
> I will only make one search in the database. I want to enter Lawyer's
> name and find all other lawyers in the database who graduated from the
> same school the same year. It's like sorting by school in a
> spreadsheet and pulling the lawyer's names. Here's the sample
> spreadsheet:
>
> https://spreadsheets.google.com/ccc?key=0Al923jWh4O4ydG1vSmx4bDVqTUFUXzVqSXhzVkcydmc=en
>
> Do you think this is the right model for what I am trying to do? Thank
> you for your comments.
>
> So far I created the tables and tomorrow I'll set up the admin and
> populate the database with some names.
>
> I am really enjoying Django. I am learning both Django and Python.
> Thanks again for your help.
> >
>



-- 
http://gregbrown.co.nz/

--~--~-~--~~~---~--~~
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 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---

Help about models

[Zeynel]

Hello,

I decided to start my own project with what I learned from part 1 of
the tutorial.

I have the project in C:\sw\sw\wkw

The app sw.wkw is a prototype for a "who-knows-who" database for legal
profession. I wanted to start with a really simple model:

class Lawyer(models.Model):
first = models.CharField(max_length=20)
initial = models.CharField(max_length=2)
last = models.CharField(max_length=20)
year_graduated = models.DateTimeField('Year graduated')

class Education(models.Model):
#lawyer = models.ForeignKey(lawyer)
school = models.CharField(max_length=200)

I commented out the ForeignKey because it caused an error.

I will only make one search in the database. I want to enter Lawyer's
name and find all other lawyers in the database who graduated from the
same school the same year. It's like sorting by school in a
spreadsheet and pulling the lawyer's names. Here's the sample
spreadsheet:

https://spreadsheets.google.com/ccc?key=0Al923jWh4O4ydG1vSmx4bDVqTUFUXzVqSXhzVkcydmc=en

Do you think this is the right model for what I am trying to do? Thank
you for your comments.

So far I created the tables and tomorrow I'll set up the admin and
populate the database with some names.

I am really enjoying Django. I am learning both Django and Python.
Thanks again for your help.
--~--~-~--~~~---~--~~
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 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---