Catalyst::Model::DBI(3pm) User Contributed Perl Documentation Catalyst::Model::DBI(3pm)NAME
Catalyst::Model::DBI - DBI Model Class
SYNOPSIS
# use the helper
create model DBI DBI dsn username password
# lib/MyApp/Model/DBI.pm
package MyApp::Model::DBI;
use base 'Catalyst::Model::DBI';
__PACKAGE__->config(
dsn => 'dbi:Pg:dbname=myapp',
password => '',
username => 'postgres',
options => { AutoCommit => 1 },
);
1;
my $dbh = $c->model('DBI')->dbh;
#do something with $dbh ...
DESCRIPTION
This is the "DBI" model class.
METHODS
new Initializes DBI connection
$self->dbh
Returns the current database handle.
$self->stay_connected
Returns a connected database handle.
$self->connected
Returns true if the database handle is active and pingable.
$self->connect
Connects to the database and returns the handle.
$self->disconnect
Executes rollback if AutoCommit is active, disconnects and unsets the database handle.
SEE ALSO
Catalyst, DBI
AUTHOR
Alex Pavlovic, "alex.pavlovic@taskforce-1.com"
COPYRIGHT
Copyright (c) 2005 - 2009 the Catalyst::Model::DBI "AUTHOR" as listed above.
LICENSE
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2010-01-28 Catalyst::Model::DBI(3pm)
Check Out this Related Man Page
CRUD(3pm) User Contributed Perl Documentation CRUD(3pm)NAME
Catalyst::Model::CDBI::CRUD - CRUD CDBI Model Class
SYNOPSIS
# lib/MyApp/Model/CDBI.pm
package MyApp::Model::CDBI;
use base 'Catalyst::Model::CDBI::CRUD';
__PACKAGE__->config(
dsn => 'dbi:SQLite2:/tmp/myapp.db',
relationships => 1
);
1;
# lib/MyApp.pm
package MyApp;
use Catalyst 'FormValidator';
__PACKAGE__->config(
name => 'My Application',
root => '/home/joeuser/myapp/root'
);
sub table : Global {
my ( $self, $c ) = @_;
$c->form( optional => [ MyApp::Model::CDBI::Table->columns
] ); #see Data::FormValidator
$c->forward('MyApp::Model::CDBI::Table');
}
sub end : Private {
$c->forward('MyApp::V::TT');
}
1;
DESCRIPTION
This is a subclass of "Catalyst::Model::CDBI" with additional CRUD methods. Don't forget to copy the base templates to config->root!
*NOTE* This module has been deprecated. See BUGS section below!
METHODS
add
Does nothing by default.
destroy
Deletes a Class::DBI object.
do_add
Creates a new Class::DBI object from $c->form.
do_edit
Updates a Class::DBI object from $c->form.
edit
Does nothing by default.
list
Does nothing by default.
process
Dispatches CRUD request to methods.
view
Does nothing by default.
BUGS
This module is no longer supported by the Catalyst developers. We keep it indexed for the sake of existing users, but highly recommend new
users to look at Catalyst::Helper::Controller::Scaffold
SEE ALSO
Catalyst, Catalyst::Model::CDBI
AUTHOR
Sebastian Riedel, "sri@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2005-10-13 CRUD(3pm)
Hi all,
Have two legacy DEC 3000 Model 800/800S AXP boxes and woud apart from learning how to set them up properly, I'd like to also increase the amount of RAM on both (or at least one) of the servers.
Currently I've moved all the RAM from the second box into the primary box which now holds a... (2 Replies)
Hi all
I am new to perl-ldap. Trying to install DBD module on sun solaris which has the iplanet51 ldap already installed.
I have got the DBD-LDAP-0.03.tar file , and un packed it.
From the dir DBD-LDAP-0.03 - i tried to do
$ perl Makefile.PL and i got the... (10 Replies)
We ran into an issue trying to install DBI and DB2 modules for perl for AIX from the link
http://www-306.ibm.com/software/data/db2/perl/
We tried to install the DBI module using
bash# perl -MCPAN -e 'install DBI'
command. However we ended up with the following error.
Stop.
... (3 Replies)
Hi everybody,
I want ask if it is possible to copy all storage structure (VGs, LVs & filesystems) from one server to another. In other words, I want to move my system from old server to new one, so I want the new server exactly have the same sizes and number of VGs, LVs, & filesystems.
Thanks... (11 Replies)
Hello !
I am working on a small Perl script that should connect to the MySQL server, will select all the databases one by one and do some queryes on each. I started working on it but I just saw that on the DBI manual page there's no method for changing the working database. Am I missing... (2 Replies)
HI all!
this is my problem:
my boss got a Model 43P 7248-100 PowerPC server with the AIX 4.2 os, but some days ago it crashed and now it doesn't want to boot up again, it stops after the initial diagnostic phase with the "PowerPC" screen!
I must recover some important data from the hard disk, so... (6 Replies)
Hey I have an IBM
IntelliStation Power 9114 Model 275 1.45GHz Workstation
1-Way 1.45GHz Power4+ Processor (5223)
2GB Memory (4x 512MB Dimms) (4447)
and was told that AIX 5.3 works on it, and that there was problems with Linux installs.
Can I download AIX 5.3 or do I need to buy... (13 Replies)
hi
every resource i see regarding DBI refers to retrieving data from a database into and array or a hash, but i havent seen anything on how to pull out a single value to a scalar
in my database i have a field called "forcewrite" with a value of "6". I am trying to connect to the database,... (2 Replies)
I have a file like below
Iter 1: Best Model = 10.0 12.0 13.0 17.0 23.3 78.7
Iter 2: Best Model = 10.0 20.0 30.0 40.0 50.0 60.0
Iter 3: Best Model = 27.3 46.3 84.5 23.0 34.5 35.4
etc
I want to use a scipts using csh or awk to select the iteration number and show the numbers in a table... (2 Replies)
Hi,
In perl DBI using mysql we can set following, can somebody poin to complete list of such values that can be set you $dbh->
example:
$dbh->{AutoCommit}
$dbh->{RaiseError}
~Thanks (2 Replies)
Hello,
an employee just left the company and a new user has taken his place.
the request is to for the new user to have the same access to the servers as the old employee had.
the old user still has his account present on the servers. can anyone tell me an easy way of doing this? without... (10 Replies)
#!/usr/local/bin/perl
use DBI;
use File::Copy;
use Time::Local;
use Data::Dumper;
-Comments Describing what I'm doing--------------
-I'm pulling information from a database that has an ID and Name. They are separated by a space and I'm trying to load them into a multidimensional array so as... (3 Replies)
Hi All,
I installed DBI module in a non INC location and using it in my script via "use lib".
But it throw the below error at the "use DBI" step.
Please help
Usage: DBI::_install_method(dbi_class, meth_name, file, attribs=Nullsv) at /xx/xxx/xxxxx/xxxxx/oracle/lib/DBI.pm/oracle/lib/DBI.pm line... (2 Replies)
Hi,
I just successfully build a Virtual Machine in virtual box with Perfectly running HMC v7. I have a IBM eServer pSeries Model 630 Model 6C4 (Power 4) i.e. 7024-6C4. I am not able to have it connect to the HMC console on the Virtual Box.
Can anyone help me on how to connect it to the... (8 Replies)