Sort by database order

[pioz]

I migrated from the annotate gem, but the order in which columns are placed does not match the database order as annotate used to do. Since I use MySQL, I often run migrations with the after: option to insert the column at a specific point. Therefore, I would like annotaterb to also follow the column order found in the database (structure.sql). Is it possible to do this? If so, how? If not, can we add this sorting option?

[pioz]

@drwl any update on this?

[geremiasanti]

I have the same problem. Is there any update on the issue?

[Cremesis]

I'm encountering the same problem as well, coundn't find a solution yet.

[Giacomobarzon97]

fix this please

[Manik5]

Same problem here, any updates?

[dariot]

Fixing this would be great, now I have to launch another script that applies the correct sorting every time there's a change

[hatsu38]

What is the value of classified_sort in .annotate.yml? When it is set to false, it will be the order of the columns in the DB.

It has the same behavior as classified-sort in annotate_models. Sort columns alphabetically, but first goes id, then the rest columns, then the timestamp columns and then the association columns
FYI: https://github.com/ctran/annotate_models?tab=readme-ov-file#options

[drwl]

Hi, I'm going through old notifications and saw this. @pioz you marked this as completed and I just wanted to confirm that it has been fixed. Is that correct?

[pioz]

Hi, I'm going through old notifications and saw this. @pioz you marked this as completed and I just wanted to confirm that it has been fixed. Is that correct?

Yes, I confirm.