JavaScript JSON Table Matching

Question

I've been going through hell trying to figure this out, i'm sure it's not that big of a deal, perhaps i'm just tired from coding all night, but I could really use some help...

"users" is a database-like object containing user account information ( server-side, of course ), "get" is a function that returns an array of matching objects from the users array.

var users = [
    {
        name:"xymon",   
            age:19,
        pass:"mypass",  
        time:1364101200684
    },
    {
        name:"test",    
            age:19,
        pass:"x",   
        time:1364101200993
    },
    {
            name:"test",
            age:19,
            pass:"bleh",
            time:1364101200992
    }

];

function get(a){

}

What I'm wanting "get" to do is return properties that match the specified object (a) in an array, like so...

var matching_users = get({name:"test",age:19});

This would return the two objects in the "users" array because their properties match the specified properties in "get" so that "matching_users" would return as...

[
    {
        name:"test",    
            age:19,
        pass:"x",time:1364101200993
    },
    {
            name:"test",
            age:19,
            pass:"bleh",
            time:1364101200992
    }

]

Damask · Accepted Answer · 2013-03-25 12:46:13Z

2

Iterate your array and check each item for matching:

function get(a){
var r = [];
for (var i=0, len=users.length; i<len; ++i) {
    var doAdd = true;
    for (var p in a) {
        if (a.hasOwnProperty(p)) {
            if (a[p] != users[i][p]) {
                doAdd = false;
                break;
            }
        }            
    }    
    if (doAdd)
        r.push(users[i]);
}
return r;
}

answered Mar 25, 2013 at 12:46

Damask

1,2941 gold badge14 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alexandrin88 · Accepted Answer · 2013-03-26 17:51:46Z

1

function get(a) {
  var matches = [];

  for (var i in users) {
     var matched = true;

     for (var prop in a) {
         if (a.hasOwnProperty(prop) && users[i][prop] !== a[prop]) {
             matched = false;
             break;
         }
     }

     if (matched) matches.push(users[i]);
  }

  return matches;
}

edited Mar 26, 2013 at 17:51

answered Mar 25, 2013 at 12:47

alexandrin88

4,3903 gold badges18 silver badges32 bronze badges

1 Comment

Damask Over a year ago

if Object.prototype has a additional properties, you'll make redundant iterations

Gurmeet · Accepted Answer · 2013-03-25 13:04:50Z

0

 function get(a) {
 var result = [];
      users.forEach(function (v, i) {
           if (v.name == a.name && v.age == a.age) {
                result.push(v);               
           }
 });

Result will be the array with matched objects.

answered Mar 25, 2013 at 13:04

Gurmeet

3,3245 gold badges23 silver badges45 bronze badges

Collectives™ on Stack Overflow

JavaScript JSON Table Matching

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related