我想制作一個 Laravel 管理包，并且想制作具有動態(tài)角色的動態(tài)面板，為此目的I need a way to get the all table names with their properties，那么在 Laravel 中獲取這些數(shù)據(jù)的合適方法是什么？
1 回答
縹緲止盈
TA貢獻2041條經(jīng)驗 獲得超4個贊
if (config('database.default') == 'pgsql') {
$database_name = 'laravel';
$tables = DB::select("SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'");
foreach ($tables as $table) {
$tablename = $table->table_name;
if ($tablename == 'model_has_permissions' || $tablename == 'password_resets'|| $tablename == 'model_has_roles'
|| $tablename == 'model_has_permissions'|| $tablename == 'role_has_permissions') {
continue;
}
DB::select("
SELECT setval(pg_get_serial_sequence('$table->table_name' , 'id'), coalesce(max(id)+1, 1), false)
FROM ".$tablename.";
");
}
}
LEATH
TA貢獻1936條經(jīng)驗 獲得超7個贊
- 1 回答
- 0 關注
- 241 瀏覽
添加回答
舉報
0/150
提交
取消