def test_query_filter_on_model_with_fk(self):
"""
"""
wam1 = Whatamess.objects.create(name="dodo",
title=1,
number=1,
text="d o d o",
author=self.auth1,
yesno=True,
birth_date=date(2000, 1, 2))
wam2 = Whatamess.objects.create(name="dada",
title=1,
number=2,
text="d a d a",
author=self.auth2,
yesno=True,
birth_date=date(2001, 2, 3))
wam3 = Whatamess.objects.create(name="dudu",
title=1,
number=3,
text="d u d u",
author=self.auth4,
yesno=True,
birth_date=date(2002, 3, 4))
self.request = HttpRequest()
qr = Whatamess.objects.all()
qrd = QueryDict('start=0&dir=ASC&atitle=D')
self.request.REQUEST = qrd
wg = WhatamessGrid()
result_qr = wg.query_from_request(self.request, qr, fields=['atitle'])
self.assertEqual(list(result_qr), [wam3])
def testGridComplexFKnull(self):
"""test FK resolutions with FK null
"""
# test FK
self.wam3 = Whatamess.objects.create(name="didi",
title=1,
number=4,
text="d i d i",
yesno=True,
birth_date=date(2003, 4, 5))
qry = Whatamess.objects.all()
wg = WhatamessGrid()
expct_data = [
{
'atitle': 'MR',
'atitle_display': "Mr."
},
{
'atitle': 'MR',
'atitle_display': "Mr."
},
{
'atitle': 'MRS',
'atitle_display': "Mrs."
},
{
'atitle': None
},
]
expct = (expct_data, 4)
result = wg.get_rows(qry, fields=[
'atitle',
])
self.assertEqual(expct, result)
def testGridComplexFK(self):
"""test FK resolutions in ExtJSONEncoder
"""
# test FK
qry = Whatamess.objects.all()
wg = WhatamessGrid()
expct_data = [
{
'atitle': 'MR',
'atitle_display': "Mr."
},
{
'atitle': 'MR',
'atitle_display': "Mr."
},
{
'atitle': 'MRS',
'atitle_display': "Mrs."
},
]
expct = (expct_data, 3)
result = wg.get_rows(qry, fields=[
'atitle',
])
self.assertEqual(expct, result)
def testGridComplex(self):
"""test FK resolutions in ExtJSONEncoder
"""
qry = Whatamess.objects.all()
import datetime
# Use method
expct_data = [
{
u'name': u"dodo",
u'author': u'toto'
},
{
u'name': u"dada",
u'author': u'tata'
},
{
u'name': u"dudu",
u'author': u'tutu'
},
]
wg = WhatamessGrid()
expct = {u"success": True, u"data": expct_data, u'results': 3}
jsonresult = wg.get_rows_json(qry)
result = simplejson.loads(jsonresult)
self.assertEqual(expct, result)
def test_query_filter_on_model_with_fk(self):
"""
"""
wam1 = Whatamess.objects.create(name="dodo", title=1, number=1, text="d o d o", author=self.auth1, yesno=True, birth_date=date(2000,1,2))
wam2 = Whatamess.objects.create(name="dada", title=1, number=2, text="d a d a", author=self.auth2, yesno=True, birth_date=date(2001,2,3))
wam3 = Whatamess.objects.create(name="dudu", title=1, number=3, text="d u d u", author=self.auth4, yesno=True, birth_date=date(2002,3,4))
self.request = HttpRequest()
qr = Whatamess.objects.all()
qrd = QueryDict('start=0&dir=ASC&atitle=D')
self.request.REQUEST = qrd
wg = WhatamessGrid()
result_qr = wg.query_from_request(self.request, qr, fields=['atitle'])
self.assertEqual(list(result_qr), [wam3])
def testGridComplexFK(self):
"""test FK resolutions in ExtJSONEncoder
"""
# test FK
qry = Whatamess.objects.all()
wg = WhatamessGrid()
expct_data = [
{'atitle': 'MR', 'atitle_display': "Mr."},
{'atitle': 'MR', 'atitle_display': "Mr."},
{'atitle': 'MRS', 'atitle_display': "Mrs."},
]
expct = (expct_data, 3)
result = wg.get_rows(qry, fields=['atitle',])
self.assertEqual(expct, result)
def testGridComplexFKnull(self):
"""test FK resolutions with FK null
"""
# test FK
self.wam3 = Whatamess.objects.create(name="didi", title=1, number=4, text="d i d i", yesno=True, birth_date=date(2003,4,5))
qry = Whatamess.objects.all()
wg = WhatamessGrid()
expct_data = [
{'atitle': 'MR', 'atitle_display': "Mr."},
{'atitle': 'MR', 'atitle_display': "Mr."},
{'atitle': 'MRS', 'atitle_display': "Mrs."},
{'atitle': None},
]
expct = (expct_data, 4)
result = wg.get_rows(qry, fields=['atitle',])
self.assertEqual(expct, result)
def testGridComplex(self):
"""test FK resolutions in ExtJSONEncoder
"""
qry = Whatamess.objects.all()
import datetime
# Use method
expct_data = [
{u'name': u"dodo", u'author': u'toto'},
{u'name': u"dada", u'author': u'tata'},
{u'name': u"dudu", u'author': u'tutu'},
]
wg = WhatamessGrid()
expct = {u"success": True, u"data": expct_data, u'results': 3}
jsonresult = wg.get_rows_json(qry)
result = simplejson.loads(jsonresult)
self.assertEqual(expct, result)