DataChecker_backend: For Yahoo Engine, discrepancy data is not generating correctly.

-----------------------------------------------------------------
Project: DataChecker
Component Used: ./generate-discrepancies.sh
Build: /var/local/builds/tsa-build-bidmgr-2010-03-09-p14-r25168
------------------------------------------------------------------

For Yahoo Engine, discrepancy data is not generating correctly.

Steps to reproduce:

1.Login to Tsacommon database

select * from searchEngineAccounts where distributionID = 164 and
accountID=289 and enabled ='true';

Select any SearchEngineIdentifier E.g.3362582011 which we update in staging
database.

2.Login to staging database.

mysql> select * from yahooDailyCheck where cmpgnID = 3362582011 order by date
DESC LIMIT 10;
---------------------------------------------------------------------------------------------------------------+

numClick | ctr | cpc | cost |
---------------------------------------------------------------------------------------------------------------+

481 | 0.00692225772097977 | 0.75991683991684 | 365.52 |

416 | 0.00686095030758828 | 0.860360576923077 | 357.91 |

384 | 0.00673554226377366 | 0.820989583333333 | 315.26 |

3.Then update yahooDailyCheck table for date 2010-03-06,2010-03-07 and 2010-03-08.

E.g.

update yahooDailyCheck set numImpr = 1200 where accountID = 1616374889 and
cmpgnID =3362582011 and date = '2010-03-06';

update yahooDailyCheck set numClick = 20 where accountID = 1616374889 and
cmpgnID =3362582011 and date = '2010-03-06';

update yahooDailyCheck set cost =12.22 where accountID = 1616374889 and
cmpgnID =3362582011 and date = '2010-03-06';

update yahooDailyCheck set numImpr = 1200 where accountID = 1616374889 and
cmpgnID =3362582011 and date = '2010-03-07';

update yahooDailyCheck set numClick = 20 where accountID = 1616374889 and
cmpgnID =3362582011 and date = '2010-03-07';
update yahooDailyCheck set cost =12.22 where accountID = 1616374889 and
cmpgnID =3362582011 and date = '2010-03-07';

update yahooDailyCheck set numImpr = 1200 where accountID = 1616374889 and
cmpgnID =3362582011 and date = '2010-03-08';

update yahooDailyCheck set numClick = 20 where accountID = 1616374889 and
cmpgnID =3362582011 and date = '2010-03-08';

update yahooDailyCheck set cost =12.22 where accountID = 1616374889 and
cmpgnID =3362582011 and date = '2010-03-08';

mysql> select * from yahooDailyCheck where cmpgnID = 3362582011 order by date
DESC LIMIT 10;

---------------------------------------------------------------------------------------------------------------+

numClick | ctr | cpc | cost |
---------------------------------------------------------------------------------------------------------------+

20 | 0.00692225772097977 | 0.75991683991684 | 12.22 |

20 | 0.00686095030758828 | 0.860360576923077 | 12.22 |

20 | 0.00673554226377366 | 0.820989583333333 | 12.22 |

4.Now execute the script and check the report file generated at tmp folder.

./generate-discrepancies.sh -d3 -account 17 -distribution 164 -T 2010-03-06 -E
2010-03-08

cat /tmp/DiscrepanciesReport164.csv

"Date","Account/Campaign","SE Imps","SE Clicks","SE Cost","SE
Conv","Status","SEAcctID","SEUserID","inMCC","AcctID","TSA Account","TSA
Imps","TSA Clicks","TSA Cost","TSA Conv","Imps","Clicks","Cost","Conv","Campaign
Last Synchronized"
"06-Mar-2010","Wills","1200","20","12.22","0","enabled","13286","694","","289","LegalZoom","57011.0","384.0","315.26","0","-55811.0","-364.0","-303.04","0.0"

Expected :

The generated CSV file should have data discrepancy for 3 dates.

I checked through ADMAX UI too (Snapshot:DataChecker_yahoo) attached.