Here is staff/models.py from django.db import models
class NICSGroupType(models.Model): n_group_number = models.IntegerField(primary_key = True) n_group_name = models.CharField(max_length = 512) def __str__(self): return self.n_group_name class Meta: db_table = "n_nics_groups" class StaffpageAdmin(models.Model): n_id = models.IntegerField(primary_key = True) n_username = models.CharField(max_length = 50) class Meta: db_table = 'n_staffpage_admin' class Staff(models.Model): username = models.CharField(primary_key = True, max_length = 50) home_phone = models.CharField(max_length = 12, null=True) cell_phone = models.CharField(max_length = 12, null = True) home_address = models.CharField(max_length = 1024, null = True) home_city = models.CharField(max_length = 64, null = True) home_state = models.CharField(max_length = 32, null = True) home_zip = models.CharField(max_length = 10, null = True) emergency_name = models.CharField(max_length =64, null = True) emergency_phone = models.CharField(max_length = 12, null = True) nics_group = models.ForeignKey(NICSGroupType, to_field="n_group_number",db_column="nics_group", null=True,blank=True) room_number = models.CharField(max_length = 32, null = True) title = models.CharField(max_length = 64) supervisor = models.CharField(max_length = 25, null = True, blank = True) url = models.CharField(max_length = 256,null = True, blank = True) im = models.CharField(max_length = 32, null = True, blank=True) last_modification_time = models.IntegerField() start_date = models.IntegerField() creation_time = models.IntegerField() termination_date = models.IntegerField(null = True, blank = True) bio = models.TextField() photopath = models.CharField(max_length = 5048) office_phone = models.CharField(max_length=12) email = models.CharField(max_length = 256) preferred_name = models.CharField(max_length = 50, null = True, blank = True) deleted = models.BooleanField(default = False) viewable = models.BooleanField(default = True) class Meta: db_table = "n_test_staff" class TG_Staff(models.Model): g_name = models.CharField(primary_key = True, max_length = 1024) g_modification_time = models.IntegerField() g_active = models.CharField(max_length = 5) g_common_name = models.CharField(max_length = 1024) g_phone_number = models.CharField(max_length = 1024) g_default_project = models.CharField(max_length = 1024) g_office_address = models.CharField(max_length = 1024) g_bz_phone = models.CharField(max_length = 1024) g_bz_phone_ext = models.CharField(max_length = 1024) g_citizenship = models.CharField(max_length = 1024) g_street_address = models.CharField(max_length = 1024) g_street_address2 = models.CharField(max_length = 1024) g_city = models.CharField(max_length = 1024) g_state = models.CharField(max_length = 1024) g_zip = models.CharField(max_length = 1024) g_country = models.CharField(max_length = 1024) g_dept = models.CharField(max_length = 1024) g_tg_person_id = models.CharField(max_length = 1024) g_org = models.CharField(max_length = 1024) g_position = models.CharField(max_length = 1024) g_home_phone = models.CharField(max_length = 1024) g_fax = models.CharField(max_length = 1024) g_ldap_id = models.IntegerField() g_email_address = models.CharField(max_length = 1024) class Meta: db_table = "g_user" Is this what you needed? Tabitha On Nov 4, 2:00 am, Furbee <furbeena...@gmail.com> wrote: > Hi Tabitha, > > I wish I could supply a quick and simple answer to fix what's going on in > your database, but nothing obvious is standing out. Can you supply your > model for StaffForm? That seems to be where the problem lies, since we can > get details from the model and view elsewhere. > > Thanks, > > Furbee > > On Thu, Nov 3, 2011 at 7:22 PM, Tabitha Samuel > <tabitha.sam...@gmail.com>wrote: > > > > > > > > > K, so that worked... > > > This is what I got: > > In [5]: i = Staff.objects.using('gold').get(username='tsamuel') > > > In [6]: i.nics_group.n_group_name > > Out[6]: u'Systems and Operations' > > > Looks like the foreign key is working fine from the db's perspective. > > This is how I'm getting the form: > > form = StaffForm(instance = Staff.objects.using('gold').get(username > > =current_staff)) > > where current_staff = 'tsamuel' > > and then if I do a print form, I get a relation n_nics_groups does not > > exist error. > > > Once again, thank you so much for your help, I really appreciate it! > > > Tabitha > > > On Nov 3, 1:26 pm, Furbee <furbeena...@gmail.com> wrote: > > > I may have lead you astray. I set up the same models on my end and get > > the > > > same query; it didn't show the join of the foreign key in the QuerySet of > > > Staff, but when I did a get() on username='tsamuel' I got a Staff object. > > > Then I was able to get the group they belonged to. This was successful > > for > > > me: > > > > Here's my data: > > > > table: n_nics_groups > > > n_group_number; n_group_name > > > 1; "TestGroup1" > > > 2; "TestGroup2" > > > 3; "TestGroup3" > > > > table: n_test_staff > > > "tfigura";"";"";"";"";"";"";"";"";2;"";"''";"";"";"";1;1;1;;"''";"''";"''";"''";"";FALSE;TRUE > > > "tsamuel";"";"";"";"";"";"";"";"";1;"";"''";"";"";"";1;1;1;;"''";"''";"''";"''";"''";FALSE;TRUE > > > > 'tfigura' is in group with n_group_number 2, tsamuel is in group with > > > n_group_number 1. > > > > python manage.py shell: > > > > >>> from project.models import NICSGroupType, Staff > > > >>> i = Staff.objects.get(username='tsamuel') > > > >>> i.nics_group.n_group_name > > > >>> u'TestGroup1' > > > > Is this operational for your instance? If not, I would double check that > > > the n_nics_groups table definitely exists in the datasource you defined > > as > > > 'gold.' This should be defined in the DATABASES section of settings.py. > > It > > > looks like it is the database 'public' from your example, but double > > check > > > that the 'gold' DATABASE points there. > > > > Otherwise, I wonder if it is somewhere where you are defining the form > > > object. First, let's verify that the foreign key reference is being > > honored > > > on your system, by running the above test, to verify that the group is > > > printed, when you get() a specific record and print the > > > nics_group.n_group_name. > > > > Thanks, > > > > Furbee > > > > On Wed, Nov 2, 2011 at 5:09 PM, Tabitha Samuel > > > <tabitha.sam...@gmail.com>wrote:> > > Thank you so much for your reply! So I got a "Staff object has no > > > > attribute 'query'" error when I did it with the get. I got the sql > > > > when I tried it with the filter instead (instance = > > > > Staff.objects.using('gold').filter(username='tsamuel') >> > > > > str(instance.query))this is what I'm getting: > > > > > 'SELECT "n_test_staff"."username", "n_test_staff"."home_phone", > > > > "n_test_staff"."cell_phone", "n_test_staff"."home_address", > > > > "n_test_staff"."home_city", "n_test_staff"."home_state", > > > > "n_test_staff"."home_zip", "n_test_staff"."emergency_name", > > > > "n_test_staff"."emergency_phone", "n_test_staff"."nics_group", > > > > "n_test_staff"."room_number", "n_test_staff"."title", > > > > "n_test_staff"."supervisor", "n_test_staff"."url", > > > > "n_test_staff"."im", "n_test_staff"."last_modification_time", > > > > "n_test_staff"."start_date", "n_test_staff"."creation_time", > > > > "n_test_staff"."termination_date", "n_test_staff"."bio", > > > > "n_test_staff"."photopath", "n_test_staff"."office_phone", > > > > "n_test_staff"."email", "n_test_staff"."preferred_name", > > > > "n_test_staff"."deleted", "n_test_staff"."viewable" FROM > > > > "n_test_staff" WHERE "n_test_staff"."username" = tsamuel ' > > > > > Looks like from the query, is not looking into the n_nics_groups > > > > table. Question is why? > > > > > Tabitha > > > > > On Nov 2, 6:00 pm, Furbee <furbeena...@gmail.com> wrote: > > > > > Can you try this and tell us what you see: > > > > > > Run a shell using python manage.py shell > > > > > > >>> instance = Staff.objects.using('gold').get(username='tsamuel') > > > > > >>> str(instance.query) > > > > > > This will tell us whether or not the database, reference, and such > > are > > > > > correctly translating into a query. The error means Django is > > sending an > > > > > erroneous query to your database layer. > > > > > > Furbeenator > > > > > > On Wed, Nov 2, 2011 at 1:54 PM, Tabitha Samuel < > > tabitha.sam...@gmail.com > > > > >wrote: > > > > > > > Hi, > > > > > > > In brief here is my problem. I have two simple tables, one has a > > one > > > > > > to many relation with the other. The problem I run into is that > > when I > > > > > > try to create a form instance of the child, and try to print it or > > > > > > render it in a template, I run into a "relation not found" error > > for > > > > > > the parent. Simply querying the parent works without a problem. > > > > > > > This is what my models.py looks like: > > > > > > from django.db import models > > > > > > > class NICSGroupType(models.Model): > > > > > > n_group_number = models.IntegerField(primary_key = True) > > > > > > n_group_name = models.CharField(max_length = 512) > > > > > > class Meta: > > > > > > db_table = "n_nics_groups" > > > > > > > class Staff(models.Model): > > > > > > username = models.CharField(primary_key = > > True, > > > > > > max_length = 50) > > > > > > home_phone = models.CharField(max_length = 12, > > > > > > null=True) > > > > > > cell_phone = models.CharField(max_length = 12, > > > > > > null = True) > > > > > > home_address = models.CharField(max_length = > > 1024, > > > > > > null = True) > > > > > > home_city = models.CharField(max_length = 64, > > > > > > null = True) > > > > > > home_state = models.CharField(max_length = 32, > > > > > > null = True) > > > > > > home_zip = models.CharField(max_length = 10, > > > > > > null = True) > > > > > > emergency_name = models.CharField(max_length =64, > > > > > > null = True) > > > > > > emergency_phone = models.CharField(max_length = 12, > > > > > > null = True) > > > > > > nics_group = models.ForeignKey(NICSGroupType, > > > > > > to_field ='n_group_number', db_column="nics_group", > > > > > > null=True,blank=True) > > > > > > room_number = models.CharField(max_length = 32, > > > > > > null = True) > > > > > > title = models.CharField(max_length = 64) > > > > > > supervisor = models.CharField(max_length = 25, > > > > > > null = True, blank = True) > > > > > > url = models.CharField(max_length = > > > > > > 256,null = True, blank = True) > > > > > > im = models.CharField(max_length = 32, > > > > > > null = True, blank=True) > > > > > > last_modification_time = models.IntegerField() > > > > > > start_date = models.IntegerField() > > > > > > creation_time = models.IntegerField() > > > > > > termination_date = models.IntegerField(null = True, > > > > > > blank = True) > > > > > > bio = models.TextField() > > > > > > photopath = models.CharField(max_length = > > 5048) > > > > > > office_phone = models.CharField(max_length=12) > > > > > > email = models.CharField(max_length = 256) > > > > > > preferred_name = models.CharField(max_length = 50, > > > > > > null = True, blank = True) > > > > > > deleted = models.BooleanField(default = > > False) > > > > > > viewable = models.BooleanField(default = > > True) > > > > > > > class Meta: > > > > > > db_table = "n_test_staff" > > > > > > > The tables that it corresponds to looks like this: > > > > > > > \d n_test_staff > > > > > > Table "public.n_test_staff" > > > > > > Column | Type | Modifiers > > > > > > ------------------------+------------------------+----------- > > > > > > username | character varying(25) | > > > > > > home_phone | character varying(12) | > > > > > > cell_phone | character varying(12) | > > > > > > home_address | character varying(256) | > > > > > > home_city | character varying(64) | > > > > > > home_state | character varying(32) | > > > > > > home_zip | character varying(10) | > > > > > > emergency_name | character varying(64) | > > > > > > emergency_phone | character varying(12) | > > > > > > nics_group | integer | > > > > > > room_number | character varying(32) | > > > > > > title | character varying(64) | > > > > > > supervisor | character varying(25) | > > > > > > url | character varying(256) | > > > > > > im | character varying(32) | > > > > > > last_modification_time | integer | > > > > > > start_date | integer | > > > > > > creation_time | integer | > > > > > > termination_date | integer | > > > > > > bio | text | > > > > > > photopath | text | > > > > > > office_phone | character varying(12) | > > > > > > email | text | > > > > > > preferred_name | character varying(50) | > > > > > > deleted | boolean | > > > > > > viewable > > ... > > read more » -- 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.