NAME

Mojolicious::Command::generate::resources - Generate MVC & OpenAPI RESTful API files from database tables

SYNOPSIS

Usage: APPLICATION generate resources [OPTIONS]

  my_app.pl generate help resources # help with all available options
  my_app.pl generate resources --tables users,groups

PERL REQUIREMENTS

This command uses "signatures" in feature, therefore Perl 5.20 is required.

DESCRIPTION

An early release...

Mojolicious::Command::generate::resources generates directory structure for a fully functional MVC set of files, routes and RESTful API specification in OpenAPI format based on existing tables in your application's database.

The purpose of this tool is to promote RAD by generating the boilerplate code for model (M), templates (V) and controller (C) and help programmers to quickly create well structured, fully functional applications. It assumes that you already have tables created in a database and you just want to generate CRUD actions for them.

In the generated actions you will find eventually working code for reading, creating, updating and deleting records from the tables you specified on the command-line. The generated code is just boilerplate to give you a jump start, so you can concentrate on writing your business-specific code. It is assumed that you will modify the generated code to suit your specific needs. All the generated code is produced from templates. You can copy the folder with the templates, push it to @{$app->renderer->paths} and modify to your taste. Please look into the t/blog folder of this distribution for examples.

The command expects to find and will use one of the commonly used helpers pg, mysql sqlite. The supported wrappers are respectively Mojo::Pg, Mojo::mysql and Mojo::SQLite.

OPTIONS

Below are the options this command accepts, described in Getopt::Long notation. Both short and long variants are shown as well as the types of values they accept. All of them, beside --tables, are guessed from your application and usually do not need to be specified.

H|home_dir=s

Optional. Defaults to app->home (which is MyApp home directory). Used to set the root directory to which the files will be dumped. If you set this option, respectively the lib and api folders will be created under the new home_dir. If you want them elsewhere, set these options explicitly.

L|lib=s

Optional. Defaults to app->home/lib (relative to the --home_dir directory). If you installed MyApp in some custom path and you wish to generate your controllers into e.g. site_lib, set this option.

api_dir

Optional. Directory where the OpenAPI json files will be generated. Defaults to app->home/api (relative to the --home_dir directory). If you installed MyApp in some custom path and you wish to generate your OpenApi files into for example site_lib/MyApp/etc/api, set this option explicitly.

C|controller_namespace=s

Optional. The namespace for the controller classes to be generated. Defaults to app->routes->namespaces->[0], usually MyApp::Controller, where MyApp is the name of your application. If you decide to use another namespace for the controllers, do not forget to add it to the list app->routes->namespaces in myapp.conf or your plugin configuration file. Here is an example.

# Setting the Controller class from which all controllers must inherit.
# See /perldoc/Mojolicious/#controller_class
# See /perldoc/Mojolicious/Guides/Growing#Controller-class
app->controller_class('MyApp::C');

# Namespace(s) to load controllers from
# See /perldoc/Mojolicious#routes
app->routes->namespaces(['MyApp::C']);

M|model_namespace=s

Optional. The namespace for the model classes to be generated. Defaults to MyApp::Model.

T|templates_root=s

Optional. Defaults to app->renderer->paths->[0]. This is usually app->home/templates directory. If you want to use another directory, do not forget to add it to the app->renderer->paths list in your configuration file. Here is how to add a new directory to app->renderer->paths in myapp.conf.

# Application/site specific templates
# See /perldoc/Mojolicious/Renderer#paths
unshift @{app->renderer->paths}, $home->rel_file('site_templates');

t|tables=s@

Mandatory. List of tables separated by commas for which controllers should be generated.

SUPPORT

Please report bugs, contribute and make merge requests on Github.

ATTRIBUTES

Mojolicious::Command::generate::resources inherits all attributes from Mojolicious::Command and implements the following new ones.

args

Used for storing arguments from the command-line.

my $args = $self->args;

description

my $description = $command->description;
$command        = $command->description('Foo!');

Short description of this command, used for the ~$ mojo generate commands list.

routes

$self->routes;

Returns an ARRAY reference containing routes, prepared after $self->args->{tables}. Suggested Perl code for the routes is dumped in a file named TODO in --homedir so you can copy and paste into your application code.

usage

my $usage = $command->usage;
$command  = $command->usage('Foo!');

Usage information for this command, used for the help screen.

METHODS

Mojolicious::Command::generate::resources inherits all methods from Mojolicious::Command and implements the following new ones.

run

Mojolicious::Command::generate::resources->new(app=>$app)->run(@ARGV);

Run this command.

render_template_to_file

Renders a template from a file to a file using Mojo::Template. Parameters: $tmpl_file - full path tho the template file; $target_file - full path to the file to be written; $template_args - a hash reference containing the arguments to the template. See also "render_to_file" in Mojolicious::Command.

$self->render_template_to_file($tmpl_file, $target_file, $template_args);

generate_formfields

Generates form-fields from columns information found in the respective table. The result is put into _form.html.ep. The programmer can then modify the generated form-fields.

$form_fields = $self->generate_formfields($table_name);

generate_openapi

Generates Open API files in json format. The generated files are put in "--api_dir". The files are: api.json - the file which will be loaded by MyApp and refers to the specific path files; definitions.json - this file is referred to in the specific path files; $path.json - a file for each resource, based on the table name from which it is generated.

generate_path_api

Generates API definitions and path file for each table. Invoked in "generate_openapi". Paramaters: $t - the table name; $$api_defs_object - the object API definition, based on the table name; $tmpl_args - the arguments for the templates. $api_defs_object and $tmpl_args will be enriched with additional key-value pairs as required by the OpenAPI specification. Returns void.

generate_validation

Generates code for the _validation method in the respective controler.

$validation_code = $self->generate_validation($table_name);

TODO

The work on the features may not go in the same order specified here. Some parts may be fully implemented while others may be left for later.

- Improve documentation.
- Implement generation of Open API specification out from
  tables' metadata. More tests.

AUTHOR

Красимир Беров
CPAN ID: BEROV
berov@cpan.org

COPYRIGHT

This program is free software licensed under

Artistic License 2.0

The full text of the license can be found in the LICENSE file included with this module.

SEE ALSO

Mojolicious::Command::generate, Mojolicious::Command, Mojolicious, Mojolicious::Plugin::OpenAPI, Perl.