Mastering Geospatial Analysis with Python

Models

For the Arena application, a script called models.py contains the models that will be used for the application. As described earlier, these models are Python classes that contain database column definitions and can have internal functions for processing data. Our simplified models contain only data column definitions using SQLAlchemy and GeoAlchemy2 classes.

To connect to the database, the app object is imported. This makes the application configuration variables, including app.config['SQLALCHEMY_DATABASE_URI'] which stores the database connection string, available to the SQLAlchemy create_engine function:

from application import app# The database connections and session management are managed with SQLAlchemy functionsfrom sqlalchemy ...