def GetLastActivityITS (days, closed_condition):
# opened issues
days = str(days)
q = "select count(*) as opened_"+days+" "+\
"from issues "+\
"where submitted_on >= ( "+\
" select (max(submitted_on) - INTERVAL "+days+" day) "+\
" from issues)"
data1 = ExecuteQuery(q)
# closed issues
q = "select count(distinct(issue_id)) as closed_"+days+" "+\
"from changes "+\
"where "+closed_condition+" "+\
"and changed_on >= ( "+\
" select (max(changed_on) - INTERVAL "+days+" day) "+\
" from changes)"
data2 = ExecuteQuery(q)
# closers
q = "SELECT count(distinct(pup.upeople_id)) as closers_"+days+" "+\
"FROM changes, people_upeople pup "+\
"WHERE pup.people_id = changes.changed_by and "+\
"changed_on >= ( "+\
" select (max(changed_on) - INTERVAL "+days+" day) "+\
" from changes) AND "+ closed_condition
data3 = ExecuteQuery(q)
# people_involved
q = "SELECT count(distinct(pup.upeople_id)) as changers_"+days+" "+\
"FROM changes, people_upeople pup "+\
"WHERE pup.people_id = changes.changed_by and "+\
"changed_on >= ( "+\
" select (max(changed_on) - INTERVAL "+days+" day) "+\
" from changes)"
data4 = ExecuteQuery(q)
agg_data = dict(data1.items()+data2.items())
agg_data = dict(agg_data.items()+data3.items())
return (agg_data)
def GetLastActivityITS(days, closed_condition):
# opened issues
days = str(days)
q = "select count(*) as opened_"+days+" "+\
"from issues "+\
"where submitted_on >= ( "+\
" select (max(submitted_on) - INTERVAL "+days+" day) "+\
" from issues)"
data1 = ExecuteQuery(q)
# closed issues
q = "select count(distinct(issue_id)) as closed_"+days+" "+\
"from changes "+\
"where "+closed_condition+" "+\
"and changed_on >= ( "+\
" select (max(changed_on) - INTERVAL "+days+" day) "+\
" from changes)"
data2 = ExecuteQuery(q)
# closers
q = "SELECT count(distinct(pup.upeople_id)) as closers_"+days+" "+\
"FROM changes, people_upeople pup "+\
"WHERE pup.people_id = changes.changed_by and "+\
"changed_on >= ( "+\
" select (max(changed_on) - INTERVAL "+days+" day) "+\
" from changes) AND "+ closed_condition
data3 = ExecuteQuery(q)
# people_involved
q = "SELECT count(distinct(pup.upeople_id)) as changers_"+days+" "+\
"FROM changes, people_upeople pup "+\
"WHERE pup.people_id = changes.changed_by and "+\
"changed_on >= ( "+\
" select (max(changed_on) - INTERVAL "+days+" day) "+\
" from changes)"
data4 = ExecuteQuery(q)
agg_data = dict(data1.items() + data2.items())
agg_data = dict(agg_data.items() + data3.items())
return (agg_data)
def lastActivityMediaWiki(init_date, days):
#commits
days = str(days)
q = "select count(wiki_pages_revs.id) as reviews_"+days+" "+\
"from wiki_pages_revs "+\
"where date >= ("+ init_date+ " - INTERVAL "+days+" day)"
data1 = ExecuteQuery(q)
q = "select count(distinct(pup.upeople_id)) as authors_"+days+" "+\
"from wiki_pages_revs, people_upeople pup "+\
"where pup.people_id = user and "+\
" date >= ("+ init_date+ " - INTERVAL "+days+" day)"
data2 = ExecuteQuery(q)
agg_data = dict(data1.items() + data2.items())
return (agg_data)
def lastActivityMediaWiki (init_date, days) :
#commits
days = str(days)
q = "select count(wiki_pages_revs.id) as reviews_"+days+" "+\
"from wiki_pages_revs "+\
"where date >= ("+ init_date+ " - INTERVAL "+days+" day)"
data1 = ExecuteQuery(q)
q = "select count(distinct(pup.upeople_id)) as authors_"+days+" "+\
"from wiki_pages_revs, people_upeople pup "+\
"where pup.people_id = user and "+\
" date >= ("+ init_date+ " - INTERVAL "+days+" day)"
data2 = ExecuteQuery(q)
agg_data = dict(data1.items() + data2.items())
return(agg_data)
def lastActivity (days) :
days = str(days)
#commits
q = "select count(distinct(message_ID)) as sent_"+days+" "+\
" from messages "+\
" where first_date >= ( "+\
" select (max(first_date) - INTERVAL "+days+" day) "+\
" from messages)"
data1 = ExecuteQuery(q)
q = "select count(distinct(pup.upeople_id)) as senders_"+days+" "+\
" from messages m, "+\
" people_upeople pup, "+\
" messages_people mp "+\
" where pup.people_id = mp.email_address and "+\
" m.message_ID = mp.message_id and "+\
" m.first_date >= (select (max(first_date) - INTERVAL "+days+" day) "+\
" from messages)"
data2 = ExecuteQuery(q)
agg_data = dict(data1.items() + data2.items())
return(agg_data)
def lastActivity(days):
days = str(days)
#commits
q = "select count(distinct(message_ID)) as sent_"+days+" "+\
" from messages "+\
" where first_date >= ( "+\
" select (max(first_date) - INTERVAL "+days+" day) "+\
" from messages)"
data1 = ExecuteQuery(q)
q = "select count(distinct(pup.upeople_id)) as senders_"+days+" "+\
" from messages m, "+\
" people_upeople pup, "+\
" messages_people mp "+\
" where pup.people_id = mp.email_address and "+\
" m.message_ID = mp.message_id and "+\
" m.first_date >= (select (max(first_date) - INTERVAL "+days+" day) "+\
" from messages)"
data2 = ExecuteQuery(q)
agg_data = dict(data1.items() + data2.items())
return (agg_data)
