wink/wink-model-generator

A powerful Laravel package that automatically generates Eloquent models from your existing database schema, supporting both MySQL and SQLite databases

Fund package maintenance!
wink-


README

Latest Version on Packagist Tests Total Downloads License

A focused Laravel package that automatically generates Eloquent models and factories from your existing database schema. For API Resource and Controller generation, check out our companion package wink-resource-generator.

Features

  • Supports MySQL, PostgreSQL, and SQLite databases (including in-memory SQLite for testing)
  • Generates complete model files with proper namespacing and comprehensive Laravel model properties
  • Smart property detection: auto-detects primary keys, key types, incrementing, soft deletes
  • Enhanced security: automatically hides sensitive fields (passwords, tokens, etc.)
  • Flexible mass assignment: configurable $fillable vs $guarded approaches
  • Complete property support: $hidden, $visible, $attributes, $with, $perPage, etc.
  • Auto-detects relationships from foreign keys
  • Configurable model generation options via comprehensive config file
  • Generates PHPDoc properties for better IDE support
  • Includes validation rules based on schema
  • Handles custom database connections
  • Optional model factory generation with automatic exclusion of auto-incremented fields
  • Optional model observer generation
  • Connection-based directory structure for multi-database projects
  • PSR-4 namespace validation and auto-correction
  • Compatible with PHP 8.3+ and Laravel 11+

Installation

You can install the package via composer:

composer require wink/wink-model-generator --dev

Related Packages

Configuration

You can publish the configuration file with:

php artisan vendor:publish --provider="Wink\ModelGenerator\ModelGeneratorServiceProvider" --tag="config"

This will create a config/model-generator.php file with comprehensive configuration options:

return [
    // Basic configuration
    'default_connection' => 'mysql',
    'excluded_tables' => ['migrations', 'failed_jobs', /* ... */],

    // Model Property Generation Options
    'model_properties' => [
        // Auto-detect primary key from schema instead of hardcoding 'id'
        'auto_detect_primary_key' => true,

        // Generate $hidden array for sensitive fields (password, token, etc.)
        'auto_hidden_fields' => true,
        'hidden_field_patterns' => ['password', 'token', 'secret', 'key', 'hash'],

        // Generate $guarded array (alternative to $fillable)
        'use_guarded_instead_of_fillable' => false,
        'guarded_fields' => ['id', 'created_at', 'updated_at'],

        // Pagination settings
        'per_page' => null, // Set to integer to override default pagination

        // Date format customization
        'date_format' => 'Y-m-d H:i:s', // Laravel default

        // Auto-generate $attributes for default values based on schema
        'auto_default_attributes' => true,

        // Auto-generate $with for common relationships
        'auto_eager_load' => false,
        'eager_load_relationships' => [], // e.g., ['user', 'category']

        // Soft delete detection
        'auto_detect_soft_deletes' => true,

        // Generate $visible array (alternative to $hidden)
        'use_visible_instead_of_hidden' => false,
    ],

    // Custom field type mappings
    'custom_casts' => [
        // Add custom cast mappings here
    ],

    // Validation rules generation
    'validation' => [
        'generate_rules' => true,
        'strict_rules' => false,
        'include_unique_rules' => true,
    ],
];

Model Property Generation

The package now automatically generates comprehensive Laravel model properties based on your database schema:

Smart Detection:

  • Primary Keys: Auto-detects from schema instead of hardcoding 'id'
  • Key Types: Sets $keyType to 'string' for UUID/varchar keys, 'int' for integers
  • Incrementing: Sets $incrementing = false for UUID/string primary keys
  • Soft Deletes: Detects deleted_at columns and adds SoftDeletes trait
  • Timestamps: Detects created_at/updated_at columns

Security & Visibility:

  • Hidden Fields: Automatically hides sensitive fields matching patterns (password, token, secret, etc.)
  • Visible Fields: Option to use $visible instead of $hidden

Mass Assignment:

  • Fillable vs Guarded: Choose between $fillable and $guarded approaches
  • Smart Exclusions: Automatically excludes primary keys and timestamps from fillable

Advanced Properties:

  • Default Attributes: Generates $attributes array from schema default values
  • Pagination: Configure custom $perPage values
  • Eager Loading: Auto-generate $with for common relationships
  • Date Formatting: Customize $dateFormat

Usage

The package provides two main commands for generating models and factories.

Model Generation

Generate Eloquent models from your database schema:

# Basic usage
php artisan wink:generate-models

# Common Options
--connection=mysql              # Specify database connection (default: sqlite)
--directory=path/to/models      # Custom output directory for models (absolute or relative to project root)
--factory-directory=path        # Custom output directory for factories (absolute or relative to project root)
--observer-directory=path       # Custom output directory for observers (absolute or relative to project root)
--with-relationships           # Include relationships based on foreign keys
--with-factories              # Generate model factories
--with-observers              # Generate model observers
--with-rules                  # Generate validation rules
--with-scopes                 # Generate query scopes
--with-timestamp-scopes       # Generate timestamp-based scopes
--with-events                 # Generate model event methods
--with-boot-method           # Generate boot method for event registration

# Examples
# Generate models with default directory structure
php artisan wink:generate-models --connection=mysql

# Generate models with custom relative paths (from project root)
php artisan wink:generate-models --connection=pacsys \
  --directory=app/Models/GeneratedModels/Pacsys \
  --factory-directory=database/factories/GeneratedFactories/Pacsys

# Generate models with absolute paths
php artisan wink:generate-models --connection=pacsys \
  --directory=/absolute/path/to/models \
  --factory-directory=/absolute/path/to/factories

# Generate with all features enabled
php artisan wink:generate-models --connection=mysql \
  --with-relationships --with-factories --with-observers \
  --with-rules --with-scopes --with-events

Factory Generation

When generating factories with --with-factories, the package intelligently creates Laravel factories with:

Smart Field Exclusion:

  • Auto-incremented fields: Automatically detects and excludes auto-incremented primary keys
  • Timestamp fields: Excludes created_at, updated_at, and deleted_at fields
  • Database-specific detection: Works across MySQL (via auto_increment), PostgreSQL (via sequences/identity), and SQLite (via INTEGER PRIMARY KEY)

Generated Factory Features:

  • Business-oriented state methods (active(), inactive(), pending(), archived())
  • Test scenario helpers (forTesting(), forDemo(), forDevelopment())
  • Relationship helpers (withUser(), withBusinessMetadata())
  • Business constraint methods for realistic data generation
  • Smart faker method selection based on column names and types

Directory Structure

By default, the package organizes generated model files into a GeneratedModels/{connection_name} subdirectory. This subdirectory is created within the path defined by the model_path configuration option (which defaults to app/Models, resulting in a final default path like app/Models/GeneratedModels/mysql). A similar structure is used for factories based on the factory_path configuration.

The typical default directory structure looks like this:

app/
├── Models/
│   └── GeneratedModels/
│       ├── mysql/           # Models for MySQL connection
│       └── sqlite/          # Models for SQLite connection
├── Observers/
│   └── GeneratedObservers/
│       ├── mysql/           # Observers for MySQL connection
│       └── sqlite/          # Observers for SQLite connection
└── database/
    └── factories/
        └── GeneratedFactories/
            ├── mysql/       # Factories for MySQL connection
            └── sqlite/      # Factories for SQLite connection

The --directory command-line option allows you to specify a custom output directory for models, completely overriding the default {model_path}/GeneratedModels/{connection_name} structure. Similarly, the --factory-directory and --observer-directory options override the defaults for factories and observers. These options accept either absolute paths or paths relative to the project root.

If the relevant directory options are not specified, the defaults are:

  • Models: {model_path}/GeneratedModels/{connection_name} (e.g., app/Models/GeneratedModels/mysql using the default model_path)
  • Factories: {factory_path}/GeneratedFactories/{connection_name} (e.g., database/factories/GeneratedFactories/mysql using the default factory_path)
  • Observers: {observer_path}/GeneratedObservers/{connection_name} (e.g., app/Observers/GeneratedObservers/mysql using the default observer_path)

Recent Improvements

Version 1.1.0

  • PostgreSQL Support: Added full support for PostgreSQL databases with auto-increment detection
  • Improved Directory Handling: Fixed path resolution for relative and absolute directory options
  • Enhanced Help Documentation: Added comprehensive examples and clearer path requirements
  • Smart Factory Generation: Factories now automatically exclude auto-incremented fields
  • Better Error Messages: More helpful error messages for directory permission issues

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

License

The MIT License (MIT). Please see License File for more information.