Learn Programming in Python with Cody Jackson

Writing a SQLAlchemy database

When working with SQLAlchemy, there are three main components to work with:

• The table, which functions as a normal DB table
• The mapper, which maps a Python class to a table
• The class object, which handles how a DB record maps to a Python object

One beneficial aspect of SQLAlchemy is that all of these items can be placed within the same location, rather than having separate files. The SQLAlchemy declarative contains the definitions of these objects.

To convert the previous SQLite database into a SQLAlchemy database, we first create the declarative program, as shown here:

# sqlalchemy_declarative.py1 from sqlalchemy import Column, Integer, String, create_engine2 from sqlalchemy.ext.declarative import declarative_base ...