titon/db

This package is abandoned and no longer maintained. No replacement package was suggested.

The Titon database package provides a basic database abstraction layer and an object relational mapper.

0.15.3 2014-06-19 06:22 UTC

Requires

• php: >=5.4.0
• ext-pdo: *
• titon/common: *
• titon/event: *
• titon/type: *

Requires (Dev)

• psr/log: *
• titon/cache: *
• titon/debug: *
• titon/test: dev-master

Suggests

• psr/log: Log queries using a Logger
• titon/cache: Cache query results using a Storage engine
• titon/db-mongodb: Enable MongoDB database access
• titon/db-mysql: Enable MySQL database access
• titon/db-postgresql: Enable PostgreSQL database access
• titon/db-sqlite: Enable SQLite database access

BSD-2

• Miles Johnson

• database
• db
• schema
• query
• type
• driver
• Connection
• relation
• entity
• titon
• predicate
• clause
• dialect

README

The Titon Database package provides a lightweight and low-level interface for interacting with database engines (known as drivers). The DB package comes bundled with a robust database abstraction layer (DBAL), an object oriented query builder, a powerful SQL dialect formatter, a data type caster, custom finder classes, behaviors, mappers, schemas, and many more.

$db = Titon\Db\Database::registry();
$db->addDriver('default', new Titon\Db\Mysql\MysqlDriver([
    'user' => 'root',
    'pass' => 'pass'
]));

$users = new Titon\Db\Repository(['table' => 'users']);
$entities = $users->select()->where('status', 1)->orderBy('created_at', 'desc')->all();

Supported database engines are packaged as individual driver packages, which are listed below.

Drivers

• MySQL - https://github.com/titon/db-mysql
• PostgreSQL - https://github.com/titon/db-postgresql
• SQLite - https://github.com/titon/db-sqlite
• MongoDB - https://github.com/titon/db-mongodb

Features

• Database - Driver manager
• Repository - Table representation, queries drivers, maps relations and returns entities
• Behavior - Executes logic during database events
• Entity - Single record of data
• EntityCollection - Collection of entities
• Finder - Select query formatting
• Driver - Interacts with a database or remote service
  • Dialect - Driver specific SQL formatting
  • Schema - Repository schema
  • Type - Data type mapping
  • ResultSet - Result set mapper
• Query - Object oriented query builder
  • RawExpr - Raw expression builder
  • Expr - Expression builder
  • Func - Function builder
  • Join - Join builder
  • Predicate - Clause builder

Dependencies

• Common
• Event
• Type
• Cache (optional)
• Psr\Log (optional)

Requirements

• PHP 5.4.0
  • PDO