xruff/basedbmodel

Nette database utility

Nette database utility

Requirements

Package requires PHP 5.6 or higher, _(*1)

• nette/database
• nette/utils

Installation

The best way to install XRuff/BaseDbModel is using Composer:, _(*2)

$ composer require xruff/basedbmodel

Short Documentation

UsersRepository for handling database table users. You should use Repository suffix after table name., _(*3)

namespace MyModels;

use XRuff\App\Model\BaseDbModel;

class UsersRepository extends BaseDbModel
{
    // no implementation needed
}

If for some reason you can not use the table name or word Repository in class name, follow these steps:, _(*4)

namespace MyModels;

use Nette\Database\Context;
use XRuff\App\Model\BaseDbModel;

class MyAnyNameRepo extends BaseDbModel
{
    public function __construct(Context $db)
    {
        parent::__construct($db, 'my_db_able_name');
    }
}

Using model in presenter (or anywhere else):, _(*5)

use Nette;
use MyModels\UsersRepository;

class MyUsersPresenter extends Nette\Application\UI\Presenter
{
    /** @var UsersRepository $usersModel */
    public $usersModel;

    public function __construct(
        UsersRepository $usersModel
    ) {
        $this->usersModel = $usersModel;
    }

    public function actionDefault()
    {
        // returns Nette\Database\Table\ActiveRow
        // with first user with name John in table users
        $this->usersModel->getOneBy(['name' => 'John']);

        // or
        // set name as Joe for user with id 5 in table users
        // and returns Nette\Database\Table\ActiveRow with updated values
        $this->usersModel->save(['id' => 5, 'name' => 'Joe']);

        // or add new user with name Jane
        // and returns Nette\Database\Table\ActiveRow with just added row
        $this->usersModel->save(['name' => 'Jane']);

        // or some another method inherited from BaseDbModel
    }
}

Repository https://github.com/XRuff/BaseDbModel., _(*6)