Re: Map Django Model to Legacy multi-join query

2015-01-21 Thread Scot Hacker
On Tuesday, January 20, 2015 at 8:02:57 AM UTC-8, Fred wrote: > > I've got a complex 1000+ table vendor read-only MS SqlServer database and > only have SELECT privileges. I can connect with pymssql no problem. > > Of all these tables, I probably care about 50 or less. > > I cannot create views

Re: Map Django Model to Legacy multi-join query

2015-01-20 Thread James Schneider
Not sure what you mean. Are you looking to build the model definitions in your models.py files, or are you trying to take the results of a query against MSSQL and pass them to a constructor for a model that has already been defined? Either way, eventually you'll end up with a copy of the 'model'

Map Django Model to Legacy multi-join query

2015-01-20 Thread Fred
I've got a complex 1000+ table vendor read-only MS SqlServer database and only have SELECT privileges. I can connect with pymssql no problem. Of all these tables, I probably care about 50 or less. I cannot create views unless I introduce another physical server and use the "Linked Server"