2017 © Pedro Peláez
 

library db

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

image

titon/db

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

  • Thursday, June 19, 2014
  • by milesj
  • Repository
  • 0 Watchers
  • 0 Stars
  • 659 Installations
  • 1 Dependents
  • 1 Suggesters
  • 0 Forks
  • 0 Open issues
  • 60 Versions
  • 0 % Grown

The README.md

Database v0.15.3 Build Status

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., (*1)

$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., (*2)

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

The Versions

19/06 2014

dev-master

9999999-dev http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

19/06 2014

0.15.3

0.15.3.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

18/06 2014

0.15.2

0.15.2.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

18/06 2014

0.15.1

0.15.1.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

07/06 2014

0.15.0

0.15.0.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

01/06 2014

0.14.1

0.14.1.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

31/05 2014

0.14.0

0.14.0.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

24/05 2014

0.13.0

0.13.0.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

22/05 2014

0.12.1

0.12.1.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

21/05 2014

0.12.0

0.12.0.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

24/02 2014

0.11.2

0.11.2.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

23/02 2014

0.11.1

0.11.1.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

23/02 2014

0.11.0

0.11.0.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

28/01 2014

0.10.1

0.10.1.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

28/01 2014

0.10.0

0.10.0.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

12/01 2014

0.9.2

0.9.2.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

12/01 2014

0.9.1

0.9.1.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

12/01 2014

0.9.0

0.9.0.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

09/01 2014

0.8.0

0.8.0.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

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

19/10 2013

0.7.1

0.7.1.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

01/10 2013

0.7.0

0.7.0.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

25/08 2013

0.6.1

0.6.1.0 http://titon.io

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

05/08 2013

0.6.0

0.6.0.0 https://github.com/titon/Model

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

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

20/07 2013

0.5.0

0.5.0.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

18/07 2013

0.4.10

0.4.10.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

16/07 2013

0.4.9

0.4.9.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

16/07 2013

0.4.8

0.4.8.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

15/07 2013

0.4.7

0.4.7.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

15/07 2013

0.4.6

0.4.6.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

15/07 2013

0.4.5

0.4.5.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

14/07 2013

0.4.4

0.4.4.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

14/07 2013

0.4.3

0.4.3.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

14/07 2013

0.4.2

0.4.2.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

12/07 2013

0.4.1

0.4.1.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

12/07 2013

0.4.0

0.4.0.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

12/07 2013

0.3.11

0.3.11.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

12/07 2013

0.3.10

0.3.10.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

11/07 2013

0.3.9

0.3.9.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

11/07 2013

0.3.8

0.3.8.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

11/07 2013

0.3.7

0.3.7.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

11/07 2013

0.3.6

0.3.6.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

11/07 2013

0.3.5

0.3.5.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

11/07 2013

0.3.4

0.3.4.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

11/07 2013

0.3.3

0.3.3.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

11/07 2013

0.3.2

0.3.2.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

10/07 2013

0.3.1

0.3.1.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

08/07 2013

0.3.0

0.3.0.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

04/07 2013

0.2.0

0.2.0.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

30/06 2013

0.1.11

0.1.11.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

29/06 2013

0.1.10

0.1.10.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

29/06 2013

0.1.9

0.1.9.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

29/06 2013

0.1.8

0.1.8.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

28/06 2013

0.1.7

0.1.7.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

28/06 2013

0.1.6

0.1.6.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

25/06 2013

0.1.5

0.1.5.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

23/06 2013

0.1.4

0.1.4.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

23/06 2013

0.1.3

0.1.3.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

23/06 2013

0.1.2

0.1.2.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

22/06 2013

0.1.1

0.1.1.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon

16/06 2013

0.1.0

0.1.0.0 https://github.com/titon/Model

The Titon model package provides a basic database abstraction layer and an object relational mapper. Requires the PDO extension for database connections.

  Sources   Download

BSD-2

The Requires

 

The Development Requires

database schema model entity query driver type connection relation predicate clause dialect titon