Django - Use of inspectdb for user's uploaded table

Question

My web application allow users to load/create tables in the Postgres database. I know Django ORM needs a model definition in models.py for each table in the database to access it.

I wonder if I could call manage.py inspectdb from a script after an upload (or a delete) to auto-generates the models.py.

If I use queues with django-celery to be sure that every inspectdb are done one at a time, could it be a viable solution?

Thank you for your comments and suggestions!

score 1 · Accepted Answer · answered Apr 23 '13 at 18:29

1

Well you can call commands with

from django.core import management
management.call_command('inspectdb')

see here for more info.

But I doubt it would work for dynamically creating models the way you want. For one thing, most wsgi servers need to be rebooted for changes to appear.

answered Apr 23 '13 at 18:29

Ngenator

10,909
4
41
46

Thank you for your answer, I am testing PostGreSQL hstore capability instead. – Below the Radar Apr 23 '13 at 18:31

Django - Use of inspectdb for user's uploaded table

1 Answers1