fabik/database

Database layer for Nette Framework.

fabik/database

This is a database layer for Nette Framework based on Nette\Database., _(*1)

Installation

Get the source code using Composer (add "fabik/database": "1.1.*" to your composer.json) or directly download Database to your libs directory., _(*2)

Example of use

1. Create the database:, _(*3)

   CREATE TABLE `users` (
       `id` int unsigned NOT NULL AUTO_INCREMENT,
       `username` varchar(255) NOT NULL,
       `password` char(40) NOT NULL,
       `email` varchar(255) NOT NULL,
       `firstname` varchar(255) NOT NULL,
       `surname` varchar(255) NOT NULL,
       PRIMARY KEY (`id`),
       UNIQUE KEY (`username`)
   ) ENGINE=InnoDB;
   
   CREATE TABLE `articles` (
       `id` int unsigned NOT NULL AUTO_INCREMENT,
       `title` varchar(255) NOT NULL,
       `content` longtext NOT NULL,
       `author_id` int unsigned NOT NULL,
       PRIMARY KEY (`id`),
       KEY (`author_id`),
       FOREIGN KEY (`author_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
   ) ENGINE=InnoDB;
   

2. Register the compiler extension in the bootstrapper., _(*4)

   use Fabik\Database\DatabaseExtension;
   
   $configurator->onCompile[] = function($configurator, $compiler) {
       $compiler->addExtension('database', new DatabaseExtension);
   };
   

3. Add the following sections to your config.neon file:, _(*5)

   nette:
       database:
           default:
               dsn: '%database.driver%:host=%database.host%;dbname=%database.dbname%'
               user: %database.user%
               password: %database.password%
   
   database:
       rowFactory:
           classes:
               articles: Blog\Article
               users: Blog\User
   
   services:
       articles: Blog\Articles
       users: Blog\Users
   

4. Create classes for rows (e.g. Article, User) and tables (e.g. Articles, Users):, _(*6)

   <?php
   
   namespace Blog;
   
   use Fabik\Database\ActiveRow,
       Fabik\Database\Table;
   
   
   
   class Article extends ActiveRow
   {
   }
   
   
   
   class User extends ActiveRow
   {
       /** @return string */
       public function getRealname()
       {
           return "$this->firstname $this->surname";
       }
   
   
   
       /** @param string */
       public function setRealname($realname)
       {
           list($this->firstname, $this->surname) = explode(' ', $realname);
       }
   }
   
   
   
   class Articles extends Table
   {
       protected $name = 'articles';
   }
   
   
   
   class Users extends Table
   {
       protected $name = 'users';
   }
   

5. Now you can use it as follows:, _(*7)

   $articles = $container->articles;
   
   foreach ($articles->findAll() as $article) {
       echo "$article->title was written by $article->author->realname\n";
   }