Hi Gregg, Is there any reason you can't treat this as a mutliple-database configuration?
https://docs.djangoproject.com/en/dev/topics/db/multi-db/ Django allows you to specify more than one database, and then direct queries at specific databases. So, you have your "main" django database for your own application, but you set up a connection to your "other" database to access the pricing report. You'll need to write some Django model wrappers for the data in the 'other' database -- inspectdb can help with that -- but once you've done that, you'll be able to query the 'other' database as if it were a set of normal Django models. Yours, Russ Magee %-) On Thu, Oct 25, 2012 at 4:43 AM, Gregg Branquinho <gr...@freightman.com>wrote: > Hi guys I am new to django and have built my first application that is > being used to track and compare pricelists from vendors and it is working > awesomly, I have had a request for a new feature and I am alittle boggled > at to how I am going to do it.. > > Basically I wasnt to create a view which returns read only data(a report) > from an external database which is not the django database. I dont want to > copy the data to the django database and use a models as then concurreny > become an issue > > What would you guys recommened.. > > I was thinking on implenting a odbc connection from the views.py method > called for my url ? but database call from the view , sound a abit dodgy. > > Any ideas ? > > > > > > Email Disclaimer <http://www.freightman.com/Legal/EmailDisclaimer> | Quote > Disclaimer <http://www.freightman.com//Legal/QuoteDisclaimer> | All > business is undertaken subject to our General Trading Conditions, a copy of > which is available on request and on our website > www.freightman.com<http://www.freightman.com/Legal/TradingTerms> > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/django-users/-/ewQAAfxJlJ4J. > To post to this group, send email to django-users@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > -- 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+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
