PHPackages                             bitsnio/json-to-migration-laravel - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. bitsnio/json-to-migration-laravel

ActiveLibrary[Database & ORM](/categories/database)

bitsnio/json-to-migration-laravel
=================================

Turn a JSON schema into Laravel migrations.

v2.0.1(2y ago)021MITPHP

Since Apr 30Pushed 2y ago1 watchersCompare

[ Source](https://github.com/Shehryar-bitsnio/json_to_migration_laravel)[ Packagist](https://packagist.org/packages/bitsnio/json-to-migration-laravel)[ RSS](/packages/bitsnio-json-to-migration-laravel/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (2)Dependencies (1)Versions (3)Used By (0)

JSON to Laravel Migrations
==========================

[](#json-to-laravel-migrations)

Simply create a .json file with the schema for your database, and run the artisan command `json:migrate Template.json` to create all the migrations for your project.

**Note:** This package is built to be used to kickstart your Laravel projects, and not to use on something that's already been built.

---

Installation
------------

[](#installation)

You can install this package by running the below composer command:

```
composer require --dev bitsnio/json-to-migration-laravel

```

---

Creating the JSON Template
--------------------------

[](#creating-the-json-template)

Create a `Template.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"
    }
}
```

The main keys of your JSON represent the table names. Make sure to create them in order in case a table has a relationship with another. In this case, `posts`, `categories`, and `subcategories` are our tables.

Next, for each table, define your columns as keys (so `name`, `state`, `text`, ... in this case), and set their properties.

Properties
----------

[](#properties)

Properties are separated with a pipe (`|`), and the first property should always be the column type. The package supports every column type in Laravel.

Additional options (such as string length) can be supplied using a colon (`:`), followed by the value of the option. Multiple options can be supplied (for `float`, for example).

Migrations
----------

[](#migrations)

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:

```