解决Python/Flask中“TypeError: ‘float‘ object is not callable”错误

在部署使用Python和Flask框架编写的简单API时，遇到一个奇怪的错误“TypeError: ‘float’ object is not callable”。尽管变量类型应为int，但仍然出现此错误。即使尝试强制将变量类型转换为int，问题仍然存在。

2、解决方案：
此错误通常是由将变量类型分配为float类型引起的，导致无法访问range()内置函数。为了解决此问题，可以将range变量声明为int类型，如下所示：

if (lng != None) and (lat != None):
    range = int(0.1)

另外，代码中还存在一些其他问题：

1. 将float类型的值分配给int类型的变量：

   price_min = request.args.get('price_min',default=None, type=float)
   price_max = request.args.get('price_max',default=None, type=float)
   
   rooms_min = request.args.get('rooms_min',default=None, type=float)
   rooms_max = request.args.get('rooms_max',default=None, type=float)
   

   为了避免此问题，应将type参数设置为int，如下所示：

   price_min = request.args.get('price_min',default=None, type=int)
   price_max = request.args.get('price_max',default=None, type=int)
   
   rooms_min = request.args.get('rooms_min',default=None, type=int)
   rooms_max = request.args.get('rooms_max',default=None, type=int)
   

2. 在字符串连接中使用int变量时没有将变量转换为字符串：

   query = query + "," + str(counter + 6)
   

   为了解决此问题，应将int变量转换为字符串，如下所示：

   query = query + "," + str(str(counter + 6))
   

经过以上修改，代码应该可以正常运行，不会再出现“TypeError: ‘float’ object is not callable”错误。

修改后的代码示例：

def closest_point():
    lng = request.args.get('lng', default=None, type=float)
    lat = request.args.get('lat', default=None, type=float)

    price_min = request.args.get('price_min', default=None, type=int)
    price_max = request.args.get('price_max', default=None, type=int)

    rooms_min = request.args.get('rooms_min', default=None, type=int)
    rooms_max = request.args.get('rooms_max', default=None, type=int)

    if (lng != None) and (lat != None):
        range = int(0.1)
        lng_min = lng - range
        lng_max = lng + range
        lat_min = lat - range
        lat_max = lat + range

        cur = g.db.cursor()
        query = "SELECT id, link, price, longitude, latitude FROM " + DATABASE_TABLE_NAME + " WHERE latitude >= " + str(lat_min) + " AND latitude <= " + str(lat_max) + " AND longitude >= " + str(lng_min) + " AND longitude <= " + str(lng_max)

        # I always have 5 basic parameters to group by. I count number of additional parameters to know how many to add
        additional_params_count = 0
        if price_min:
            query = query + " AND price >= " + str(price_min)
            additional_params_count = additional_params_count + 1
        query = query + "GROUP BY 1,2,3,4,5"
        for counter in range(0, additional_params_count):
            query = query + "," + str(str(counter + 6))
        query = query + ";"
        cur.execute(query)
        columns = [desc[0] for desc in cur.description]
        rows = cur.fetchall()
        flats_json = []
        for row in rows:
            flats_json.append(dict((k, str(v)) for k, v in zip(columns, row)))
        response_body = str(rows)
        return json.dumps(flats_json)
    else:
        return "One of lng or lat parameters missing"