class Record < ApplicationRecord
  acts_as_active on: [:create, :update],                 # ➜ Track different actions
                 if:           -> { track_activity? },   # ➜ On different conditions
                 unless:       -> { skip_tracking? },
                 after_record: -> (activity) { activity.update(metadata: {be: "BOP!"}) }   # ➜ Hook: runs after an activity is created or updated
end

record = Record.create!(title: "First draft")   # ➜ Records activity for today
record.update!(title: "Second draft")           # ➜ Activity count for today = 2
 

record.active_today?                # => true
record.active_on?(Date.yesterday)   # => false
record.activity_count(range: 1.day.ago..Date.today)
# => 2   (two events in the last 24 h)


record.heatmap(range: 1.week.ago..Date.today)
# => { "2025-08-01" => 1, "2025-08-02" => 3, "2025-08-03" => 2 }

record.longest_streak   # => 3   (e.g. active 1-3 Aug)
record.current_streak   # => 2   (e.g. active 5-6 Aug, still “on a streak” today)

record = Record.find(1) 
record.activities  # Accessing activities for a model that includes ActsAsActive

ActsAsActive::Activity.where(trackable: record)  # Query the namespaced model directly
ActsAsActive::Activity.all                       # Get all activities across all trackable types

# Where metadata contains key/value
ActsAsActive::Activity.where("metadata @> ?", { source: "api" }.to_json)

# Where nested key/value
ActsAsActive::Activity.where("metadata @> ?", { user: { id: 42 } }.to_json)

# MySQL: Find where metadata->source == 'api'
ActsAsActive::Activity.where("JSON_UNQUOTE(JSON_EXTRACT(metadata, '$.source')) = ?", "api")

# SQLite (with JSON1 extension):
ActsAsActive::Activity.where("json_extract(metadata, '$.source') = ?", "api")

activity.update!(
  metadata: {
    source: "api",
    user: { id: 42, name: "Amit" },
    tags: ["Dig", "Be", "Bop"]
  }
)