mherrera05/data-dictionary

Bundle to expose database composition as data dictionary.

Installs: 601

Dependents: 0

Suggesters: 0

Stars: 0

Watchers: 0

Forks: 0

Open Issues: 0

Language:HTML

Type:symfony-bundle

v1.2.0 2017-12-13 12:06 UTC

README

Symfony Bundle

Packagist GitHub tag Codacy grade Packagist SensioLabsInsight knpbundles.com

Introduction

Data Dictionary is a Symfony Bundle that offers database composition of project rendered as HTML format, making it easy for developers to read field name, data type and comments.

Requirements

  • PHP 5.3 or higher
  • Symfony 2.x or 3.x
  • Doctrine Symfony Bundle ~1.4
  • Doctrine ORM ^2.4.8
  • Twig ^1.0||^2.0

Installation & Usage

This is a Symfony Bundle with dependency on Doctrine, you can install it via composer.

Installation

Step 1: Download the Bundle

Open a command console, enter your project directory and execute the following command to download the latest stable version of this bundle:

$ composer require mherrera05/data-dictionary "dev-master"
ó
$ composer require mherrera05/data-dictionary ">=1.0"

This command requires you to have Composer installed globally, as explained in the installation chapter of the Composer documentation.

Step 2: Enable the Bundle

Then, enable the bundle by adding it to the list of registered bundles in the app/AppKernel.php file of your project:

<?php
// app/AppKernel.php

// ...
class AppKernel extends Kernel
{
    public function registerBundles()
    {
        $bundles = array(
            // ...
            new DataDictionaryBundle\DataDictionaryBundle(),
        );

        // ...
    }

    // ...
}

Step 3: Import resources from Bundle

Import bundle resources adding resources in routing.yml.

data_dictionary:
    resource: "@DataDictionaryBundle/Resources/config/routing.yml"
    prefix:   /

If you prefer, you can add a prefix for URL.

Step 4: Add vendor templates

Add vendor templates directory as path in twig configuration config.yml.

twig:
    ...
    paths:
        '%kernel.root_dir%/../vendor/mherrera05/data-dictionary/Resources/views': 'DataDictionaryBundle'

Usage

Step 1: Import model to json files

Once installed and enabled the Bundle, you can execute the command:

$ php app/console data:dictionary:import {bundle-name}

This command will export database tables and fields composition to .json files.

Use the name of bundle where you want to put the json files. Example, Doctrine creates orm.yml from database on your base bundle.

Step 2: Call URL

Once files have been imported, just call the URL on web browser.

/app.php/data-dictionary

Maintainer

Miguel Herrera https://github.com/mherrera05/