python - 当参数基于用户检查的输入时，如何在 python 烧瓶中使用 pd.read_sql 选择查询？

Question

到目前为止，我可以制作复选框。当用户选中复选框时，它们以数组的形式列出。我不知道如何在使用选择查询时将它们从数组分离到字符串并在（？）中单独传递它们

HTML

<!-- Check Box -->
<form action="/tables"  method = "POST">
<div class="form-check">
 <label class="form-check-label">
<input type="checkbox" class="form-check-input" name="match-with-vehicle" value="Passenger Car">Passenger Car
 </label>
</div>

轻型商用车 取消 下一个

Python

#CheckBox
if request.method == 'POST':
options= request.form.getlist('match-with-vehicle')
checkedoptions = str(options)

 vehicle_seg_test = pd.read_sql("SELECT lvpf.Brand, lvpf.VehicleSegment, 
 vehicle_segmentation.VehicleOffering FROM lvpf INNER JOIN vehicle_segmentation Where 
 vehicle_segmentation.VehicleOffering = (?) and  vehicle_segmentation.Segment = lvpf.VehicleSegment ", conn2, params=[checkedoptions])
 print(vehicle_seg_test)

标签： python