Код: Выделить всё
CREATE TABLE classes (
model_id TEXT NOT NULL,
class_number INTEGER,
class_name TEXT,
FOREIGN KEY(model_id) REFERENCES models(model_id)
);
< /code>
Проблема в том, что это мой маршрут колбы. Я использую такую структуру: < /p>
@app.route("/model/",methods=["POST","GET"])
@login_required
def view_model(model_id):
...
with sqlite3.connect("database.db") as con:
.
.
.
return render_template("train.html",
categories=CATEGORIES,
model_id=model_id,
model=model,
classes=classes,
images=images,
istrained=istrained,
test_image=test_image
)
images=images)
Код: Выделить всё
@app.route("/add_class/",methods=["POST","GET"])
@login_required
def add_class(model_id):
with sqlite3.connect("database.db") as con:
con.row_factory = sqlite3.Row
db = con.cursor()
result = db.execute("SELECT MAX(class_number) FROM classes WHERE model_id = ?", (model_id,)).fetchone()
max_num = result[0] if result and result[0] is not None else 0
default_num = int(max_num +1)
default_name = "Class " + str(max_num + 1)
db.execute("INSERT INTO classes (model_id,class_name,class_number) VALUES(?,?,?)",
(model_id,default_name,default_num))
con.commit()
return redirect(f"/model/{model_id}")
Подробнее здесь: https://stackoverflow.com/questions/797 ... h-in-flask
Мобильная версия