xruff/basedbmodel

Nette database utility

v2.0.2 2019-08-30 19:03 UTC

Requires

• nette/database: ~2.4
• nette/utils: ~2.4

Requires (Dev)

• nette/database: ~2.4
• nette/tester: ~1.1.0
• nette/utils: ~2.4
• tracy/tracy: 2.4.*
• vanio/coding-standards: ^0.1@dev

BSD-3-Clause, GPL-2.0, GPL-3.0

• Pavel Lauko

• analytics
• google
• nette
• component
• ga

README

Requirements

Package requires PHP 5.6 or higher

• nette/database
• nette/utils

Installation

The best way to install XRuff/BaseDbModel is using Composer:

$ composer require xruff/basedbmodel

Short Documentation

UsersRepository for handling database table users. You should use Repository suffix after table name.

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:

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):

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.