Add automatic field detection in resources

[adrianthedev]

Feature

Some users would like to get all or some fields automatically from it's model class.
We can check the model attributes and foreign keys similar to how we discover them in the resource generator.

Current workarounds

Declare them manually as fields or build your own method.

Possible API

Note

Naming is TBD

# == Schema Information
#
# Table name: users
#
#  id                     :bigint           not null, primary key
#  name                   :string
#  age                    :string
#  is_admin               :integer
#  created_at             :datetime         not null
#  updated_at             :datetime         not null
class User < ApplicationRecord
end

# before
class Avo::Resources::User < Avo::BaseResource
  def fields
    field :id, as: :id
    field :name, as: :text
    field :age, as: :number
    field :is_admin, as: :boolean
    field :created_at, as: :date_time

    field :comments, as: :has_many
  end
end

# after
class Avo::Resources::User < Avo::BaseResource
  def fields
    # adds fields for all attributes
    discover_fields

    # selectively pick fields
    discover_fields only_attributes: [:id, :name]

    discover_fields except_attributes: [:age]

    # associations 
    discover_associations
  end
end

[github-actions]

This issue has been marked as stale because there was no activity for the past 15 days.

[ObiWanKeoni]

@Paul-Bob @adrianthedev Do you mind if I take a crack at this one?

[Paul-Bob]

Sure @ObiWanKeoni, thank you!

We don't have a lot of research on this but basically we would like to browse and manipulate the database (and all the attribute accessors of an model) without need to configure each field individually.

Let me know if you need any help with this

[ObiWanKeoni]

Hey @Paul-Bob 👋

FYI - I do have a working prototype locally but before I commit a substantial feature change, I'm working to get the necessary internal approvals from my workplace.

[Paul-Bob]

FYI - I do have a working prototype locally but before I commit a substantial feature change, I'm working to get the necessary internal approvals from my workplace.

Amazing! We would love to see it