subnet add

subnet_add.py

# Works...
@app.route('/subnets/add', methods=['GET', 'POST'])
def subnets_add():
    form = subnet.SubnetFormv2()
    data = helpers.top_ten()

    if form.validate_on_submit():
        form.populate_obj(Subnet)
        dbo.session.commit()

        flash("Added subnet {}".format(form.subnet.data), category='success')

        return redirect('/subnets')

    return render_template('subnets_add.html', data=data, form=form)
    
# Results in stack trace...
@app.route('/subnets')
def subnets_list():
    lists = {
        'active': Subnet.query.filter_by(isactive=True).order_by(dbo.desc(Subnet.id)),
        'inactive': Subnet.query.filter_by(isactive=False).order_by(dbo.desc(Subnet.id)),
    }

    return render_template('subnets_list.html', subnets=lists)
    
# Traceback (most recent call last):
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
#     return self.wsgi_app(environ, start_response)
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
#     response = self.make_response(self.handle_exception(e))
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask_restful/__init__.py", line 258, in error_router
#     return original_handler(e)
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask/app.py", line 1403, in handle_exception
#     reraise(exc_type, exc_value, tb)
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
#     response = self.full_dispatch_request()
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
#     rv = self.handle_user_exception(e)
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask_restful/__init__.py", line 258, in error_router
#     return original_handler(e)
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
#     reraise(exc_type, exc_value, tb)
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
#     rv = self.dispatch_request()
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
#     return self.view_functions[rule.endpoint](**req.view_args)
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/vsvlandb/web_endpoints.py", line 117, in subnets_list
#     'active': Subnet.query.filter_by(isactive=True).order_by(dbo.desc(Subnet.id)),
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 1266, in filter_by
#     return self.filter(sql.and_(*clauses))
#   File "<string>", line 2, in and_
    
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 1531, in and_
#     return cls._construct(operators.and_, True_, False_, *clauses)
#   File "/home/mcrilly/Documents/Git/vs-vlan-db/venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 1509, in _construct
#     return clauses[0].self_group(against=operators._asbool)
# AttributeError: 'bool' object has no attribute 'self_group'