Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

dbix::datasource::driver(3) [debian man page]

DataSource::Driver(3)					User Contributed Perl Documentation				     DataSource::Driver(3)

NAME
DBIx::DataSource::Driver - Driver Writer's Guide and base class SYNOPSIS
perldoc DBIx::DataSource::Driver; or package DBIx::DataSource::FooBase; use DBIx::DataSource::Driver; @ISA = qw( DBIx::DataSource::Driver ); DESCRIPTION
To implement a driver for your database: 1) If you can create a database with an SQL command through DBI/DBD, simply provide a parse_dsn class method which returns a list consisting of the *actual* data source to use in DBI->connect and the SQL. package DBIx::DataSource::NewDatabase; use DBIx::DataSource::Driver; @ISA = qw( DBIx::DataSource::Driver ); sub parse_dsn { my( $class, $action, $dsn ) = @_; # $action is `create' or `drop' # for example, if you parse parse $dsn for $database, # $sql = "$action $database"; # you can die on errors - it'll be caught ( $new_dsn, $sql ); } 2) Otherwise, you'll need to write create_database and drop_database class methods. package DBIx::DataSource::NewDatabase; sub create_database { my( $class, $dsn, $user, $pass ) = @_; # for success, return true # for failure, die (it'll be caught) } sub drop_database { my( $class, $dsn, $user, $pass ) = @_; # for success, return true # for failure, die (it'll be caught) } 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
SEE ALSO
DBIx::DataSource, DBIx::DataSource::mysql, DBIx::DataSource::Pg, DBI perl v5.8.0 2000-09-25 DataSource::Driver(3)

Check Out this Related Man Page

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)
Man Page

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

searching for {

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)
Discussion started by: yotoruja
4 Replies

2. Solaris

sun Blade 2000 and XVR100

hello, I have SunBlade 2000 with XVR-1000 graphics card. Xserver won't loaded. I've reinstalled OS 9 ( loaded Driver) nor 10 still won't do it. Anyone has this problem or have any ideas whats' wrong, greatly appreciated!! thanks in adv. (1 Reply)
Discussion started by: anphdula
1 Replies

3. Shell Programming and Scripting

Access to database/eval command

Hi i have the following code: if(($line!=1) and (@field!='\$')){ print ( "\nTRY TO CONNECT TO DATABASE................\n"); my $dbh = DBI->connect($dsn, $user, $pass); print ("CONNECTED TO DATABASE\n"); eval ... (1 Reply)
Discussion started by: chriss_58
1 Replies

4. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi Yogesh, Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel" I tried creating a simple text file to get the query output, but the... (1 Reply)
Discussion started by: dolphin123
1 Replies

5. Shell Programming and Scripting

redirecting sql query output to a file

Hi, I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning. success records to success.log file failure record to failure.log file. As of now i am doing like... (1 Reply)
Discussion started by: sailaja_80
1 Replies

6. Programming

Problems using Perl DBI to edit database entries - basic stuff

Hello. I am taking a Perl class in college and we've briefly covered SQL and moved on. We have a term project and we can do whatever we want. My project will rely strongly on an SQL Database so I am trying to learn as much about Perl DBI as I can to get things up and going. I am basically... (1 Reply)
Discussion started by: Dave247
1 Replies

7. UNIX for Dummies Questions & Answers

Help with SQL Shell script

Hi, I need to excute two .sql scripts sequentially within file.sh sqlplus user/pass@db1 @/opt/Infor/Outbound_Marketing/7.2.2/custom/iadeploy1.sql THEN sqlplus user/pass@db2 @/opt/Infor/Outbound_Marketing/7.2.2/custom/iadeploy3.sql Thanks, Soph (4 Replies)
Discussion started by: soph1997
4 Replies

8. Shell Programming and Scripting

Print between multiple patterns

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)
Discussion started by: sirababu
14 Replies

9. AIX

I cannot find dsn and TNSNAMES.ora on UNIX

Where can I find dsn and TNSNAMES.ora on UNIX AIX Thanks for contribution (3 Replies)
Discussion started by: digioleg54
3 Replies