X-Git-Url: https://git.squeep.com/?a=blobdiff_plain;f=lib%2Fpleroma%2Fstats.ex;h=df80fbaa41f0d62fd252444b16cef22325e1d9cc;hb=67d772dd73af7adb2dfb912298c194fa796a72f9;hp=938e5c3435f9893586878a88752d0b5aa6a076ed;hpb=5a6f54b336c8cca7f6514bb9ce7db5b6c97f296f;p=akkoma

diff --git a/lib/pleroma/stats.ex b/lib/pleroma/stats.ex
index 938e5c343..df80fbaa4 100644
--- a/lib/pleroma/stats.ex
+++ b/lib/pleroma/stats.ex
@@ -1,43 +1,85 @@
+# Pleroma: A lightweight social networking server
+# Copyright © 2017-2019 Pleroma Authors <https://pleroma.social/>
+# SPDX-License-Identifier: AGPL-3.0-only
+
 defmodule Pleroma.Stats do
-  use Agent
   import Ecto.Query
-  alias Pleroma.{User, Repo, Activity}
+  alias Pleroma.Repo
+  alias Pleroma.User
+
+  use GenServer
+
+  @interval 1000 * 60 * 60
 
-  def start_link do
-    agent = Agent.start_link(fn -> {[], %{}} end, name: __MODULE__)
-    schedule_update()
-    agent
+  def start_link(_) do
+    GenServer.start_link(__MODULE__, initial_data(), name: __MODULE__)
+  end
+
+  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 schedule_update do
-    update_stats()
-    spawn(fn ->
-      Process.sleep(1000 * 60 * 60 * 1) # 1 hour
-      schedule_update()
-    end)
+  def handle_call(:get_state, _from, state) do
+    {:reply, state, state}
   end
 
-  def update_stats do
-    peers = from(u in Pleroma.User,
-      select: fragment("?->'host'", u.info),
-      where: u.local != ^true)
-    |> Repo.all() |> Enum.uniq()
+  def handle_info(:run_update, _state) do
+    new_stats = get_stat_data()
+
+    Process.send_after(self(), :run_update, @interval)
+    {:noreply, new_stats}
+  end
+
+  defp initial_data do
+    %{peers: [], stats: %{}}
+  end
+
+  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 p in Activity,
-      where: p.local == ^true,
-      where: fragment("?->'object'->>'type' = ?", p.data, ^"Note")
-    status_count = Repo.aggregate(status_query, :count, :id)
-    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_query =
+      from(u in User.Query.build(%{local: true}),
+        select: fragment("sum((?->>'note_count')::int)", u.info)
+      )
+
+    status_count = Repo.one(status_query)
+
+    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