Req: help with DBD::AnyData test.pl in DBI::PurePerl configuration
From: Mr. Markus (MarksAcct_at_gmail.com)
Date: 11/05/04
- Next message: Vassiliy Truskov: "DBI or DBD::ODBC core dumps"
- Previous message: Susan Cassidy: "more DBD::Oracle utf8 weirdness, and kludge that should not have worked, but did"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 4 Nov 2004 16:22:42 -0800
Hi all,
First. Jeff Zucker, Jochen Weidmann & Tim Bunce, thank you for these
cool tools. Additional thanks to Jim Turner for DBD::Sprite and
improvements to Shishir Gurdavaram's Sprite.
Now the fun stuff.
I'm looking for a little help on why DBD::AnyData's test.pl is failing.
It could be that SQL::Statement or something in DBI is finding an
available module which I need to remove so it will failback to its
internal routines. (One of many ideas I've considered and don't know
where to start.)
My goal is to setup and have a portable PurePerl database not knowing
the environment my scripts will end up. I'm building and testing on
Debian 3.x. I've currenly installed by hand (more info on that near the
end):
* AnyData-0.10.tar.gz
* DBD-AnyData-0.08.tar.gz
* DBD-Sprite-0.50.tar.gz (if desired)
* DBI-1.45.tar.gz
* SQL-Statement-1.09.tar.gz
I've had to modify all the test.pl scripts with the following per the
DBI::PurePerl perldoc so they'll execute.
BEGIN {
$ENV{DBI_PUREPERL} = 1; # or =2
unshift @INC, '/home/myacct/lib';
}
Everything tests OK except DBD::AnyData.
When running the DBD::AnyData CPAN test.pl (corrected for DBI::PurePerl
and $HOME/lib), I recieve the following feedback for each data format
it tests -- qw(CSV Pipe Tab Fixed Paragraph ARRAY).
These errors are coming from the SQL::Statement subroutine "is_matched"
at line 1120. ( BTW, vim's color syntax highlighting goes solid at line
2662. Something minor might be malformed. ) Here's just one set of
errors which repeats for all formats
-- Error Starts --
CSV ... Argument "Tom" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN5> line 3.
Argument "Sue" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN5> line 3.
Argument "Tom" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN5> line 4.
Argument "Tom" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN5> line 4.
Argument "Tom" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN5> line 5.
Argument "Bev" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN5> line 5.
Argument "Bev" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN6> line 3.
Argument "Sue" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN6> line 3.
Argument "Bev" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN6> line 4.
Argument "Tom" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN6> line 4.
Argument "Bev" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN6> line 5.
Argument "Bev" isn't numeric in numeric eq (==) at
/home/mark/lib/SQL/Statement.pm line 1120, <GEN6> line 5.
Execution ERROR: No such column 'TEST.SEX' called from
/home/mark/lib/DBI.pm at 1445.
Use of uninitialized value in string eq at ./mytest.pl line 86.
Failed single select!
(repeats for all types)
-- Error Ends --
The line 86 of mytest.pl is the "return" below
-- from CPAN test.pl start --
$val{single_select} =
$dbh->selectrow_array( # display single
value
qq/SELECT sex FROM test WHERE name = 'Sue'/
);
return "Failed single select" unless 'f' eq $val{single_select};
-- from CPAN test.pl end --
I do appreciate any help anyone can provide. I'm documenting my
instructions for later posting here as other's may find it helpful (and
possibly beneficial on obscure platforms like Handheld or
non-unix/win32 OS's.)
As stated above, here's how I installed by hand my current
installation.
Created LIB
* mkdir ~/lib
Copying DBI
* cd ~/temp/
* tar xzf DBI-1.45.tar.gz
* cd DBI-1.45
* cp DBI.pm /path/to/private/lib
* cp -r lib/* /path/to/private/lib
Copying SQL::Statement
* cd ~/temp/
* tar xzf SQL-Statement-1.09.tar.gz
* cd SQL-Statement-1.09/lib
* cp -ir SQL /path/to/private/lib
Copying DBD::AnyData
* cd ~/temp/
* tar xzf DBD-AnyData-0.08.tar.gz
* mkdir /path/to/private/lib/DBD
* cp -ir DBD-AnyData-0.08/AnyData.pm /path/to/private/lib
Copying AnyData
* cd ~/temp/
* tar xzf AnyData-0.10.tar.gz
* cp -ir AnyData-0.10/AnyData* /path/to/private/lib
Copying DBD::Sprite (if desired)
* cd ~/temp/
* tar xzf DBD-Sprite-0.50.tar.gz
* cd DBD-Sprite-0.50/lib/
* cp . /path/to/private/lib
* cp DBD/Sprite.pm /path/to/private/lib/DBD
Later, Markus.
#include <stddisclaimer.h> // Mark Stinson - MarksAcct a.t. gmail.com
- Next message: Vassiliy Truskov: "DBI or DBD::ODBC core dumps"
- Previous message: Susan Cassidy: "more DBD::Oracle utf8 weirdness, and kludge that should not have worked, but did"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
