Viewing Options

Doctrine ORM for PHP

Guide to Doctrine for PHP

The Guide to Doctrine for PHP is the main source of documentation for the project. It is a reference book that can be read from start to finish and provides dozens of practice exercises that can be executed by the user.

Introduction
- Code Examples
- What is Doctrine?
- What is an ORM?
- What is the Problem?
- Minimum Requirements
- Basic Overview
- Doctrine Explained
- Key Concepts
- Further Reading
- Conclusion
Getting Started
- Checking Requirements
- Installing
- Implementing
- Conclusion
Introduction to Connections
- DSN, the Data Source Name
  - Examples
- Opening New Connections
- Lazy Database Connecting
- Testing your Connection
- Conclusion
Configuration
- Levels of Configuration
- Defaults Attributes
  - Default Column Options
  - Default Added Auto Id
- Portability
  - Portability Mode Attributes
  - Examples
- Identifier quoting
- Exporting
- Naming convention attributes
- Optional String Syntax
- Conclusion
Connections
- Introduction
- Opening Connections
- Retrieve Connections
- Current Connection
- Change Current Connection
- Iterating Connections
- Get Connection Name
- Close Connection
- Get All Connections
- Count Connections
- Creating and Dropping Database
- Conclusion
Introduction to Models
- Introduction
- Generating Models
  - Existing Databases
    - Making the first import
  - Schema Files
- Manually Writing Models
- Autoloading Models
  - Conservative
  - Aggressive
- Custom Accessors/Mutators
- Conclusion
Defining Models
- Columns
  - Column Lengths
  - Column Aliases
  - Default values
  - Data types
    - Introduction
    - Type modifiers
    - Boolean
    - Integer
    - Float
    - Decimal
    - String
    - Array
    - Object
    - Blob
    - Clob
    - Timestamp
    - Time
    - Date
    - Enum
    - Gzip
  - Examples
- Relationships
- Indexes
- Checks
- Table Options
- Transitive Persistence
  - Application-Level Cascades
    - Save Cascades
    - Delete Cascades
  - Database-Level Cascades
- Conclusion
Working with Models
- Define Test Schema
- Dealing with Relations
- Many-to-Many Relations
  - Creating a New Link
  - Deleting a Link
- Fetching Data
  - Sample Queries
  - Field Lazy Loading
- Arrays and Objects
- Overriding the Constructor
- Conclusion
DQL (Doctrine Query Language)
- Introduction
- SELECT queries
  - Aggregate values
- UPDATE queries
- DELETE Queries
- FROM clause
- JOIN syntax
  - ON keyword
  - WITH keyword
- INDEXBY keyword
- WHERE clause
- Conditional expressions
- Functional Expressions
  - String functions
  - Arithmetic functions
- Subqueries
  - Introduction
  - Comparisons using subqueries
- GROUP BY, HAVING clauses
- ORDER BY clause
- LIMIT and OFFSET clauses
  - Driver Portability
  - The limit-subquery-algorithm
- Named Queries
- BNF
- Magic Finders
- Debugging Queries
- Conclusion
Component Overview
- Manager
  - Retrieving Connections
- Connection
- Table
- Record
- Collection
- Validator
  - More Validation
  - Valid or Not Valid
    - Implicit Validation
    - Explicit Validation
- Profiler
  - Basic Usage
- Locking Manager
- Views
  - Using Views
- Conclusion
Native SQL
- Introduction
- Component Queries
- Fetching from Multiple Components
- Conclusion
YAML Schema Files
- Introduction
- Abbreviated Syntax
- Verbose Syntax
- Relationships
- Features & Examples
- Using Schema Files
- Conclusion
Data Validation
- Introduction
- Examples
  - Not Null
  - Email
  - Not Blank
  - No Space
  - Past
  - Future
  - Min Length
  - Country
  - IP Address
  - HTML Color
  - Range
  - Unique
  - Regular Expression
  - Credit Card
  - Read Only
  - Unsigned
  - US State
- Validating Relationships
- Custom Validators
- Conclusion
Inheritance
- Simple
- Concrete
- Column Aggregation
- Conclusion
Behaviors
- Introduction
- Simple Templates
- Templates with Relations
- Delegate Methods
- Creating Behaviors
- Core Behaviors
  - Introduction
  - Versionable
  - Timestampable
  - Sluggable
  - I18n
  - NestedSet
  - Searchable
  - Geographical
  - SoftDelete
- Nesting Behaviors
- Generating Files
- Querying Generated Classes
- Conclusion
Searching
- Introduction
- Index structure
- Index Building
- Text Analyzers
- Query language
- Performing Searches
- File searches
- Conclusion
Hierarchical Data
- Introduction
- Nested Set
- Conclusion
Data Fixtures
- Importing
- Dumping
- Implement
- Writing
- Fixtures For Nested Sets
- Fixtures For I18n
- Conclusion
Database Abstraction Layer
- Export
- Import
- DataDict
- Drivers
  - Mysql
    - Setting table type
- Conclusion
Transactions
- Introduction
- Nesting
- Savepoints
- Isolation Levels
- Conclusion
Event Listeners
- Introduction
- Connection Listeners
- Hydration Listeners
- Record Listeners
- Record Hooks
- DQL Hooks
- Chaining Listeners
- The Event object
- Conclusion
Caching
- Introduction
- Drivers
  - Memcache
  - APC
  - Db
- Query Cache & Result Cache
- Conclusion
Migrations
- Performing Migrations
- Implement
- Writing Migration Classes
- Conclusion
Utilities
- Pagination
- Facade
- Command Line Interface
  - Introduction
  - Tasks
  - Usage
- Sandbox
  - Installation
- Conclusion
Unit Testing
- Running tests
  - CLI
  - Browser
- Writing Tests
- Conclusion
Improving Performance
- Introduction
- Compile
- Conservative Fetching
- Bundle your Class Files
- Use a Bytecode Cache
- Free Objects
- Other Tips
- Conclusion
Technology
- Introduction
- Architecture
- Design Patterns Used
- Speed
- Conclusion
Exceptions and Warnings
- Manager exceptions
- Relation exceptions
- Connection exceptions
- Query exceptions
- Conclusion
Real World Examples
- User Management System
- Forum Application
- Conclusion
Coding Standards
- PHP File Formatting
- Naming Conventions
- Coding Style
- Conclusion

Doctrine ORM for PHP

Viewing Options

Doctrine ORM for PHP

Table of Contents