elixir - 如何避免在 iex 中出现 ecto 日志？

Question

我有一个创建数据库查询的工作人员，如下所示:

defmodule MyApp.Periodically do
  use GenServer

  def start_link do
    GenServer.start_link(__MODULE__, %{})
  end

  def init(state) do
    schedule_work() # Schedule work to be performed at some point
    {:ok, state}
  end

  def handle_info(:work, state) do
    # big amount of ecto stuff
    schedule_work() # Reschedule once more
    {:noreply, state}
  end

  defp schedule_work() do
    Process.send_after(self(), :work, 2 * 60 * 60 * 1000) # In 2 hours
  end
end

除了一件事，一切都很好。当我打开时 iex -S mix我在 shell 中收到了很多 ecto 调试消息，例如:

01:58:10.921 [debug] QUERY OK db=7.8ms decode=0.2ms
SELECT r0."id", r0."description", r0."property_type", r0."beds", r0."baths", r0."square", r0."price", r0."availability", r0."state", r0."country", r0."city", r0."address", r0."zipcode", r0."full_address", r0."external_provider_url", r0."location", r0."visits_count", r0."likes_count", r0."comments_count", r0."deleted_at", r0."credits", r0."somehere", r0."zis", r0."thumbnail_type", r0."video", r0."review_thumbnail", r0."user_id", r0."inserted_at", r0."updated_at" FROM "reviews" AS r0 WHERE (r0."zis" IS NULL AND r0."somehere" IS NULL) ORDER BY r0."id" LIMIT 1 []

我怎样才能避免这种情况？

Answer 1

您可以更改日志级别(在 iex 中):

Logger.configure(level: :info)

或者在您的配置中:

config :logger, level: :info

您可以完全禁用 Ecto 的日志:

config :my_app, MyApp.Repo,
  loggers: []

如 https://hexdocs.pm/ecto/Ecto.Repo.html 中所述