library potato-orm

andela-aonyango/potato-orm

A lightweight ORM built using PHP and PDO.

potato-orm

![Software License][ico-license] [![Coverage Status][ico-coveralls]][link-coveralls] ![Total Downloads][ico-downloads], _(*1)

A light-weight ORM which allows you to insert records into a database, retrieve them, update them, and delete them., _(*2)

Install

Via Composer, _(*3)

``` bash $ composer require andela-aonyango/potato-orm, <sub>(*4)</sub>

In the package directory, run
``` bash
$ composer install

Usage

Edit the example .env provided in the root of this package with the database settings you will use (make sure you .gitignore YOUR .env file). The one given uses MYSQL settings. PDO supports many database drivers so you can get familiar with what are valid/invalid inputs for the DSN and so on., <sub>(*5)</sub>

Sample Table

create table Person (
    id int unsigned auto_increment primary key,
    first_name varchar(30) not null,
    last_name varchar(30) not null,
    age int(2),
    gender varchar(7)
);

Sample Usage

``` php first_name = "yua"; $person->last_name = "madha"; $person->age = 73; // the add() method inserts an object and returns the last inserted id $id = $person->add(); // retrieve the just-added person $test = $person->find($id); print_r($test); $test->gender = "female"; $test->update(); // is the update successful print_r($test->find($id)); // delete the person from the database $test->remove(); // retrieve all people print_r($person->findAll()); ?>, <sub>(*6)</sub>

### Change log

Please see [CHANGELOG](CHANGELOG.md) for more information what has changed recently.

### Testing

``` bash
$ composer test

Contributing

Please see CONTRIBUTING and CONDUCT for details., <sub>(*7)</sub>

Security

If you discover any security related issues, please email andrew.onyango@andela.com instead of using the issue tracker., <sub>(*8)</sub>

Credits

• andela-aonyango
• All Contributors

License

The MIT License (MIT). Please see License File for more information., <sub>(*9)</sub>