Guest User

Untitled

a guest
Jun 25th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.50 KB | None | 0 0
  1. File "C:UsersnoteEnvsgadashlibsite-packagesdjangodbbackendsutils.
  2. , line 85, in _execute
  3. return self.cursor.execute(sql, params)
  4. django.db.utils.ProgrammingError: relation "listado_inicial" does not exist
  5.  
  6. from django.test import TestCase
  7. from django.test import Client
  8. from .models import *
  9.  
  10. class SimpleTest(TestCase):
  11. def SetUp(self):
  12. self.cliente=Client()
  13. def test_details(self):
  14. rp=c.get('/intra/datos-grafico/', data={'cod_suc':309},content_type='application/json')
  15. self.assertEqual(len(rp.json()['rows']),0)
  16.  
  17. def datos(request,cod_suc):
  18.  
  19. if cod_suc==0:
  20. 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" ''')
  21. else:
  22. 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])
  23.  
  24. datos_aux={}
  25. datos=[]
  26.  
  27. for e in edad_stock:
  28. datos_aux["saldo"]=int(e.s)
  29. datos_aux["edicion"]=e.edi
  30. datos.append(datos_aux)
  31. datos_aux={}
  32.  
  33.  
  34.  
  35. description2={"saldo":("number","saldo"),"edicion":("string","edicion")}
  36. data_table = gviz_api.DataTable(description2)
  37. data_table.LoadData(datos)
  38. j=data_table.ToJSon(columns_order=("edicion", "saldo"))
  39.  
  40.  
  41. return HttpResponse(j, content_type='application/json')
Add Comment
Please, Sign In to add comment