phore/dba

Database abstraction layer and ORM

Phore Dba (DatabaseAbstraction)

TL;DR;

Phore-dba is a very simple Object-Relational Mapper for PHP 7., _(*1)

It will map Objects to Tables using exact the same Names., _(*2)

• It will work with mysqli, sql, and PDO in gerneral.
• Update only changed properties
• See sqlite3 example

Installation

Install using composer:, _(*3)

composer require phore/dba

Example

• Create as Entity Class SomeEntity and define __META__ data
• Initialize a Sqlite Connection to /path/to/sqlite.db3
• Create a Table SomeEntity
• Insert a new Entity for name: someName and company: SomeCompany
• query() all Entities and map them back to Entity using each(callable $fn)
• update() each entity, then delete() it (hm - it's just a demo)

class SomeEntity {
    use Entity;
    const __META__ = [ "primaryKey" => "id" ];
    public $id;
    public $name;
    public $company;
}

$odb = PhoreDba::InitDSN("sqlite:/path/to/sqlite.db3");
// Use multi_query() to execute multiple Statements
$odb->multi_query ("CREATE TABLE IF NOT EXISTS SomeEntity (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT,
    company TEXT
);");

$odb->insert(new SomeEntity(["name"=>"someName", "company"=>"SomeCompany"]));

$odb->query("SELECT * FROM SomeEntity WHERE name=?", ["UnescapedValue"])->each(
    function (array $row) use ($odb) {
        print_r ($entity = SomeEntity::Load($row["id"]);
        $entity->name = "MyNewName";
        $odb->update($entity);
        $odb->delete($entity);
    }
);

Loading from Database

$entity = $odb->load(SomeEntity::class, 103878);

or - with object casting (IDE Code-Completion):, _(*4)

$entity = SomeEntity::Load(103878);

Working with entities

Entities must be loaded calling the load() method, so the framework can track changes. You should use query() only to retrieve Id's and load the entities afterwards., _(*5)

Changed fields

$entity = SomeEntity::Load(1234); // Shortcut
$entity->name = "new Name";
assert ($enetity->isChanged("name") === true)