Ting - Documentation

• Simple: no magic inside : it’s basically SQL queries
• Fast: with no magic comes no overhead
• Supports Mysql and PostgreSQL

Why another datamapper for PHP?

Great datamappers for MySQL and PostgreSQL already exist. However the most popular tools are complex and hard to master requiring new skills to query databases or boring xml files to describe the database. Ting has been created with the simplicity as a credo.

Ting is not an ORM, because it doesn’t fully support relations between objects. But you can easily build join queries and retrieve every objects involved in your query.

• 1   Getting started
  • 1.1   Setup
  • 1.2   Installation
  • 1.3   Setup database
  • 1.4   Creating repositories
  • 1.5   Creating City repository
  • 1.6   Creating Country repository
  • 1.7   Creating CountryLanguage repository
  • 1.8   Database connection settings
  • 1.9   Repositories settings
  • 1.10   Creating entities
  • 1.11   You can now use Ting
• 2   Getting started with Symfony 2.8
  • 2.1   Setup
  • 2.2   Delete Doctrine dependencies
  • 2.3   Install Ting
  • 2.4   Setup database
  • 2.5   Creating repositories
  • 2.6   Creating City repository
  • 2.7   Creating Country repository
  • 2.8   Creating CountryLanguage repository
  • 2.9   Database connection settings
  • 2.10   Repositories settings
  • 2.11   Creating entities
  • 2.12   You can now use Ting
• 3   Entities
  • 3.1   About the entities
  • 3.2   Entities and UnitOfWork
• 4   Queries
  • 4.1   Perform a read query
    • 4.1.1   The Query object
    • 4.1.2   Parameters
    • 4.1.3   Perform the query
    • 4.1.4   Get the output
    • 4.1.5   Details about the output format
    • 4.1.6   Simplified output format for queries without joins
    • 4.1.7   Counting items in a collection
    • 4.1.8   Perform a query on the master
    • 4.1.9   Error on a query
  • 4.2   Perform a write query
• 5   Repository
  • 5.1   About the repository
  • 5.2   Creating Metadata
  • 5.3   Serializer
    • 5.3.1   About the serializer
    • 5.3.2   Serializer configuration
    • 5.3.3   Writing a serializer
  • 5.4   QueryBuilder
  • 5.5   Queries
    • 5.5.1   Find an object by it’s primary key
    • 5.5.2   All items
    • 5.5.3   An object according to one or more properties of the model
    • 5.5.4   An object collection, according to one or more properties of the model
• 6   About the hydrators
  • 6.1   About hydrators
  • 6.2   Default hydrator
    • 6.2.1   SQL join with no data
  • 6.3   The hydrator for a single object
  • 6.4   The aggregator hydrator
  • 6.5   The relational hydrator
  • 6.6   Data without metadata
  • 6.7   Mapping data without metadata
  • 6.8   Deserialize data without metadata
  • 6.9   Object composition
• 7   UnitOfWork
  • 7.1   About the unitofwork
    • 7.1.1   Internal process
  • 7.2   Principle
    • 7.2.1   Specifity
  • 7.3   Notes for batch process
• 8   Cache
  • 8.1   About the cache
  • 8.2   Simple query
  • 8.3   Prepared query
• 9   The cache component