def test_get_keyword_data_part(self):
base_data = Data.get_month_data(2000, 1)
data = Data.get_keyword_data(base_data, "分")
expects = [
"立替分1",
"立替分2"
]
self._assert_list(data, expects)
def test_get_method_data(self):
month_data = Data.get_month_data(2000, 1)
data = Data.get_method_data(month_data, 3)
expects = [
"PayPayチャージ",
"立替分1"
]
self._assert_list(data, expects)
def test_filter_temps(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_temps(base_data, [True])
expects = [
"立替分1",
"立替分2"
]
self._assert_list(data, expects)
def test_filter_categories(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_categories(base_data, [1])
expects = [
"コンビニ",
"スーパー",
"立替分1"
]
self._assert_list(data, expects)
def test_get_category_data(self):
month_data = Data.get_month_data(2000, 1)
data = Data.get_category_data(month_data, 1)
expects = [
"コンビニ",
"スーパー",
"立替分1"
]
self._assert_list(data, expects)
def test_filter_price_upper(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_price(base_data, None, 130)
expects = [
"コンビニ",
"その他1",
"貯金"
]
self._assert_list(data, expects)
def test_filter_price(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_price(base_data, 100, 400)
expects = [
"コンビニ",
"貯金",
"ガス代",
"立替分1"
]
self._assert_list(data, expects)
def test_filter_price_lower(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_price(base_data, 3000, None)
expects = [
"給与",
"必需品2",
"現金収入",
"銀行収入"
]
self._assert_list(data, expects)
def test_get_cash_data(self):
base_data = Data.get_month_data(2000, 1)
data = Data.get_cash_data(base_data)
expects = [
"コンビニ",
"その他1",
"必需品2",
"現金収入",
"スーパー"
]
self._assert_list(data, expects)
def test_get_unchecked_data(self):
base_data = Data.get_month_data(2000, 1)
data = Data.get_unchecked_data(base_data)
expects = [
"必需品1",
"スーパー",
"計算外",
"貯金",
"PayPayチャージ",
"立替分1"
]
self._assert_list(data, expects)
def test_filter_directions(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_directions(base_data, [1])
expects = [
"給与",
"現金収入",
"銀行収入",
"PayPayチャージ",
"立替分1",
"立替分2"
]
self._assert_list(data, expects)
def test_filter_checkeds(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_checkeds(base_data, [False])
expects = [
"必需品1",
"スーパー",
"計算外",
"貯金",
"PayPayチャージ",
"立替分1"
]
self._assert_list(data, expects)
def test_filter_methods(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_methods(base_data, [1, 3])
expects = [
"コンビニ",
"その他1",
"必需品2",
"現金収入",
"スーパー",
"PayPayチャージ",
"立替分1",
]
self._assert_list(data, expects)
def test_get_bank_data(self):
base_data = Data.get_month_data(2000, 1)
data = Data.get_bank_data(base_data)
expects = [
"給与",
"必需品1",
"銀行収入",
"計算外",
"貯金",
"PayPayチャージ",
"電気代",
"ガス代",
"水道代",
"立替分2"
]
self._assert_list(data, expects)
def test_get_checked_data(self):
base_data = Data.get_month_data(2000, 1)
data = Data.get_checked_data(base_data)
expects = [
"給与",
"コンビニ",
"その他1",
"必需品2",
"現金収入",
"銀行収入",
"PayPayチャージ",
"電気代",
"ガス代",
"水道代",
"立替分2"
]
self._assert_list(data, expects)
def get(self, request, *args, **kwargs):
# validation
if "year" in request.GET and "month" in request.GET:
year = request.GET.get("year")
month = request.GET.get("month")
if not is_valid_date(year, month):
return HttpResponseBadRequest("parameter error")
else:
return HttpResponseBadRequest("parameter error")
# 今月のデータ
monthly_data = Data.sort_descending(
Data.get_month_data(int(year), int(month)))
context = {
'show_data': monthly_data,
}
# 追加後のmonthlyテーブルを返す
return render(request, '_data_table.html', context)
def test_filter_without_intra_move(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_without_intra_move(base_data)
expects = [
"給与",
"コンビニ",
"その他1",
"必需品1",
"必需品2",
"現金収入",
"銀行収入",
"スーパー",
"計算外",
"貯金",
"電気代",
"ガス代",
"水道代",
"立替分1",
"立替分2"
]
self._assert_list(data, expects)
def test_get_normal_data(self):
'''計算外と内部移動を除く'''
base_data = Data.get_month_data(2000, 1)
data = Data.get_normal_data(base_data)
expects = [
"給与",
"コンビニ",
"その他1",
"必需品1",
"必需品2",
"現金収入",
"銀行収入",
"スーパー",
"貯金",
"電気代",
"ガス代",
"水道代",
"立替分1",
"立替分2"
]
self._assert_list(data, expects)
def test_get_month_data(self):
data = Data.get_month_data(2000, 1)
expects = [
"給与",
"コンビニ",
"その他1",
"必需品1",
"必需品2",
"現金収入",
"銀行収入",
"スーパー",
"計算外",
"貯金",
"PayPayチャージ",
"PayPayチャージ",
"電気代",
"ガス代",
"水道代",
"立替分1",
"立替分2"
]
self._assert_list(data, expects)
def test_sort_descending(self):
base_data = Data.get_month_data(2000, 1)
data = Data.sort_descending(base_data)
expects = [
"立替分2",
"立替分1",
"水道代",
"ガス代",
"電気代",
"PayPayチャージ",
"PayPayチャージ",
"貯金",
"計算外",
"スーパー",
"銀行収入",
"現金収入",
"必需品2",
"必需品1",
"その他1",
"コンビニ",
"給与"
]
self._assert_list(data, expects)
def get(self, request, *args, **kwargs):
# validation
if "year" in request.GET and "month" in request.GET:
year = request.GET.get("year")
month = request.GET.get("month")
if not is_valid_date(year, month):
return HttpResponseBadRequest("parameter error")
else:
return HttpResponseBadRequest("parameter error")
# 今月のデータ
monthly_data = Data.get_month_data(int(year), int(month))
# ジャンルごとの支出
positive_categories_outgo = {}
for c in Category.list():
if c.show_order >= 0:
d = Data.get_category_data(monthly_data, c.pk)
positive_categories_outgo[
c.name] = Data.get_outgo_sum(d) - Data.get_temp_sum(d)
context = {
'categories_outgo': positive_categories_outgo,
}
return render(request, '_chart_container_data.html', context)
def test_filter_checkeds_empty(self):
base_data = Data.get_month_data(1999, 1)
data = Data.filter_checkeds(base_data, [True])
self.assertEqual(data.count(), 0)
def test_filter_checkeds_nothing(self):
base_data = Data.get_month_data(2000, 2)
data = Data.filter_checkeds(base_data, [False])
self.assertEqual(data.count(), 0)
def test_get_unchecked_data_empty(self):
base_data = Data.get_month_data(1999, 1)
data = Data.get_unchecked_data(base_data)
self.assertEqual(data.count(), 0)
def test_filter_temps_nothing(self):
base_data = Data.get_month_data(2000, 2)
data = Data.filter_temps(base_data, [True])
self.assertEqual(data.count(), 0)
def test_filter_categories_empty(self):
base_data = Data.get_month_data(1999, 1)
data = Data.filter_categories(base_data, [1])
self.assertEqual(data.count(), 0)
def test_filter_categories_nothing(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_categories(base_data, [100])
self.assertEqual(data.count(), 0)
def test_filter_price_nothing(self):
base_data = Data.get_month_data(2000, 1)
data = Data.filter_price(base_data, None, 10)
self.assertEqual(data.count(), 0)
def test_filter_methods_empty(self):
base_data = Data.get_month_data(1999, 1)
data = Data.filter_methods(base_data, [1, 3])
self.assertEqual(data.count(), 0)
def test_filter_price_empty(self):
base_data = Data.get_month_data(1999, 1)
data = Data.filter_price(base_data, 10, 1000)
self.assertEqual(data.count(), 0)
