Accessing sqlite3 db tables and contents

The version shouldn't matter, so you could reconstruct your DB in a Treehouse workspace, and then you can share a snapshot of your workspace to allow us to replicate your issue.

I'm using VSCode, below are the relevant scripts to the DB construction. (Sorry couldn't get the markdown to properly work with the code)

models.py:

from flask import Flask from flask_sqlalchemy import SQLAlchemy import datetime

app = Flask(name) app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite:///pets.db" db = SQLAlchemy(app)

class Pet(db.Model): id = db.Column(db.Integer, primary_key=True) created = db.Column("Created", db.DateTime, default=datetime.datetime.now) # this is not datetime.datetime.now() due to the () means it called when the file is run and never called again name = db.Column("Name", db.String()) age = db.Column("Age", db.String()) breed = db.Column("Breed", db.String()) color = db.Column("Color", db.String()) size = db.Column("Size", db.String()) weight = db.Column("Weight", db.String()) url = db.Column("URL", db.String()) url_tag = db.Column("Alt Tag", db.String()) pet_type = db.Column("Pet Type", db.String()) gender = db.Column("Gender", db.String()) spay = db.Column("Spay", db.String()) house_trained = db.Column("House Trained", db.String()) description = db.Column("Description", db.Text())

def __repr__(self):
    return f"""<Pet (Name: {self.name})
            Age: {self.age}
            Breed: {self.breed}
            Color: {self.color}
            Size: {self.size}
            Weight: {self.weight}
            URL: {self.url}
            Tag: {self.url_tag}
            Gender: {self.gender}
            Spay: {self.spay}
            House Trained: {self.house_trained}
            Description: {self.description}
            """

app.py:

from flask import (render_template, url_for, request, redirect) from models import db, Pet, app

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

@app.route("/add-pet", methods=["GET", "POST"]) def add_pet(): if request.form: print(request.form) print(request.form["name"]) new_pet = Pet(name=request.form["name"], age=request.form["age"], breed=request.form["breed"], color=request.form["color"], size=request.form["size"], weight=request.form["weight"], url=request.form["url"], url_tag=request.form["alt"], pet_type=request.form["pet"], gender=request.form["gender"], spay=request.form["spay"], house_trained=request.form["housetrained"], description=request.form["description"] ) db.session.add(new_pet) db.session.commit() return redirect(url_for("index")) return render_template("addpet.html")

@app.route("/pet") def pet(): return render_template("pet.html")

if name == "main": db.create_all()

app.run(debug=True, port=8000, host="127.0.0.1")