Thanks for the pointer! Knowing "DBI" and the references are great.
IndigoPerl has mSQL and faq has the syntax or exampled script. Many thanks!
-mike mitchell
----- Original Message -----
From: "Peter Scott" <[EMAIL PROTECTED]>
To: "Michael Mitchell" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 7:36 PM
Subject: Re: As relates to Software QA
> [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
>
>
