perrotin/smart-select

A tool that will allow you set default select to your model and create the database user with the limited grants.

0.1.1 2025-06-30 19:10 UTC

Requires

• php: ^8.0
• illuminate/console: ^8.0|^9.0|^10.0|^11.0|^12.0
• illuminate/database: ^8.0|^9.0|^10.0|^11.0|^12.0
• illuminate/filesystem: ^8.0|^9.0|^10.0|^11.0|^12.0
• illuminate/support: ^8.0|^9.0|^10.0|^11.0|^12.0
• symfony/yaml: ^6.0|^7.0

Requires (Dev)

• phpstan/phpstan: ^2.1
• phpunit/phpunit: ^9.0

MIT

• Thomas Phlippoteau

• database
• mysql
• model
• laravel
• grants
• smart-select

README

Install

Install the package

composer require perrotin/smart-select

followed by

php artisan vendor:publish --provider="SmartSelect\Providers\SmartSelectServiceProvider"

for developement

If you wish to update the package, a good way is to update the repository and replace it with

"repositories": [
    {
        "type": "path",
        "url": "./packages-folder/smartselect",
        "options": {
            "symlink": true
        }
    }
],

How to use

Set up the package

In every model you want, you must :

• use the HasDefaultSelect trait
• use the HasDefaultSelectColumns interface
• set the getGrantColumns()method.

For example

namespace App\Models;

use SmartSelect\Contracts\HasDefaultSelectColumns;
use SmartSelect\Traits\HasDefaultSelect;

class User extends Model implements HasDefaultSelectColumns
{

	use HasDefaultSelect;

	protected $table = 'users';

	public function getGrantColumns(): array
    {
        return [
			'select' => ['id','name','created_at','updated_at'],
            'insert' => ['email', 'name'] // $this->fillable
		];
    }
}

Configure it

use commands

TODO

• Testing
• Config option to execute grant access depending of environment
• ...