Time ................................................................................................................................................ 63
Date ................................................................................................................................................ 63
Enum............................................................................................................................................... 64
Gzip................................................................................................................................................. 65
Examples ............................................................................................................................ 65
Relationships ........................................................................................................... 68
Introduction........................................................................................................................ 68
Foreign Key Associations ................................................................................................... 73
One to One...................................................................................................................................... 73
One to Many and Many to One ....................................................................................................... 74
Tree Structure ................................................................................................................................ 76
Join Table Associations....................................................................................................... 77
Many to Many ................................................................................................................................. 77
Self Referencing (Nest Relations) .................................................................................................. 81
Non-Equal Nest Relations ............................................................................................................................ 81
Equal Nest Relations .................................................................................................................................... 82
Foreign Key Constraints..................................................................................................... 85
Introduction .................................................................................................................................... 85
Integrity Actions ............................................................................................................................. 87
Indexes..................................................................................................................... 88
Introduction........................................................................................................................ 88
Adding indexes ................................................................................................................... 89
Index options ...................................................................................................................... 90
Special indexes................................................................................................................... 91
Checks ..................................................................................................................... 92
Table Options........................................................................................................... 93
Transitive Persistence ............................................................................................. 94
Application-Level Cascades................................................................................................ 95
Save Cascades ................................................................................................................................ 95
Delete Cascades.............................................................................................................................. 95
Database-Level Cascades ................................................................................................... 96
Conclusion ............................................................................................................... 97
Working with Models ...................................................................................... 98
Define Test Schema ................................................................................................. 98
Dealing with Relations........................................................................................... 102
Creating Related Records ................................................................................................ 102
Retrieving Related Records.............................................................................................. 105
Updating Related Records................................................................................................ 105
Deleting Related Records................................................................................................. 106
Working with Related Records......................................................................................... 107
Testing the Existence of a Relation .............................................................................................. 107
Many-to-Many Relations ........................................................................................ 108
Creating a New Link......................................................................................................... 108
Deleting a Link ................................................................................................................. 108
Fetching Objects.................................................................................................... 110
Sample Queries ................................................................................................................ 112
Field Lazy Loading ........................................................................................................... 119
Arrays and Objects ................................................................................................ 120
To Array............................................................................................................................ 120
From Array ....................................................................................................................... 120
Synchronize With Array.................................................................................................... 121
Overriding the Constructor ................................................................................... 122
Conclusion ............................................................................................................. 122
DQL (Doctrine Query Language) .................................................................. 123
Introduction ........................................................................................................... 123
Table of Contents iv
-----------------
Brought to you by
