dennis-fedco

DROP SCHEMA IF EXISTS `dennis_db` ;
CREATE SCHEMA IF NOT EXISTS `dennis_db` DEFAULT CHARACTER SET utf8 ;
USE `dennis_db` ;

-- -----------------------------------------------------
-- Table `dennis_db`.`resource`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dennis_db`.`resource` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL,

dennis-fedco

I modeled my application using SQL first. I wanted to have users, roles, resources, and access. My privileges table contained {role, resource, access} entries. I then put it together with CsnAuthorization, and modeled it with MySQL Workbench:

Image: SQL with data: https://gist.github.com/dennis-fedco/7084960

Referential Integrity ensures that access (such as "cook") can only be added if there is a resource that exists (such as "Kitchen" controller), and that a privilege can only be added if a user/role and resource and access exists.

What I can call from my application is any one of these:

dennis-fedco

<?php
/**
 * Zend Framework (http://framework.zend.com/)
 *
 * @link      http://github.com/zendframework/FedcoUser for the canonical source repository
 * @copyright Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
 * @license   http://framework.zend.com/license/new-bsd New BSD License
 */

$additionalNamespaces = $additionalModulePaths = $moduleDependencies = null;

dennis-fedco

<?php
/**
 * Zend Framework (http://framework.zend.com/)
 *
 * @link      http://github.com/zendframework/ZendSkeletonModule for the canonical source repository
 * @copyright Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
 * @license   http://framework.zend.com/license/new-bsd New BSD License
 */

/**

dennis-fedco

<?php
namespace FedcoUserTest;
use FedcoUser\Controller\MachinistController;


require_once 'vendor/zf-commons/zfc-user/src/ZfcUser/Controller/UserController.php';

/**
 * MachinistController test case.
 */

dennis-fedco

<?php
namespace FedcoUser\Controller;

use Zend\View\Model\ViewModel;
use ZfcUser\Controller\UserController as ZfcUserController;

/**
 * MachinistController
 *
 * @author

dennis-fedco

<?php
namespace FedcoUserTest;

use Zend\Test\PHPUnit\Controller\AbstractHttpControllerTestCase;

class IndexControllerTest extends AbstractHttpControllerTestCase
{

    public function setUp()
    {

dennis-fedco

<?php
use Zend\Form\Form;
use Zend\Form\Annotation\AnnotationBuilder;
use Zend\Hydrator\ClassMethods;
use Zend\Form\Annotation;
require 'vendor/autoload.php';

/*
 * How to run: php ClassMethodsExample.php
 *

dennis-fedco

<?php
use Zend\Form\Form;
use Zend\Form\Annotation\AnnotationBuilder;
use Zend\Form\Annotation;
use Zend\Form\Element\Collection;
require 'vendor/autoload.php';

class FormTestController
{

dennis-fedco

<?php
use Zend\Form\Form;
use Zend\Form\Annotation\AnnotationBuilder;
use Zend\Form\Annotation;
use Zend\View\Renderer\PhpRenderer;
use Zend\View\Resolver;
use Zend\View\View;

require 'vendor/autoload.php';