Download the PHP package bennett-treptow/laravel-migration-generator without Composer

On this page you can find all versions of the php package bennett-treptow/laravel-migration-generator. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of bennett-treptow/laravel-migration-generator

Informations about the package laravel-migration-generator

Laravel Migration Generator

Latest Version on Packagist

Generate migrations from existing database structures, an alternative to the schema dump provided by Laravel. A primary use case for this package would be a project that has many migrations that alter tables using ->change() from doctrine/dbal that SQLite doesn't support and need a way to get table structures updated for SQLite to use in tests. Another use case would be taking a project with a database and no migrations and turning that database into base migrations.

Installation

Lumen Installation

Copy config file from vendor/bennett-treptow/laravel-migration-generator/config to your Lumen config folder

Register service provider in bootstrap/app.php

Usage

Whenever you have database changes or are ready to squash your database structure down to migrations, run:

By default, the migrations will be created in tests/database/migrations. You can specify a different path with the --path option:

You can specify the connection to use as the database with the --connection option:

You can also clear the directory with the --empty-path option:

This command can also be run by setting the LMG_RUN_AFTER_MIGRATIONS environment variable to true and running your migrations as normal. This will latch into the MigrationsEnded event and run this command using the default options specified via your environment variables. Note: it will only run when your app environment is set to local.

Configuration

Want to customize the migration stubs? Make sure you've published the vendor assets with the artisan command to publish vendor files above.

Environment Variables

Key Default Value Allowed Values Description
LMG_RUN_AFTER_MIGRATIONS false boolean Whether or not the migration generator should run after migrations have completed.
LMG_CLEAR_OUTPUT_PATH false boolean Whether or not to clear out the output path before creating new files. Same as specifying --empty-path on the command
LMG_TABLE_NAMING_SCHEME [Timestamp]_create_[TableName]_table.php string The string to be used to name table migration files
LMG_VIEW_NAMING_SCHEME [Timestamp]_create_[ViewName]_view.php string The string to be used to name view migration files
LMG_OUTPUT_PATH tests/database/migrations string The path (relative to the root of your project) to where the files will be output to. Same as specifying --path= on the command
LMG_SKIPPABLE_TABLES migrations comma delimited string The tables to be skipped
LMG_SKIP_VIEWS false boolean When true, skip all views
LMG_SKIPPABLE_VIEWS '' comma delimited string The views to be skipped
LMG_SORT_MODE 'foreign_key' string The sorting mode to be used. Options: foreign_key
LMG_PREFER_UNSIGNED_PREFIX true boolean When true, uses unsigned variant methods instead of the ->unsigned() modifier.
LMG_USE_DEFINED_INDEX_NAMES true boolean When true, uses index names defined by the database as the name parameter for index methods
LMG_USE_DEFINED_FOREIGN_KEY_INDEX_NAMES true boolean When true, uses foreign key index names defined by the database as the name parameter for foreign key methods
LMG_USE_DEFINED_UNIQUE_KEY_INDEX_NAMES true boolean When true, uses unique key index names defined by the database as the name parameter for the unique methods
LMG_USE_DEFINED_PRIMARY_KEY_INDEX_NAMES true boolean When true, uses primary key index name defined by the database as the name parameter for the primary method
LMG_WITH_COMMENTS true boolean When true, export comment using ->comment() method.
LMG_USE_DEFINED_DATATYPE_ON_TIMESTAMP false boolean When false, uses ->timestamps() by mashing up created_at and updated_at regardless of datatype defined by the database
LMG_MYSQL_TABLE_NAMING_SCHEME null ?boolean When not null, this setting will override LMG_TABLE_NAMING_SCHEME when the database driver is mysql.
LMG_MYSQL_VIEW_NAMING_SCHEME null ?boolean When not null, this setting will override LMG_VIEW_NAMING_SCHEME when the database driver is mysql.
LMG_MYSQL_OUTPUT_PATH null ?boolean When not null, this setting will override LMG_OUTPUT_PATH when the database driver is mysql.
LMG_MYSQL_SKIPPABLE_TABLES null ?boolean When not null, this setting will override LMG_SKIPPABLE_TABLES when the database driver is mysql.
LMG_MYSQL_SKIPPABLE_VIEWS null comma delimited string The views to be skipped when driver is mysql
LMG_SQLITE_TABLE_NAMING_SCHEME null ?boolean When not null, this setting will override LMG_TABLE_NAMING_SCHEME when the database driver is sqlite.
LMG_SQLITE_VIEW_NAMING_SCHEME null ?boolean When not null, this setting will override LMG_VIEW_NAMING_SCHEME when the database driver is sqlite.
LMG_SQLITE_OUTPUT_PATH null ?boolean When not null, this setting will override LMG_OUTPUT_PATH when the database driver is sqlite.
LMG_SQLITE_SKIPPABLE_TABLES null ?boolean When not null, this setting will override LMG_SKIPPABLE_TABLES when the database driver is sqlite.
LMG_SQLITE_SKIPPABLE_VIEWS null comma delimited string The views to be skipped when driver is sqlite
LMG_PGSQL_TABLE_NAMING_SCHEME null ?boolean When not null, this setting will override LMG_TABLE_NAMING_SCHEME when the database driver is pgsql.
LMG_PGSQL_VIEW_NAMING_SCHEME null ?boolean When not null, this setting will override LMG_VIEW_NAMING_SCHEME when the database driver is pgsql.
LMG_PGSQL_OUTPUT_PATH null ?boolean When not null, this setting will override LMG_OUTPUT_PATH when the database driver is pgsql.
LMG_PGSQL_SKIPPABLE_TABLES null ?boolean When not null, this setting will override LMG_SKIPPABLE_TABLES when the database driver is pgsql.
LMG_PGSQL_SKIPPABLE_VIEWS null comma delimited string The views to be skipped when driver is pgsql
LMG_SQLSRV_TABLE_NAMING_SCHEME null ?boolean When not null, this setting will override LMG_TABLE_NAMING_SCHEME when the database driver is sqlsrc.
LMG_SQLSRV_VIEW_NAMING_SCHEME null ?boolean When not null, this setting will override LMG_VIEW_NAMING_SCHEME when the database driver is sqlsrv.
LMG_SQLSRV_OUTPUT_PATH null ?boolean When not null, this setting will override LMG_OUTPUT_PATH when the database driver is sqlsrv.
LMG_SQLSRV_SKIPPABLE_TABLES null ?boolean When not null, this setting will override LMG_SKIPPABLE_TABLES when the database driver is sqlsrv.
LMG_SQLSRV_SKIPPABLE_VIEWS null comma delimited string The views to be skipped when driver is sqlsrv

Stubs

There is a default stub for tables and views, found in resources/stubs/vendor/laravel-migration-generator/. Each database driver can be assigned a specific migration stub by creating a new stub file in resources/stubs/vendor/laravel-migration-generator/ with a driver-prefix, e.g. mysql-table.stub for a MySQL specific table stub.

Stub Naming

Table and view stubs can be named using the LMG_(TABLE|VIEW)_NAMING_SCHEME environment variables. Optionally, driver-specific naming schemes can be used as well by specifying LMG_{driver}_TABLE_NAMING_SCHEME environment vars using the same tokens. See below for available tokens that can be replaced.

Table Name Stub Tokens

Table stubs have the following tokens available for the naming scheme:

Token Example Description
[TableName] users Table's name, same as what is defined in the database
[TableName:Studly] Users Table's name with Str::studly() applied to it (useful for standardizing table names if they are inconsistent)
[TableName:Lowercase] users Table's name with strtolower applied to it (useful for standardizing table names if they are inconsistent)
[Timestamp] 2021_04_25_110000 The standard migration timestamp format, at the time of calling the command: Y_m_d_His
[Index] 0 The key of the migration in the sorted order, for use with enforcing a sort order
[IndexedEmptyTimestamp] 0000_00_00_000041 The standard migration timestamp format, but filled with 0s and incremented by [Index] seconds
[IndexedTimestamp] 2021_04_25_110003 The standard migration timestamp format, at the time of calling the command: Y_m_d_His incremented by [Index] seconds

Table Schema Stub Tokens

Table schema stubs have the following tokens available:

Token Description
[TableName] Table's name, same as what is defined in the database
[TableName:Studly] Table's name with Str::studly() applied to it, for use with the class name
[TableUp] Table's up() function
[TableDown] Table's down() function
[Schema] The table's generated schema

View Name Stub Tokens

View stubs have the following tokens available for the naming scheme:

Token Example Description
[ViewName] user_earnings View's name, same as what is defined in the database
[ViewName:Studly] UserEarnings View's name with Str::studly() applied to it (useful for standardizing view names if they are inconsistent)
[ViewName:Lowercase] user_earnings View's name with strtolower applied to it (useful for standardizing view names if they are inconsistent)
[Timestamp] 2021_04_25_110000 The standard migration timestamp format, at the time of calling the command: Y_m_d_His
[Index] 0 The key of the migration in the sorted order, for use with enforcing a sort order
[IndexedEmptyTimestamp] 0000_00_00_000041 The standard migration timestamp format, but filled with 0s and incremented by [Index] seconds
[IndexedTimestamp] 2021_04_25_110003 The standard migration timestamp format, at the time of calling the command: Y_m_d_His incremented by [Index] seconds

View Schema Stub Tokens

View schema stubs have the following tokens available:

Token Description
[ViewName] View's name, same as what is defined in the database
[ViewName:Studly] View's name with Str::studly() applied to it, for use with the class name
[Schema] The view's schema

Example Usage

Given a database structure for a users table of:

A tests/database/migrations/[TIMESTAMP]_create_users_table.php with the following Blueprint would be created:

Currently Supported DBMS's

These DBMS's are what are currently supported for creating migrations from. Migrations created will, as usual, follow what database drivers Laravel migrations allow for

All versions of laravel-migration-generator with dependencies

PHP Build Version
Package Version
Requires php Version ^7.4|~8.0
illuminate/support Version ^6.0|^7.0|^8.0|^9.0|^10.0|^11.0
illuminate/console Version ^6.0|^7.0|^8.0|^9.0|^10.0|^11.0
illuminate/database Version ^6.0|^7.0|^8.0|^9.0|^10.0|^11.0
illuminate/config Version ^6.0|^7.0|^8.0|^9.0|^10.0|^11.0
marcj/topsort Version ^2.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package bennett-treptow/laravel-migration-generator contains the following files

Loading the files please wait ....