I am trying to fill up a field in a table database with contents of a text
file, but get None as the response when I run the code. Any assistance will
be appreciated. Here is my code:
# view function - routes.py
.......
@app.route('/add_vlans', methods = ['GET', 'POST'])
@login_required
def add_vlans():
form = AddVlanForm(current_user.routername)
if form.validate_on_submit():
with open("show_vlans", "r") as vlans:
vlan_output = vlans.read()
rt = Router(raw_vlans=vlan_output) #raw_vlans - field variable
name
db.session.add(rt)
db.session.commit()
return render_template('_show_vlans.html', title='Router Vlans')
#forms.py
class AddVlanForm(FlaskForm):
raw_vlans = TextAreaField('Router vlan output:',
validators=[Length(min=0, max=140)])
submit = SubmitField('Get Vlans on Router')
#templates - router.html
{% extends "base.html" %}
{% block content %}
<h1>Router: {{ router.routername }}</h1>
{% if router.about_router %} <p>About router: {{ router.about_router
}}</p> {% endif %}
Vlans on {{ router.routername }}<br>
{% for vlan in vlans %}
<ul>
<li>{% include '_vlan.html' %}</li>
</ul>
{% endfor %}
{% if router == current_user %}
<p> <a href="{{ url_for('edit_router') }}"> Edit Router </a> </p>
{% endif %}
<h1> Vlan Configurations </h1>
<a href="{{ url_for('add_vlans') }}"> Show Router Vlans </a>
<p> {% include '_show_vlans.html' %} </p>
{% endblock %}
#sub-template - _show_vlans.html
<table>
<tr>
<td>Vlans on router {{ current_user.routername }}:
<pre>{{ current_user.raw_vlans }}</pre>
</td>
</tr>
</table>
I get the response:
Vlans on router router20: None
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/e583f6d0-72f6-44dd-8898-f7234ca442b1n%40googlegroups.com.
