Paris

http://j4mie.github.com/idiormandparis/

A lightweight Active Record implementation for PHP5.

Built on top of Idiorm.

Tested on PHP 5.2.0+ - may work on earlier versions with PDO and the correct database drivers.

Released under a BSD license.

Features

• Extremely simple configuration.
• Exposes the full power of Idiorm's fluent query API.
• Supports associations.
• Simple mechanism to encapsulate common queries in filter methods.
• Built on top of PDO.
• Uses prepared statements throughout to protect against SQL injection attacks.
• Database agnostic. Currently supports SQLite, MySQL, Firebird and PostgreSQL. May support others, please give it a try!
• Supports collections of models with method chaining to filter or apply actions to multiple results at once.
• Multiple connections are supported

Documentation

The documentation is hosted on Read the Docs: paris.rtfd.org

Building the Docs

You will need to install Sphinx and then in the docs folder run:

make html

The documentation will now be in docs/_build/html/index.html

Let's See Some Code

class User extends Model {
    public function tweets() {
        return $this->has_many('Tweet');
    }
}

class Tweet extends Model {}

$user = Model::factory('User')
    ->where_equal('username', 'j4mie')
    ->find_one();
$user->first_name = 'Jamie';
$user->save();

$tweets = $user->tweets()->find_many();
foreach ($tweets as $tweet) {
    echo $tweet->text;
}

Changelog

1.3.0 - released 2013-01-31

• Documentation moved to paris.rtfd.org and now built using Sphinx
• Add support for multiple database connections - closes issue #15 [tag]
• Allow a prefix for model class names - see Configuration in the documentation - closes issues #33
• Exclude tests and git files from git exports (used by composer)
• Implement set_expr - closes issue #39
• Add is_new - closes issue #40
• Add support for the new IdiormResultSet object in Idiorm - closes issue #14
• Change Composer to use a classmap so that autoloading is better supported [javierd] - issue #44
• Move tests into PHPUnit to match Idiorm
• Update included Idiorm version for tests
• Move documentation to use Sphinx

1.2.0 - released 2012-11-14

• Setup composer for installation via packagist (j4mie/paris)
• Add in basic namespace support, see issue #20
• Allow properties to be set as an associative array in set(), see issue #13
• Patch in idiorm now allows empty models to be saved (j4mie/idiorm see issue #58)

1.1.1 - released 2011-01-30

• Fix incorrect tests, see issue #12

1.1.0 - released 2011-01-24

• Add is_dirty method

1.0.0 - released 2010-12-01

• Initial release