Converting postgresql indexes to Django migrations

Question

We have a Django application that has been in production since Django 1.1. Over the years, we've manually added bells and whistles to the production PostgreSQL db that weren't at the time overtly supported by Django's db automation, especially in the form of custom indexes.

Django's come a long way since 1.1, and now w/ 1.10 I'm pretty sure the migration framework supports all the custom features we've added manually. Is there any automated tool which will compare a database to the models, and generate migrations to bring the models up to date with the db?

Sayse · Accepted Answer · 2017-02-21 16:05:25Z

2

This is built into django, you can just run inspectdb

manage.py inspectdb

Introspects the database tables in the database pointed-to by the NAME setting and outputs a Django model module (a models.py file) to standard output. You may choose what tables to inspect by passing their names as arguments.

Use this if you have a legacy database with which you’d like to use Django. The script will inspect the database and create a model for each table within it.

answered Feb 21, 2017 at 16:05

Sayse

43.4k14 gold badges85 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David Eyk Over a year ago

Ha, "batteries included", indeed. I'd read about that feature before, but had completely forgotten about it. Thanks!

Collectives™ on Stack Overflow

Converting postgresql indexes to Django migrations

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related