Subversion Repositories SmartDukaan

Rev

Rev 15443 | Rev 15455 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 15443 Rev 15444
Line 119... Line 119...
119 
"""
 119 
"""
120 
FRESH_QUERY_AIT="""
 120 
FRESH_QUERY_AIT="""
121 
select timestampdiff(second, last_action_time, created) from fetchdatahistory where call_type='fresh' and date(created)=date(now() - INTERVAL 1 DAY);
 121 
select timestampdiff(second, last_action_time, created) from fetchdatahistory where call_type='fresh' and date(created)=date(now() - INTERVAL 1 DAY);
122 
"""
 122 
"""
123 
FRESH_QUERY_LINKS_CONVERTED="""
 123 
FRESH_QUERY_LINKS_CONVERTED="""
124 
select count(*) from retailerlinks where date(activated) = date(created) and date(created)=date(now() - interval 1 day);
 124 
select count(*) from retailerlinks where date(activated) is not null and date(activated)=date(now() - interval 1 day);
125 
"""
 125 
"""
126 
FRESH_QUERY_LINKS_NOT_CONVERTED="""
 126 
FRESH_QUERY_LINKS_NOT_CONVERTED="""
127 
select count(*) from retailerlinks where date(activated) is null and date(created)=date(now() - interval 1 day);
 127 
select count(*) from retailerlinks where date(activated) is null and date(created)=date(now() - interval 1 day);
128 
"""
 128 
"""
129 
FRESH_AGENTS_CALLED_COUNT="""
 129 
FRESH_AGENTS_CALLED_COUNT="""
Line 145... Line 145...
145 
"""
 145 
"""
146 
AGENT_FRESH_QUERY_AIT="""
 146 
AGENT_FRESH_QUERY_AIT="""
147 
select timestampdiff(second, last_action_time, created) from fetchdatahistory where call_type='fresh' and date(created)=date(now() - INTERVAL 1 DAY) and agent_id=%s;
 147 
select timestampdiff(second, last_action_time, created) from fetchdatahistory where call_type='fresh' and date(created)=date(now() - INTERVAL 1 DAY) and agent_id=%s;
148 
"""
 148 
"""
149 
AGENT_FRESH_QUERY_LINKS_CONVERTED="""
 149 
AGENT_FRESH_QUERY_LINKS_CONVERTED="""
150 
select count(*) from retailerlinks where date(activated) = date(created) and date(created)=date(now() - interval 1 day) and agent_id=%s;
 150 
select count(*) from retailerlinks where date(activated) is not null and date(activated)=date(now() - interval 1 day) and agent_id=%s;
151 
"""
 151 
"""
152 
AGENT_FRESH_QUERY_LINKS_NOT_CONVERTED="""
 152 
AGENT_FRESH_QUERY_LINKS_NOT_CONVERTED="""
153 
select count(*) from retailerlinks where date(activated) is null and date(created)=date(now() - interval 1 day) and agent_id=%s;
 153 
select count(*) from retailerlinks where date(activated) is null and date(created)=date(now() - interval 1 day) and agent_id=%s;
154 
"""
 154 
"""
155 
 
 155