Open source, privacy-first web analytics. Lightweight, cookie-free Google Analytics alternative. Self-hosted or cloud.
TypeScript analyticsanalytics-dashboardclickhouseelixirgoogle-analyticsmarketingopen-source-analyticsphoenixplausible-analyticspostgresqlprivacyprivacy-friendlyself-hostedsimple-analyticsstatisticstailwindcssweb-analyticswebsite-analyticswebsite-statswebsite-tracking
defmodule Plausible.TeamDeletionScheduleTest do
use Plausible.DataCase, async: true
on_ee do
alias Plausible.TeamDeletionSchedule
describe "schema" do
test "inserts a valid schedule with expected defaults" do
team = insert(:team)
today = Date.utc_today()
deletion_date = Date.shift(today, day: 60)
assert {:ok, schedule} =
%TeamDeletionSchedule{
team_id: team.id,
category: :expired_trial,
expiry_date: today,
deletion_date: deletion_date,
first_notice_due_date: Date.shift(deletion_date, day: -30)
}
|> Repo.insert()
assert schedule.status == :scheduled
assert schedule.is_backlog == false
assert is_nil(schedule.first_notice_sent_at)
assert is_nil(schedule.reminder_sent_at)
assert is_nil(schedule.snoozed_until)
end
test "accepts both categories" do
team1 = insert(:team)
team2 = insert(:team)
today = Date.utc_today()
assert {:ok, %{category: :expired_trial}} =
Repo.insert(%TeamDeletionSchedule{
team_id: team1.id,
category: :expired_trial,
expiry_date: today,
deletion_date: Date.shift(today, day: 60),
first_notice_due_date: Date.shift(today, day: 30)
})
assert {:ok, %{category: :churned_subscription}} =
Repo.insert(%TeamDeletionSchedule{
team_id: team2.id,
category: :churned_subscription,
expiry_date: today,
deletion_date: Date.shift(today, day: 180),
first_notice_due_date: Date.shift(today, day: 150)
})
end
test "rejects an invalid category" do
team = insert(:team)
today = Date.utc_today()
assert_raise Ecto.ChangeError, fn ->
Repo.insert(%TeamDeletionSchedule{
team_id: team.id,
category: :not_a_real_category,
expiry_date: today,
deletion_date: today,
first_notice_due_date: today
})
end
end
test "rejects an invalid status" do
team = insert(:team)
today = Date.utc_today()
assert_raise Ecto.ChangeError, fn ->
Repo.insert(%TeamDeletionSchedule{
team_id: team.id,
category: :expired_trial,
status: :not_a_real_status,
expiry_date: today,
deletion_date: today,
first_notice_due_date: today
})
end
end
test "categories/0 and statuses/0 expose the valid enum values" do
assert TeamDeletionSchedule.categories() == [:expired_trial, :churned_subscription]
assert TeamDeletionSchedule.statuses() == [
:scheduled,
:first_notice_sent,
:reminder_sent,
:completed,
:cancelled,
:snoozed
]
end
test "terminal_statuses/0 and active_statuses/0 partition statuses/0" do
terminal = TeamDeletionSchedule.terminal_statuses()
active = TeamDeletionSchedule.active_statuses()
assert Enum.sort(terminal ++ active) == Enum.sort(TeamDeletionSchedule.statuses())
end
end
describe "crm_changeset/2" do
test "is valid for a snoozed_until date in the future" do
schedule = insert(:team_deletion_schedule, status: :reminder_sent)
until_date = Date.shift(Date.utc_today(), day: 1)
changeset =
TeamDeletionSchedule.crm_changeset(schedule, %{
"snoozed_until" => Date.to_iso8601(until_date),
"snooze_note" => "customer asked for time"
})
assert changeset.valid?
assert Ecto.Changeset.get_change(changeset, :snoozed_until) == until_date
assert Ecto.Changeset.get_change(changeset, :snooze_note) == "customer asked for time"
end
test "does not require a note" do
schedule = insert(:team_deletion_schedule, status: :reminder_sent)
until_date = Date.shift(Date.utc_today(), day: 1)
changeset =
TeamDeletionSchedule.crm_changeset(schedule, %{
"snoozed_until" => Date.to_iso8601(until_date)
})
assert changeset.valid?
end
test "requires snoozed_until" do
schedule = insert(:team_deletion_schedule, status: :reminder_sent)
changeset = TeamDeletionSchedule.crm_changeset(schedule, %{})
refute changeset.valid?
assert {"can't be blank", _} = changeset.errors[:snoozed_until]
end
test "rejects a snoozed_until of today" do
schedule = insert(:team_deletion_schedule, status: :reminder_sent)
changeset =
TeamDeletionSchedule.crm_changeset(schedule, %{
"snoozed_until" => Date.to_iso8601(Date.utc_today())
})
refute changeset.valid?
assert {"must be in the future", _} = changeset.errors[:snoozed_until]
end
test "rejects a snoozed_until in the past" do
schedule = insert(:team_deletion_schedule, status: :reminder_sent)
changeset =
TeamDeletionSchedule.crm_changeset(schedule, %{
"snoozed_until" => Date.to_iso8601(Date.shift(Date.utc_today(), day: -1))
})
refute changeset.valid?
assert {"must be in the future", _} = changeset.errors[:snoozed_until]
end
test "does not touch status" do
schedule = insert(:team_deletion_schedule, status: :reminder_sent)
until_date = Date.shift(Date.utc_today(), day: 1)
changeset =
TeamDeletionSchedule.crm_changeset(schedule, %{
"snoozed_until" => Date.to_iso8601(until_date)
})
refute Ecto.Changeset.get_change(changeset, :status)
end
end
describe "team_id foreign key" do
test "deleting the team cascades to the schedule" do
schedule = insert(:team_deletion_schedule)
Repo.delete!(schedule.team)
refute Repo.get(TeamDeletionSchedule, schedule.id)
end
test "rejects a schedule for a non-existent team" do
today = Date.utc_today()
assert_raise Ecto.ConstraintError, fn ->
Repo.insert!(%TeamDeletionSchedule{
team_id: -1,
category: :expired_trial,
expiry_date: today,
deletion_date: today,
first_notice_due_date: today
})
end
end
end
describe "one_active_schedule_per_team index" do
test "rejects a second active schedule for the same team" do
team = insert(:team)
today = Date.utc_today()
base = %{
team_id: team.id,
category: :expired_trial,
expiry_date: today,
deletion_date: Date.shift(today, day: 60),
first_notice_due_date: Date.shift(today, day: 30)
}
assert {:ok, _} = Repo.insert(struct(TeamDeletionSchedule, base))
assert_raise Ecto.ConstraintError, fn ->
Repo.insert!(struct(TeamDeletionSchedule, Map.put(base, :status, :first_notice_sent)))
end
end
test "allows a new schedule once the previous one is cancelled" do
team = insert(:team)
today = Date.utc_today()
base = %{
team_id: team.id,
category: :expired_trial,
expiry_date: today,
deletion_date: Date.shift(today, day: 60),
first_notice_due_date: Date.shift(today, day: 30)
}
assert {:ok, _} =
struct(TeamDeletionSchedule, Map.put(base, :status, :cancelled))
|> Repo.insert()
assert {:ok, _} = Repo.insert(struct(TeamDeletionSchedule, base))
end
test "allows a new schedule once the previous one is completed" do
team = insert(:team)
today = Date.utc_today()
base = %{
team_id: team.id,
category: :churned_subscription,
expiry_date: today,
deletion_date: Date.shift(today, day: 180),
first_notice_due_date: Date.shift(today, day: 150)
}
assert {:ok, _} =
struct(TeamDeletionSchedule, Map.put(base, :status, :completed))
|> Repo.insert()
assert {:ok, _} = Repo.insert(struct(TeamDeletionSchedule, base))
end
test "allows active schedules for different teams" do
team1 = insert(:team)
team2 = insert(:team)
today = Date.utc_today()
for team <- [team1, team2] do
assert {:ok, _} =
Repo.insert(%TeamDeletionSchedule{
team_id: team.id,
category: :expired_trial,
expiry_date: today,
deletion_date: Date.shift(today, day: 60),
first_notice_due_date: Date.shift(today, day: 30)
})
end
end
end
end
end