Re: create unmanaged model to oracle view/synonym

Hello, Shai and Edgar

yes, I've tried using inspectdb, however, it only generates models for database tables, but not for database View[1] and database Synonym[2].

The Django documentation is currently not explicit in showing that the specific database features are supported by Django database backends.

inspectdb does not support "database schemas"[3][4].

Any other ideas how to solve this?

[1] http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8004.htm

[2] http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8004.htm
[3] https://groups.google.com/d/msg/django-users/jsoDvI7DipU/CYOdstKeTYcJ 

[4] https://code.djangoproject.com/ticket/22673

Em quinta-feira, 1 de janeiro de 2015 16h57min38s UTC-3, Edgar Gabaldi escreveu:

Fabio,

Django ORM support Oracle Database[1].

If you want connect an existing oracle database, i recomend you see the inspectdb management command.

[1] https://docs.djangoproject.com/en/1.7/ref/databases/#oracle-notes

[2] https://docs.djangoproject.com/en/1.7/howto/legacy-databases/

On Thu, Jan 1, 2015 at 2:40 PM, Shai <sh...@platonix.com> wrote:

Hi Fábio,

On Wednesday, December 31, 2014 6:05:05 PM UTC+2, Fabio Caritas Barrionuevo da Luz wrote:

Hello, is possible with Django 1.7 create a unmanaged Django model for Oracle database View?

Yes. In your model's Meta, set managed to False and db_table to the view name:

class MyUnManagedModel(models.Model):
    # ...
    # fields
    # ...
    class Meta:
        managed = False
        db_table = 'view_name'

Have you run into difficulties?

HTH,
Shai.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/bf043f16-043a-4f0f-a6bf-2856c405be43%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/bfb315be-bbab-4704-85e6-5b8efadb7f4a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.