所以我有一个服务列表,所有服务都是用geogoder gem进行地理编码的。
调用Service.near("London")
抛出
ActiveRecord::StatementInvalid:Mysql2::Error:中有错误您的SQL语法;查看与MySQL对应的手册在附近使用正确语法的服务器版本
Service.near("London").to_sql
给出
SELECT services.*, MOD(CAST((ATAN2( ((services.longitude - -4.8824474) / 57.2957795),
((services.latitude - 36.510071) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing
FROM `services`
WHERE (services.latitude BETWEEN 36.220607433778305 AND 36.7995345662217
AND services.longitude BETWEEN -5.242587667147616 AND -4.522307132852385
AND () BETWEEN 0.0 AND 20)
ORDER BY distance ASC
distance_between
工作没有问题。
有人能告诉我做错了什么吗?
提前感谢
您必须发送正确的参数,Geocoder gem才能合成工作的SQL。
在gem文档中,尽管无可否认没有明确说明,但您需要完全指定所有参数
nearbys = Place.near("Omaha, NE", 50,:order => "distance")
一般
nearbys = Model.near("Gecodeable address string", N (range constant), order: parameter)
对于您的情况,我建议尝试下面的方法,看看是否能让您通过MySQL错误
@result = Service.near("London, UK", YOUR_DISTANCE_CONSTANT, order: false)
我不知道这有多大帮助,但这是我的一个模型的SQL.near生成的。我正在通过地理坐标并测试"活动"标志:
[1m[36mAnimalRescue Load (0.0ms)[0m [1mSELECT animal_rescues.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((30.326374 - animal_rescues.latitude) * PI() / 180 / 2), 2) + COS(30.326374 * PI() / 180) * COS(animal_rescues.latitude * PI() / 180) * POWER(SIN((-97.771258 - animal_rescues.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((animal_rescues.longitude - -97.771258) / 57.2957795), ((animal_rescues.latitude - 30.326374) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM "animal_rescues" WHERE "animal_rescues"."active_listing" = 't' AND (animal_rescues.latitude BETWEEN 29.77639322417878 AND 30.876354775821223 AND animal_rescues.longitude BETWEEN -98.40842692015944 AND -97.13408907984056 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((30.326374 - animal_rescues.latitude) * PI() / 180 / 2), 2) + COS(30.326374 * PI() / 180) * COS(animal_rescues.latitude * PI() / 180) * POWER(SIN((-97.771258 - animal_rescues.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND 38) ORDER BY delivery_item_count + dropoff_item_count DESC LIMIT 3[0m
在某个时候,我显然添加了Geokit宝石,然后又删除了它。
模型中留下的是acts_as_mappable
这导致SQL语法被抛出。