+1 on raw SQL in this instance. On Mon, Jul 11, 2011 at 2:36 AM, Jian Chang <[email protected]> wrote:
> Using raw sql is a better idea > > > 2011/7/11 Jonas Geiregat <[email protected]> > >> >> >> 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 [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/django-users?hl=en. >> >> >> >> Jonas Geiregat >> [email protected] >> >> >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
