Notes on Doctrine 2

Doctrine 2 Notes

• Introduction to Mapping Object Relationships
  • Object Relationships
    • 1. One to Many Relationships
    • 2. Many To Many Relationships
    • 3. One to One relationships
  • Database Relationships
    • 1. One to Many
    • 2. Many to Many
    • 3. One to One
    • Directionality of relationships: Uni-directional vs Bidirectional
  • Doctrine Object Mappings
    • Marco Pivetta’s Example
    • Cookbook Example
    • Entities and owning side
    • One–To–Many, Unidirectional with Join Table
  • Summary of key points
• Doctrine 2 in Depth
  • Review: ORM Entities
  • How to avoid reservered word conflicts
    • Configuration
    • Development vs Production Configuration
    • Metadata Mappings for Associations
  • Cascade and Associations
    • CASCADE ON DELETE
    • Achieving DB Level Cascading Delete in Doctrine
    • Cascade at the ORM level
      • cascade={“persist”}
      • cascade={“remove”}
  • Association Examples
    • One–To–One unidirectional
    • One–To–One bidirectional
    • One–To–One self referencing
    • One–To–Many, Unidirectional with Join Table
    • Many–To–One, Unidirectional
    • One–To–Many, Bidirectional
    • One–To–Many, Self-referencing
    • Many–To–Many, Unidirectional (with Join Table)
    • Many–To–Many, Bidirectional
    • Many–To–Many, Self–referencing
  • Ordering Collections
  • Inheritance
    • Mapped Superclass
    • Single Table Inheritance
    • Class Table Inheritance
  • Working with Objects
    • Unit of Work and Entity State concepts
    • The downside to EntityManager::find()
  • Various Query Techniques
    • 1. Using EntityManager find methods
    • 1.1 You can find by primary key
    • 1.2 EntityRepositories’ findBy and findOneBy
    • 1.3 getReference() enhances performance
    • 3. By DQL
    • 4. By Raw SQL
    • 5. Custom Repositories
    • Discusssion of Repositories
  • Concurrency and Transactions
    • Conceptual or Long-Running Transactions
  • DQL
    • SELECT Queries
    • JOINs
    • Prefer Fetch Joins to tranversing associations between objects
    • Using Aggregate Functions:
    • Named and Positional Parameters
    • Partial Object Syntax
    • UPDATE queries
    • Iterating Large Result Set Queries
    • DELETE queries
    • Hydration modes
    • Functions, Operators, Aggregates
    • Query Builder
    • Bulk Operation Examples
    • Bulk Insert Examples
    • Bulk Update Example
    • Bulk Delete Example
    • Alternative Delete technique: iterate results
  • Change Tracking
  • Partial Objects
  • Events
  • Notes from Jonathan Wage’s Webinar
  • Iterating over queries directly
  • Best Practices
  • Improving Performance (best practices)
  • Use Transaction Demarcation (best practices)