pkeidel/dbtolaravel

Reads a database and creates the migrations, models, controllers and blades for the tables

v2.0.5 2024-07-19 20:32 UTC

Requires

• php: ^8.1
• doctrine/dbal: ^3.7
• jfcherng/php-diff: ^6.15

MIT

• PKeidel

• laravel5
• dbtolaravel
• db2laravel
• laravel6

README

With this package it is possible to auto-generate a lot of needed files if you already have an existing database schema. Files that can be generated:

• migration
• model
• views to view a single model, edit a single model and list all models
• controller
• route
• seeder with existing data

Install

composer require pkeidel/dbtolaravel

DB2Laravel is only active if APP_DEBUG=true or DBTOLARAVEL_ENABLED=true

usage

• visit yoururl/dbtolaravel, for example http://127.0.0.1/dbtolaravel
• you can select a configured database connection
• in the table you can create all files of view a diff to compare the file to an existing one

Filter Tables

Register a filter in your AppServiceProvider.php:

DBtoLaravelHelper::$FILTER = function($table) {
    return strpos($table, 'eyewitness_io_') !== 0 && strpos($table, 'oauth_') !== 0;
};

Override type mapping

DBtoLaravelHelper::$MAPPINGS = ['enum' => 'string', 'bytea' => 'binary', 'macaddr' => 'string'];