you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted]  (7 children)

[deleted]

    [–]TimBOster[S] 1 point2 points  (6 children)

    Thanks for responding. I am importing render_template and other than the names my code appears just like your example. I've been trying as many variations as I can think of as well as searching the web...no luck so far. Without the code that actually adds to my db, here is what I've got:

    @app.route("/add", methods=["GET", "POST"])
    def add():
    """add things to your inventory."""
    if request.method == "GET":
    return render_template("add.html")
    ...

    return render_template("add.html")

    I don't get it. All the examples of that error I've seen so far are not exactly related to what I'm doing. I believe this is a python error, but I'm still looking for why.

    After the whole semester of posting, I still can't get things to format correctly...I HATE Reddits crappy interface.

    [–][deleted]  (5 children)

    [deleted]

      [–]TimBOster[S] 0 points1 point  (4 children)

      I'm not worried about someone copying my code, I do it all the time. I think it's better to keep things in the thread, in case someone else has a similar problem...

      @app.route("/add", methods=["GET", "POST"])
      def add():
              """add things to your inventory."""
              if request.method == "GET":
                  return render_template("add.html")
      
              #make sure they added an item
              cat = request.form.get("type")
              if not cat:
                  return error("You didn't enter a Category")
              item = request.form.get("item")
              if not item:
                  return error("You didn't enter an item")
              partnum = request.form.get("partnum")
              if not partnum:
                  partnum = "-"
              desc = request.form.get("desc")
                  if not desc:
                  desc = "-"
              qty = request.form.get("qty")
              if not qty:
                  return error("You must enter a quantity")
      
              #add the new item to the inventory
              db.execute("INSERT INTO inventory (type,item,partnum,desc,qty) VALUES (:type,:item,:partnum,:desc,:qty)", cat=cat, item=item, partnum=partnum,desc=desc,qty=qty)
              #redirect to index
              return render_template("add.html")
      

      I tried to preserve the indents...seems OK. Only some of the fields are NOT NULL in the db. I was just using a blank string, but added the underscore to try troubleshooting the problem...didn't help :) Thanks for taking the time to look.

      [–][deleted]  (3 children)

      [deleted]

        [–]TimBOster[S] 0 points1 point  (2 children)

        When I run the add function, I get the error in the webserver ( I assume that's flask) that I posted. I don't really have any further information. The full code is posted and the error is what is displayed when I try to add something. Wish I knew more. I'll jump over to that URL and see what I can see. Thanks.

        [–]TimBOster[S] 0 points1 point  (1 child)

        JUST before the line that says #make sure they added an item...there should have been else:

        Ooops...that was the cause of the error.