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")