Question: Save with custom columns

[janpeterka]

Hi, this may be stupid question, I'm quite new to Rails, so some things are not obvious to me.

My notifications table has some additional columns that I need to save data to. Main is content_message column, which I need to be the same as :content value. I'm unable to set this, tried:

• .with(announcement:, content: 'created', content_message: 'created')
• in before_delivery
• in Notification model before_validate

Thanks for help!

[excid3]

See https://github.com/excid3/noticed/blob/main/docs/delivery_methods/database.md and

noticed/lib/noticed/delivery_methods/database.rb

Line 6 in a970f68

recipient.send(association_name).create!(attributes)

class MyNotification do
  deliver_by :database, format: :custom_attributes

  def custom_attributes
    notification.params.slice(:announcement, :content, :content_message).merge(
      type: notification.class.name,
      params: notification.params
    )
  end
end

[artur1313]

@excid3 any update? I do not see anything in docs about how to save extra attributes to database models

[excid3]

It's supported and they're just ActiveRecord models so you can set attributes like you normally would.

CommentNotifier.new(attribute: value, params: {}).deliver(User.last)

[artur1313]

thx, but what if i want save extra data to Noticed::Notification instance? In my case i want save body of notification because i sending some dynamic data like "Hi #{user_name}, received #{amount}" and i want to know what exactly was sended.

[excid3]

That should really be in the params on the Noticed::Event.

You can add columns to Noticed::Notification and include it by overriding recipient_attributes_for method on the Notifier.

[phil-6]

You can also use Virtual attributes on the Noticed Event table and then delegate those values from the Notification to the Event.

For the Migration:

    create_table :noticed_events, id: :uuid do |t|
      t.string :type
      t.belongs_to :record, polymorphic: true, type: :uuid
      t.jsonb :params

      # Custom Fields
      t.string :organisation_id, type: :uuid, as: "((params ->> 'organisation_id')::uuid)", stored: true
      t.virtual :action_type, type: :string, as: "((params ->> 'action_type'))", stored: true
      t.virtual :url, type: :string, as: "((params ->> 'url'))", stored: true

      t.timestamps
    end

In the Notification Extensions concern

    delegate :organisation_id, :action_type, :url, to: :event, allow_nil: true

I've added this example to the docs in #389