java - neo4j和Java集合搜索

嗨，我正在尝试使用运算符IN进行搜索，但始终返回一个空列表，这是怎么回事？下面是我的单元测试。我想要的是按描述性或类似描述的词语搜索产品。 （将来我假装实现模糊）。

private GraphDatabaseService graph;
private Index<Node> indexProduct;
private ExecutionEngine engine;

@Before
public void prepareTestDatabase() {
    TestGraphDatabaseFactory testGraphDatabaseFactory = new TestGraphDatabaseFactory();
    this.graph = testGraphDatabaseFactory.newEmbeddedDatabase("/tmp/neo4j/tests");
    this.indexProduct = this.graph.index().forNodes("node_product");
    this.engine = new ExecutionEngine(this.graph, StringLogger.SYSTEM);
    this.loadDataForTest();
}

private void loadDataForTest() {
    Transaction tx = this.graph.beginTx();

    List<String> similarities = new ArrayList<>();
    similarities.add("televisor");
    similarities.add("tv");
    String description = "televisão";
    Product product = new Product(description, similarities);

    Node node = this.graph.createNode(DynamicLabel.label(product.description));
    node.setProperty("description", product.description);
    node.setProperty("similarities", product.similarities);

    this.indexProduct.add(node, "PRODUCT", product.description);

    tx.success();
    tx.finish();
}

@Test
public void searchByDescription(){
    String description = "televisão";

    List<String> list = new ArrayList<>();
    ExecutionResult result = this.engine.execute("start n=node:node_product('PRODUCT:*') WHERE HAS(n.similarities) AND n.similarities IN ['tv'] return n.description");
    for (Map<String, Object> row : result) {
        for (Entry<String, Object> column : row.entrySet()) {
            Object value = column.getValue();
            list.add(String.valueOf(value));
        }
    }

    Assert.assertTrue(list.contains(description));
}

这是产品类别

class Product {
    String description;
String[] similarities;

Product(String description, List<String> similaritiesList) {
    super();
    this.description = description;
    this.similarities = new String[similaritiesList.size()];
    for (int i=0; i<similaritiesList.size(); i++)
        this.similarities[i] = similaritiesList.get(i);
}

最佳答案

希望我对您的用例正确。但是我认为您的Cypher查询有点混乱。
您的查询：

"start n=node:node_product('PRODUCT:*') WHERE HAS(n.similarities) AND n.similarities IN ['tv'] return n.description"

让我们来看看n.similarities IN ['tv']。属性similarities是一个数组。 ['tv']是一个字符串数组。因此，表达式`n.similarities IN ['tv']始终求值为false，因为['tv']不包含任何数组，更不用说similarities数组了。

最后，我只是觉得您的意思是别的，即。

 'tv' IN n.similarities

这样可以吗？您要检查字符串tv是否包含在similarities数组中。当我以这种方式更改查询时，即结果查询将是

start n=node:node_product('PRODUCT:*') WHERE HAS(n.similarities) AND 'tv' IN n.similarities return n.description

然后，改编的测试班对我有用。

关于java - neo4j和Java集合搜索，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/17981501/