Mastering the Doctrine ORM

Installing Doctrine

• Installing via Pear
• Installing via SVN
• Installing by downloading package

Starting Application

• Simple MVC application
• Home brewed database abstraction layer
• Vulnerable to SQL injections
• Hard to maintain
• Lots of things done manually

Connections

• Bootstrap Doctrine autoloader
• Using the DSN(Data Source Name)
• Creating connections
• Creating and dropping databases
• Executing raw queries with PDO
• Managing multiple connections
• Binding models to connections
• Lazy connections
• Using existing PDO instances
• Managing connections
• Connection profiling/query logging

Configuration

• Global attributes
• Connection attributes
• Record attributes
• Table options

Database Abstraction Layer

• Complete API for altering databases
• Creating tables
• Creating and dropping databases
• Executing SQL queries

Models

• Writing your models in PHP
• Model autoloading
• Using Models
• Create tables from your models

Relationships

• Many to Many
• Equal Many to Many
• One to Many
• One to One
• Self Referencing
• Cascading operations

Retrieving Data

• Doctrine Query Language
• Querying Many to Many relationships
• Magic finder methods
• Custom finder methods
• Named queries
• Hydration methods

Working with Objects

• Modifying objects
• Saving objects
• Deleting objects
• Linking Objects
• From arrays
• Synchronizing with arrays

Events

• Using event listeners
• Connection listeners
• Record listeners
• DQL callbacks
• Hydration listeners

Inheritance

• Single Table
• Concrete
• Column Aggregation

Behaviors

• Core behaviors
• Loading behaviors
• Writing your own behaviors

Schema Files

• Generate YAML from existing database or set of models
• Alternatively specify schema information in YAML
• Generate PHP code from YAML

Data Fixtures

• Writing data fixtures
• Loading data fixtures
• Dumping data fixtures

Migrations

• Generating migrations from models and existing databases
• Developing migrations for model schema changes
• Running migrations

Unit Testing

• Testing your model
• Writing tests
• Running tests