ccmbenchmark/ting

Ting : a lightweight datamapper

3.9.1 2024-07-19 14:35 UTC

Requires

• php: >=7.1
• aura/sqlquery: ^2.6
• doctrine/cache: ^1.6
• pimple/pimple: ^3.0

Requires (Dev)

• ext-mysqli: *
• ext-pgsql: *
• atoum/atoum: ^4.0
• atoum/stubs: ^2.0
• brick/geo: ^0.5.1

Suggests

• brick/geo: Allow support of MariaDB Geometry type

Apache-2.0

• database
• mysql
• repository
• pgsql
• datamapper
• model
• mapper
• entity
• unitofwork

README

Ting is a simple DataMapper implementation for PHP. It runs with MySQL and PostgreSQL and is under Apache-2.0 licence.

It has some distinctive features and design choices :

• Pure PHP implementation (no PDO, no XML)
• No abstraction layer : you speak the language of your RDBMS
• Fast, low memory consumption
• Simple to use, simple to extend

You can read this few examples, or go to the Documentation or see more samples.

Retrieve object by ID

<?php
$cityRepository = $services->get('RepositoryFactory')->get('\sample\src\model\CityRepository');

## Retrieve city by id :
$city = $cityRepository->get(3);

Simple query

<?php
# This query supports the same syntax as prepared statements, but it'll be a regular query
$query = $cityRepository->getQuery(
    "select cit_id, cit_name, c.cou_code, cit_district, cit_population, last_modified,
        co.cou_code, cou_name, cou_continent, cou_region, cou_head_of_state
    from t_city_cit as c
    inner join t_country_cou as co on (c.cou_code = co.cou_code)
    where co.cou_code = :code limit 3"
);

$collection = $query->setParams(['code' => 'FRA'])->query();

foreach ($collection as $result) {
    var_dump($result);
    echo str_repeat("-", 40) . "\n";
}

Prepared Statement

<?php
// Simple query :
$query = $cityRepository->getQuery('SQL Statement');
// Prepared statement :
$query = $cityRepository->getPreparedQuery('SQL Statement');

QueryBuilder provided by aura/sqlquery

<?php
$queryBuilder = $cityRepository->getQueryBuilder($cityRepository::QUERY_SELECT);
$queryBuilder
    ->cols(['cit_id', 'cit_name as name'])
    ->from('t_city_cit');
$query = $cityRepository->getQuery($queryBuilder->getStatement());

More :

• Documentation
• Issues