Repo / Model with Sequel, SQLite and Dry-Struct #ruby

events.rb

require 'app'
require 'dry-struct'
require 'types'

class Events
  def self.migrate!
    return if db.table_exists?(table_name)

    db.create_table table_name do
      String :project,      null: false
      String :env,          null: false
      String :id,           null: false
      String :type,         null: false
      DateTime :created_at, null: false
      
      index [:project, :env, :type], unique: true
    end
  end

  class Event < Dry::Struct
    attribute :project,    Types::Strict::String
    attribute :env,        Types::Strict::String    
    attribute :type,       Types::Strict::String
    attribute :created_at, Types::Strict::Time
  end

  def self.all
    table.all.map { |attrs| Event.new(attrs) }
  end

  def self.insert(attributes)
    attributes[:created_at] ||= Time.now
    
    Event.new(attributes).tap do |event|
      table.insert(event.attributes)
    end    
  end

  def self.find(attributes)
    Event.new(table.first(attributes))
  end 

  class << self
    private
    
    def table
      db[table_name]
    end

    def table_name
      :events
    end

    def db
      App.configuration.db
    end
  end
end