php laravel model,Laravel创建Model命令
由于数据库表太多不想一个个创建基础的Model模板，所以就写了这个东东！
好了直接上代码把！
namespace App\Console\Commands;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
class CreateModelCommand extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'create:model {table_name}';
/**
* The console command description.
*
* @var string
*/
protected $description = '创建Model';
/**
* Create a new command instance.
*
* @return void
*/
public function __construct()
{
parent::__construct();
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$table = $this->argument('table_name');
if('' === $table){
echo '参数错误';
return;
}
if('all' === $table){
// 所有表名称
$tables = DB::select('show tables;');
foreach ($tables as $table){
$this->createModel($table->Tables_in_community);
}
} else if($table){
$this->createModel($table);
}
echo '大功告成';
}
private function createModel(string $table): void
{
// c_为表前缀 改成自己的
$tableName = str_replace('c_','',$table);
$tableName = explode('_', $tableName);
$modelName = array_map(function ($value) {
return ucfirst($value);
}, $tableName);
$modelName = implode('', $modelName).'Model';
// Model存放目录可以自行修改
$fileName = app_path('/Models/').$modelName.'.php';
if(is_file($fileName)){
return;
}
$tableInfo = DB::select('show columns from ' . $table);
$pk = 'id';
foreach ($tableInfo as $fieldInfo) {
if ('PRI' === $fieldInfo->Key) {
$pk = $fieldInfo->Field;
break;
}
}
!is_file($fileName) && file_put_contents($fileName, $this->formatModelString($modelName, $pk, $table));
}
private function formatModelString(string $modelName, string $pk, string $table): string
{
$content = '<?php
namespace App\Models;
use App\Models\BaseModel;
class {{__MODEL_NAME__}} extends BaseModel
{
/**
* 重定义主键
*
* @var string
*/
protected $primaryKey = \'{{__PK__}}\';
/**
* 与模型关联的表名
*
* @var string
*/
protected $table = \'{{__TABLE_NAME__}}\';
/**
* 指示是否自动维护时间戳
*
* @var bool
*/
public $timestamps = false;
}';
return str_replace(['{{__MODEL_NAME__}}','{{__PK__}}', '{{__TABLE_NAME__}}'],
[$modelName, $pk, $table], $content);
}
}