def attackCountTime():
startTime = request.form.get('startTime', None)
endTime = request.form.get('endTime', None)
if startTime is None or endTime is None:
return jsonify(AttackCount.selectAllAttackCount())
else:
return jsonify(AttackCount.selectAllAttackCountTime(
startTime, endTime))
def selectSourceAndCount():
attack = Attack.query.with_entities(Attack.source, func.count(Attack.id).label('count')).group_by(Attack.source)\
.order_by(desc('count')).limit(5)
source = []
count = []
if AttackCount.selectSevenDayCnt() == 0:
return []
else:
for i in attack:
source.append(i.source)
count.append(int(i.count) / AttackCount.selectSevenDayCnt())
return [source, count]
def AttackSituationAssessmentStatistics():
startTime = request.form.get('startTime', None)
endTime = request.form.get('endTime', None)
print(startTime, endTime)
if startTime is None or endTime is None:
return jsonify([])
else:
return jsonify(
AttackCount.AttackSituationAssessmentStatistics(
startTime, endTime))
def selectSevenDayIpCount():
end_date = datetime.datetime.now()
begin_date = end_date - datetime.timedelta(days=7)
attack = Attack.query.with_entities(Attack.ip, func.count(Attack.id).label("count")).filter(
and_(Attack.time >= begin_date, Attack.time <= end_date, Attack.attackType.notin_(['normal', 'anomalous'])))\
.group_by(Attack.ip).order_by(desc("count")).limit(5)
if attack.count is None:
return []
else:
ip = list()
count = list()
for i in attack:
ip.append(i.ip)
if AttackCount.selectSevenDayAttackCnt() != 0:
count.append(
int(i.count) / AttackCount.selectSevenDayAttackCnt())
else:
count.append(0)
return [ip, count]
def HistoricalAssessmentTrendStatistics():
return jsonify(AttackCount.HistoricalAssessmentTrendStatistics())
def visitCount():
return jsonify(AttackCount.selectOneDayCnt())
def weekdayCount():
return jsonify(AttackCount.weekdayCount())
def attackCountAna():
objects_list = AttackCount.selectAllAttackCount()
return jsonify(objects_list)
def attackCountTable():
objects_list = AttackCount.selectSevenDayAttackType()
return jsonify(objects_list)
def visitcount():
list_cnt = AttackCount.selectOneDayCnt()
list_cnt[0] = list_cnt[0] + list_cnt[1] + list_cnt[2]
return jsonify(list_cnt)
def visitcountchart():
return jsonify(AttackCount.selectLatestThreeMonth())
def radarchart():
objects_list = AttackCount.selectTimeCount()
detectionWarning()
return jsonify(objects_list)