Creating models with sql data

Question

This code

from django.db import models

class Person(models.Model):
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)

produces these sql statements

CREATE TABLE myapp_person (
    "id" serial NOT NULL PRIMARY KEY,
    "first_name" varchar(30) NOT NULL,
    "last_name" varchar(30) NOT NULL
);

I want to know if it is possible to do it the other way around. That is given a .sql file with

CREATE TABLE myapp_person (
    "id" serial NOT NULL PRIMARY KEY,
    "first_name" varchar(30) NOT NULL,
    "last_name" varchar(30) NOT NULL
);

should produce models.py file with

class Person(models.Model):
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)

TIA

if you create the database with those tables you can then inspectdb - docs.djangoproject.com/en/dev/ref/django-admin/#inspectdb — JamesO
– JamesO, Commented Dec 9, 2013 at 14:39
my question is can how to create a models.py file with a .sql file. because i have a .sql file(from client) with schema and i have to make a models.py. Instead of writing all the models i want to know if there is any other way to generate models. — user3030969
– user3030969, Commented Dec 9, 2013 at 14:48

Daniel Roseman · Accepted Answer · 2013-12-09 15:52:51Z

2

As JamesO says in the comments, you can use inspectdb for that.

First, create a database, and run that SQL file against that database to create the tables.

Then, run python manage.py inspectdb to create the models from the database tables.

answered Dec 9, 2013 at 15:52

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

Collectives™ on Stack Overflow

Creating models with sql data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related