NAME
Mojolicious::Command::Author::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
my_app.pl generate resources --tables users,groups -D dbx
PERL REQUIREMENTS
This command uses "signatures" in feature, therefore Perl 5.20 is required.
DESCRIPTION
An usable 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=s
Optional. Directory where the OpenAPI json
file 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');
D|db_helper=s
Optional. If passed, this method name will be used when generating Model classes and helpers. The application is still expected to support the unified API of the supported database adapters. This feature helps to generate code for an application that wants to support all the three adaptors or if for example tomorrow suddenly appears a Mojo::Oracle tiny wrapper around DBD::Oracle.
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 file in json format. The generated file is put in "--api_dir". The filename is api.json
. This is the file which will be loaded by MyApp
.
generate_path_api
Generates API definitions and paths 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.
- Add initial documentation stub to the generated classes.
- Improve templates to generate code to which is more ready to use.
- Append to the existing api.json if it already exists. 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.