SQL Databases Using SQLAlchemy: Using the SQLAlchemy ORM

The SQLAlchemy Object Relational Mapping (ORM) module treats each database table as a class and each row in that table as an instance or object of that class. These classes are very easy to define and use via base classes provided in the ORM API. In this course youll start by defining check constraints and using them to enforce generic conditions on data in a column. Youll then use cascading update and delete with foreign keys to propagate changes from the parent table to child table. Next youll illustrate how the SQLAlchemy ORM treats each table in a database as a class and rows in that table as objects of that class. Youll identify how the declarative_base class is suitable for creating new tables while the automap_base is ideal for reading in pre-existing tables from a database. Upon finishing this course youll be able to create and enforce check constraints enable cascading delete and update on foreign key constraints use the ORM API to model tables as classes correctly extend the declarative_base and automap_base classes from the ORM API and use them to perform SQL commands.