So this is how I'm creating the staff form:
def staff_info(request, *args, **kws):
class StaffForm(forms.ModelForm):
class Meta:
model= Staff
....
....
....
if request.method == 'POST' and request.POST['event'] ==
'choosestaff':
current_staff =
request.POST.get('selectstaff')
elif request.method == 'POST' and request.POST['event'] ==
'editstaff':
#print
request
current_staff =
request.POST.get('username')
errors =
validate_staff(request)
if errors is not None and len(errors) ==
0:
print
request.POST
staffinstance = Staff.objects.using('gold').get(username =
current_staff)
#new_form =
StaffForm(instance=staffinstance)
#print
new_form
staff_form = StaffForm(request.POST,
instance=staffinstance).using('gold')
staff_form.last_modification_time =
datetime.now()
staff_form.supervisor =
staffinstance.supervisor
staff_form.start_date =
staffinstance.start_date
staff_form.creation_time =
staffinstance.creation_time
staff_form.termination_date =
staffinstance.termination_date
staff_form.using('gold').save()
else:
current_staff =
request.user.username
tg_info,staff, nics_info =
get_tg_info(current_staff)
groups =
NICSGroupType.objects.using('gold').all()
form = StaffForm(instance =
Staff.objects.using('gold').select_related().get(username =
current_staff))
print
form
return render_to_response('staff/staffinfo.html',{'form':form,
'tginfo':tg_info, 'nicsinfo': nics_info, 'staff':staff,
'is_admin':is_admin, 'errors':errors},context_instance =
RequestContext(request))
Funny thing is that this worked perfectly in version 1.1a of django.
All trouble started when I switched to 1.3. I was using extDbManager
to create the gold connection in the 1.1 version since 'gold' is a non-
default db (used only for this model) and 1.1 only had in built
support for a single db.
And yes, I do have a page for the view. Problem is that it is passcode
protected and I don't think I'm at liberty to give you access to it. :
(
Tabitha
On Nov 4, 10:44 am, Mark Furbee <markfur...@gmail.com> wrote:
> 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')
>
> ...
>
> 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.
