– Pattern DAO (Data Access Object)
– ORM Frameworks: functionalities, interest
– Python ORMs: SQLAlchemy, Django ORM, PonyORM, SQLObject, Peewee, …
– Mapping of tables and management of primary keys (simple, compound)
– Mapping of database types, column properties
– Concurrency management: optimistic (versioning), pessimistic
– Relationship management: OneToMany / ManyToOne, OneToOne, ManyToMany
– Cascades configuration –
Collection management
– Inheritance mapping
– Loading strategies: Lazy or Eager

Workshop: Realization of a global mapping diagram of a database

– Object request language
– Basic selections, filters
– Complex joins
– Aggregation, chain functions, …
– Lazy / Eager load management

Workshop: Performing CRUD (Create Read Update Delete) operations – complex requests

– Entity life cycle and validation
– Interceptors, Event-listeners
– Advanced configuration: performance and functionalities
– Use of the cache
– Websockets servers in Python

Workshop: Implementation of interceptors and cache management.

Workshop: Implementation of a chat room using websockets.

Passing of the certification (if foreseen in the financing).