taffyDB JSON示例

Question

我从taffyDB.com中获取了这个JSON (为了节省空间，我将其缩短了一点)

var friends = TAFFY([
    {"id":1,"gender":"M","first":"John"},
    {"id":2,"gender":"F","first":"Kelly"},
    {"id":3,"gender":"M","first":"Jeff"},
    {"id":4,"gender":"F","first":"Jennifer"}    
]);

我正在尝试将此JSON与taffyDb结合使用

var friends = TAFFY([{
    people:[
        { "id": 1, "gender": "M", "first": "John" },
        { "id": 2, "gender": "F", "first": "Kelly" },
        { "id": 3, "gender": "M", "first": "Jeff" },
        { "id": 4, "gender": "F", "first": "Jennifer" }
    ]
}]);

但我一点运气都没有。

假设我想使用下面的代码：

// Find John Smith, by Gender and name
friends({gender: "M", first: "John"});

我不能让它工作。当我不包括人时，它工作得很好：...

我试过了

friends({people.gender: "M", people.first: "John"});

但这也不起作用。

有什么想法吗？

Answer 1

var friends = TAFFY([
    {"id":1,"gender":"M","first":"John"},
    {"id":2,"gender":"F","first":"Kelly"},
    {"id":3,"gender":"M","first":"Jeff"},
    {"id":4,"gender":"F","first":"Jennifer"}    
]);

// Find all "M" frends, then filter firstname like "John"
friends({'gender': "M"}).filter({"first": {"like": "John"}});

//  Ignores case
friends({'gender': "M"}).filter({"first": {"likenocase": "john"}})

// directly filter
friends(friends({"first": {"like": "John"}});


// output: [{"id":1,"gender":"M","first":"John","___id":"T000003R000002","___s":true}]