developerawam/generate-migration

This package automatically generates migration files for your Laravel application. With this feature, you can quickly create database structures without writing SQL code manually. Simply specify the model you want to create, and this package will handle the rest, streamlining development and minimiz

v2.0.5 2024-08-13 04:19 UTC

This package is auto-updated.

Last update: 2024-11-13 04:50:43 UTC


README

Latest Version on Packagist Total Downloads

This package automatically create and generate migration files for your Laravel application. With this feature, you can quickly create database structures without writing SQL code manually. Simply specify the model you want to create, and this package will handle the rest, streamlining development and minimizing human errors.

Requirements

  • Laravel 11
  • PHP ^8.0
  • TailwindCSS ^3.4

Installation

You can install the package via composer:

composer require developerawam/generate-migration

Publish the Assets

Run the following Artisan command to publish the assets to your Laravel application's public directory:

php artisan vendor:publish --tag=assets

Usage

After installation, you can access the user interface to auto create generate models, migrations, and tables by visiting the following URL in your browser:

/generate-migration/generate-ui

This screenshot showcases the user interface provided by the package. The interface allows users to easily generate models, migrations, and database tables in a Laravel project through a simple and intuitive UI.

UI Screenshot

Use the GenerateMigration class to create a migration with the desired table name and columns. The example code below demonstrates how to create a migration for a post table with columns:

    use Developerawam\GenerateMigration\GenerateMigration;

    // table name example
    $table_name = "post";

    // table column example
    $table_colom = [
        [
            "name"      => "name",
            "type"      => "string",
            "default"   => null
        ],
        [
            "name"      => "description",
            "type"      => "text",
            "default"   => null
        ],
        [
            "name"      => "age",
            "type"      => "integer",
            "default"   => 20
        ],
        [
            "name"      => "views",
            "type"      => "bigInteger",
            "default"   => 0
        ],
        [
            "name"      => "price",
            "type"      => "decimal",
            "precision" => 8,
            "scale"     => 2,
            "default"   => 0.00
        ],
        [
            "name"      => "rating",
            "type"      => "float",
            "precision" => 8,
            "scale"     => 2,
            "default"   => 0.00
        ],
        [
            "name"      => "birthdate",
            "type"      => "date",
            "default"   => "2000-01-01"
        ],
        [
            "name"      => "appointment_time",
            "type"      => "time",
            "default"   => "12:00:00"
        ],
        [
            "name"      => "created_at",
            "type"      => "timestamp",
            "default"   => "CURRENT_TIMESTAMP"
        ],
        [
            "name"      => "is_active",
            "type"      => "boolean",
            "default"   => true
        ],
        [
            "name"      => "status",
            "type"      => "enum",
            "values"    => ["pending", "approved", "rejected"],
            "default"   => "pending"
        ],
        [
            "name"      => "settings",
            "type"      => "json",
            "default"   => "{\"theme\": \"dark\", \"notifications\": true}"
        ]
    ];

    // table_name must be string
    // table_column must be array object
    GenerateMigration::create($table_name, $table_colom);

Code Explanation

  • $table_name: The name of the table you want to create, in this case, post.
  • $table_columns: An array of columns to be created in the table. Each column is an array containing the column name (name) and data type (type).
  • GenerateMigration::create($table_name, $table_columns): Calls the create method from the GenerateMigration class to create a migration based on the specified table name and columns.

Testing

composer test

Laravel Package Boilerplate

This package was generated using the Laravel Package Boilerplate.

Support the Project

If you find this project useful and would like to support its development, you can make a donation: