How do I set up SQLAlchemy in my Python project?

How do I set up SQLAlchemy in my Python project?

To set up SQLAlchemy, first install it using pip: pip install SQLAlchemy. Then, you can create a database connection.

What do I need to do after installing it?

After installation, you can define your database models by creating classes that inherit from Base. Don't forget to create a session to interact with the database.

Can you show me an example of a model?

Sure! Here's a simple example:

from sqlalchemy import Column, Integer, String, create_engine
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    age = Column(Integer)

This defines a User model with id, name, and age fields.

How do I create the database tables from my models?

You can create the tables by using the create_all method on your engine:

engine = create_engine('sqlite:///mydatabase.db')
Base.metadata.create_all(engine)