[php] [phpsandbox] [laravel] create table from json

 

create laravel project
composer create-project --prefer-dist laravel/laravel app

install json-to-laravel-migrations package
composer require --dev andyabih/json-to-laravel-migrations

Create a schema.json file in the root of your project, and use a template like the below:
{ "posts": { "name" : "string:50|index:50", "state" : "enum:active,inactive|default:active", "text" : "text", "slug" : "string:50|unique", "active" : "boolean|default:false", "user_id": "foreign|nullable|constrained|onDelete" }, "categories": { "name" : "string", "image": "string" }, "subcategories": { "name" : "string", "category_id": "foreign|constrained" } }

Run the above using:
php artisan json:migrate schema.json

The above schema will create something three different migrations. The posts schema will look like:
<?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePostsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('posts', function (Blueprint $table) { $table->id(); $table->string("name", 50)->index(); $table->enum("state", ['active', 'inactive'])->default('active'); $table->text("text"); $table->string("slug", 50)->unique(); $table->boolean("active")->default(false); $table->foreignId("user_id")->nullable(true)->constrained()->onDelete('cascade'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('posts'); } }

ref:
JSON to Laravel Migrations