Porte: Object Relational Mapping (ORM) in PHP
Porte has been designed to save time and to simplify the development of relational database applications written in PHP.
Tired of writing repetitive SQL to interact between your objects and the database, Porte will greatly simplify your life. Porte can retrieve, search and save objects without a single line of SQL. Porte deliver a natural and easy to use framework.
A design goal of Porte was to avoid any external configuration (being XML or others). In its simplest form, a record is a PHP object which class extends "PorteRecord" and which contain its definition in an array called "meta_fields". Getter and setter methods as well as a lot more of goodies will be automatically derived from there.
To some extends, Porte is inspired by Martin Fowler concept of Active Records.
June 26th, 2008: Porte 0.1.9 released
- Model: new functionnalities to register, retrieve and call methods
- Records: new type "double"
- Assocations: Improved one-to-one assocation: model is now complete, get and set methods tested on both sides
- Validation: New property url to validate correct url
- Events: Now use valid php callback
- Records: Introduce new plugin "Temporal" to add creation and modification date automatically
- Records: New method isDirty to check wether a record has recieved changes or not
- Assocations: Improved one-to-many support
- DojoStore: Introduce new plugin PorteDojoStore which help converting a list of record into a Dojo data store format
- Position: Plugin "order" is now renamed "position"
What does it give you?
- Property access: get, set, add, delete
- One-to-many associations
- Many-to-many associations (with or without a join table)
- Parent-child associations
- Table operations: exists, add, drop
- Table migrations: add and delete fields based on $meta_field configuration
- MySQL support
- Sql injection safe
- Events notification
- Validation framework
- Multi databases support in a same connection
- More than 200 tests which worth many lines of documentation
What it doesn't (yet) give you?
- one-to-one associations (not complete)
Quick exemple
Create a new group, associate it with a new user and save both
Command: "php samples/home/quick_exemple.php"
class Group extends PorteRecord{
public $meta_fields = array(
'name'=>array('size'=>50),
'users'=>array(
'has_many'=>true,
),
);
}
class User extends PorteRecord{
public $meta_table = array(
'name'=>'Users',
'primary_key'=>'id',
'encoding'=>'utf8',
);
public $meta_fields = array(
'id'=>array('int'=>11),
'username'=>array('size'=>50),
'password'=>array('size'=>50),
'groups'=>array(
'has_many'=>true,
),
);
}
PorteConfig::$database = 'porte';
PorteConfig::$connection = new PorteConnection();
$group = new Group();
$group->table->update(array('drop'));
$group->setName('my group');
$user = new User();
$user->table->update(array('drop'))
->setUsername('my username')
->setPassword('my password')
->addGroup($group)
->save();
echo 'User id is '.$user->getId()."\r\n";
echo 'Group id is '.$group->getId()."\r\n";
// User id is: 1
// Group id is: 1