migration.exs

# priv/repo/migrations/20160809055905_set_subscription_renew_for_users.exs

defmodule LearnPhoenix.Repo.Migrations.SetSubscriptionRenewForUsers do
  use Ecto.Migration
  alias LearnPhoenix.{Repo, User}
  import Ecto.Query

  def up do
    set_subscription_renew = from(u in User, update: [set: [subscription_renew: true]])
    Repo.update_all(set_subscription_renew, [])

    now = Ecto.DateTime.utc()
    users = from(u in User, where: u.subscription_expiration < ^now)
    Repo.update_all(users, set: [subscription_renew: false])
  end

  def down do
    set_subscription_renew = from(u in User, update: [set: [subscription_renew: nil]])
    Repo.update_all(set_subscription_renew, [])
  end
end