def __new__(cls, *args, **kwargs):
cls.__new_lock.acquire()
if cls.__singleton is None:
cls.__singleton = super(ReportService, cls).__new__(cls)
cls.__applicationuserrquery = ApplicationUserQuery()
cls.__numberingmasterquery = NumberingMasterQuery()
cls.__googleapiservice = GoogleApiService()
cls.__reportrepository = ReportRepository()
cls.__reportquery = ReportQuery()
cls.__downloadinformationrepository = DownloadInformationRepository()
cls.__downloadinformationquery = DownloadInformationQuery()
cls.__new_lock.release()
return cls.__singleton
def __paging(request, current_page, previous, next, target_page):
offset, target_page = function.get_offset(
previous, next, target_page, current_page, __limit)
target_year = request.session['target_year']
full_name = request.session['full_name']
file_name = request.session['file_name']
current_sort_item = request.session['current_sort_item']
current_descending_order = request.session['current_descending_order']
result_list_count = ReportQuery().custom_count(target_year, full_name, file_name)
result_list = ReportQuery().custom_query(
target_year,
full_name,
file_name,
offset,
__limit,
current_sort_item,
current_descending_order)
context = {
'result_list': result_list,
'result_list_count': result_list_count,
'current_page': target_page,
'limit': __limit,
'current_sort_item': current_sort_item,
'current_descending_order': current_descending_order,
'authority_name': request.session['authority']
}
html = render_to_string(
'student/report/search_result.html',
context,
request=request)
return HttpResponse(html)
def test_custom_query_case2(self):
result_list = ReportQuery().custom_query("2019", "", "", 0, 5,
"target-year-sort", "True")
self.assertEqual(len(result_list), 2)
self.assertEqual(result_list[0].report_id, "R000002")
self.assertEqual(result_list[0].target_year, "2019")
self.assertEqual(result_list[0].file_name, "file_name002")
self.assertEqual(result_list[0].full_name, "first_name2 last_name2")
self.assertEqual(result_list[0].download_count, 2)
self.assertEqual(result_list[0].comment, "comment002")
self.assertEqual(result_list[1].report_id, "R000001")
self.assertEqual(result_list[1].target_year, "2019")
self.assertEqual(result_list[1].file_name, "file_name001")
self.assertEqual(result_list[1].full_name, "first_name1 last_name1")
self.assertEqual(result_list[1].download_count, 2)
self.assertEqual(result_list[1].comment, "comment001")
def search_sp(request):
form = ReportSearchSpForm(data=request.POST)
if form.is_valid():
search_value = form.cleaned_data['search_value']
result_list = ReportQuery().custom_query_sp(search_value)
context = {
'result_list': result_list
}
html = render_to_string(
'student/report/search_result_sp.html',
context,
request=request)
return HttpResponse(html)
else:
return None
def test_select_all_case1(self):
result_list = ReportQuery().select_all()
self.assertEqual(len(result_list), 4)
self.assertEqual(result_list[0].report_id, "R000002")
self.assertEqual(result_list[0].auther_user_id, "U0002")
self.assertEqual(result_list[0].target_year, "2019")
self.assertEqual(result_list[0].file_name, "file_name002")
self.assertEqual(result_list[0].google_file_id, "google_file_id_002")
self.assertEqual(result_list[0].comment, "comment002")
self.assertEqual(result_list[0].create_user_id, "U0001")
self.assertEqual(result_list[0].update_user_id, "U0001")
self.assertEqual(result_list[1].report_id, "R000001")
self.assertEqual(result_list[1].auther_user_id, "U0001")
self.assertEqual(result_list[1].target_year, "2019")
self.assertEqual(result_list[1].file_name, "file_name001")
self.assertEqual(result_list[1].google_file_id, "google_file_id_001")
self.assertEqual(result_list[1].comment, "comment001")
self.assertEqual(result_list[1].create_user_id, "U0001")
self.assertEqual(result_list[1].update_user_id, "U0001")
self.assertEqual(result_list[2].report_id, "R000004")
self.assertEqual(result_list[2].auther_user_id, "U0002")
self.assertEqual(result_list[2].target_year, "2018")
self.assertEqual(result_list[2].file_name, "file_name004")
self.assertEqual(result_list[2].google_file_id, "google_file_id_004")
self.assertEqual(result_list[2].comment, "comment004")
self.assertEqual(result_list[2].create_user_id, "U0001")
self.assertEqual(result_list[2].update_user_id, "U0001")
self.assertEqual(result_list[3].report_id, "R000003")
self.assertEqual(result_list[3].auther_user_id, "U0001")
self.assertEqual(result_list[3].target_year, "2018")
self.assertEqual(result_list[3].file_name, "file_name003")
self.assertEqual(result_list[3].google_file_id, "google_file_id_003")
self.assertEqual(result_list[3].comment, "comment003")
self.assertEqual(result_list[3].create_user_id, "U0001")
self.assertEqual(result_list[3].update_user_id, "U0001")
def test_custom_count_case4(self):
result = ReportQuery().custom_count("2019", "_name1", "_name")
self.assertEqual(result, 1)
def test_custom_count_case3(self):
result = ReportQuery().custom_count("", "", "_name")
self.assertEqual(result, 4)
def test_custom_count_case1(self):
result = ReportQuery().custom_count("2019", "", "")
self.assertEqual(result, 2)
def test_exist_same_file_name_case2(self):
result = ReportQuery().exist_same_file_name("abc")
self.assertEqual(result, False)
def test_exist_same_file_name_case1(self):
result = ReportQuery().exist_same_file_name("file_name002")
self.assertEqual(result, True)