Girard clément Girard clément - 21 days ago 6
SQL Question

Error "'DefaultConnectionProxy' object has no attribute '__getitem__'" when calling stored procedure

Hi i'm making a project using python/Django, on my first page (index) i'm calling a stored procedure to fetch the data.

def index(request):
listOPT = []
Data = []
fluxState = settings.FLUX_MANAGER_STATE
if fluxState != True:
listOPT.append('FLUX AXEREAL : OFF')
cursor = connection['site'].cursor()
"""MS SQL CALL TO STORED PROCEDURE SP_webGET_RESUME_MVT_INIT_ACTIF """
cursor.execute("{CALL SP_webGET_RESUME_MVT_INIT_ACTIF}")
mouvements = cursor.fetchall()
cursor.close()
return render(request, 'index.html', locals())


but when executing i get this error "'DefaultConnectionProxy' object has no attribute 'getitem'"

Traceback :

Environment:


Request Method: GET
Request URL: http://10.1.20.14:8084/gestion_mouvement/index

Django Version: 1.9.6
Python Version: 2.7.11
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'Gestion_Mouvement']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'easy_pjax.middleware.UnpjaxMiddleware']



Traceback:

File "C:\Python27\lib\site-packages\django\core\handlers\base.py" in get_response
149. response = self.process_exception_by_middleware(e, request)

File "C:\Python27\lib\site-packages\django\core\handlers\base.py" in get_response
147. response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "E:\prog2\PJ1705-027_Automatisation_Silo1_Site_LADON\4-Developpement\Informatique\Web\Gestion_Mouvements\Gestion_Mouvements\Gestion_Mouvement\views.py" in index
26. cursor = connection['site'].cursor()
Exception Type: TypeError at /gestion_mouvement/index
Exception Value: 'DefaultConnectionProxy' object has no attribute '__getitem__'


Any idea on how to fix this ? i saw some people had to add some
def __unicode__
to their models but it doesn't seem to work for me.

Answer Source

It looks like you should be using connections, not connection.

from django.db import connections

cursor = connections['site'].cursor()