nrawe/wabi-orm

A minimalist, (near) zero-config object-relational mapper

v1.1.0 2019-02-15 22:21 UTC

This package is auto-updated.

Last update: 2024-04-10 10:00:37 UTC


README

WabiORM is a minimalist, (near) zero-config object-relational mapper.

Build Status Maintainability Coverage

Rationale

"Wabi" is a term borrowed from Japanese asethetics which loosely translates as "deliberately simple in daily living". This is something I miss when working with databases in PHP.

Don't get me wrong, there are some great libraries like Doctrine and Eloquent written to solve this problem and all credit to their authors for the fantastic work they've put in.

However, in probably 80% of what I want to do, they're less simple than I'd like. Additionally, from working with more functional programming ideas in the React/JavaScript world, I find myself wanting some of those characteristics on the server.

Lastly, I caught the train during the MicroPHP years and still look back at that period fondly. The desire for minimalism and focus on the 80% requirement stands in direct contrast to the monoliths, as good as they are, which surround us today.

In all, this is my attempt to find joy in database usage again, and maybe it will bring that to you, too. Or not ¯_(ツ)_/¯

@Glance

<?php

use function WabiORM\{
    belongs_to,
    connect, 
    delete, 
    find_one, 
    has_many, 
    global_read, 
    global_write, 
    mysql, 
    save
};

$connect = connect(mysql($host, $db, $user, $pwd));

global_read($connect);
global_write($connect);

class User {
    public $id;

    public function posts() {
        return has_many(Post::class, $this);
    }
}

class Post {
    public $id;

    public $user_id;

    public $title;

    public $content;

    public function user() {
        return belongs_to(User::class, $this);
    }
}

$newPost = new Post();
$newPost->title = 'My first post';
$newPost->content = 'WabiORM put the fun back into database usage!';

$id = save($newPost);

$post = find_one(Post::class, $id);
$post->title = 'My first post (edited!)';

save($post);
delete($post);

$user = find_one(User::class, 1);

foreach ($user->posts() as $post) {
    echo $post->title, PHP_EOL;
}

Features

  1. PDO connection middleware
  2. Works with plain classes
  3. Simple, powerful query templates

Install

Installation is handled via Composer:

$ composer require nrawe/wabi-orm

Test

The library ships with a test suite, see specs, which can be run by:

$ composer test

Documentation

This section documents the advanced usage.

  1. Using connections
  2. Working with models
  3. Working with model relationships
  4. Writing queries with q()

Roadmap

See ROADMAP.md for details of the planned work.

License

MIT.