apaoww/yii2-dbmanager-oci8

Auth Dbmanager for Yii2 for Oracle db Customize for Oci8 driver

Installs: 371

Dependents: 3

Suggesters: 0

Security: 0

Stars: 0

Watchers: 2

Forks: 0

Open Issues: 0

Type:yii2-extension

dev-master / 1.0.x-dev 2023-09-14 02:06 UTC

This package is not auto-updated.

Last update: 2024-04-25 05:17:32 UTC


README

Installation

Install With Composer

The preferred way to install this extension is through composer.

Either run

php composer.phar require apaoww/yii2-dbmanager-oci8 "dev-master"

or add

"apaoww/yii2-dbmanager-oci8": "dev-master"

to the require section of your composer.json file.

Install From Archive

Download source at https://github.com/apaoww/yii2-dbmanager-oci8

return [
    ...
    'aliases' => [
        '@apaoww/DbManagerOci8' => 'path/to/your/extracted',
        ...
    ]
];

Usage

Once the extension is installed, simply modify your application configuration as follows :

return [	
	'components' => [
		....
		'authManager' => [
                    'class' => 'apaoww\DbManagerOci8\DbManager', // or use 'yii\rbac\DbManager'
		    'itemTable' => 'SCHEMANAME.AUTH_ITEM',
            	    'assignmentTable' => 'SCHEMANAME.AUTH_ASSIGNMENT',
                    'itemChildTable' => 'SCHEMANAME.AUTH_ITEM_CHILD',
                    'ruleTable' => 'SCHEMANAME.AUTH_RULE',
                ],
];

Custom Auth's Table Migration

You may want to create auth's table using migration command. Instead of using yii default migrate (yii migrate), specify the custom migrationPath to point to custom auth's table migration, all column are uppercase.

php yii migrate --migrationPath=@apaoww/DbManagerOci8/migrations