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/lib/plausible/purge.ex

53 lines
1.4 KiB
Elixir

defmodule Plausible.Purge do
@moduledoc """
Deletes data from a site.
Stats are stored on Clickhouse, and unlike other databases data deletion is
done asynchronously.
- [Clickhouse `ALTER TABLE ... DELETE` Statement](https://clickhouse.com/docs/en/sql-reference/statements/alter/delete)
- [Synchronicity of `ALTER` Queries](https://clickhouse.com/docs/en/sql-reference/statements/alter/#synchronicity-of-alter-queries)
"""
@spec delete_imported_stats!(Plausible.Site.t()) :: :ok
@doc """
Deletes imported stats from Google Analytics, and clears the
`stats_start_date` field.
"""
def delete_imported_stats!(site) do
Enum.each(Plausible.Imported.tables(), fn table ->
sql = "ALTER TABLE #{table} DELETE WHERE site_id = {$0:UInt64}"
Ecto.Adapters.SQL.query!(Plausible.ClickhouseRepo, sql, [site.id])
end)
clear_stats_start_date!(site)
:ok
end
@spec delete_native_stats!(Plausible.Site.t()) :: :ok
@doc """
Move stats pointers so that no historical stats are available.
"""
def delete_native_stats!(site) do
reset!(site)
:ok
end
def reset!(site) do
site
|> Ecto.Changeset.change(
native_stats_start_at: NaiveDateTime.utc_now() |> NaiveDateTime.truncate(:second),
stats_start_date: nil
)
|> Plausible.Repo.update!()
end
defp clear_stats_start_date!(site) do
site
|> Ecto.Changeset.change(stats_start_date: nil)
|> Plausible.Repo.update!()
end
end