Files
rickyandClaude Opus 5.5 7694719582 Off-site backup to Google Drive
- Admin → Off-site Backup: connect a Google account with your own OAuth
  client (drive.file scope; refresh token and secret encrypted)
- Nightly after the verified database backup: upload the gzipped snapshot
  (newest N kept, Settings) and every uploaded file not yet copied
- Restore test downloads the newest copy, opens and checks it, and checks
  sampled files against their checksums; failures emailed to admins
- About, procedures document, policy completeness and audits use it
- offsite:restore_files rake task; restore steps in the admin guide

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-11-07 13:51:45 -05:00

12 lines
414 B
Ruby

class OffsiteRun < ApplicationRecord
KINDS = %w[backup restore_test].freeze
validates :kind, inclusion: { in: KINDS }
scope :backups, -> { where(kind: "backup") }
scope :restore_tests, -> { where(kind: "restore_test") }
def self.latest_backup = backups.order(:created_at, :id).last
def self.latest_restore_test = restore_tests.order(:created_at, :id).last
def recent? = created_at > 2.days.ago
end