def testGridError(self): """Get a error with a query from a GridModel """ qry = Author.objects.all() ag = AuthorGrid() # And now get result in JSONResponse expct_data = [ {'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2000-01-02", 'name': u"toto"}, {'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2001-02-03", 'name': u"tata"}, {'title': u"MRS", 'title_display': "Mrs.", 'birth_date': u"2002-03-04", 'name': u"tutu"}, ] expct = {u"success": False, u"message": "Error : No mapped field 'titl'"} jsonresult = ag.get_rows_json(qry, fields=['titl', 'birth_date', 'name'], jsonerror=True) result = simplejson.loads(jsonresult) self.assertEqual(expct, result) # Without jsonerror we get normal Django's exception self.assertRaises(AttributeError, ag.get_rows_json, qry, fields=['titl', 'birth_date', 'name'])
def testGridbasic_utf8(self): """Get a query from a GridModel with utf8 """ # adds utf8 record from datetime import date self.auth4 = Author.objects.create(name="tété", title="TéTé", birth_date=date(2000, 1, 2)) qry = Author.objects.all() # And now get result in JSONResponse expct_data = [ { 'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2000-01-02", 'his_name': u"toto" }, { 'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2001-02-03", 'his_name': u"tata" }, { 'title': u"MRS", 'title_display': "Mrs.", 'birth_date': u"2002-03-04", 'his_name': u"tutu" }, { 'title': u"TéTé", 'title_display': u"TéTé", 'birth_date': u"2000-01-02", 'his_name': u"tété" }, ] ag = AuthorGrid() expct = {u"success": True, u"data": expct_data, u'results': 4} jsonresult = ag.get_rows_json( qry, fields=['title', 'birth_date', 'his_name']) result = simplejson.loads(jsonresult) self.assertEqual(expct, result)
def testGridbasic_utf8(self): """Get a query from a GridModel with utf8 """ # adds utf8 record from datetime import date self.auth4 = Author.objects.create(name="tété", title="TéTé", birth_date=date(2000,1,2)) qry = Author.objects.all() # And now get result in JSONResponse expct_data = [ {'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2000-01-02", 'his_name': u"toto"}, {'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2001-02-03", 'his_name': u"tata"}, {'title': u"MRS", 'title_display': "Mrs.", 'birth_date': u"2002-03-04", 'his_name': u"tutu"}, {'title': u"TéTé", 'title_display': u"TéTé", 'birth_date': u"2000-01-02", 'his_name': u"tété"}, ] ag = AuthorGrid() expct = {u"success": True, u"data": expct_data, u'results': 4} jsonresult = ag.get_rows_json(qry, fields=['title', 'birth_date', 'his_name']) result = simplejson.loads(jsonresult) self.assertEqual(expct, result)
def testGridError(self): """Get a error with a query from a GridModel """ qry = Author.objects.all() ag = AuthorGrid() # And now get result in JSONResponse expct_data = [ { 'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2000-01-02", 'name': u"toto" }, { 'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2001-02-03", 'name': u"tata" }, { 'title': u"MRS", 'title_display': "Mrs.", 'birth_date': u"2002-03-04", 'name': u"tutu" }, ] expct = { u"success": False, u"message": "Error : No mapped field 'titl'" } jsonresult = ag.get_rows_json(qry, fields=['titl', 'birth_date', 'name'], jsonerror=True) result = simplejson.loads(jsonresult) self.assertEqual(expct, result) # Without jsonerror we get normal Django's exception self.assertRaises(AttributeError, ag.get_rows_json, qry, fields=['titl', 'birth_date', 'name'])
def testGridbasic(self): """Get a query from a GridModel """ qry = Author.objects.all() import datetime expct_data = [ {'his_name': u"toto", 'title': u"MR", 'title_display': "Mr.", 'birth_date': datetime.date(2000, 1, 2)}, {'his_name': u"tata", 'title': u"MR", 'title_display': "Mr.", 'birth_date': datetime.date(2001, 2, 3)}, {'his_name': u"tutu", 'title': u"MRS", 'title_display': "Mrs.", 'birth_date': datetime.date(2002, 3, 4)}, ] ag = AuthorGrid() raw_result, length = ag.get_rows(qry,) self.assertEqual(expct_data, raw_result) self.assertEqual(length, 3) # And now get result in JSONResponse expct_data = [ {'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2000-01-02", 'his_name': u"toto"}, {'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2001-02-03", 'his_name': u"tata"}, {'title': u"MRS", 'title_display': "Mrs.", 'birth_date': u"2002-03-04", 'his_name': u"tutu"}, ] expct = {u"success": True, u"data": expct_data, u'results': 3} jsonresult = ag.get_rows_json(qry, fields=['title', 'birth_date', 'his_name']) result = simplejson.loads(jsonresult) self.assertEqual(expct, result) # use pre-configured View response = self.client.get("/api/author/getjson") result = simplejson.loads(response.content) expct_data = [ {'his_name': "toto", 'title': "MR", 'title_display': "Mr.", 'birth_date': "2000-01-02"}, {'his_name': "tata", 'title': "MR", 'title_display': "Mr.", 'birth_date': "2001-02-03"}, {'his_name': "tutu", 'title': "MRS", 'title_display': "Mrs.", 'birth_date': "2002-03-04"}, ] expct = {"success": True, "data": expct_data, 'results': 3} self.assertEqual(expct, result)
def testGridbasic(self): """Get a query from a GridModel """ qry = Author.objects.all() import datetime expct_data = [ { 'his_name': u"toto", 'title': u"MR", 'title_display': "Mr.", 'birth_date': datetime.date(2000, 1, 2) }, { 'his_name': u"tata", 'title': u"MR", 'title_display': "Mr.", 'birth_date': datetime.date(2001, 2, 3) }, { 'his_name': u"tutu", 'title': u"MRS", 'title_display': "Mrs.", 'birth_date': datetime.date(2002, 3, 4) }, ] ag = AuthorGrid() raw_result, length = ag.get_rows(qry, ) self.assertEqual(expct_data, raw_result) self.assertEqual(length, 3) # And now get result in JSONResponse expct_data = [ { 'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2000-01-02", 'his_name': u"toto" }, { 'title': u"MR", 'title_display': "Mr.", 'birth_date': u"2001-02-03", 'his_name': u"tata" }, { 'title': u"MRS", 'title_display': "Mrs.", 'birth_date': u"2002-03-04", 'his_name': u"tutu" }, ] expct = {u"success": True, u"data": expct_data, u'results': 3} jsonresult = ag.get_rows_json( qry, fields=['title', 'birth_date', 'his_name']) result = simplejson.loads(jsonresult) self.assertEqual(expct, result) # use pre-configured View response = self.client.get("/api/author/getjson") result = simplejson.loads(response.content) expct_data = [ { 'his_name': "toto", 'title': "MR", 'title_display': "Mr.", 'birth_date': "2000-01-02" }, { 'his_name': "tata", 'title': "MR", 'title_display': "Mr.", 'birth_date': "2001-02-03" }, { 'his_name': "tutu", 'title': "MRS", 'title_display': "Mrs.", 'birth_date': "2002-03-04" }, ] expct = {"success": True, "data": expct_data, 'results': 3} self.assertEqual(expct, result)