# frozen_string_literal: true

require "logger"
$logger = Logger.new(Rails.root.join("log/backup.log").to_s)
desc "backup mysql"
task backup: :environment do
  uri = URI(ENV["DATABASE_URL"])
  cmd = "mysqldump --skip-lock-tables -u#{uri.user} -p#{uri.password} --port #{uri.port || 3306 } --databases kb_prod > /var/local/backup/kb_prod_#{Time.now.strftime("%Y%m%d")}.sql"
  puts cmd
  system(cmd)
  system("find /var/local/backup/ -mtime +7 -exec rm -f {} \\;")
  $logger.info "backup #{Time.now}"
end