xmarkclx / laravel-autodb by xmarkclx

Automatically creates database for Laravel based on a few PHP documentation comments.
12
0
2
Package Data
Maintainer Username: xmarkclx
Maintainer Contact: xmarkclx@gmail.com (Mark Christian Lopez)
Package Create Date: 2016-03-12
Package Last Update: 2016-03-13
Language: PHP
License: MIT
Last Refreshed: 2024-04-22 15:00:22
Package Statistics
Total Downloads: 12
Monthly Downloads: 0
Daily Downloads: 0
Total Stars: 0
Total Watchers: 2
Total Forks: 0
Total Open Issues: 0

Introduction

Automatically creates database based on few PHP documentation comments.

  • Easy to use
  • Stable
  • Fully Tested: Major Features are tested for stability
  • Framework agnostic
  • Pleasurable to work with
  • Supports Laravel / Eloquent

Usage

Install via composer

composer require xmarkclx/laravel-autodb

Create Database Comments

Given we have a comment on a class like so:

/**
 * Class Example
 *
 * @db===
 * @property string $avatar_url
 * @property int $id #increments         
 * @db===
 **
 * @package App
 */
 class Example implements AutogeneratedDBFields
 {

We run:

    php artisan autodb

What happens:

  • Will create table example if not yet created.
  • In that table:
    • Creates string called avatar_url.
    • Creates integer called id that is a primary key and auto-increments.

FAQs

Why?

  • Creating database migrations and changing them is time consuming. This will make it faster.
  • Also, this would avoid migration conflicts that happens when multiple migrations, try to modify the same database fields.
  • Furthermore, with this method, you can automatically get autocomplete suggestions on your IDE for the database fields due to it being related to phpdoc tags.
  • No more need to open database viewer to know what fields the model has, just look at the model file.
  • Agile Friendly: Make database improvements fast.

Why not just make this tool create migrations?

Well, we can, and it's not hard, but I don't have time for that yet.

If you want to help, you just need to make an assembler for that, just see how src/LaravelModelAssembler.php works and you can make a LaravelMigrationAssembler.php or something that assembles migrations instead of the database.

Example

  • I create migration where name is now an integer based on a test.
  • Production server gets my migration and migrated it.
  • Production server names are now integers.
  • So that's why it was decided to auto migrate data instead of creating migration files.

I want to help make this project better.

See docs/Architecture.md for how it is architected.