I'm new to UNIX.....
I'm trying to test a software that requires Perl. I installed Perl 5.004_04 without any problem on a UNIX SCO OpenServer Machine.
The software I'm testing also requires some Perl Modules (Net::Telnet, Test::More, Net::Telnet::Cisco & Term::ReadKey).
I installed... (4 Replies)
I am trying to install Oracle perl module(DBD-Oracle). MY oracle server runs on solaris 8 while the machine am tring to install DBD-Oracle runs Suse linux 9(SLE 9)
Oracle client library including sqlplus are NFS mount on my suse linux machine from my solaris oracle server but when I run make on... (1 Reply)
Hi, all,
I need to add a user to our system in order to let him use Oracle and Perl. We want him to remain in his home directory and have no access to our data and other users' files.
I created a separate group for this user, and set his shell to rksh when I created his account, by which he... (2 Replies)
I am trying to write a program that will use templates, so I figured I would use the Text::Template CPAN module...
...only problem is that I cant force my "clients" to install this module, cause they are clueless. Is there anyway that I can NOT install it for the whole machine, but install it... (1 Reply)
Hi all,
I am trying to install the DBI module in perl
using perl -MCPAN -e shell
install 'DBI'
--It is installing into the nuild directory properly but when it try to
make it is saying
NOT OK
-I tried to copy the module manually to the /lib/perl5/vendor_perl ... (3 Replies)
Hi,
Iam not able to install DBD-mysql-4.005 into my Sun machine as the error comes -
perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config
I will use the following settings for compiling and testing:
cflags (mysql_config ) = -I/usr/local/mysql/include/mysql
... (2 Replies)
Hi, i have some queries on installing the Perl DBI and the DBD Oracle.
I know that i have to install the DBI first. I have the source files in a folder in my home directory.The commands to install arecd /home/DBI
Perl Makefile.PL
make
make installI would like to know, after executing these... (4 Replies)
Hi All,
When I tried to install Math::Pari module in a AIX 5.3 server,I am getting the following error.
# pwd
/usr/local/bin
# cd Math-Pari-2.010709
# perl Makefile.PL
Did not find GP/PARI build directory around.
Do you want to me to fetch GP/PARI automatically?
(If you do not, you... (2 Replies)
Hi,
I want to install WWW:Mechanize module.
Followed the following steps:
1. wget http://www.cpan.org/authors/id/C/CO/CORION/Bundle-
WWW-Mechanize-Shell-0.29.tar.gz
perl Makefile.PL
make
make test
make install (Got the below message)
Appending installation info to... (1 Reply)
Hi Guys,
I am trying to install DBI and DBD-MYSQL for strawberry perl.
But i am not able to install.
:wall:
DBD-MYSQL
>> makefile.pl
gives error as
'Access denied for user 'ODBC'@'localhost' (using password: NO)'. (7 Replies)
Discussion started by: vasanth.vadalur
7 Replies
LEARN ABOUT DEBIAN
class::dbi::loader
Class::DBI::Loader(3pm) User Contributed Perl Documentation Class::DBI::Loader(3pm)NAME
Class::DBI::Loader - Dynamic definition of Class::DBI sub classes.
SYNOPSIS
use Class::DBI::Loader;
my $loader = Class::DBI::Loader->new(
dsn => "dbi:mysql:dbname",
user => "root",
password => "",
options => { RaiseError => 1, AutoCommit => 0 },
namespace => "Data",
additional_classes => qw/Class::DBI::AbstractSearch/, # or arrayref
additional_base_classes => qw/My::Stuff/, # or arrayref
left_base_classes => qw/Class::DBI::Sweet/, # or arrayref
constraint => '^foo.*',
relationships => 1,
options => { AutoCommit => 1 },
inflect => { child => 'children' },
require => 1
);
my $class = $loader->find_class('film'); # $class => Data::Film
my $obj = $class->retrieve(1);
use with mod_perl
in your startup.pl
# load all tables
use Class::DBI::Loader;
my $loader = Class::DBI::Loader->new(
dsn => "dbi:mysql:dbname",
user => "root",
password => "",
namespace => "Data",
);
in your web application.
use strict;
# you can use Data::Film directly
my $film = Data::Film->retrieve($id);
DESCRIPTION
Class::DBI::Loader automate the definition of Class::DBI sub-classes. scan table schemas and setup columns, primary key.
class names are defined by table names and namespace option.
+-----------+-----------+-----------+
| table | namespace | class |
+-----------+-----------+-----------+
| foo | Data | Data::Foo |
| foo_bar | | FooBar |
+-----------+-----------+-----------+
Class::DBI::Loader supports MySQL, Postgres and SQLite.
See Class::DBI::Loader::Generic.
METHODS
new %args
additional_base_classes
List of additional base classes your table classes will use.
left_base_classes
List of additional base classes, that need to be leftmost, for example Class::DBI::Sweet (former Catalyst::Model::CDBI::Sweet).
additional_classes
List of additional classes which your table classes will use.
constraint
Only load tables matching regex.
exclude
Exclude tables matching regex.
debug
Enable debug messages.
dsn DBI Data Source Name.
namespace
Namespace under which your table classes will be initialized.
password
Password.
options
Optional hashref to specify DBI connect options
relationships
Try to automatically detect/setup has_a and has_many relationships.
inflect
An hashref, which contains exceptions to Lingua::EN::Inflect::PL(). Useful for foreign language column names.
user
Username.
require
Attempt to require the dynamically defined module, so that extensions defined in files. By default errors from imported modules are
suppressed. When you want to debug, use require_warn.
require_warn
Warn of import errors when requiring modules.
AUTHOR
Daisuke Maki "dmaki@cpan.org"
AUTHOR EMERITUS
Sebastian Riedel, "sri@oook.de" IKEBE Tomohiro, "ikebe@edge.co.jp"
THANK YOU
Adam Anderson, Andy Grundman, Autrijus Tang, Dan Kubb, David Naughton, Randal Schwartz, Simon Flack and all the others who've helped.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Class::DBI, Class::DBI::mysql, Class::DBI::Pg, Class::DBI::SQLite, Class::DBI::Loader::Generic, Class::DBI::Loader::mysql,
Class::DBI::Loader::Pg, Class::DBI::Loader::SQLite
perl v5.10.0 2007-03-22 Class::DBI::Loader(3pm)