[LRUG] Rails schema line order changing

[Sam Livingston-Gray]

I like this.  The only thing I would change is that instead of "whoever
yells loudest gets to keep their database," you run `db:schema:dump`
against the production database, then copy the resulting file to somewhere
it can be committed to Git.  :)

On Mon, Mar 1, 2021 at 1:36 AM Patrick Gleeson <patrick.c.gleeson at gmail.com>
wrote:

> Step one: Whoever yells loudest gets to keep their database
> Step two: Everyone else does rails db:reset on their development
> databases, and possibly just db:schema:load on their test ones if you have
> seed data you don't want in your test db.
>
> The key is that db:schema:load reads from the schema file as-is, rather
> than reading from the migrations and re-constructing the schema from the
> database.
>
>  - Patrick
>
> Why aren't you coding? <https://whyarentyoucoding.com/>
>
> On Mon, 1 Mar 2021 at 08:10, Stuart Harrison <pezholio at gmail.com> wrote:
>
>> Morning LRUG
>>
>> I wanted to share an annoyance I've had on multiple projects, and
>> wondered if anyone had any fixes for it?
>>
>> If there are multiple devs on a project committing a bunch of migrations
>> and running `db:migrate`, it seems that, over time, the order of columns in
>> the schema.rb file jumps around every time the command is run.
>>
>> I can get around this by only committing the relevant line(s) when I run
>> a migration, but this does get annoying.
>>
>> I'm sure there is a solution, but it's disappeared out of my head, and
>> seems to be an ungoogleable problem, so was wondering if anyone had come
>> across a solution?
>>
>> Cheers
>>
>> Stu
>> _______________________________________________
>> Chat mailing list
>> Chat at lists.lrug.org
>> Archives: http://lists.lrug.org/pipermail/chat-lrug.org
>> Manage your subscription: http://lists.lrug.org/options.cgi/chat-lrug.org
>> List info: http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>>
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> Archives: http://lists.lrug.org/pipermail/chat-lrug.org
> Manage your subscription: http://lists.lrug.org/options.cgi/chat-lrug.org
> List info: http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20210301/727b3866/attachment.html>