Mimic SQL table with ActiveModel Attributes

Question

I am using

ActiveModel::Model 
ActiveModel::Attributes.

I noticed that the attributes method used in my form object (active model) does not allow :text type. I was wondering how I can setup attributes to mimic the below sql table?

create_table "teachers", force: :cascade do |t|
    t.string "name"
    t.text "credentials", default: [], array: true
    t.integer "age"
    t.boolean "working", default: false
    t.bigint "user_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["user_id"], name: "index_cpas_on_user_id"
  end

score 0 · Answer 1 · answered Sep 15 '20 at 23:10

0

Just use attribute :my_attribute, :string.

There is no actual difference between how ActiveRecord treats casting VARCHAR columns (represented by the :string type) and TEXT columns.

The only difference is the SQL generated by the migration and thus what type of column is used for storing the actual information.

On Postgres for example both TEXT and VARCHAR columns have an upper limit of about 1GB, but VARCHAR(n) lets you set a lower arbitrary limit such as VARCHAR(255) - but there is no performance benefit to either and thus no advantage to using the TEXT type. This of course can vary depending on what RDBMS is in use.

See:

answered Sep 15 '20 at 23:10

max

96,212
14
104
165

What about using array? Or setting a default value? – Lefty Sep 15 '20 at 23:55
Use the array and default options. Read the manual... – max Sep 16 '20 at 05:27
Can you send the link, I looked for it, but could not find it the info for active model, I found array options for active record. – Lefty Sep 16 '20 at 10:14

Mimic SQL table with ActiveModel Attributes

1 Answers1