- 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
+ }
+ }