165/206 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░]  80%
   ErrorException 

  Undefined offset: 1

  at vendor/bennett-treptow/laravel-migration-generator/src/Tokenizers/MySQL/ColumnTokenizer.php:76
     72▕ 
     73▕         $this->resolveColumnMethod();
     74▕         if ($hasConstraints) {
     75▕             preg_match("/\((.+?)\)/", $originalColumnType, $constraintMatches);
  ➜  76▕             $matches = explode(',', $constraintMatches[1]);
     77▕             $this->resolveColumnConstraints($matches);
     78▕         }
     79▕     }
     80▕ 

CREATE TABLE `pr_feature` (
  `feature_id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sysname` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sysvalue` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pos` int unsigned DEFAULT '1',
  `status` tinyint(1) DEFAULT '1' COMMENT '0: disabled; 1:enabled',
  `cl_publication_type_publication_type_id` tinyint DEFAULT NULL,
  `editable_user_rights` tinyint NOT NULL COMMENT '0: feature is not editable by users; 1: show in overview user features editable',
  `category` enum('module','setting','special','publication_type','option','admin_option','admin_feature','admin_limit','admin_preset','deprecated') COLLATE utf8mb4_general_ci DEFAULT NULL,
  `feature_type` tinyint NOT NULL COMMENT '0: view(analytics); 1:property(500 mb)',
  `calculate` enum('one','and','highest or','lowest or','sum','highest position or','lowest position or') COLLATE utf8mb4_general_ci NOT NULL COMMENT 'set the way we calculate a feature value. with high or low or the sort is by position',
  PRIMARY KEY (`feature_id`),
  KEY `status` (`status`),
  KEY `sysname` (`sysname`),
  KEY `editable_user_rights` (`editable_user_rights`) USING BTREE,
  KEY `feature_type` (`feature_type`) USING BTREE,
  KEY `cl_publication_type_publication_type_id` (`cl_publication_type_publication_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

TypeError 

Argument 2 passed to LaravelMigrationGenerator\GeneratorManagers\MySQLGeneratorManager::handle() must be an instance of Illuminate\Console\OutputStyle, array given, called in /../vendor/bennett-treptow/laravel-migration-generator/src/Commands/GenerateMigrationsCommand.php on line 80

php artisan generate:migrations --path=database/migrations/test

Using connection mysql
Using [laravel path] as the output path..



   TypeError

  Return value of LaravelMigrationGenerator\Generators\BaseTableGenerator::getStubFileName() must be of the type string, null returned

  at [laravel path]\vendor\bennett-treptow\laravel-migration-generator\src\Generators\Concerns\WritesTablesToFile.php:41
     37▕                 $baseStubFileName = preg_replace("/\[" . $variable . "\]/i", $replacement, $baseStubFileName);
     38▕             }
     39▕         }
     40▕
  ➜  41▕         return $baseStubFileName;
     42▕     }
     43▕
     44▕     protected function getStubPath(): string
     45▕     {

  1   [laravel path]\vendor\bennett-treptow\laravel-migration-generator\src\Generators\Concerns\WritesToFile.php:16
      LaravelMigrationGenerator\Generators\BaseTableGenerator::getStubFileName()

  2   [laravel path]\vendor\bennett-treptow\laravel-migration-generator\src\GeneratorManagers\MySQLGeneratorManager.php:52
      LaravelMigrationGenerator\Generators\BaseTableGenerator::write()`

$table->string('name_base', 50)->default('')->unique('UniqueBaseName');

UNIQUE KEY `UniqueBaseName` (`name_base`)

$table->string('name_base', 50)->default('')->unique();

▶ php artisan generate:migrations --connection=pgsql
Using connection pgsql
The `pgsql` driver is not supported at this time.

Using connection mysql
Using /var/www/network/tests/database/migrations as the output path..

   1/103 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0% < 1 sec/< 1 sec 26.0 MiB
   ErrorException 

  Undefined offset: 0

  at vendor/bennett-treptow/laravel-migration-generator/src/Generators/Concerns/WritesTablesToFile.php:38
     34▕         $baseStubFileName = ConfigResolver::tableNamingScheme($driver);
     35▕         foreach ($this->stubNameVariables() as $variable => $replacement) {
     36▕             if (is_callable($replacement)) {
     37▕                 //replacement is a closure
  ➜  38▕                 [$variable, $replacement] = $replacement($baseStubFileName);
     39▕             }
     40▕             if ($variable === null) {
     41▕                 continue;
     42▕             }

`PHP Fatal error:  Cannot declare class CreateAllActivitiesHistoryTable, because the name is already in use in 
C:\Users\user1\dev\laravel\migratetest\database\migrations\create_all_activities_istory_table.php on line 7

   Symfony\Component\ErrorHandler\Error\FatalError

  Cannot declare class CreateAllActivitiesHistoryTable, because the name is already in use

  at C:\Users\user1\dev\laravel\migratetest\database\migrations\create_all_activities_history_table.php:7
      3▕ use Illuminate\Support\Facades\Schema;
      4▕ use Illuminate\Database\Schema\Blueprint;
      5▕ use Illuminate\Database\Migrations\Migration;
      6▕
      7▕ class CreateAllActivitiesHistoryTable extends Migration
      8▕ {
      9▕     /**
     10▕      * Run the migrations.
     11▕      *


   Whoops\Exception\ErrorException`

$table->unsignedInteger('id')->nullable(false)->primary();

$table->increments('id');

$table->integer(xx)->unsigned()

$table->unsignedInteger(xx)

php artisan generate:migrations --table="countries,states"

# php artisan generate:migrations
Using connection mysql
Using /var/www/html/tests/database/migrations as the output path..

   BadMethodCallException 

  Method LaravelMigrationGenerator\Commands\GenerateMigrationsCommand::newLine does not exist.

  at vendor/laravel/framework/src/Illuminate/Support/Traits/Macroable.php:103
     99|      */
    100|     public function __call($method, $parameters)
    101|     {
    102|         if (! static::hasMacro($method)) {
  > 103|             throw new BadMethodCallException(sprintf(
    104|                 'Method %s::%s does not exist.', static::class, $method
    105|             ));
    106|         }
    107| 

  • Bad Method Call: Did you mean LaravelMigrationGenerator\Commands\GenerateMigrationsCommand::line() ? 

      +14 vendor frames 
  15  artisan:37
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

$ php artisan generate:migrations --verbose
Using connection mysql
Using /home/jim/projects/maglr/dashboard/tests/database/migrations as the output path..

   MJS\TopSort\ElementNotFoundException 

  Dependency `REFERENCES` not found, required by `js_spread_text`

  at vendor/marcj/topsort/src/ElementNotFoundException.php:40
    36|      */
    37|     public static function create($source, $target)
    38|     {
    39|         $message = sprintf('Dependency `%s` not found, required by `%s`', $target, $source);
  > 40|         $exception = new static($message, 0, null, $source, $target);
    41| 
    42|         return $exception;
    43|     }
    44| 

  1   vendor/marcj/topsort/src/Implementations/ArraySort.php:77
      MJS\TopSort\ElementNotFoundException::create()

  2   vendor/marcj/topsort/src/Implementations/FixedArraySort.php:50
      MJS\TopSort\Implementations\ArraySort::visit()

  3   vendor/marcj/topsort/src/Implementations/FixedArraySort.php:33
      MJS\TopSort\Implementations\FixedArraySort::doSort()

  4   vendor/bennett-treptow/laravel-migration-generator/src/Helpers/DependencyResolver.php:51
      MJS\TopSort\Implementations\FixedArraySort::sort()

  5   vendor/bennett-treptow/laravel-migration-generator/src/Helpers/DependencyResolver.php:21
      LaravelMigrationGenerator\Helpers\DependencyResolver::build()

  6   vendor/bennett-treptow/laravel-migration-generator/src/GeneratorManagers/BaseGeneratorManager.php:105
      LaravelMigrationGenerator\Helpers\DependencyResolver::__construct()

  7   vendor/bennett-treptow/laravel-migration-generator/src/GeneratorManagers/BaseGeneratorManager.php:87
      LaravelMigrationGenerator\GeneratorManagers\BaseGeneratorManager::sortTables()

  8   vendor/bennett-treptow/laravel-migration-generator/src/Commands/GenerateMigrationsCommand.php:80
      LaravelMigrationGenerator\GeneratorManagers\BaseGeneratorManager::handle()

  9   vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
      LaravelMigrationGenerator\Commands\GenerateMigrationsCommand::handle()

php artisan generate:migrations
Using connection mysql
Using /app/tests/database/migrations as the output path..

   Error 

  Typed property LaravelMigrationGenerator\Definitions\IndexDefinition::$foreignReferencedTable must not be accessed before initialization

  at vendor/bennett-treptow/laravel-migration-generator/src/Definitions/IndexDefinition.php:74
     70▕      * @return string
     71▕      */
     72▕     public function getForeignReferencedTable(): string
     73▕     {
  ➜  74▕         return $this->foreignReferencedTable;
     75▕     }
     76▕
     77▕     /**
     78▕      * @return array

      +18 vendor frames
  19  artisan:37
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

[2022-01-24 19:29:21] local.ERROR: Typed property LaravelMigrationGenerator\Definitions\IndexDefinition::$foreignReferencedTable must not be accessed before initialization {"exception":"[object] (Error(code: 0): Typed property LaravelMigrationGenerator\\Definitions\\IndexDefinition::$foreignReferencedTable must not be accessed before initialization at /app/vendor/bennett-treptow/laravel-migration-generator/src/Definitions/IndexDefinition.php:74)
[stacktrace]
#0 /app/vendor/bennett-treptow/laravel-migration-generator/src/Helpers/DependencyResolver.php(37): LaravelMigrationGenerator\\Definitions\\IndexDefinition->getForeignReferencedTable()
#1 /app/vendor/bennett-treptow/laravel-migration-generator/src/Helpers/DependencyResolver.php(21): LaravelMigrationGenerator\\Helpers\\DependencyResolver->build()
#2 /app/vendor/bennett-treptow/laravel-migration-generator/src/GeneratorManagers/BaseGeneratorManager.php(105): LaravelMigrationGenerator\\Helpers\\DependencyResolver->__construct(Array)
#3 /app/vendor/bennett-treptow/laravel-migration-generator/src/GeneratorManagers/BaseGeneratorManager.php(87): LaravelMigrationGenerator\\GeneratorManagers\\BaseGeneratorManager->sortTables(Array)
#4 /app/vendor/bennett-treptow/laravel-migration-generator/src/Commands/GenerateMigrationsCommand.php(80): LaravelMigrationGenerator\\GeneratorManagers\\BaseGeneratorManager->handle('/app/tests/data...', Array, Array)
#5 /app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): LaravelMigrationGenerator\\Commands\\GenerateMigrationsCommand->handle()
#6 /app/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 /app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 /app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#9 /app/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#10 /app/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)
#11 /app/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#12 /app/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#13 /app/vendor/symfony/console/Application.php(1005): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#14 /app/vendor/symfony/console/Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand(Object(LaravelMigrationGenerator\\Commands\\GenerateMigrationsCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#15 /app/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#16 /app/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#17 /app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#18 /app/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#19 {main}
"} 

php artisan generate:migrations --seed=model --transaction
php artisan generate:migrations --seed=table // no transaction

class UserSeeder extends Seeder
{
    public function run()
    {
        // With or without closure transaction
        DB::transaction(function () {

            // Multiple insertions
            DB::table('users')->insert(['name1..' => 'Name', 'email' => 'email1...', 'password' => 'hash1...']);
            DB::table('users')->insert(['name2..' => 'Name', 'email' => 'email2...', 'password' => 'hash2...']);
            DB::table('users')->insert(['name3..' => 'Name', 'email' => 'email3...', 'password' => 'hash3...']);

            // Or multiple creations
            User::create(['name1..' => 'Name', 'email' => 'email1...', 'password' => 'hash1...']);
            User::create(['name2..' => 'Name', 'email' => 'email2...', 'password' => 'hash3...']);
            User::create(['name3..' => 'Name', 'email' => 'email3...', 'password' => 'hash3...']);
        });


        // or data in array
        $data = [
            ['name1..' => 'Name', 'email' => 'email1...', 'password' => 'hash1...'],
            ['name2..' => 'Name', 'email' => 'email2...', 'password' => 'hash2...'],
            ['name3..' => 'Name', 'email' => 'email3...', 'password' => 'hash3...'],
        ];

        // Transaction in another way
        try {
            DB::beginTransaction();
            foreach ($data as $item) {
                // table
                DB::table('users')->insert($item);
                // model
                User::create($item);
            }
            DB::commit();
        } catch (Throwable $e) {
            DB::rollback();
        }
    }
}

 Error

  Call to a member function filter() on array

  at vendor/bennett-treptow/laravel-migration-generator/src/GeneratorManagers/BaseGeneratorManager.php:79
     75▕                 return in_array($viewGenerator->getViewName(), $viewNames);
     76▕             })->toArray();
     77▕         }
     78▕
  ➜  79▕         $tableDefinitions = $tableDefinitions->filter(function ($tableDefinition) {
     80▕             return ! $this->skipTable($tableDefinition->getTableName());
     81▕         });
     82▕
     83▕         $viewDefinitions = $viewDefinitions->filter(function ($viewDefinition) {

      +14 vendor frames
  15  artisan:37
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

php artisan vendor:publish --provider="LaravelMigrationGenerator\LaravelMigrationGeneratorProvider"