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

78 lines
2.9 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
end
end