You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
analytics/test/plausible_web/controllers/api/stats_controller/regions_test.exs

118 lines
3.8 KiB
Elixir

defmodule PlausibleWeb.Api.StatsController.RegionsTest do
use PlausibleWeb.ConnCase
describe "GET /api/stats/:domain/regions" do
defp seed(%{site: site}) do
populate_stats(site, [
build(:pageview,
country_code: "EE",
subdivision1_code: "EE-37",
city_geoname_id: 588_409
),
build(:pageview,
country_code: "EE",
subdivision1_code: "EE-37",
city_geoname_id: 588_409
),
build(:pageview,
country_code: "EE",
subdivision1_code: "EE-37",
city_geoname_id: 588_409
),
build(:pageview,
country_code: "EE",
subdivision1_code: "EE-39",
city_geoname_id: 591_632
),
build(:pageview,
country_code: "EE",
subdivision1_code: "EE-39",
city_geoname_id: 591_632
)
])
end
setup [:create_user, :log_in, :create_new_site, :add_imported_data, :seed]
test "returns top cities by new visitors", %{conn: conn, site: site} do
conn = get(conn, "/api/stats/#{site.domain}/regions?period=day")
assert json_response(conn, 200) == [
%{"code" => "EE-37", "country_flag" => "🇪🇪", "name" => "Harjumaa", "visitors" => 3},
%{"code" => "EE-39", "country_flag" => "🇪🇪", "name" => "Hiiumaa", "visitors" => 2}
]
end
test "when list is filtered returns one city only", %{conn: conn, site: site} do
filters = Jason.encode!(%{region: "EE-39"})
conn = get(conn, "/api/stats/#{site.domain}/regions?period=day&filters=#{filters}")
assert json_response(conn, 200) == [
%{"code" => "EE-39", "country_flag" => "🇪🇪", "name" => "Hiiumaa", "visitors" => 2}
]
end
test "malicious input - date", %{conn: conn, site: site} do
filters = Jason.encode!(%{region: "EE-39"})
garbage = "2020-07-30'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'"
conn =
get(
conn,
"/api/stats/#{site.domain}/regions?period=custom&filters=#{filters}&date=#{garbage}"
)
assert resp = response(conn, 400)
assert resp =~ "Failed to parse 'date' argument."
end
test "malicious input - from", %{conn: conn, site: site} do
filters = Jason.encode!(%{region: "EE-39"})
garbage = "2020-07-30'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'"
conn =
get(
conn,
"/api/stats/#{site.domain}/regions?period=custom&filters=#{filters}&from=#{garbage}"
)
assert resp = response(conn, 400)
assert resp =~ "Failed to parse 'from' argument."
end
test "malicious input - to", %{conn: conn, site: site} do
filters = Jason.encode!(%{region: "EE-39"})
garbage = "2020-07-30'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'"
conn =
get(
conn,
"/api/stats/#{site.domain}/regions?period=custom&filters=#{filters}&from=2020-04-01&to=#{garbage}"
)
assert resp = response(conn, 400)
assert resp =~ "Failed to parse 'to' argument."
end
test "bugfix: don't crash on ambiguous date time", %{conn: conn, user: user} do
# The site has timezone set to Azores.
# Given it's 28th Nov and there's 30 day range, the starting day falls on 29th Oct
# which coincides with daylight savings time change there:
# https://www.timeanddate.com/time/change/portugal/ponta-delgada-azores.
site = insert(:site, members: [user], timezone: "Atlantic/Azores")
populate_stats(site, [
build(:pageview, timestamp: relative_time(minutes: -5))
])
conn =
get(
conn,
"/api/stats/#{site.domain}/regions?period=30d&date=2023-11-28&with_imported=true"
)
assert json_response(conn, 200)
end
end
end