```main.py from crypt import methods from turtle import title #db 追加 from flaskr import app, db from flask import render_template, request, redirect, url_for from flaskr.db import DATABASE import sqlite3 DATABASE = "database.db" @app.route('/') def index(): con = sqlite3.connect(DATABASE) db_books = con.execute("SELECT * FROM books").fetchall() con.close books = [] for row in db_books: books.append({"title": row[0], "price": row[1], "arrival_day": row[2]}) return render_template( 'index.html',books=books ) @app.route("/form") def form(): return render_template("form.html") @app.route("/register", methods=["POST"]) def register(): title = request.form["title"] price = request.form["price"] arrival_day =request.form["arrival_day"] con = sqlite3.connect(DATABASE) con.execute('INSERT INTO books VALUES(?,?,?)',[title,price,arrival_day]) con.commit() con.close() return redirect(url_for("index")) ``` 以上のコードに削除機能を追加したく質問させて頂きました。 ```main.py from crypt import methods from turtle import title #db 追加 from flaskr import app, db from flask import render_template, request, redirect, url_for from flaskr.db import DATABASE import sqlite3 DATABASE = "database.db" @app.route('/') def index(): con = sqlite3.connect(DATABASE) db_books = con.execute("SELECT * FROM books").fetchall() con.close books = [] for row in db_books: books.append({"title": row[0], "price": row[1], "arrival_day": row[2]}) return render_template( 'index.html',books=books ) @app.route("/form") def form(): return render_template("form.html") @app.route("/register", methods=["POST"]) def register(): title = request.form["title"] price = request.form["price"] arrival_day =request.form["arrival_day"] con = sqlite3.connect(DATABASE) con.execute('INSERT INTO books VALUES(?,?,?)',[title,price,arrival_day]) con.commit() con.close() return redirect(url_for("index")) #以下追記した削除コードです @app.route('/delete/', methods=['GET', 'POST']) def delete(id): con = sqlite3.connect(DATABASE) if request.method == 'POST': con.execute('DELETE FROM books WHERE id = ?', [id]) con.commit() con.close() return redirect(url_for('index')) else: book = con.execute('SELECT * FROM books WHERE id = ?', [id]).fetchone() con.close() if book: return render_template('delete.html', book=book) else: return "Book not found", 404 ``` ```db.py import sqlite3 DATABASE = "database.db" def create_books_table(): con = sqlite3.connect(DATABASE) con.execute("CREATE TABLE IF NOT EXISTS books (title, price, arrival_day)") con.close() ``` ```__init__.py from flask import Flask app = Flask(__name__) import flaskr.main from flaskr import db db.create_books_table() ``` ```index.html sapu-app

書店

今月の新刊一覧

{% if books == [] %}

今月の新刊情報はまだありません

{% else %} {% for book in books %} {% endfor %}

入荷日	タイトル	金額
{{ book.arrival_day }}	{{ book.title }}	{{ book.price }}円

{% endif %} 編集 {% for book in books %} {% endfor %}

Title	Price	Arrival Day	Actions
{{ book["title"] }}	{{ book["price"] }}	{{ book["arrival_day"] }}	Delete

``` ```form.html sapu-app

書店

入荷日	タイトル	金額

Delete Book

Are you sure you want to delete the following book?

Title: {{ book[0] }}

Price: {{ book[1] }}

Arrival Day: {{ book[2] }}

``` ```delete.html Delete Book

Delete Book

Are you sure you want to delete the following book?

Title: {{ book[0] }}

Price: {{ book[1] }}

Arrival Day: {{ book[2] }}

``` ローカルホストを立ち上げdeleteを押すと以下のエラーが出てきます。 ``` OperationalError sqlite3.OperationalError: no such column: id Traceback (most recent call last) File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 2213, in __call__ return self.wsgi_app(environ, start_response) File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 2193, in wsgi_app response = self.handle_exception(e) File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 2190, in wsgi_app response = self.full_dispatch_request() File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 1486, in full_dispatch_request rv = self.handle_user_exception(e) File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request rv = self.dispatch_request() File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) File "/Users/kojitakemura/Desktop/pythonProject1 2元本 2/flaskr/main.py", line 58, in delete book = con.execute('SELECT * FROM books WHERE id = ?', [id]).fetchone() sqlite3.OperationalError: no such column: id The debugger caught an exception in your WSGI application. You can now look at the traceback which led to the error. To switch between the interactive traceback and the plaintext one, you can click on the "Traceback" headline. From the text traceback you can also create a paste of it. For code execution mouse-over the frame you want to debug and click on the console icon on the right side. You can execute arbitrary Python code in the stack frames and there are some extra helpers available for introspection: dump() shows all variables in the frame dump(obj) dumps all that's known about the object ``` vscodeで作業をしています。 Python 3.10.7 64bit 　です。駆け出しの身でflaskのdeleteの書き方がわからずつまづいております。htmlもぐちゃぐちゃですがアドバイスいただきたいです。

	@@ -1,1 +1,1 @@
1	- flaskのdelete機能の追加につまづいております。
1	+ flaskのdelete機能の追加につまづいております。(ドのつく初心者です)

質問編集履歴