Download the PHP package danilovl/entity-data-list-console-bundle without Composer

EntityDataListConsoleBundle

About

This is a Symfony bundle providing a console command designed to render database data for a specified doctrine entity in a tabular format.

The command is highly flexible, allowing developers to configure which fields to display, handle related associations, and apply pagination using options like --limit and --offset.

Requirements

• PHP 8.3 or higher
• Symfony 7.0 or higher

1. Installation

Install danilovl/entity-data-list-console-bundle package by Composer:

2. Command overview

The abstract class EntityDataListCommand provides a base for creating commands that retrieve and display data for doctrine entities.

The OrmEntityDataListCommand is a concrete implementation registered as a Symfony console command under the name:

3. Features

• Universal data rendering:
  Works with any doctrine entity by providing its class name.
  Retrieves data directly from the database.

• Field customization:
  Allows you to configure which fields of the entity to display in the output.
  Supports customization of related entity fields (e.g., OneToMany, ManyToOne).

• Pagination support:
  Includes --limit and --offset options to control the number of records retrieved and the starting point.

• Formatted output:
  Displays data in a structured table format for easy reading.

• Date handling:
  Automatically formats datetime and date fields into human-readable strings.

4. Usage

To list the data of a specific entity:

4.1 Options

--entity (required argument):

Specifies the fully qualified class name of the doctrine entity to query (e.g., App\Entity\User).

--limit (optional):

Limits the number of rows retrieved. Default: 10.

--offset (optional):

Skips the specified number of rows before starting the result set. Default: 0.

--associations-ignore (optional):

Specifies associations (e.g., OneToMany, ManyToOne) to ignore during rendering.
Provide a comma-separated list of association field names.
Default: value returned by getAssociationsIgnore().

--associations-limit (optional):

Limits the number of items rendered for associations (e.g., child entities in OneToMany relationships).
Default: value returned by getAssociationsLimit().

Example Commands

5. Extending the command

The EntityDataListCommand provides a flexible foundation for building custom commands tailored to specific doctrine entities.
By extending this base command, you can customize the behavior to suit your application's needs.

Here are the steps to create and extend your own entity data listing command:

Run your custom command:

5. Gedmo

If your project utilizes the Gedmo\Translatable extension to manage translations for entities, you can leverage the OrmTranslatableEntityDataListCommand class to handle translatable entities in console commands.

This command ensures that the correct translation locale is set before querying data, allowing you to easily render localized data from the database.

5.1 Important note

The default locale is set to en (English).
If your project uses a different default locale (e.g., en, fr), you need to override the getLocale() method in your custom command to set the appropriate default.

`

5.2 How to use

Create your custom command class and extend OrmTranslatableEntityDataListCommand.

Run your custom command:

License

The EntityDataListConsoleBundle is open-sourced software licensed under the MIT license.