Good Morning Tabitha.
Actually, do you have a model for StaffForm? That is the object being
instantiated and then causing the error. If there is no nics group
reference field in the StaffForm object, it may raise this error. Also, do
you have this running in a view/template? Do you have a real page that
you've tried this on, or have you just tried it in the shell?
Thanks,
Furbee
On Fri, Nov 4, 2011 at 7:02 AM, Tabitha Samuel <tabitha.sam...@gmail.com>wrote:
> 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.
>
>
--
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.
