如何在数据库中进行精确搜索

Question

一般情况下，在phrase queries中搜索精确的数学是得到使用双引号。在bw2 (例如，请看这里)中，它似乎大部分(但不是所有时间)都能工作。

db.search('"{}"'.format("Carbon dioxide, from soil or biomass stock"))

['Carbon dioxide, from soil or biomass stock' (kilogram, None, ('air','non-urban air or from high stacks')), 
'Carbon dioxide, to soil or biomass stock' (kilogram, None, ('soil', agricultural')), 
'Carbon dioxide, from soil or biomass stock' (kilogram, None, ('air', 'urban air close to ground')),
'Carbon dioxide, from soil or biomass stock' (kilogram, None, ('air',)),
'Carbon dioxide, to soil or biomass stock' (kilogram, None, ('soil', 'forestry')),
'Carbon dioxide, from soil or biomass stock' (kilogram, None, ('air', 'indoor')),
'Carbon dioxide, from soil or biomass stock' (kilogram, None, ('air', 'lower stratosphere + upper troposphere')),
'Carbon dioxide, to soil or biomass stock' (kilogram, None, ('soil', 'industrial')),
'Carbon dioxide, from soil or biomass stock' (kilogram, None, ('air', 'low population density, long-term')),
'Carbon dioxide, to soil or biomass stock' (kilogram, None, ('soil',))]

知道如何得到精确匹配的搜索结果吗？

Answer 1

查找那些在Whoosh搜索索引中似乎很困难的东西的最简单的方法是跳过它，然后过滤原始数据集。

[ds for ds in db if ds['name'].startswith('Carbon dioxide, from soil or biomass stock')]

添加任意复杂性非常容易，因为您只是在添加Python函数。