Help changing Json Store data

[nicosk]

I have two JsonStores.
One is a full list of data, and the other is just the updates of the data(if any). If there is a match of the ids i should change the data of that row in one store with the data from the other.

updateScoreStore.each(function(upd){
			liveScoreStore.each(function(liv){
				if (upd.data['id'] == liv.data['id']){
					console.log("WE HAVE A MATCH!");
					//liv.data['currentScore'] == upd.data['currentScore'];
				}				
			});
		});

Is this a correct way to compare the 2 stores. Also, how do i change the values of liveScoreStore with the data of updateScoreStore

[tomtom-]

A solution could be :

updateScoreStore.each(function(upd){
    if(liveScoreStore.find('id', upd.get('id'), 0, false, true) == (-1))
       liveScoreStore.loadData(upd.data, true); 
});

[Condor]

If you also configured the id as the idProperty of the store reader then using store.indexOfId is much faster than a tablescan.

[nicosk]

Condor, do you mean something like this?

var XMLReader = new Ext.data.XmlReader ({
			record: 'Match',
			idProperty: 'Match@id'
		},[
			{name: 'mid', 			mapping: '@id'},
			{name: 'startTime', 	mapping: '@startTime'},
			{name: 'statusType', 	mapping: '@statustype'},
			{name: 'status', 		mapping: '@status'},
			{name: 'home', 			mapping: 'Home@name'},
			{name: 'homeStanding', 	mapping: 'Home@standing'},
			{name: 'away', 			mapping: 'Away@name'},
			{name: 'awayStanding', 	mapping: 'Away@standing'},
			{name: 'country', 		mapping: 'Information > country'},
			{name: 'league', 		mapping: 'Information > league'},
			{name: 'currentScore', 	mapping: 'Results > Result@value'}
		]);

And then

updateScoreStore.each(function(upd){
    if(liveScoreStore.indexOf(upd.get['mid']))
       //change liveScoreStore row data
});

Thanks
Nicos

[Condor]

Almost.
1. The idProperty should be '@id'.
2. The loop should contain liveScoreStore.indexOf(upd.id)

[nicosk]

Thank you Condor! Works great.
Since we are on the subject, how to change the liveScoreStore with the date from the updateStore, so the changes will be visible on the grid?
They share the same reader, and the data is exactly the same.

    liveScoreStore = new Ext.data.GroupingStore({
 		url: "update/soccerLive.xml",
		autoDestroy : true,
		reader: XMLReader, 
	    sortInfo:{field: 'mid', direction: "ASC"},
        groupField:'status'
	});

	updateScoreStore = new Ext.data.GroupingStore({
		url: "update/soccerUpdate.xml",
		reader: XMLReader, 
	    sortInfo:{field: 'mid', direction: "ASC"},
        groupField:'status'		
	});

This fails to work

	function processUpdate(){
		console.log("In processUpdate. " + updateScoreStore.getCount());
		var grid = Ext.getCmp('liveScores');
		updateScoreStore.each(function(upd){
			if (liveScoreStore.indexOf(upd.id)) {
				console.log("Match: " + upd.id + "(" + upd.get("home") + " Vs " + upd.get("away") + ")");
				var myRecord = grid.getStore().getById(upd.id);
				myRecord.set('currentScore', upd.get('currentScore'));
				grid.getStore().commitChanges();
			} else {
				console.log("Adding row...")
				//liveScoreStore.add(upd.record);
			}
			
		});
	}

How can i do it correctly?

Regards,
Nicos

[Condor]

function processUpdate(){
    var liveScoreStore = Ext.getCmp('liveScores').getStore();
    updateScoreStore.each(function(rec){
        var rec2 = liveScoreStore.getById(rec.id);
        if (rec2) {
            rec2.set('currentScore', rec.get('currentScore'));
            rec2.commit();
        } else {
            liveScoreStore.add(rec.copy());
        }
    });
}

[nicosk]

Excellent. Thank you Condor!