SPOPS::Tool::DBI::Datasource -- Embed the parameters for a DBI handle in object configuration
my $spops = { myobject => { class => 'My::Object', rules_from => [ 'SPOPS::Tool::DBI::Datasource' ], dbi_config => { dsn => 'DBI:mysql:test', username => 'kool', password => 'andthegang' }, ... }, }; SPOPS::Initialize->process({ config => $spops }); my $object = My::Object->fetch( 'celebrate' );
This rule allows you to embed the DBI connection information in your object rather than using the strategies described elsewhere. This is very handy for creating simple, one-off scripts, but you should still use the subclassing strategy from SPOPS::Manual::Cookbook if you will have multiple objects using the same datasource.
You can specify the following items in the configuration:
dsn: The DBI DSN, or the first entry in the normal DBI connect call.
dsn
connect
username: Username to connect with
username
password: Password to connect with
password
trace: Trace level to use (0-5, see DBI for what the levels mean)
trace
behavior_factory( $class )
Generates a behavior to generate the datasource retrieval code during the 'manipulate_configuration' phase.
datasource_access( $class )
Generates the 'global_datasource_handle()' method that retrieves an opened database handle if it exists or creates one otherwise.
None known.
Nothing known.
SPOPS::Manual::CodeGeneration
SPOPS::DBI
Copyright (c) 2001-2004 intes.net, inc.. All rights reserved.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
Chris Winters <chris@cwinters.com>
Thanks to jeffa on PerlMonks (http://www.perlmonks.org/index.pl?node_id=18800) for suggesting this!
To install SPOPS, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SPOPS
CPAN shell
perl -MCPAN -e shell install SPOPS
For more information on module installation, please visit the detailed CPAN module installation guide.