+1 on raw SQL in this instance. On Mon, Jul 11, 2011 at 2:36 AM, Jian Chang <changjia...@gmail.com> wrote:
> 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. > -- 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.
