activerecord-clean-db-structure

activerecord-clean-db-structure copied to clipboard

I introduced a primary key into my schema with a character varying as datatype but still id as it's name. In order for this to work I had to disable the ignore_ids functionality, which is a shame since that functionality does a good job of cleaning up de sql file.

In order to make it work I separated the logic that handles primary keys from the logic that handles sequences. This allows to have a primary key with any datatype and any column name and still does the cleanup correctly. As a side benefit it now recognizes the primary key of the ar_internal_metadata table, which is named key instead of id.

There's still room for improvement on the sequences bit but that falls outside the scope of this PR.