Notes

start-2016-05-24 14:56:22
select count(*) from application where created_datetime>'2016-05-24 14:56:22';

select error_code, count(*) from uerules_custids a join application b on a.newleadid=b.request_id where newleadid is not NULL group by 1 with rollup;

select request_id,application_id,leadid from uerules_custids a join application b on a.newleadid=b.request_id where error_code='SE' and created_datetime>'2016-05-24 14:56:22' order by created_datetime desc limit 5;

select request_id,application_id,leadid from uerules_custids a join application b on a.newleadid=b.request_id where error_code='DP_MISSING' and created_datetime>'2016-05-24 14:56:22' order by created_datetime desc limit 5;


update uerules_custids set newleadid=NULL where newleadid in (select request_id from application where error_code='SE');

select user_id,purchased_position,application_price,count(*) from uerules_custids a join application b on a.newleadid=b.request_id where error_code='MarketCodeNotSetInConfig' group by 1,2,3 with rollup ;

select request_id,b.application_id,leadid,error_code from uerules_custids a join application b on a.newleadid=b.request_id join dataprovider_response c on substr(a.leadid, 1,19)=c.application_id where error_code='DP_MISSING' and c.response!='None' limit 5;

select a.leadid from ukl_viveks.uerules_custids a left join ClientResponse b on a.leadid=b.leadid where b.chlapproved=1 limit 5;


select a.leadid,newleadid, error_code from uerules_custids a join dataprovider_response c on substr(a.leadid,1,19)=c.application_id join application b on a.newleadid=b.application_id where c.response IS NOT NULL and c.service_type='CR_Delphi' and newleadid IS NOT NULL order by newleadid limit 5;

select avg(datereceived-daterequested) from dataprovider_response where application_id>160142636 and dataprovider_name='FreeDataClient';


select leadid from CRAResponse where leadid like '20160110%' and response is not null and CRAName in ('Experian', 'CallCredit_TAC', 'EXPerian_Delphi', 'GBGroup', 'TraceSmart_32') group by leadid having count(*) =5;

src/core/lib/foundation/config/config_dev.ini
src/services/account/ValidationBank.py
src/services/application/application_controller.py
src/services/application/application_utils.py
src/services/application/middleware/application_entity.py
src/services/application/middleware/dp_manager.py
src/services/application/middleware/submitted_state_handler.py


20160110144035052351_82