X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=lib%2Fpleroma%2Fstats.ex;h=8154a09b754a75b36d72b8e01700f0f2612cec7f;hb=43ea16870fe60578a6528e1f01bfaab68943a1bc;hp=737e9b62ea268cda1a70a473af8b1060623e932f;hpb=f0cde24f71f292b417dfcac663e1f4e6082c833a;p=akkoma diff --git a/lib/pleroma/stats.ex b/lib/pleroma/stats.ex index 737e9b62e..8154a09b7 100644 --- a/lib/pleroma/stats.ex +++ b/lib/pleroma/stats.ex @@ -1,41 +1,80 @@ +# Pleroma: A lightweight social networking server +# Copyright © 2017-2019 Pleroma Authors +# SPDX-License-Identifier: AGPL-3.0-only + defmodule Pleroma.Stats do import Ecto.Query - alias Pleroma.{User, Repo, Activity} + alias Pleroma.Repo + alias Pleroma.User + + use GenServer + + @interval 1000 * 60 * 60 + + def start_link(_) do + GenServer.start_link(__MODULE__, initial_data(), name: __MODULE__) + end - def start_link do - agent = Agent.start_link(fn -> {[], %{}} end, name: __MODULE__) - spawn(fn -> schedule_update() end) - agent + def force_update do + GenServer.call(__MODULE__, :force_update) end def get_stats do - Agent.get(__MODULE__, fn {_, stats} -> stats end) + %{stats: stats} = GenServer.call(__MODULE__, :get_state) + + stats end def get_peers do - Agent.get(__MODULE__, fn {peers, _} -> peers end) + %{peers: peers} = GenServer.call(__MODULE__, :get_state) + + peers + end + + def init(args) do + Process.send(self(), :run_update, []) + {:ok, args} + end + + def handle_call(:force_update, _from, _state) do + new_stats = get_stat_data() + {:reply, new_stats, new_stats} + end + + def handle_call(:get_state, _from, state) do + {:reply, state, state} + end + + def handle_info(:run_update, _state) do + new_stats = get_stat_data() + + Process.send_after(self(), :run_update, @interval) + {:noreply, new_stats} end - def schedule_update do - spawn(fn -> - Process.sleep(1000 * 60 * 60 * 1) # 1 hour - schedule_update() - end) - update_stats() + defp initial_data do + %{peers: [], stats: %{}} end - def update_stats do - peers = from(u in Pleroma.User, - select: fragment("distinct ?->'host'", u.info), - where: u.local != ^true) - |> Repo.all() + defp get_stat_data do + peers = + from( + u in User, + select: fragment("distinct split_part(?, '@', 2)", u.nickname), + where: u.local != ^true + ) + |> Repo.all() + |> Enum.filter(& &1) + domain_count = Enum.count(peers) - status_query = from(u in User.local_user_query, - select: fragment("sum((?->>'note_count')::int)", u.info)) - status_count = Repo.one(status_query) |> IO.inspect - user_count = Repo.aggregate(User.local_user_query, :count, :id) - Agent.update(__MODULE__, fn _ -> - {peers, %{domain_count: domain_count, status_count: status_count, user_count: user_count}} - end) + + status_count = Repo.aggregate(User.Query.build(%{local: true}), :sum, :note_count) + + user_count = Repo.aggregate(User.Query.build(%{local: true, active: true}), :count, :id) + + %{ + peers: peers, + stats: %{domain_count: domain_count, status_count: status_count, user_count: user_count} + } end end