How do I set up Flask with SQLAlchemy?

How do I set up Flask with SQLAlchemy?

To set up Flask with SQLAlchemy, first install Flask and Flask-SQLAlchemy using pip. You can do this by running: pip install Flask Flask-SQLAlchemy.

What are the basic configurations I need to do?

You need to create a Flask app and configure the SQLALCHEMY_DATABASE_URI. For example:

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///site.db'

How do I create a model for my database?

You can create a model by defining a class that inherits from db.Model. For example:

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(150), nullable=False)

How do I create the database and tables?

You can create the database and tables by running:

from yourapp import db
db.create_all()