Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- File "C:UsersnoteEnvsgadashlibsite-packagesdjangodbbackendsutils.
- , line 85, in _execute
- return self.cursor.execute(sql, params)
- django.db.utils.ProgrammingError: relation "listado_inicial" does not exist
- from django.test import TestCase
- from django.test import Client
- from .models import *
- class SimpleTest(TestCase):
- def SetUp(self):
- self.cliente=Client()
- def test_details(self):
- rp=c.get('/intra/datos-grafico/', data={'cod_suc':309},content_type='application/json')
- self.assertEqual(len(rp.json()['rows']),0)
- def datos(request,cod_suc):
- if cod_suc==0:
- edad_stock=v.objects.raw('''select 1 as id_number, sum("SALDO") as s ,l."EDICION" as edi from ventas v join **listado_inicial** l on l."ISBN"=v."ISBN" where v."FECHA"=(select max(v."FECHA") from ventas v) group by l."EDICION" ''')
- else:
- edad_stock=v.objects.raw('''select 1 as id_number, sum("SALDO") as s ,l."EDICION" as edi from ventas v join **listado_inicial** l on l."ISBN"=v."ISBN" where v."FECHA"=(select max(v."FECHA") from ventas v) and "COD_SUCURSAL"=%s group by l."EDICION" ''',[cod_suc])
- datos_aux={}
- datos=[]
- for e in edad_stock:
- datos_aux["saldo"]=int(e.s)
- datos_aux["edicion"]=e.edi
- datos.append(datos_aux)
- datos_aux={}
- description2={"saldo":("number","saldo"),"edicion":("string","edicion")}
- data_table = gviz_api.DataTable(description2)
- data_table.LoadData(datos)
- j=data_table.ToJSon(columns_order=("edicion", "saldo"))
- return HttpResponse(j, content_type='application/json')
Add Comment
Please, Sign In to add comment