Learning Python Networking - Second Edition

Creating a session and ORM queries

The sqlalchemy.orm.sessionmaker() function allows you to create a sqlalchemy.orm.session.sessionmaker class that contains attributes and methods that allow you to interact with the database. You can use the following methods to manage session data:

• The add() method, which adds or replaces the record that's bound to the instantiated object of a Base subclass in the corresponding record within the database
• The delete() method, which deletes the record that's bound to the object
• The commit() method, which applies the changes to the database

Now that our tables have been assigned and created, we can insert data. This insertion is done by creating instances of the class, which is created with MyTable. At this ...