On Thu, 2007-10-04 at 12:39 -0700, Jonathan Ballet wrote: > Hi everyone, > > I have a project which uses a PostgreSQL database with several tables, > and I have created VIEWs in this database. > > Now, I would like to be able to use those views from my Django > project. Is there any "official" way to do this ? > > Currently, I made a new Model class, with the same fields as in my > view, but this has several disadvantages : > * I can't use syncdb anymore (or I must ensure that the view is > created _before_ doing syncdb) ;
There's a ticket open to find a way to say "don't create a table for this model", precisely for the view case. I remember reading it during the sprint and debating a few points with somebody. It's tended towards over-engineering at some places in the comments (particularly the solution linked to from the ticket), but the concept is sound. > * I have methods on instances of my class which should not be there > (.create, .delete, .save) (at least, I'm not using materialized > views). Life's like that. Deal with it. :-) There's plenty of stuff you can do in Python that won't raise an error until you call try the action. This is another one of those. Don't call those methods and you'll be fine. Do call those methods and it will just be a different error from if the function was missing altogether. So the first point is an annoyance; currently you have to work as you indicate. The second point is really a non-issue and it's unlikely we'll be doing much about it in the near future. The reason it's not completely trivial is that you need a way to tell the difference between "this table already exists, so don't create it with syncdb" and "this thing already exists *and* it's not writable". It's probably not worth adding more and more settings options for a case where the existence of a couple of extra methods causes no genuine harm. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
