Skip to content

Plugin for Mojolicious perl web-framework. Provides DBD::AnyData handler

License

Notifications You must be signed in to change notification settings

dfateyev/Mojolicious-Plugin-AnyData

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Mojolicious::Plugin::AnyData
============================
VERSION 1.11

This Mojolicious web framework plugin provides access 
to DBD::AnyData instance from a Mojolicious helper.

It allows the test data to be loaded directly from the memory
or separate config files, but not from a database. 

Please note, this plugin should be used in development mode only. 
You may use it as a test data source without a database connection.

For more information, see DBD::AnyData
-----------------------------
In Mojolicious::Lite

plugin any_data => {
    load_data => {
        cars => [
	    ['id', 'model'],
	    [   1, 'Honda'],
	    [   2, 'Lexus'],
	],
    },
    helper => 'db',
};

get '/get-car/:id' => sub {
    my $self = shift;
    
    my $id = $self->stash->{id};
    my $model = $self->db->selectrow_array(qq{
        select model
	from cars
	where
	    id = ?
    }, undef, $id);
    
    $self->render( text => $car );
};

get '/new-func' => sub {
    my $self = shift;
    
    $self->dbh->func('cars_numbers', 'ARRAY', [
        ['car_number', 'id'],
	[     '12456',    1],
	[     '34567',    2],
    ], 'ad_import');
    
    my $cars_data = $self->db->selectrow_hashref(qq{
        select
	    model, car_number
	from cars, cars_numbers
	where
	    cars.id = ?
	        and cars.id = cars_numbers.id 
    }, undef, 1);
    
    $self->reder(text => Dumper $cars_data);
}

===========================
INSTALL

You can install this module, using following commands:

$ perl Makefile.PL
$ make
$ make test
$ sudo make install

Or, directly from CPAN:

$ sudo cpan Mojolicious::Plugin::AnyData

About

Plugin for Mojolicious perl web-framework. Provides DBD::AnyData handler

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages

  • Perl 100.0%