Chip 2000 May

home *** CD-ROM | disk | FTP | other *** search

/ Chip 2000 May / Chip_2000-05_cd1.bin / zkuste / Perl / ActivePerl-5.6.0.613.msi / 䆊䌷䈹䈙䏵-䞅䞆䞀㡆䞃䄦䠥 / _9592d2b289dc2c0dec3ba2cbf30102bb < prev next >

Wrap

Text File | 2000-03-23 | 5.2 KB | 157 lines

<HTML> <HEAD> <TITLE>DBI::Format - A package for displaying result tables</TITLE> <LINK REL="stylesheet" HREF="../../../Active.css" TYPE="text/css"> <LINK REV="made" HREF="mailto:"> </HEAD> <BODY> <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%> <TR><TD CLASS=block VALIGN=MIDDLE WIDTH=100% BGCOLOR="#cccccc"> DBI::Format - A package for displaying result tables </TD></TR> </TABLE> <A NAME="__index__"></A>  <UL> <LI><A HREF="#name">NAME</A></LI><LI><A HREF="#supportedplatforms">SUPPORTED PLATFORMS</A></LI> <LI><A HREF="#synopsis">SYNOPSIS</A></LI> <LI><A HREF="#description">DESCRIPTION</A></LI> <LI><A HREF="#available subclasses">AVAILABLE SUBCLASSES</A></LI> <UL> <LI><A HREF="#ascii boxes">Ascii boxes</A></LI> </UL> <LI><A HREF="#author and copyright">AUTHOR AND COPYRIGHT</A></LI> <LI><A HREF="#see also">SEE ALSO</A></LI> </UL>  <HR> <H1><A NAME="name">NAME</A></H1> DBI::Format - A package for displaying result tables <HR> <H1><A NAME="supportedplatforms">SUPPORTED PLATFORMS</A></H1> <UL> <LI>Linux</LI> <LI>Solaris</LI> <LI>Windows</LI> </UL> <HR> <H1><A NAME="synopsis">SYNOPSIS</A></H1> <PRE> # create a new result object $r = DBI::Format->new('var1' => 'val1', ...);</PRE> <PRE> # Prepare it for output by creating a header $r->header($sth, $fh);</PRE> <PRE> # In a loop, display rows while ($ref = $sth->fetchrow_arrayref()) { $r->row($ref); }</PRE> <PRE> # Finally create a trailer $r->trailer();</PRE> <HR> <H1><A NAME="description">DESCRIPTION</A></H1> THIS PACKAGE IS STILL VERY EXPERIMENTAL. THINGS WILL CHANGE. This package is used for making the output of DBI::Shell configurable. The idea is to derive a subclass for any kind of output table you might create. Examples are <UL> <LI> a very simple output format as offered by DBI::neat_list(). <A HREF="#available subclasses">AVAILABLE SUBCLASSES</A>. <LI> a box format, as offered by the Data::ShowTable module. <LI> HTML format, as used in CGI binaries <LI> postscript, to be piped into lpr or something similar </UL> In the future the package should also support interactive methods, for example tab completion. These are the available methods: <DL> <DT><A NAME="item_new"><CODE>new(@attr)</CODE></A> <DD> <DT><CODE>new(\%attr)</CODE> <DD> (Class method) This is the constructor. You'd rather call a subclass constructor. The construcor is accepting either a list of key/value pairs or a hash ref. <DT><A NAME="item_header">header($sth, $fh)</A> <DD> (Instance method) This is called when a new result table should be created to display the results of the statement handle $sth. The (optional) argument $fh is an IO handle (or any object supporting a print method), usually you use an IO::Wrap object for STDIN. The method will query the $sth for its NAME, NUM_OF_FIELDS, TYPE, SCALE and PRECISION attributes and typically print a header. In general you should not assume that $sth is indeed a DBI statement handle and better treat it as a hash ref with the above attributes. <DT><A NAME="item_row"><CODE>row($ref)</CODE></A> <DD> (Instance method) Prints the contents of the array ref $ref. Usually you obtain this array ref by calling $sth->fetchrow_arrayref(). <DT><A NAME="item_trailer">trailer</A> <DD> (Instance method) Once you have passed all result rows to the result package, you should call the trailer method. This method can, for example print the number of result rows. </DL> <HR> <H1><A NAME="available subclasses">AVAILABLE SUBCLASSES</A></H1> First of all, you can use the DBI::Format package itself: It's not an abstract base class, but a very simple default using DBI::neat_list(). <H2><A NAME="ascii boxes">Ascii boxes</A></H2> This subclass is using the Box mode of the Data::ShowTable module internally. <A HREF="../../../Data/ShowTable(3).html">the Data::ShowTable(3) manpage</A>. <HR> <H1><A NAME="author and copyright">AUTHOR AND COPYRIGHT</A></H1> This module is Copyright (c) 1997, 1998 <PRE> Jochen Wiedmann Am Eisteich 9 72555 Metzingen Germany</PRE> <PRE> Email: joe@ispsoft.de Phone: +49 7123 14887</PRE> The DBD::Proxy module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. <HR> <H1><A NAME="see also">SEE ALSO</A></H1> <A HREF="../../../DBI/Shell(3).html">the DBI::Shell(3) manpage</A>, DBI(3), dbish(1) <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%> <TR><TD CLASS=block VALIGN=MIDDLE WIDTH=100% BGCOLOR="#cccccc"> DBI::Format - A package for displaying result tables </TD></TR> </TABLE> </BODY> </HTML>