DataSource(3) User Contributed Perl Documentation DataSource(3)NAME
DBIx::DataSource - Database-independant create and drop functions
SYNOPSIS
use DBIx::DataSource qw( create_database drop_database );
create_database( $data_source, $username, $password )
or warn $DBIx::DataSource::errstr;
drop_database( $data_source, $username, $password )
or warn $DBIx::DataSource::errstr;
DESCRIPTION
This module implements create_database and drop_database functions for databases. It aims to provide a common interface to database cre-
ation and deletion regardless of the actual database being used.
Currently supported databases are MySQL and PostgreSQL. Assistance adding support for other databases is welcomed and relatively simple -
see DBIx::DataSource::Driver.
FUNCTIONS
create_database DATA_SOURCE USERNAME PASSWORD
Create the database specified by the given DBI data source.
drop_database DATA_SOURCE
Drop the database specified by the given DBI data source.
AUTHOR
Ivan Kohler <ivan-dbix-datasource@420.am>
COPYRIGHT
Copyright (c) 2000 Ivan Kohler Copyright (c) 2000 Mail Abuse Prevention System LLC All rights reserved. This program is free software; you
can redistribute it and/or modify it under the same terms as Perl itself.
BUGS
If DBI data sources were objects, these functions would be methods.
SEE ALSO
DBIx::DataSource::Driver, DBIx::DataSource::mysql, DBIx::DataSource::Pg, DBI
perl v5.8.0 2000-09-25 DataSource(3)
Check Out this Related Man Page
CGI::Session::Driver::sqlite(3) User Contributed Perl Documentation CGI::Session::Driver::sqlite(3)NAME
CGI::Session::Driver::sqlite - CGI::Session driver for SQLite
SYNOPSIS
$s = new CGI::Session("driver:sqlite", $sid, {DataSource=>'/my/folder/sessions.sqlt'});
$s = new CGI::Session("driver:sqlite", $sid, {Handle=>$dbh});
or
$s = new CGI::Session('driver:sqlite', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
Handle=>$dbh,
});
DESCRIPTION
sqlite driver stores session data in SQLite files using DBD::SQLite DBI driver. More details see CGI::Session::Driver::DBI, its parent
class.
DRIVER ARGUMENTS
Supported driver arguments are DataSource and Handle. At most only one of these arguments can be set while creating session object.
DataSource should be in the form of "dbi:SQLite:dbname=/path/to/db.sqlt". If "dbi:SQLite:" is missing it will be prepended for you. If
Handle is present it should be database handle ($dbh) returned by DBI::connect().
As of version 1.7 of this driver, the third argument is NOT optional. Using a default database in the temporary directory is a security
risk since anyone on the machine can create and/or read your session data. If you understand these risks and still want the old behavior,
you can set the "DataSource" option to '/tmp/sessions.sqlt'.
BUGS AND LIMITATIONS
None known.
LICENSING
For support and licensing see CGI::Session
perl v5.16.3 2008-07-16 CGI::Session::Driver::sqlite(3)
Hello,
I am having a hard time trying to do the following:
I have a file that looks like this:
0 CacheMaxConn 4 64
0 RMThread 16 3423423
7 DataSource 0 /hello/sas/ses
0 {94545B4-E343-1410-81E4-08000000} 3 DDBE
3 ... (4 Replies)
Hello Gurus,
I have a file this
Dir Path 1
Connection pool="somename"; "DataSource Name"="DS name"; Password="pwd"; User Id="uid";some other fields
Dir Path2
Password="pwd2"; User id="uid2"; Connection pool="somename2"; "datasource name"="DS name2";some other fields.
Under each dir... (14 Replies)