reverse engineer mysql database to create django app

Question

I basically want to take an existing mysql database structure created and used by a php app (codeigniter framework) and reverse engineer it to a django app. is there some tool to do this? south migrations maybe?

Mez · Accepted Answer · 2009-10-09 20:26:21Z

60

Create a project, and point your settings @ your database

Then run

./manage.py inspectdb

This will print out a python models file for the DB you're pointing at

You can output this to a file by doing something like

./manage.py inspectdb > models.py

And then you can move the file to the most suitable location, and edit it as needed.

edited Oct 9, 2009 at 20:26

answered Oct 9, 2009 at 19:52

Mez

25k14 gold badges75 silver badges93 bronze badges

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

3 Comments

Alasdair Over a year ago

Good answer. Chapter 18 of the Django Book has further details on using inspectdb to integrate existing databases - djangobook.com/en/2.0/chapter18

Rasiel Over a year ago

Great this is what i wanted exactly!, also going to generate the er diagram based on this using graphviz & django_extensions

Nick Craig-Wood Over a year ago

Make sure you check the generated model.py carefully! In particular lengths of CharFields and missing ForeignKeys was the problem cases last time I used it. It saved many hours of making the model.py by hand though.

Collectives™ on Stack Overflow

reverse engineer mysql database to create django app

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related