A platform for community discussion. Free, open, simple.
# 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
#