creating django model for existing database/sql view?

Question

I have inserted a definition for a view in $template_dir/sql/$someTableName.sql file. (create or replace view) so every time I run syncdb, the db views are created.

Can I create in models.py a python class which accesses that view?

Is it better practice to just use python's raw sql functionality instead?

---EDIT---

Another problem I have is that the view doesn't have a primary key, but django seems to be assuming there will be one because I get an error caught an exception while rendering: (1054, "Unknown column 'appName_currentleagues.id' in 'field list'") But I don't have such a member defined:

Class CurrentLeagues(models.Model):
        League = models.ForeignKey(League)
        class Meta:
                managed = False

So my guess is that django reasonably sees that I don't define a primary key in the CurrentLeagues class, so Django assumes there's one called id. Is there a way to tell Django that there is no primary key (since this is actually a view), or is that not even my problem?

Will Hardy · Accepted Answer · 2010-02-11 17:13:02Z

6

See Unmanaged models

You define the model as usual and add managed = False to the meta options:

class MyModel(models.Model):
    ...
    class Meta:
         managed = False

answered Feb 11, 2010 at 17:13

Will Hardy

14.9k5 gold badges46 silver badges44 bronze badges

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

4 Comments

Alexander Bird Over a year ago

But how do I associate that python class with the mysql view I want it associated with? And do I need to explicitly type the members of "MyModel" correctly to match the spelling of the fields in the view and it just works automatically somehow?

Alexander Bird Over a year ago

I just need to spell the view as appName_classname because that's the spelling that django automatically uses for every python Model instance.

Will Hardy Over a year ago

You can manually pass the name of the view using the db_table meta option: docs.djangoproject.com/en/dev/ref/models/options/#db-table. Yes you will need to type the field names in, otherwise django wont have a python version of your models. If you want to reduce the amount of typing you could employ an intricate web of abstract models and inheritance, but I would keep things as simple as possible, even if it means a little repetition.

Will Hardy Over a year ago

If you set primary_key=True on one of your fields, django wont automatically create the id field. It seems you have to have one field as a primary key. If you're using sqlite or oracle, you might get away with this hack: groups.google.com/group/django-developers/browse_thread/thread/…

Bernardo Rychtenberg · Accepted Answer · 2012-08-14 19:14:55Z

3

Try to use python manage.py inspectdb or python manage.py inspectdb > models.py

answered Aug 14, 2012 at 19:14

Bernardo Rychtenberg

311 bronze badge

Collectives™ on Stack Overflow

creating django model for existing database/sql view?

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related