Corma
Corma is a high-performance, convention-based ORM based on Doctrine DBAL.
Corma is great because:
- No complex and difficult to verify annotations or configuration files
- Promotes consistent code organization
- Loads and saves one-to-one, one-to-many, and many-to-many relationships with a method call
- Can save multiple objects in a single query (using an upsert)
- Makes it easy to cache and avoid database queries
- Supports soft deletes
- Makes it easy to handle transactions in a Unit of Work
- Highly customizable
Corma doesn't:
- Autoload or lazy load relationships by default
- Do migrations or code generation
Works in MySql and PostgreSQL.
Install via Composer
Via the command line:
composer.phar require thewunder/corma ~3.0
Or add the following to the require section your composer.json:
"thewunder/corma": "~3.0"
For PHP version > 5.5 < 7.1 use Corma version ~2.0
Basic Usage
Create a DataObject
namespace YourNamespace\Dataobjects;
class YourDataObject {
protected $id;
//If the property name == column name on the table your_data_objects it will be saved
protected $myColumn;
//Getters and setters..
}
And a Repository (optional)
namespace YourNamespace\Dataobjects\Repository;
class YourDataObjectRepository extends ObjectRepository {
//Override default behavior and add custom methods...
}
Create the orm and use it
$db = DriverManager::getConnection(...); //see Doctrine DBAL docs
$orm = ObjectMapper::withDefaults($db);
$object = $orm->create(YourDataObject::class);
//Call setters...
$orm->save($object);
//Call more setters...
$orm->save($object);
//Call more setters on $object...
$objects = [$object];
$newObject = $orm->create(YourDataObject::class);
//call setters on $newObject..
$objects[] = $newObject;
$orm->saveAll($objects);
//find existing object by id
$existingObject = $orm->find(YourDataObject::class, 5);
//find existing objects with myColumn >= 42 AND otherColumn = 1
$existingObjects = $orm->findBy(YourDataObject::class, ['myColumn >='=>42, 'otherColumn'=>1], ['sortColumn'=>'ASC']);
//load relationships
$orm->loadOne($existingObjects, OtherObject::class, 'otherObjectId');
$orm->loadMany($existingObjects, AnotherObject::class, 'yourObjectId');
$orm->loadManyToMany($existingObjects, DifferentObject::class, 'link_table');
//delete those
$orm->deleteAll($existingObjects);
Documentation
See the wiki for full documentation.
Contributing
Please see CONTRIBUTING for details.
97 Dec 29, 2022
311 Dec 28, 2022
745 Jan 7, 2023
18 Dec 10, 2022
8 Oct 26, 2022
29 Jul 13, 2022
9.5k Jan 2, 2023
2k Dec 27, 2022
146 Sep 28, 2022
1.2k Dec 27, 2022
2 Jun 29, 2021
560 Nov 20, 2022
12 Nov 9, 2021
3 Nov 1, 2022
3 Apr 29, 2021
187 Nov 17, 2022
25 Oct 12, 2022
427 Dec 30, 2022
511 Dec 31, 2022
2k Dec 27, 2022
146 Sep 28, 2022
1.2k Dec 27, 2022
427 Dec 30, 2022
632 Dec 13, 2022
4 Jan 4, 2022
4 Sep 22, 2022
161 Oct 17, 2022
6.3k Jan 5, 2023
501 Dec 30, 2022