What are the basics of SQLAlchemy ORM?

What are the basics of SQLAlchemy ORM?

SQLAlchemy ORM is a powerful tool for database interaction in Python. It allows you to map Python classes to database tables.

How do I define a model in SQLAlchemy?

You define a model by creating a class that inherits from Base, and then you define class attributes that represent the columns.

Can you show me an example of a simple 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 a session to interact with the database?

You can create a session using sessionmaker from SQLAlchemy. Here's how:

from sqlalchemy.orm import sessionmaker

Session = sessionmaker(bind=engine)
session = Session()

This will allow you to interact with your database using the session object.