Ошибка с sqlalchemy во flask
from flask import Flask, render_template, request
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///shop.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
class Item(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
price = db.Column(db.Integer, nullable=False)
isActive = db.Column(db.Boolean, default=True)
text = db.Column(db.Text, nullable=False)
@app.route('/')
def index():
return render_template("index.html")
@app.route('/about')
def about():
return render_template("about.html")
@app.route('/create', methods=['POST', 'GET'])
def create():
if request.method == "POST":
title = request.form['title']
text = request.form['text']
price = request.form['price']
item = Item(title=title, text=text, price=price)
try:
db.session.add(item)
db.session.commit()
return redirect('/')
except:
return "Ошибка"
else:
return render_template("create.html")
if name == "main":
app.run(debug=True)
