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.
118 lines
4.0 KiB
Elixir
118 lines
4.0 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,
|
|
session_country_code: "EE",
|
|
session_subdivision1_code: "EE-37",
|
|
session_city_geoname_id: 588_409
|
|
),
|
|
build(:pageview,
|
|
session_country_code: "EE",
|
|
session_subdivision1_code: "EE-37",
|
|
session_city_geoname_id: 588_409
|
|
),
|
|
build(:pageview,
|
|
session_country_code: "EE",
|
|
session_subdivision1_code: "EE-37",
|
|
session_city_geoname_id: 588_409
|
|
),
|
|
build(:pageview,
|
|
session_country_code: "EE",
|
|
session_subdivision1_code: "EE-39",
|
|
session_city_geoname_id: 591_632
|
|
),
|
|
build(:pageview,
|
|
session_country_code: "EE",
|
|
session_subdivision1_code: "EE-39",
|
|
session_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
|