On Oct 26, 4:43 am, gillengam <gillen...@gmail.com> wrote: > Hi, I must develop an application that use Oracle database. The Oracle > connection user is the owner of some tables, but he can only read two > views (he is not the owner). I used command "python manage.py > inspectdb > models.py", but I got only user's tables and .... I need > also the two views. How can I do? Is it possible? > > Thanks
I usually create a table using something similar to: create table temp_member_view as select * from member_view where rownum < 2; Where member_view would be the original view name. I then use the inspectdb to create the model for the new table and then drop the table it should create a better model than I do usually when I try to do it manually. If your view doesn't have an obvious single column primary key you may want to look at my notes on this subject: http://projects.django-development.info/trac/dd_dd/wiki/Creating_Django_Views_of_Tables Great call on overriding save/delete I'll add to my notes and start doing that as well since I wasn't. Mark --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
