本文整理汇总了Python中vizgrimoire.ITS.ITS.get_query_builder方法的典型用法代码示例。如果您正苦于以下问题:Python ITS.get_query_builder方法的具体用法?Python ITS.get_query_builder怎么用?Python ITS.get_query_builder使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类vizgrimoire.ITS.ITS
的用法示例。
在下文中一共展示了ITS.get_query_builder方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: result
# 需要导入模块: from vizgrimoire.ITS import ITS [as 别名]
# 或者: from vizgrimoire.ITS.ITS import get_query_builder [as 别名]
def result(self, data_source = None, destdir = None):
if data_source != SCM or destdir is None: return None
automator = Report.get_config()
db_identities = automator["generic"]["db_identities"]
dbuser = automator["generic"]["db_user"]
dbpass = automator["generic"]["db_password"]
start_date = automator['r']['start_date']
if 'end_date' not in automator['r']:
end_date = time.strftime('%Y-%m-%d')
else:
end_date = automator['r']['end_date']
start_year = int(start_date.split("-")[0])
end_year = int(end_date.split("-")[0])
activity = {}
activity['name'] = []
# Commits
data = self.db.ExecuteQuery(self.get_sql_commits())
activity = self.add_organizations_data (activity, data)
self.add_metric_years("commits", activity, start_year, end_year)
# Authors
data = self.db.ExecuteQuery(self.get_sql_authors())
activity = self.add_organizations_data (activity, data)
self.add_metric_years("authors", activity, start_year, end_year)
# Committers
data = self.db.ExecuteQuery(self.get_sql_committers())
activity = self.add_organizations_data (activity, data)
self.add_metric_years("committers", activity, start_year, end_year)
# Committers active: only valid for today
data = self.db.ExecuteQuery(self.get_sql_committers(None, True))
data = self._convert_dict_field(data, "committers_active","committers-active")
activity = self.add_organizations_data (activity, data)
# Committers inactive: only valid for today
activity['committers-inactive'] = \
[ activity['committers'][i] - activity['committers-active'][i] \
for i in range(0, len(activity['committers']))]
activity['committers-percent-active'] = []
for i in range(0, len(activity['committers'])):
if activity['committers'][i] == 0:
activity['committers-percent-active'].append(100)
else:
activity['committers-percent-active'].append(\
(activity['committers-active'][i]*100) / activity['committers'][i])
# Actions
data = self.db.ExecuteQuery(self.get_sql_actions())
activity = self.add_organizations_data (activity, data)
self.add_metric_years("actions", activity, start_year, end_year)
# Source lines of code added
data = self.db.ExecuteQuery(self.get_sql_lines_added())
data = self._convert_dict_field(data, "lines_added", "lines-added")
activity = self.add_organizations_data (activity, data)
self.add_metric_years("lines-added", activity, start_year, end_year)
# Source lines of code removed
data = self.db.ExecuteQuery(self.get_sql_lines_removed())
data = self._convert_dict_field(data, "lines_removed","lines-removed")
activity = self.add_organizations_data (activity, data)
self.add_metric_years("lines-removed", activity, start_year, end_year)
# Source lines of code total (added+removed)
data = self.db.ExecuteQuery(self.get_sql_lines_total())
data = self._convert_dict_field(data, "lines_total","lines-total")
activity = self.add_organizations_data (activity, data)
self.add_metric_years("lines-total", activity, start_year, end_year)
# Lines per commit
self.add_metric_lines_commit(activity, start_year, end_year)
# We need to change the db to tickets
dbname = automator["generic"]["db_bicho"]
dsquery = ITS.get_query_builder()
dbcon = dsquery(dbuser, dbpass, dbname, db_identities)
self.db = dbcon
# Tickets opened
data = self.db.ExecuteQuery(self.get_sql_opened())
activity = self.add_organizations_data (activity, data)
self.add_metric_years("opened", activity, start_year, end_year)
# Tickets closed
data = self.db.ExecuteQuery(self.get_sql_closed())
activity = self.add_organizations_data (activity, data)
self.add_metric_years("closed", activity, start_year, end_year)
# Messages sent
dbname = automator["generic"]["db_mlstats"]
dsquery = MLS.get_query_builder()
dbcon = dsquery(dbuser, dbpass, dbname, db_identities)
self.db = dbcon
data = self.db.ExecuteQuery(self.get_sql_sent())
activity = self.add_organizations_data (activity, data)
self.add_metric_years("sent", activity, start_year, end_year)
createJSON(activity, destdir+"/organizations-activity.json")
logging.info(destdir+"/organizations-activity.json created")