Slince\CakePermission\SchemaFactory

Complexity

Total Complexity

10

Size/Duplication

Total Lines	162
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes	1
Bugs	0	Features	1

5 Methods

Rating	Name	Duplication	Size	Complexity
A	getUsersSchema()	0	20	2
B	getRolesSchema()	0	36	2
B	getPermissionsSchema()	0	37	2
A	getUsersRolesSchema()	0	21	2
A	getRolesPermissionsSchema()	0	21	2

<?php
/**
 * CakePHP permission handling library
 * @author Tao <taosikai@yeah.net>
 */
namespace Slince\CakePermission;

use Cake\Core\Configure;
use Cake\Database\Schema\TableSchema;

class SchemaFactory
{
    /**
     * Gets the users table schema
     * @return TableSchema
     */
    public static function getUsersSchema()
    {
        $schema = new TableSchema(Configure::read('Permission.tableNameMap.users') ?: 'users');

        $schema->addColumn('id', [
            'type' => 'integer',
            'autoIncrement' => true
        ])
            ->addConstraint('primary', [
                'type' => 'primary',
                'columns' => ['id']
            ]);
        $schema->addColumn('name', [
            'type' => 'string',
            'length'  => 255,
            'default' => '',
            'null' => false
        ]);
        return $schema;
    }

    /**
     * Gets the roles table schema
     * @return TableSchema
     */
    public static function getRolesSchema()
    {
        $schema = new TableSchema(Configure::read('Permission.tableNameMap.roles') ?: 'roles');

        $schema->addColumn('id', [
                'type' => 'integer',
                'autoIncrement' => true
            ])
            ->addConstraint('primary', [
                'type' => 'primary',
                'columns' => ['id']
            ]);
        $schema->addColumn('name', [
            'type' => 'string',
            'length'  => 255,
            'default' => '',
            'null' => false
        ]);
        $schema->addColumn('slug', [
            'type' => 'string',
            'length'  => 255,
            'default' => '',
            'null' => false
        ]);
        $schema->addColumn('created', [
            'type' => 'datetime',
            'default' => null,
            'null' => false
        ]);
        $schema->addColumn('modified', [
            'type' => 'datetime',
            'default' => null,
            'null' => false
        ]);
        return $schema;
    }

    /**
     * Gets the roles table schema
     * @return TableSchema
     */
    public static function getPermissionsSchema()
    {
        $schema = new TableSchema(Configure::read('Permission.tableNameMap.permissions') ?: 'permissions');

        $schema->addColumn('id', [
            'type' => 'integer',
            'autoIncrement' => true
        ])
            ->addConstraint('primary', [
                'type' => 'primary',
                'columns' => ['id']
            ]);

        $schema->addColumn('name', [
            'type' => 'string',
            'length'  => 255,
            'default' => '',
            'null' => false
        ]);
        $schema->addColumn('slug', [
            'type' => 'string',
            'length'  => 255,
            'default' => '',
            'null' => false
        ]);
        $schema->addColumn('created', [
            'type' => 'datetime',
            'default' => null,
            'null' => false
        ]);
        $schema->addColumn('modified', [
            'type' => 'datetime',
            'default' => null,
            'null' => false
        ]);
        return $schema;
    }

    /**
     * Gets the join table schema between users and roles
     * @return TableSchema
     */
    public static function getUsersRolesSchema()
    {
        $schema = new TableSchema(Configure::read('Permission.tableNameMap.users_roles') ?: 'users_roles');

        $schema->addColumn('user_id', [
            'type' => 'integer',
            'default' => null,
            'null' => false
        ]);

        $schema->addColumn('role_id', [
            'type' => 'integer',
            'default' => null,
            'null' => false
        ]);

        $schema->addConstraint('primary', [
            'type' => 'primary', 'columns' => ['user_id', 'role_id']
        ]);
        return $schema;
    }

    /**
     * Gets the join table schema between roles and permissions
     * @return TableSchema
     */
    public static function getRolesPermissionsSchema()
    {
        $schema = new TableSchema(Configure::read('Permission.tableNameMap.roles_permissions') ?: 'roles_permissions');

        $schema->addColumn('role_id', [
            'type' => 'integer',
            'default' => null,
            'null' => false
        ]);

        $schema->addColumn('permission_id', [
            'type' => 'integer',
            'default' => null,
            'null' => false
        ]);

        $schema->addConstraint('primary', [
            'type' => 'primary', 'columns' => ['role_id', 'permission_id']
        ]);
        return $schema;
    }
}