def language_breakdown(self, user_name):
sql = Reader()
return sql.run_query("SELECT login, language, SUM(bytes) as sum \
FROM pie_chart_data \
WHERE login = '******' \
GROUP BY login, language \
ORDER BY (sum) desc \
LIMIT 6")
def bytes(self, user_name):
sql = Reader()
return sql.run_query("SELECT row_number \
FROM projects_sum a \
INNER JOIN ( \
SELECT Login, ROW_NUMBER() OVER (ORDER BY sum)\
FROM projects_sum \
) b ON a.Login = b.Login \
where a.login = '******' ")
def commits(self, user_name):
sql = Reader()
return sql.run_query("SELECT row_number \
FROM commits_users_data a \
INNER JOIN ( \
SELECT Login, ROW_NUMBER() OVER (ORDER BY count_of_commits)\
FROM commits_users_data \
) b ON a.Login = b.Login \
where a.login = '******' ")
def languages(self, language):
sql = Reader()
return sql.run_query(" select avg(b.sum) as avg \
FROM ( \
SELECT DISTINCT login, language, Sum(bytes) as sum \
FROM pie_chart_data \
where language = '" + language + "' \
group by login, language \
order by sum asc \
) b ")
def projects_breakdown_1(self, user_name):
sql = Reader()
return sql.run_query(
"SELECT a.project_name, a.description, a.language, a.bytes as sum \
FROM pie_chart_data a \
INNER JOIN ( \
SELECT project_name, max(bytes) as sum \
FROM pie_chart_data \
WHERE login = '******' \
GROUP BY project_name \
) b ON a.project_name = b.project_name AND a.bytes = b.sum \
ORDER BY a.bytes desc \
LIMIT 6")
def total_commits(self, user_name):
sql = Reader()
return sql.run_query("SELECT count(*) as count \
FROM commits_users_data")
def user_language(self, user_name, language):
sql = Reader()
return sql.run_query(" select sum(bytes) as sum \
from pie_chart_data \
where login = '******' and language = '" + language + "' ")
def run_custom_query(self, query):
sql = Reader()
return sql.run_query(query)
def total_bytes(self, user_name):
sql = Reader()
return sql.run_query("SELECT count(*) as count \
FROM projects_sum")