Django convert Model to sql code

views:

answers:

+1 Q:

Django convert Model to sql code

Hi,

My plan is to be able to dynamically generated sql tables. Since I know django can create sql tables via Models, they must have a function for this. The problem is I can not find this function in the django folder, or maybe I simply don't recognize it. thnx

+2 A:

It's called django-admin.py

Start here: http://docs.djangoproject.com/en/dev/ref/django-admin/

Specifically, see http://docs.djangoproject.com/en/dev/ref/django-admin/#django-admin-sql

S.Lott 2010-10-20 15:31:52

I'm looking for the specific function actually. This way I can implement it in my python script.

Benjamin 2010-10-20 18:41:49

@Benjamin: You can import and execute that. Further, you can read the source to see how they do it. It's quite clear from reading the source.

S.Lott 2010-10-20 18:45:03

I am not exactly sure what you mean, but you can get the SQL for all the tables in an app by running this command: python manage.py sqlall your_app

Ivan P 2010-10-20 15:36:25

If you're looking for the specific pieces of code, have a look at django.db.backends.creation to see how the sql is generated, of course there need to be individual implementations for different database types, so for example also see django.db.backends.postgresl.creation!

lazerscience 2010-10-20 22:04:28

ansaurus

tags:

views:

answers:

Django convert Model to sql code

related questions