Re: inspectdb Oracle

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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---