Integration with Legacy DB

[Sells, Fred]

Although I have not tried it, the docs are pretty clear about how to sync a django model to an existing legacy DB (sqlserver08 in this case).

 

But is there a way to sync to a select statement with multi-table joins without first creating a View?

 

I know that creating a view would be easiest, but I’ve got some policy/security issues in my organization that require jumping through additional hoops and am hoping there is some Django “magic” to solve this.

 

Thanks,

 

Fred.

[Collin Anderson]

Hi,

It should be possible to re-write you select statement using the Django ORM, but there's not an automatic way to convert it. There's also raw() which might take the statement as is.

https://docs.djangoproject.com/en/dev/topics/db/sql/

Collin