django models to work with database views,tables

Question

My database has the tables books[isbn,name,author,availableNum],students[name,major,coursestaking],course[name,department,number,capacity,booksNeeded],department[name,courses] I have a small view that has fields from all the above {courseName,booksRecommended,dept,countofstudents}. When creating a model for view should I say something like this.

class Lookup(models.Model):
    course = models.ForeignKey('course',db_column = 'name')
    booksRecommended = models.ForeignKey('books',db_column = 'isbn')
    dept = models.ForeignKey('department',db_column = 'name')
    studentcount = models.IntegerField()

I'm getting the error ProgrammingError: column lookup.id does not exist. Ideas are welcome

lprsd · Accepted Answer · 2011-02-16 07:17:57Z

2

The models.Model that you have inherited from assumes that the table (or the view, in your case) has a column called as id that is used as a primary key, unless you have explicitly marked some other column to be primary_key = True.

Your view's sql, or the ./manage.py inspectdb should help us find the primary key for this view.

answered Feb 16, 2011 at 7:17

lprsd

87.9k48 gold badges140 silver badges169 bronze badges

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

4 Comments

stackover Over a year ago

this view doesn't have a primary key.so when i did ./manage.py inspectdb i couldnt see. but making one of the column(which was unique) to primary_key=True, did solve the issue.Thanks Lakshman

stackover Over a year ago

but in the views should i specify the relation explicitly, or as the database view already is aware of the constraints do i have to worry about it?

lprsd Over a year ago

If the name of the primary key is id, django can guess it, otherwise, you need to specify it explicitly.

David Louda Over a year ago

The fact I missed this autoId pattern caused me to lose some time. Adding primary_key = True to any field on the model for the view that will always be not null not blank solved it!

Collectives™ on Stack Overflow

django models to work with database views,tables

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related