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)