Flask with SQLAlchemy Basics > Connecting To A Database with SQLAlchemy > Working with A Plant Database

Question

Bummer: Make sure your new_plant variable is inside of the form function's if statement.

Not sure what I'm getting wrong..

app.py

from models import db, Plant, app
from flask import render_template, url_for, request, redirect


@app.route('/')
def index():
    return render_template('index.html')


@app.route('/form', methods=['GET', 'POST'])
def form():
    if request.form:
        new_plant = Plant(type=request.form['type'],
                          status=request.form['status'])        
        db.add(new_plant)
        db.commit()

        return redirect(url_for('index'))
    return render_template('form.html')


if __name__ == '__main__':
    app.run(host='0.0.0.0', port=8000)

models.py

from flask import Flask
from flask_sqlalchemy import SQLAlchemy


app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///plants.db'
db = SQLAlchemy(app)

class Plant(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    plant_type = db.Column(db.String())
    plant_status = db.Column(db.String())

form.html

{% extends 'layout.html' %}

{% block content %}
    <form action="{{ url_form('form') }}" method="POST">
        <label for="type">Plant Type:</label>
        <input type="text" name="type" id="type" placeholder="Plant type">

        <p>Plant Status:</p>
        <label for="good">GOOD</label>
        <input type="radio" name="status" id="good">
        <label for="ok">OK</label>
        <input type="radio" name="status" id="ok">
        <label for="bad">BAD</label>
        <input type="radio" name="status" id="bad">
    </form>
{% endblock %}

index.html

{% extends 'layout.html' %}

{% block content %}
    <h1>Our Plants:</h1>
    <div>
        <h2>Plant Type</h2>
        <p>Plant Status</p>
    </div>
{% endblock %}

Answer 1 · 2021-08-14T22:00:32Z

August 14, 2021 10:00pm

class Plant(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    plant_type = db.Column(db.String())
    plant_status = db.Column(db.String())

When you create a new plant, it should have plant_type rather than type and plant_status rather than status.

Welcome to the Treehouse Community

Looking to learn something new?

Trenton Spears

Trenton Spears

Flask with SQLAlchemy Basics > Connecting To A Database with SQLAlchemy > Working with A Plant Database

1 Answer

jb30

jb30

Trenton Spears

Trenton Spears