MyReelty migration commands

my_reelty.ex

# rsync files
rsync -rv --include '*/' --include '*.jpg' --exclude '*' --prune-empty-dirs [email protected]:~/videos/ ~/
rsync -rv --prune-empty-dirs [email protected]:~/images/ ~/

# change backup
mix ecto.drop ; mix ecto.create ; psql my_reelty_dev < ~/development/my_reelty/production/backup.sql

# Remove all reviews except last 200
required_ids = Ecto.Query.from(r in Review, limit: 200, order_by: [desc: :id], select: [:id], where: is_nil(r.deleted_at)) |> Repo.all |> Enum.map(fn(r) -> r.id end)
Ecto.Query.from(r in Review, where: not(r.id in ^required_ids), order_by: [asc: :id]) |> Repo.update_all(set: [deleted_at: Ecto.DateTime.utc])

# First not-deleted video id
# => 25195 TODO fix this stuff before production migration