Using raw sql is a better idea 2011/7/11 Jonas Geiregat <jo...@geiregat.org>
> > > In order to find the places in near by area I want to make following > mysql query. but I am not sure how should I translate it using django > models and managers. > > > You could execute the raw sql query string, see: > https://docs.djangoproject.com/en/dev/topics/db/sql/ > for more information on the subject. Seeing the complexity of the query and > knowing it's a good working version why should you even bother translating > it to django's ORM framework ? > > > orig.lat = x > orig.lon = y > > "SELECT destination.*, > 3956 * 2 * ASIN(SQRT( POWER(SIN((orig.lat - dest.lat) * pi()/180 / > 2), 2) + > COS(orig.lat * pi()/180) * COS(dest.lat * pi()/180) * > POWER(SIN((orig.lon -dest.lon) * pi()/180 / 2), 2) )) as > distance > FROM place as dest > WHERE dest.longitude > BETWEEN lon1 and lon2 > AND dest.latitude > BETWEEN lat1 and lat2 > " > > the model which talks to database is called Place in my case. > > Thank you all for the help, > sanket > > -- > 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. > > > > Jonas Geiregat > jo...@geiregat.org > > > > > > -- > 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. > -- 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.
