andela-cnnadi/micro-orm

Simple PHP ORM Solution

Cashew - Micro ORM

Lightweight PHP ORM Solution. Supports only MySQL for now., _(*1)

Installation

Run the following command within the root folder of your application, _(*2)

composer require "andela-cnnadi/micro-orm": "dev-master"

Or you can just add the package name "andela-cnnadi/micro-orm": "dev-master" as a dependency within your composer.json file., _(*3)

Getting Started

To get started you need to configure your database connection. This can be done within the config folder in the package directory. There's a file called config.php which you can fill out with your database configuration information., _(*4)

Start Creating Models

To create a model you need to create a new class that extends the Cashew class. Each separate model should extend this class. Recommended file structure is shown below. See example for more details. By Default, Cashew Micro-ORM makes use of plural conventions for table names., _(*5)

```php , <sub>(*6)</sub>

-app - vendor - micro-orm - models - User.php - Phone.php - index.php, <sub>(*7)</sub>

Models can then be required within the application as shown below

```php
require 'vendor/autoload.php';
require 'models/User.php';
require 'models/Phone.php';

Model Configuration options

The $model variable within the Model class is used to store the field configuration of the model you are creating. It contains the field names as keys and field configurations as value. The field configuration contains key-value pairs of the various configuration options against the required values. The available configuration options include, <sub>(*8)</sub>

• type - Type of the field. Available options include int, text, varchar, smallint
• null - (optional) True or False value indicating whether the field can be null or not respectively. Defaults to true if nothing is specified
• size - Supports fields like varchar, int. Used to specify the maximum length of the field.

An example of a Model using the configuration options is shown below:, <sub>(*9)</sub>

 [
      'type' => 'varchar',
      'length' => 255,
      'null' => false
    ],
    'content' => [
      'type' => 'text',
      'null' => false
    ]
  ]
}
?>

Model Methods

• get - Fetches the result from a table based on an id. Example is shown below:

  // $id must be a number
  $user = User::get($id);