# frozen_string_literal: true

class UserExport < ActiveRecord::Base
  belongs_to :user
  belongs_to :upload, dependent: :destroy
  belongs_to :topic, dependent: :destroy

  has_many :upload_references, as: :target, dependent: :destroy

  after_save do
    if saved_change_to_upload_id?
      UploadReference.ensure_exist!(upload_ids: [upload_id], target: self)
    end
  end

  DESTROY_CREATED_BEFORE = 2.days

  def self.remove_old_exports
    UserExport
      .where("created_at < ?", DESTROY_CREATED_BEFORE.ago)
      .find_each do |user_export|
        UserExport.transaction do
          Post.where(topic_id: user_export.topic_id).find_each { |p| p.destroy! }
          user_export.destroy!
        rescue => e
          Rails.logger.warn(
            "Failed to remove user_export record with id #{user_export.id}: #{e.message}\n#{e.backtrace.join("\n")}",
          )
        end
      end
  end

  def attach_upload(zip_filename, uploader_id)
    return if !File.exist?(zip_filename)

    upload =
      File.open(zip_filename) do |file|
        UploadCreator.new(
          file,
          File.basename(zip_filename),
          type: "csv_export",
          for_export: "true",
        ).create_for(uploader_id)
      end

    if upload.persisted?
      update_columns(upload_id: upload.id)
    else
      Rails.logger.warn("Failed to upload the file #{zip_filename}: #{upload.errors.full_messages}")
    end

    File.delete(zip_filename)
    upload
  end

  def retain_hours
    (created_at + DESTROY_CREATED_BEFORE - Time.zone.now).to_i / 1.hour
  end

  def self.base_directory
    Rails
      .public_path
      .join("uploads", "csv_exports", RailsMultisite::ConnectionManagement.current_db)
      .to_s
  end
end

# == Schema Information
#
# Table name: user_exports
#
#  id         :integer          not null, primary key
#  file_name  :string           not null
#  created_at :datetime         not null
#  updated_at :datetime         not null
#  topic_id   :integer
#  upload_id  :integer
#  user_id    :integer          not null
#