Generathor Laravel

Generathor Laravel allows you to automatically generate Eloquent models and CRUD operations based on your database structure.

---

Table of Contents

1. Installation
2. Generating Files
   1. Generating Eloquent Models
   2. Generating Eloquent Models and CRUDs
3. Additional Settings
4. Files
5. TODO

---

Installation

To begin using Generathor Laravel, install the necessary dependencies:

$ npm i -D generathor generathor-db generathor-laravel mysql2

Then, create the generathor configuration file:

$ touch generathor.config.cjs

The content of the configuration file will depend on what you want to generate.

Add the following script to your package.json:

"scripts": {
  "generathor": "generathor -c generathor.config.cjs"
}

---

Generating Files

Whether you need to generate Eloquent models or CRUDs, you must install the PHP dependencies by running the following command:

$ composer require tucker-eric/eloquentfilter kyslik/column-sortable

Next, follow one of the steps below.

---

Generating Eloquent Models

Your generathor.config.cjs file should look like this:

const { Source } = require('generathor-db');
const { LaravelGenerator } = require('generathor-laravel');

const laravel = new LaravelGenerator({
  createEloquentModelsOnly: true
});
const dbSource = new Source({
  type: 'mysql',
  configuration: {
    host: 'localhost',
    port: '3306',
    user: 'my_user',
    password: 'my_password',
    database: 'my_database'
  },
  excludes: ['migrations']
}, [
  laravel.transformer.bind(laravel)
]);

module.exports = {
  sources: {
    db: dbSource,
  },
  generators: laravel.generators()
};

Then, run the following command:

$ npm run generathor

---

Generating Eloquent Models and CRUDs

Your generathor.config.cjs file should look like this:

const { Source } = require('generathor-db');
const { LaravelGenerator } = require('generathor-laravel');

const laravel = new LaravelGenerator();
const dbSource = new Source({
  type: 'mysql',
  configuration: {
    host: 'localhost',
    port: '3306',
    user: 'my_user',
    password: 'my_password',
    database: 'my_database'
  },
  excludes: ['migrations']
}, [
  laravel.transformer.bind(laravel)
]);

module.exports = {
  sources: {
    db: dbSource,
  },
  generators: laravel.generators()
};

Then, run the following command:

$ npm run generathor

To make everything work, it's necessary to set up other things in your project:

Installing frontend dependencies

You need to install TailwindCSS: https://tailwindcss.com/docs/guides/laravel

Also, you need to install the following packages:

• alpinejs
• @alpinejs/collapse
• laravel-precognition-alpine
• sweetalert2
• @fortawesome/fontawesome-free

npm i -D alpinejs @alpinejs/collapse laravel-precognition-alpine sweetalert2 @fortawesome/fontawesome-free

File app.js must contain:

import Alpine from 'alpinejs';
import collapse from '@alpinejs/collapse'
import Precognition from 'laravel-precognition-alpine';
import Swal from 'sweetalert2';

window.Alpine = Alpine;
window.Swal = Swal;

Alpine.plugin(Precognition);
Alpine.plugin(collapse);
Alpine.start();

File app.css must contain:

@import "@fortawesome/fontawesome-free/css/all.css";

Expose the routes

Add generatehor routes to routes/web.php:

Route::prefix('manage')->group(function () {
    require __DIR__.'/generathor.php';
});

Set up your 'home' route

You neet to set up your home route. You can change the home route reference in the generathor.config.cjs file.

Route::get('/', function () {
    return view('welcome');
})->name('home');

Set up datepickers (optional)

Install the following package:

npm i -D flatpickr

Add the following code to app.js:

import flatpickr from 'flatpickr';

flatpickr('.input-datetime', {
  enableTime: true,
  enableSeconds: true,
  dateFormat: 'Y-m-d H:i:S',
});
flatpickr('.input-date', {
  dateFormat: 'Y-m-d',
});
flatpickr('.input-time', {
  noCalendar: true,
  enableTime: true,
  enableSeconds: true,
  dateFormat: 'H:i:S',
});

Add the following code to app.css:

@import "flatpickr/dist/flatpickr.css";

Set up loading spinner (optional)

Add the following code to app.js:

const loader = document.getElementById('generathor-loader');
window.showLoading = () => {
  if (loader) {
    loader.classList.remove('hidden');
    loader.classList.add('flex');
  }
};
window.hideLoading = () => {
  if (loader) {
    loader.classList.remove('flex');
    loader.classList.add('hidden');
  }
};

const forms = document.getElementsByTagName('form');
for (const form of forms) {
  form.addEventListener('submit', window.showLoading);
}

// Only for Livewire
if (typeof Livewire !== undefined) {
  Livewire.hook('commit', ({ succeed, fail }) => {
    succeed(() => {
      window.hideLoading();
    });
    fail(() => {
      window.hideLoading();
    });
  });
}

Add the following code in layout.blade.php or in your layout:

<x-generathor.loader />

Set up header (optional)

You can define a header in your layout. For example, in layout.blade.php or in your layout:

@if(isset($header))
<div>
    {{$header}}
</div>
@endif

---

Additional settings

You can modify settings in the generathor.config.cjs file.

Variable	Required	Type	Default	Description
createChildModel	No	boolean	true	Prevents overwriting the child class of a model, so you retain your custom changes.
createEloquentModelsOnly	No	boolean	false	Creates only Eloquent models, skipping the generation of other files.
reference	No	string	'laravel-generathor'	Reference name used in templates.
source	No	string	'db'	Reference to the Generathor source for database structure.
directory	No	string	'.'	Directory path for the Laravel project.
homeRoute	No	string	'home'	Initial base route, used for redirection to the home page.
layout	No	string	'layout'	Main layout of your project.
eloquent	No	object		Object for defining parent classes for models.
eloquent.parent	No	string	'Illuminate\Database\Eloquent\Model'	General parent class for models.
eloquent.customParents	No	Record<string, string>	{}	Parent class by table, allowing custom parent classes for specific tables.

Example

const { Source } = require('generathor-db');
const { LaravelGenerator }= require('generathor-laravel-testing');

const laravel = new LaravelGenerator({
  ccreateChildModel: true,
  createEloquentModelsOnly: false,
  reference: 'laravel',
  source: 'db2',
  directory: './project',
  homeRoute: 'index',
  layout: 'app',
  eloquent: {
    parent: 'App\\Models\\Model',
    customParents: {
      users: 'App\\Models\\Jetstream\\User as Model',
    }
  }
});
const dbSource = new Source({
  type: 'mysql',
  configuration: {
    host: 'localhost',
    port: '3306',
    user: 'my_user',
    password: 'my_password',
    database: 'my_database'
  },
  excludes: ['migrations']
}, [
  laravel.transformer.bind(laravel)
]);

module.exports = {
  sources: {
    db: dbSource,
  },
  generators: laravel.generators()
};

---

Files

• app/Models/Generathor/[model].php (for each table)
• app/Models/[model].php (for each table)
• app/ModelFilters/[filter].php (for each table)
• app/Http/Requests/Generathor/[create-request].php (for each table)
• app/Http/Requests/Generathor/[update-request].php (for each table)
• app/Http/Requests/Generathor/[filter-request].php (for each table)
• app/Http/Requests/Generathor/[attach-request].php (for each 'has-many' relationship in each table)
• resources/views/generathor/menu.blade.php
• routes/generathor.php
• app/Http/Controllers/Generathor/Controller.php
• app/Http/Controllers/Generathor/[controller].php (for each table)
• resources/views/generathor/[table-context]/index.blade.php (for each table)
• resources/views/generathor/[table-context]/edit.blade.php (for each table)
• resources/views/generathor/[table-context]/show.blade.php (for each table)
• resources/views/generathor/[table-context]/[relation].blade.php (for each relationship in each table)
• resources/views/components/generathor/[table-context]/create-form.blade.php (for each table)
• resources/views/components/generathor/[table-context]/filter-form.blade.php (for each table)
• resources/views/components/generathor/[table-context]/update-form.blade.php (for each table)
• resources/views/components/generathor/[table-context]/[attach-form].blade.php (for each 'has-many' relationship in each table)
• resources/views/components/generathor/[table-context]/[create-form].blade.php (for each relationship in each table)
• resources/views/components/generathor/[table-context]/[filter-form].blade.php (for each 'has-many' relationship in each table)
• app/Models/Generathor/GenerathorKey.php
• resources/views/components/generathor/record-input.blade.php
• resources/views/components/generathor/breadcrumbs.blade.php
• resources/views/components/generathor/tabs.blade.php
• resources/views/components/generathor/modal.blade.php
• resources/views/components/generathor/loader.blade.php
• resources/views/components/generathor/icon-check-circle.blade.php
• resources/views/components/generathor/icon-chevron-right.blade.php
• resources/views/components/generathor/icon-computer.blade.php
• resources/views/components/generathor/icon-eye.blade.php
• resources/views/components/generathor/icon-funnel.blade.php
• resources/views/components/generathor/icon-home.blade.php
• resources/views/components/generathor/icon-pencil.blade.php
• resources/views/components/generathor/icon-plus.blade.php
• resources/views/components/generathor/icon-trash.blade.php
• resources/views/components/generathor/icon-x-circle.blade.php
• resources/views/components/generathor/icon-x.blade.php
• resources/views/components/generathor/icon-chevron-down.blade.php
• resources/views/components/generathor/icon-list-bullet.blade.php
• resources/views/components/generathor/icon-link.blade.php
• resources/views/components/generathor/icon-unlink.blade.php

---

TODO

• [ ] Separate inputs into components.
• [ ] Customize inputs based on prefix or specific logic.
• [ ] TBD