Download the PHP package breier/mykrorm without Composer

MykrORM

This library started with the idea of providing less than minimal DB functionality with still some intuitive automated stuff.

In order to handle data models and its properties in a clean code manner (readable and maintainable) I developed this library on top of PDO. Please enjoy (use at your own risk XD).

* You can find all the methods from PDO and their documentation at php.net/manual/class.pdo.

Table of Contents:

• Model Example
• Methods in MykrORM
• CRUD Methods
• Table Management

Model Example

This is a code example of a model that extends MykrORM

Further Information

The first time you try to "Create" an entry of that model, the table will be created in the database.

If you update the model adding more columns they will be added on creation as well.

While Create, Update and Delete deal with the current instance, "Read" (find) returns an ExtendedArray of instances of the Model.

Properties listed in $this->dbProperties should be declared with protected visibility. MykrORM will provide automatic getters and setters for them.

Methods in MykrORM

This is the abstract class that implements the ORM and it's also the base for every model you wish to create.

• The model class that extends from it has to implement getDSN() that returns a DSN string to PDO connection;
• It sets these default PDO options:
  • PDO::ATTR_ERRMODE -> PDO::ERRMODE_EXCEPTION
  • PDO::ATTR_DEFAULT_FETCH_MODE -> PDO::FETCH_NAMED
• It sets the DB table name based on the model class name that extended from it.
  But you can override it by setting $this->dbTableName before parent::__construct();
• If you use parameters for the extended __construct you also need to set
  $this->dbConstructorArgs as an array containing the parameters' values in it;
• It provides automatic getters via __get for related DB properties;
• It maps setters via __set for fetchObject() PDO mode.
  (you have to declare public setters like setPropertyName($value));

abstract protected function getDSN(): string

Returns the DSN for PDO connection (has to be implemented by the extending class).

protected function getDBProperties(): ExtendedArray

Get DB Properties (ensure it is an ExtendedArray instance)

protected function getConnection(): PDO

Gets the stored PDO object with a valid connection.

public function __get(string $propertyName)

Provides automatic getters for DB properties.

public function __set(string $name, $value): void

Maps setters automatically for fetchObject() PDO mode.

final protected static function camelToSnake(string $string): string

[static] Converts Camel-Case to Snake-Case (from Property to DB).

final protected static function snakeToCamel(string $string): string

[static] Converts Snake-Case to Camel-Case (from DB to Property).

CRUD Methods

This methods are embedded in MykrORM but I rather list them here for better organization.

public function create(): void

Insert new row to the model table with current properties.

public function find($criteria): ExtendedArray

Get all rows of the model table that matches $criteria (returns an ExtendedArray with model instances).

public function update($criteria): void

Update a row of the model table that matches $criteria.

* It internally uses find to get the original object.

public function delete(): void

Delete a row of the model table with current properties.

protected function getProperties(): ExtendedArray

Get database available properties in an associative array manner.

protected function bindIndexedParams(PDOStatement $statement, ExtendedArray $parameters): void

Binds parameters to indexed (?) placeholders in the prepared statement.

* Specially useful to detect booleans and nulls and bind them properly.

final protected function validateCriteria($criteria): bool

Make sure that any key in the criteria matches "dbProperties".

protected function findPrimaryKey(): ExtendedArray

Get DB property set as 'PRIMARY KEY' (or the first index if not found).

Table Management

A little bit of magic that actually limits the DB structure to a very simple one.

protected function createTableIfNotExists(): void

Checks if a table exists for the current extending model.
If it doesn't, it creates it.
If it does, it further checks for alterations to alter it.