本文整理汇总了Python中vizgrimoire.data_source.DataSource.get_filter_bots方法的典型用法代码示例。如果您正苦于以下问题:Python DataSource.get_filter_bots方法的具体用法?Python DataSource.get_filter_bots怎么用?Python DataSource.get_filter_bots使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类vizgrimoire.data_source.DataSource
的用法示例。
在下文中一共展示了DataSource.get_filter_bots方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: get_list
# 需要导入模块: from vizgrimoire.data_source import DataSource [as 别名]
# 或者: from vizgrimoire.data_source.DataSource import get_filter_bots [as 别名]
def get_list(self):
from vizgrimoire.data_source import DataSource
from vizgrimoire.filter import Filter
startdate = self.filters.startdate
enddate = self.filters.enddate
closed_condition = ITS._get_closed_condition()
if self.filters.closed_condition is not None:
closed_condition = self.filters.closed_condition
bots = DataSource.get_filter_bots(Filter("domain"))
fbots = ''
for bot in bots:
fbots += " dom.name<>'"+bot+"' and "
tables = Set([])
filters = Set([])
tables.union_update(self.db.GetTablesDomains(self.db.identities_db))
tables.add(self.db.identities_db + ".domains dom")
tables_str = self.db._get_tables_query(tables)
filters.union_update(self.db.GetFiltersDomains())
filters_str = self.db._get_filters_query(filters)
q = "SELECT dom.name "+\
"FROM "+ tables_str + " "+\
"WHERE " + filters_str +" AND "+\
" dom.id = upd.domain_id and "+\
" "+ fbots +" "+\
" c.changed_on >= "+ startdate+ " AND "+\
" c.changed_on < "+ enddate+ " AND "+\
" "+ closed_condition+" "+\
"GROUP BY dom.name "+\
"ORDER BY COUNT(DISTINCT(c.issue_id)) DESC LIMIT " + str(Metrics.domains_limit)
data = self.db.ExecuteQuery(q)
return (data)
示例2: get_list
# 需要导入模块: from vizgrimoire.data_source import DataSource [as 别名]
# 或者: from vizgrimoire.data_source.DataSource import get_filter_bots [as 别名]
def get_list (self):
filter_ = DataSource.get_filter_bots(Filter("country"))
filter_countries = ''
for country in filter_:
filter_countries += " cou.name<>'"+country+"' AND "
countries_tables = self.db._get_tables_query(self.db.GetTablesCountries())
countries_filters = self.db._get_filters_query(self.db.GetFiltersCountries())
q = "SELECT cou.name as name, COUNT(m.message_ID) as sent "+\
"FROM "+ countries_tables + " "+\
"WHERE "+ countries_filters + " AND "+\
" "+ filter_countries+ " "+\
" m.first_date >= "+self.filters.startdate+" AND "+\
" m.first_date < "+self.filters.enddate+" "+\
"GROUP BY cou.name "+\
"ORDER BY COUNT((m.message_ID)) DESC, cou.name "
data = self.db.ExecuteQuery(q)
return(data['name'])
示例3: get_list
# 需要导入模块: from vizgrimoire.data_source import DataSource [as 别名]
# 或者: from vizgrimoire.data_source.DataSource import get_filter_bots [as 别名]
def get_list (self) :
filter_ = DataSource.get_filter_bots(Filter("domain"))
filter_domains = ""
for domain in filter_:
filter_domains += " d.name<>'"+ domain + "' AND "
domains_tables = self.db._get_tables_query(self.db.GetTablesDomains())
domains_filters = self.db._get_filters_query(self.db.GetFiltersDomains())
q = "SELECT d.name as name, COUNT(DISTINCT(m.message_ID)) as sent "+\
" FROM "+ domains_tables + " "+\
" WHERE "+ domains_filters + " AND "+\
" "+ filter_domains+ " "+\
" m.first_date >= "+self.filters.startdate+" AND "+\
" m.first_date < "+self.filters.enddate+\
" GROUP BY d.name "+\
" ORDER BY COUNT(DISTINCT(m.message_ID)) DESC, d.name LIMIT " + str(Metrics.domains_limit)
data = self.db.ExecuteQuery(q)
return (data['name'])