[I'm going to keep this in the group, others deserve to see the answers.]
At 02:25 AM 4/17/01 +0000, Michael Mitchell wrote:
>Thanks again!
>
>Frequently need to do data validation, NT based intranet, SQL
>server. Using 32win perl, the Indigo Perl distribution.
>
>I know the tables, etc., have access (username/password), etc. Requires
>both read and insertions.
>
>Previously have used VB tool put together by the customer development
>team, and/or SQL select statements with query analyzer.
>
>I know very little about how one would write the basic code, could puzzle
>through the select statements, but do not know how all that integrates
>into PERL.
>
>I have project ending and may find it difficult to immediately implement
>in the time left apart from a short-cut.
>
>The "shortcut" I hope for is a pointer, or example code. Hope this
>narrowed parameters enough.
You need DBI. If you can get the book quickly enough, it's your best bet
by far:
http://www.oreilly.com/catalog/perldbi/
Otherwise, just get it from CPAN and start plowing though:
http://search.cpan.org/search?dist=DBI
I'm assuming there's a DBD for SQL Server. I would imagine there must be,
but I haven't used it and I don't see anything by that name on
http://dbi.symbolstone.org/. Probably it's taken care of by the ODBC driver.
>Again thanks for any help!
>
>Mike Mitchell
>
>
>>From: Peter Scott <[EMAIL PROTECTED]>
>>To: "Michael Mitchell" <[EMAIL PROTECTED]>
>>CC: [EMAIL PROTECTED]
>>Subject: Re: As relates to Software QA
>>Date: Mon, 16 Apr 2001 16:07:35 -0700
>>
>>[Brought back to the group.]
>>
>>>Thanks for asking the question. I trying to find the route used for making
>>>PERL a tool to test non-PERL apps.
>>
>>Interesting. Well, I'd have to know a lot more about the type of
>>application you propose testing. If you're executing applications that
>>simply change files, then you need the ability to diff files from their
>>expected states. If you're executing applications that alter databases,
>>you'll want to know about DBI for talking to those databases. If you're
>>executing applications on web servers, you'll want to know about LWP for
>>talking to those web servers.
>>
>>This covers a heck of a lot of ground, so maybe you can narrow it down a bit.
>>
>>>----- Original Message -----
>>>From: "Peter Scott" <[EMAIL PROTECTED]>
>>>To: "Michael Mitchell" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>>>Sent: Monday, April 16, 2001 11:45 AM
>>>Subject: Re: As relates to Software QA
>>>
>>>
>>> > At 09:07 AM 4/16/01 -0700, Michael Mitchell wrote:
>>> > >Currently I'm a strictly blackbox tester type, but see the utility of
>>>perl
>>> > >for testing. What would be the best resource for learning PERL pointing
>>> > >to that goal? That is, should I pay more attention to one area over
>>>another?
>>> >
>>> > Are you talking about learning how to use Perl for testing non-Perl
>>> > applications, or how to test Perl applications?
>>> >
>>> > --
>>> > Peter Scott
>>> > Pacific Systems Design Technologies
>>> >
>>> >
>>
>>--
>>Peter Scott
>>Pacific Systems Design Technologies
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Peter Scott
Pacific Systems Design Technologies
