I found this patch for the raw function (https://
code.djangoproject.com/attachment/ticket/13805/manager.patch), because
according to this ticket (https://code.djangoproject.com/ticket/
13805), .raw does not work in a multi db env. So this is what I have:
in django/db/models/manager.py, I have created a new function:
def raw(self, raw_query, params=None, using=None, *args, **kwargs):
if using is None:
using = self._db
print using
return RawQuerySet(raw_query=raw_query, model=self.model,
params=params, using=using, *args, **kwargs)
The print using returns "gold" so I know it is using this method.
Now, I have
form = StaffForm(instance = Staff.objects.raw("SELECT s.*,
g.n_group_name FROM n_test_staff s LEFT JOIN n_nics_groups g
ON(g.n_group_number = s.nics_group) WHERE s.username =
'tsamuel'",None,"gold"))
in my view and I am still getting the error:
AttributeError at /staff/staffinfo
'RawQuerySet' object has no attribute '_meta'
This is the traceback:
Traceback:
File "/nics/a/applications/gibbs/python/site-packages_django/django/
core/handlers/base.py" in get_response
111. response = callback(request,
*callback_args, **callback_kwargs)
File "/nics/a/applications/gibbs/python/site-packages_django/django/
contrib/auth/decorators.py" in _wrapped_view
23. return view_func(request, *args, **kwargs)
File "/nics/a/home/tsamuel/tssandbox/gibbs/utils/decorators.py" in
decorate
11. return view_func(request, *args, **kws)
File "/nics/a/home/tsamuel/tssandbox/gibbs/../gibbs/staff/views.py" in
staff_info
156. form = StaffForm(instance = Staff.objects.raw("SELECT s.*,
g.n_group_name FROM n_test_staff s LEFT JOIN n_nics_groups g
ON(g.n_group_number = s.nics_group) WHERE s.username =
'tsamuel'",None,"gold"))
File "/nics/a/applications/gibbs/python/site-packages_django/django/
forms/models.py" in __init__
237. object_data = model_to_dict(instance, opts.fields,
opts.exclude)
File "/nics/a/applications/gibbs/python/site-packages_django/django/
forms/models.py" in model_to_dict
110. opts = instance._meta
Exception Type: AttributeError at /staff/staffinfo
Exception Value: 'RawQuerySet' object has no attribute '_meta'
On Nov 4, 2:49 pm, Tabitha Samuel <tabitha.sam...@gmail.com> wrote:
> One thought I have is that the using() is messing things up. Would it
> be possible for you to create a second non-default db, throw these two
> tables in there and then try the same thing? If that works for you,
> then I must have a ghost sitting in my system! :-|
>
> On Nov 4, 2:28 pm, Furbee <furbeena...@gmail.com> wrote:
>
>
>
>
>
>
>
> > That is very strange... I recreated this on my development system and it
> > worked fine. I looked for Django bugs, but haven't found any related to
> > this issue. To be clear, the table n_nics_groups definitely exists in the
> > same database as n_test_staff, right? It does in mine because I used python
> > manage.py syncdb to create them from the models. If so, maybe we should try
> > to create a raw() query to see if the system has a bug creating the query.
> > This should be similar:
>
> > form = StaffForm(instance = Staff.objects.raw("SELECT s.*, g.n_group_name
> > FROM n_test_staff s LEFT JOIN n_nics_groups g ON(g.n_group_number =
> > s.nics_group) WHERE s.username = 'tsamuel'))
>
> > If that throws an error, we may have a problem in the DB layer.
>
> > Thanks,
>
> > Furbee
>
> > On Fri, Nov 4, 2011 at 10:29 AM, Tabitha Samuel
> > <tabitha.sam...@gmail.com>wrote:
>
> > > The error that I'm getting is on the second form instantiation, that
> > > is on the line:
>
> > > form = StaffForm(instance = Staff.objects.using('gold').get(username =
> > > current_staff)
> > > where current_staff='tsamuel' for instance
>
> > > This is the traceback of the error that I get when I do a print form
> > > right after getting the form:
> > > Environment:
>
> > > Request Method: GET
> > > Request URL:http://watermelon.nics.utk.edu:8004/staff/staffinfo
>
> > > Django Version: 1.3.1
> > > Python Version: 2.6.2
> > > Installed Applications:
> > > ['django.contrib.auth',
> > > 'django.contrib.contenttypes',
> > > 'django.contrib.sessions',
> > > 'django.contrib.sites',
> > > 'gibbs.quartermaster',
> > > 'gibbs.userportal',
> > > 'gibbs.reports',
> > > 'gibbs.events',
> > > 'gibbs.job_stats',
> > > 'gibbs.simulator',
> > > 'gibbs.staff']
> > > Installed Middleware:
> > > ('django.contrib.csrf.middleware.CsrfViewMiddleware',
> > > 'django.middleware.common.CommonMiddleware',
> > > 'django.contrib.csrf.middleware.CsrfResponseMiddleware',
> > > 'django.contrib.sessions.middleware.SessionMiddleware',
> > > 'django.contrib.auth.middleware.AuthenticationMiddleware')
>
> > > Traceback:
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > core/handlers/base.py" in get_response
> > > 111. response = callback(request,
> > > *callback_args, **callback_kwargs)
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > contrib/auth/decorators.py" in _wrapped_view
> > > 23. return view_func(request, *args, **kwargs)
> > > File "/nics/a/home/tsamuel/tssandbox/gibbs/utils/decorators.py" in
> > > decorate
> > > 11. return view_func(request, *args, **kws)
> > > File "/nics/a/home/tsamuel/tssandbox/gibbs/../gibbs/staff/views.py" in
> > > staff_info
> > > 159. print form
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > utils/encoding.py" in __str__
> > > 27. return self.__unicode__().encode('utf-8')
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > forms/forms.py" in __unicode__
> > > 95. return self.as_table()
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > forms/forms.py" in as_table
> > > 217. errors_on_separate_row = False)
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > forms/forms.py" in _html_output
> > > 180. 'field': unicode(bf),
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > forms/forms.py" in __unicode__
> > > 408. return self.as_widget()
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > forms/forms.py" in as_widget
> > > 439. return widget.render(name, self.value(), attrs=attrs)
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > forms/widgets.py" in render
> > > 516. options = self.render_options(choices, [value])
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > forms/widgets.py" in render_options
> > > 533. for option_value, option_label in chain(self.choices,
> > > choices):
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/
> > > forms/models.py" in __iter__
> > > 882. for obj in self.queryset.all():
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/db/
> > > models/query.py" in _result_iter
> > > 107. self._fill_cache()
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/db/
> > > models/query.py" in _fill_cache
> > > 772.
> > > self._result_cache.append(self._iter.next())
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/db/
> > > models/query.py" in iterator
> > > 273. for row in compiler.results_iter():
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/db/
> > > models/sql/compiler.py" in results_iter
> > > 680. for rows in self.execute_sql(MULTI):
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/db/
> > > models/sql/compiler.py" in execute_sql
> > > 735. cursor.execute(sql, params)
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/db/
> > > backends/util.py" in execute
> > > 34. return self.cursor.execute(sql, params)
> > > File "/nics/a/applications/gibbs/python/site-packages_django/django/db/
> > > backends/postgresql_psycopg2/base.py" in execute
> > > 44. return self.cursor.execute(query, args)
>
> > > Exception Type: DatabaseError at /staff/staffinfo
> > > Exception Value: relation "n_nics_groups" does not exist
>
> > > Tabitha
>
> > > On Nov 4, 11:31 am, Furbee <furbeena...@gmail.com> wrote:
> > > > Oh no, that would not be a good thing to share! :-) That's a bummer that
> > > > the upgrade broke things.
>
> > > > So, the error is being raised on this line?
> > > > staff_form = StaffForm(request.POST,
> > > instance=staffinstance).using('gold')
>
> > > > Furbee
>
> > > > On Fri, Nov 4, 2011 at 8:02 AM, Tabitha Samuel <tabitha.sam...@gmail.com
> > > >wrote:
>
> > > > > 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...
>
> 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.
