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" option. There are several administrative and performance hurdles to this. This DB is not clearly documented, so I have to explore and refine my SELECT statement for each query. I'm typically ending up with 5...10 joins per query. Most relationships are Foreign Keys although a few are many-to-many. I've searched without success for a way to "encapsulate" a complex SELECT statement into a django model definition. Is there any way to do this within the django model framework? -- 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 [email protected]. To post to this group, send email to [email protected]. 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/8cc80725-083a-406e-a6cb-725ff6a2222c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
