Completed
Push — master ( 638968...b26d9e )
by -
01:31
created

sandbox()   C

Complexity

Conditions 8

Size

Total Lines 20

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 11
CRAP Score 9.953
Metric Value
cc 8
dl 0
loc 20
ccs 11
cts 16
cp 0.6875
crap 9.953
rs 6.6666
1 1
import logging
2 1
import re
3 1
import string
4
5 1
from time import time
6 1
from flask import Blueprint, render_template, request, redirect, flash, Response
7 1
from sqlalchemy.exc import SQLAlchemyError
0 ignored issues
show
Configuration introduced by
The import sqlalchemy.exc could not be resolved.

This can be caused by one of the following:

1. Missing Dependencies

This error could indicate a configuration issue of Pylint. Make sure that your libraries are available by adding the necessary commands.

# .scrutinizer.yml
before_commands:
    - sudo pip install abc # Python2
    - sudo pip3 install abc # Python3
Tip: We are currently not using virtualenv to run pylint, when installing your modules make sure to use the command for the correct version.

2. Missing __init__.py files

This error could also result from missing __init__.py files in your module folders. Make sure that you place one file in each sub-folder.

Loading history...
8
9 1
from spike.model import db
10 1
from spike.model.naxsi_rules import NaxsiRules
11 1
from spike.model.naxsi_rulesets import NaxsiRuleSets
12 1
from spike.model import naxsi_mz, naxsi_score
13
14 1
rules = Blueprint('rules', __name__)
15
16
17 1
@rules.route("/")
18
def index():
19 1
    _rules = NaxsiRules.query.order_by(NaxsiRules.sid.desc()).all()
0 ignored issues
show
Bug introduced by
The Class NaxsiRules does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
20 1
    if not _rules:
21
        flash("no rules found, please create one", "success")
22
        return redirect("/rules/new")
23 1
    return render_template("rules/index.html", rules=_rules)
24
25
26 1
@rules.route("/plain/<int:sid>", methods=["GET"])
27
def plain(sid):
28 1
    _rule = NaxsiRules.query.filter(NaxsiRules.sid == sid).first()
0 ignored issues
show
Bug introduced by
The Class NaxsiRules does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
29 1
    if not _rule:
30
        flash("no rules found, please create one", "error")
31
        return redirect("/rules/new")
32
33 1
    return Response(_rule.fullstr(), mimetype='text/plain')
34
35
36 1
@rules.route("/view/<int:sid>", methods=["GET"])
37
def view(sid):
38 1
    _rule = NaxsiRules.query.filter(NaxsiRules.sid == sid).first()
0 ignored issues
show
Bug introduced by
The Class NaxsiRules does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
39 1
    if _rule is None:
40 1
        flash("no rules found, please create one", "error")
41 1
        return redirect("/rules/")
42
43 1
    return render_template("rules/view.html", rule=_rule, rtext=_rule)
44
45
46 1
@rules.route("/search/", methods=["GET"])
47
def search():
48 1
    terms = request.args.get('s', '')
49
50 1
    if len(terms) < 2:
51 1
        return redirect('/rules')
52
53
    # No fancy injections
54 1
    whitelist = set(string.ascii_letters + string.digits + ':-_ ')
55 1
    filtered = ''.join(filter(whitelist.__contains__, terms))
56
57 1
    if filtered.isdigit():  # get rule by id
58 1
        _rules = db.session.query(NaxsiRules).filter(NaxsiRules.sid == int(filtered)).all()
59
    else:
60 1
        expression = '%' + filtered + '%'
61 1
        _rules = db.session.query(NaxsiRules).filter(
62
            db.or_(
63
                NaxsiRules.msg.like(expression),
64
                NaxsiRules.rmks.like(expression),
65
                NaxsiRules.detection.like(expression)
66
            )
67
        ).order_by(NaxsiRules.sid.desc()).all()
68 1
    return render_template("rules/index.html", rules=_rules, selection="Search: %s" % filtered, lsearch=terms)
69
70
71 1
@rules.route("/new", methods=["GET", "POST"])
72
def new():
73 1
    latest_sid = NaxsiRules.query.order_by(NaxsiRules.sid.desc()).first()
0 ignored issues
show
Bug introduced by
The Class NaxsiRules does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
74 1
    if latest_sid is None:
75
        sid = 200001
76
    else:
77 1
        sid = latest_sid.sid + 1
78
79 1
    if request.method == "GET":
80 1
        _rulesets = NaxsiRuleSets.query.all()
0 ignored issues
show
Bug introduced by
The Class NaxsiRuleSets does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
81 1
        return render_template("rules/new.html", mz=naxsi_mz, rulesets=_rulesets, score=naxsi_score, latestn=sid)
82
83
    # create new rule
84 1
    logging.debug('Posted new request: %s', request.form)
85 1
    mz = "|".join(filter(len, request.form.getlist("mz") + request.form.getlist("custom_mz_val")))
86
87 1
    score = request.form.get("score", "")
88 1
    score += ':'
89 1
    score += request.form.get("score_%s" % request.form.get("score", ""), "")
90
91 1
    nrule = NaxsiRules(request.form.get("msg", ""), request.form.get("detection", ""), mz, score, sid,
92
                       request.form.get("ruleset", ""), request.form.get("rmks", ""), "1",
93
                       request.form.get("negative", ""), int(time()))
94
95 1
    nrule.validate()
96
97 1
    if nrule.error:
98 1
        flash("ERROR: {0}".format(",".join(nrule.error)))
99 1
        return redirect("/rules/new")
100 1
    elif nrule.warnings:
101 1
        flash("WARNINGS: {0}".format(",".join(nrule.warnings)))
102 1
    db.session.add(nrule)
103
104 1
    try:
105 1
        db.session.commit()
106 1
        flash("OK: created %s : %s" % (sid, request.form.get("msg", "")), "success")
107 1
        return redirect("/rules/edit/%s" % sid)
108
    except SQLAlchemyError:
109
        flash("ERROR while trying to create %s : %s" % (sid, request.form.get("msg", "")), "error")
110
111
    return redirect("/rules/new")
112
113
114 1
@rules.route("/edit/<int:sid>", methods=["GET", "POST"])
115
def edit(sid):
116 1
    rinfo = NaxsiRules.query.filter(NaxsiRules.sid == sid).first()
0 ignored issues
show
Bug introduced by
The Class NaxsiRules does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
117 1
    if not rinfo:
118 1
        return redirect("/rules/")
119
120 1
    _rulesets = NaxsiRuleSets.query.all()
0 ignored issues
show
Bug introduced by
The Class NaxsiRuleSets does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
121 1
    rruleset = NaxsiRuleSets.query.filter(NaxsiRuleSets.name == rinfo.ruleset).first()
0 ignored issues
show
Bug introduced by
The Class NaxsiRuleSets does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
122 1
    custom_mz = ""
123 1
    mz_check = rinfo.mz
124 1
    if re.search(r"^\$[A-Z]+:(.*)\|[A-Z]+", mz_check):
125
        custom_mz = mz_check
126
        rinfo.mz = "custom"
127 1
    return render_template("rules/edit.html", mz=naxsi_mz, rulesets=_rulesets, score=naxsi_score, rules_info=rinfo,
128
                           rule_ruleset=rruleset, custom_mz=custom_mz)
129
130
131 1
@rules.route("/save/<int:sid>", methods=["POST"])
132
def save(sid):
133 1
    mz = "|".join(filter(len, request.form.getlist("mz") + request.form.getlist("custom_mz_val")))
134 1
    score = "{}:{}".format(request.form.get("score", ""), request.form.get("score_%s" % request.form.get("score", "")))
135 1
    nrule = NaxsiRules.query.filter(NaxsiRules.sid == sid).first()
0 ignored issues
show
Bug introduced by
The Class NaxsiRules does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
136 1
    nrule.msg = request.form.get("msg", "")
137 1
    nrule.detection = request.form.get("detection", "")
138 1
    nrule.mz = mz
139 1
    nrule.score = score
140 1
    nrule.ruleset = request.form.get("ruleset", "")
141 1
    nrule.rmks = request.form.get("rmks", "")
142 1
    nrule.active = request.form.get("active", "")
143 1
    nrule.negative = request.form.get("negative", "")
144 1
    nrule.timestamp = int(time())
145 1
    nrule.validate()
146
147 1
    if nrule.error:
148 1
        flash("ERROR: {0}".format(",".join(nrule.error)))
149 1
        logging.debug("ERROR: {0}".format(",".join(nrule.error)))
150 1
        return redirect("/rules/edit/%s" % sid)
151 1
    elif nrule.warnings:
152 1
        flash("WARNINGS: {0}".format(",".join(nrule.warnings)))
153 1
        logging.debug("WARNINGS: {0}".format(",".join(nrule.warnings)))
154
155 1
    db.session.add(nrule)
156 1
    try:
157 1
        db.session.commit()
158
    except SQLAlchemyError:
159
        flash("ERROR while trying to update %s : %s" % (sid, nrule.error), "error")
160 1
    return redirect("/rules/edit/%s" % sid)
161
162
163 1
@rules.route("/del/<int:sid>", methods=["GET"])
164 1
def del_sid(sid=''):
165 1
    nrule = NaxsiRules.query.filter(NaxsiRules.sid == sid).first()
0 ignored issues
show
Bug introduced by
The Class NaxsiRules does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
166 1
    if not nrule:
167
        return redirect("/rules/")
168
169 1
    db.session.delete(nrule)
170 1
    try:
171 1
        db.session.commit()
172 1
        flash("OK: deleted %s : %s" % (sid, nrule.msg), "success")
173
    except SQLAlchemyError:
174
        flash("ERROR while trying to update %s : %s" % (sid, nrule.msg), "error")
175
176 1
    return redirect("/rules/")
177
178
179 1
@rules.route("/deact/<int:sid>", methods=["GET"])
180
def deact(sid):
181 1
    nrule = NaxsiRules.query.filter(NaxsiRules.sid == sid).first()
0 ignored issues
show
Bug introduced by
The Class NaxsiRules does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
182 1
    if nrule is None:
183 1
        return redirect("/rules/")
184
185 1
    fm = 'deactivate' if nrule.active else 'reactivate'
186 1
    nrule.active = not nrule.active
187
188 1
    db.session.add(nrule)
189 1
    try:
190 1
        db.session.commit()
191 1
        flash("OK: %s %sd : %s" % (fm, sid, nrule.msg), "success")
192
    except SQLAlchemyError:
193
        flash("ERROR while trying to %s %s : %s" % (fm, sid, nrule.msg), "error")
194
195 1
    _rulesets = NaxsiRuleSets.query.all()
0 ignored issues
show
Bug introduced by
The Class NaxsiRuleSets does not seem to have a member named query.

This check looks for calls to members that are non-existent. These calls will fail.

The member could have been renamed or removed.

Loading history...
196
    return render_template("rules/edit.html", mz=naxsi_mz, rulesets=_rulesets, score=naxsi_score, rules_info=nrule)
197