Merge branch 'master' into subfolders-8.3

[pyTivo.git] / Cheetah / Tools / MondoReportDoc.txt

MondoReport Documentation  \r
Version 0.01 alpha 24-Nov-2001.  iron@mso.oz.net or mso@oz.net.\r
Copyright (c) 2001 Mike Orr.  License: same as Python or Cheetah.\r
\r
* * * * *\r
STATUS:  previous/next batches and query string are not implemented yet.\r
Sorting not designed yet.  Considering "click on this column header to sort by\r
this field" and multiple ascending/descending sort fields for a future version.\r
\r
Tested with Python 2.2b1.  May work with Python 2.1 or 2.0.\r
\r
* * * * *\r
OVERVIEW\r
\r
MondoReport -- provide information about a list that is useful in generating\r
any kind of report.  The module consists of one main public class, and some\r
generic functions you may find useful in other programs.  This file contains an\r
overview, syntax reference and examples.  The module is designed both for\r
standalone use and for integration with the Cheetah template system\r
(http://www.cheetahtemplate.org/), so the examples are in both Python and\r
Cheetah.  The main uses of MondoReport are: \r
\r
(A) to iterate through a list.  In this sense MR is a for-loop enhancer,\r
providing information that would be verbose to calculate otherwise.\r
\r
(B) to separate a list into equal-size "pages" (or "batches"--the two terms are\r
interchangeable) and only display the current page, plus limited information\r
about the previous and next pages.\r
\r
(C) to extract summary statistics about a certain column ("field") in the list.\r
\r
* * * * *\r
MAIN PUBLIC CLASS\r
\r
To create a MondoReport instance, supply a list to operate on.\r
\r
    mr = MondoReport(origList)\r
\r
The list may be a list of anything, but if you use the 'field' argument in any\r
of the methods below, the elements must be instances or dictionaries.\r
\r
MondoReport assumes it's operating on an unchanging list.  Do not modify the\r
list or any of its elements until you are completely finished with the\r
ModoReport object and its sub-objects.  Otherwise, you may get an exception or\r
incorrect results.\r
\r
MondoReport instances have three methods:\r
\r
    .page(size, start, overlap=0, orphan=0\r
        sort=None, reverse=False)                => list of (r, a, b).\r
\r
'size' is an integer >= 1.  'start', 'overlap' and 'orphan' are integers >= 0.\r
The list returned contains one triple for each record in the current page.  'r'\r
is the original record.  'a' is a BatchRecord instance for the current record\r
in relation to all records in the origList.  'b' is a BatchRecord instance for\r
the current record in relation to all the records in that batch/page.  (There\r
is a .batch method that's identical to .page.)\r
\r
The other options aren't implemented yet, but 'overlap' duplicates this many\r
records on adjacent batches.  'orphan' moves this many records or fewer, if\r
they are on a page alone, onto the neighboring page.  'sort' (string) specifies\r
a field to sort the records by.  It may be suffixed by ":desc" to sort in\r
descending order.  'reverse' (boolean) reverses the sort order.  If both\r
":desc" and 'reverse' are specified, they will cancel each other out.  This\r
sorting/reversal happens on a copy of the origList, and all objects returned\r
by this method use the sorted list, except when resorting the next time.\r
To do more complicated sorting, such as a hierarchy of columns, do it to the\r
original list before creating the ModoReport object.\r
\r
    .all(sort=None, reverse=False)              => list of (r, a).\r
\r
Same, but the current page spans the entire origList.\r
\r
    .summary()                                  => Summary instance.\r
\r
Summary statistics for the entire origList.\r
\r
In Python, use .page or .all in a for loop:\r
\r
    from Cheetah.Tools.MondoReport import MondoReport\r
    mr = MondoReport(myList)\r
    for r, a, b in mr.page(20, 40):\r
        # Do something with r, a and b.  The current page is the third page,\r
        # with twenty records corresponding to origList[40:60].\r
    if not myList:\r
        # Warn the user there are no records in the list.\r
\r
It works the same way in Cheetah, just convert to Cheetah syntax.  This example\r
assumes the template doubles as a Webware servlet, so we use the servlet's\r
'$request' method to look up the CGI parameter 'start'.  The default value is 0\r
for the first page.\r
\r
    #from Cheetah.Tools.MondoReport import MondoReport\r
    #set $mr = $MondoReport($bigList)\r
    #set $start = $request.field("start", 0)\r
    #for $o, $a, $b in $mr.page(20, $start)\r
        ... do something with $o, $a and $b ...\r
    #end for\r
    #unless $bigList\r
        This is displayed if the original list has no elements.\r
        It's equivalent to the "else" part Zope DTML's <dtml-in>.\r
    #end unless\r
\r
* * * * *\r
USING 'r' RECORDS\r
\r
Use 'r' just as you would the original element.  For instance:\r
\r
    print r.attribute     # If r is an instance.\r
    print r['key']        # If r is a dictionary.\r
    print r               # If r is numeric or a string.\r
\r
In Cheetah, you can take advantage of Universal Dotted Notation and autocalling:\r
\r
    $r.name        ## 'name' may be an attribute or key of 'r'.  If 'r' and/or\r
                   ## 'name' is a function or method, it will be called without\r
                   ## arguments.\r
    $r.attribute\r
    $r['key']\r
    $r\r
    $r().attribute()['key']()\r
\r
If origList is a list of name/value pairs (2-tuples or 2-lists), you may\r
prefer to do this:\r
\r
    for (key, value), a, b in mr.page(20, 40):\r
        print key, "=>", value\r
    \r
    #for ($key, $value), $a, $b in $mr.page(20, $start)\r
        $key =&gt; $value\r
    #end for\r
\r
* * * * *\r
STATISTICS METHODS AND FIELD VALUES\r
\r
Certain methods below have an optional argument 'field'.  If specified, \r
MondoReport will look up that field in each affected record and use its value\r
in the calculation.  MondoReport uses Cheetah's NameMapper if available,\r
otherwise it uses a minimal NameMapper substitute that looks for an attribute\r
or dictionary key called "field".  You'll get an exception if any record is a\r
type without attributes or keys, or if one or more records is missing that\r
attribute/key.\r
\r
If 'field' is None, MondoReport will use the entire record in its\r
calculation.  This makes sense mainly if the records are a numeric type.\r
\r
All statistics methods filter out None values from their calculations, and\r
reduce the number of records accordingly.  Most filter out non-numeric fields\r
(or records).  Some raise NegativeError if a numeric field (or record) is\r
negative.\r
\r
\r
* * * * *\r
BatchRecord METHODS\r
\r
The 'a' and 'b' objects of MondoReport.page() and MondoReport.all() provide\r
these methods.\r
\r
    .index()\r
\r
The current subscript.  For 'a', this is the true subscript into origList.\r
For 'b', this is relative to the current page, so the first record will be 0.\r
Hint: In Cheetah, use autocalling to skip the parentheses: '$b.index'.\r
\r
    .number()\r
\r
The record's position starting from 1.  This is always '.index() + 1'.\r
\r
    .Letter()\r
\r
The letter ("A", "B", "C") corresponding to .number().  Undefined if .number()\r
> 26.  The current implementation just adds the offset to 'a' and returns\r
whatever character it happens to be.  \r
\r
To make a less dumb implementation (e.g., "Z, AA, BB" or "Z, A1, B1"):\r
1) Subclass BatchRecord and override the .Letter method. \r
2) Subclass MondoReport and set the class variable .BatchRecordClass to your\r
new improved class.\r
\r
    .letter()\r
\r
Same but lower case.\r
\r
    .Roman()\r
\r
The Roman numeral corresponding to .number().\r
\r
    .roman()\r
\r
Same but lower case.\r
\r
    .even()\r
\r
True if .number() is even.\r
\r
    .odd()\r
\r
True if .number() is odd.\r
\r
    .even_i()\r
\r
True if .index() is even.\r
\r
    .odd_i()\r
\r
True if .index() is odd.\r
\r
    .length()\r
\r
For 'a', number of records in origList.  For 'b', number of records on this\r
page.\r
\r
    .item()\r
\r
The record itself.  You don't need this in the normal case since it's the same\r
as 'r', but it's useful for previous/next batches.\r
\r
    .size()\r
\r
The 'size' argument used when this BatchRecord was created.  \r
'a.size() == b.size()'.\r
\r
    .first()\r
\r
True if this is the first record.\r
\r
    .last()\r
\r
True if this is the last record.\r
\r
    .firstValue(field=None)\r
\r
True if there is no previous record, or if the previous field/record has a \r
different value.  Used for to print section headers.  For instance, if you\r
are printing addresses by country, this will be true at the first occurrance\r
of each country.  Or for indexes, you can have a non-printing field showing\r
which letter of the alphablet this entry starts with, and then print a "B"\r
header before printing the first record starting with "B".\r
\r
    .lastValue(field=None)\r
\r
True if this is the last record containing the current value in the\r
field/record.\r
\r
    .percentOfTotal(field=None, suffix="%", default="N/A", decimals=2)\r
\r
Returns the percent that the current field/record is of all fields/records.\r
If 'suffix' is None, returns a number; otherwise it returns a string with\r
'suffix' suffixed.  If the current value is non-numeric, returns 'default'\r
instead (without 'suffix').  'decimals' tells the number of decimal places to\r
return; if 0, there will be no decimal point.\r
\r
    .prev()\r
\r
Returns a PrevNextBatch instance for the previous page.  If there is no\r
previous page, returns None.  [Not implemented yet.]\r
\r
    .next()\r
\r
Returns a PrevNextBatch instance for the next page.  If there is no next page,\r
returns None.  [Not implemented yet.]\r
\r
    .prevPages()\r
\r
Returns a list of PrevNextPage instances for every previous page, or [] if no\r
previous pages.  [Not implemented yet.]\r
\r
    .nextPages()\r
\r
Returns a list of PrevNextPage instances for every next page, or [] if no next\r
pages.  [Not implemented yet.]\r
\r
    .query(start=None, label=None, attribName="start", attribs=[])\r
\r
[Not implemented yet.]\r
\r
With no arguments, returns the HTML query string with start value removed (so\r
you can append a new start value in your hyperlink).  The query string is taken\r
from the 'QUERY_STRING' environmental variable, or "" if missing.  (This is\r
Webware compatible.)  \r
\r
With 'start' (an integer >= 0), returns the query string with an updated start\r
value, normally for the next or previous batch.\r
\r
With 'label' (a string), returns a complete HTML hyperlink:\r
'<A HREF="?new_query_string">label</A>'.  You'll get a TypeError if you specify\r
'label' but not 'start'.\r
\r
With 'attribName' (a string), uses this attribute name rather than "start".\r
Useful if you have another CGI parameter "start" that's used for something\r
else.\r
\r
With 'attribs' (a dictionary), adds these attributes to the hyperlink.\r
For instance, 'attribs={"target": "_blank"}'.  Ignored unless 'label' is \r
specified too.\r
\r
This method assumes the start parameter is a GET variable, not a POST variable.\r
\r
    .summary()\r
\r
Returns a Summary instance.  'a.summary()' refers to all records in the\r
origList, so it's the same as MondoReport.summary().  'b.summary()' refers only\r
to the records on the current page.  [Not implemented yet.]\r
\r
* * * * *\r
PrevNextPage INSTANCES\r
\r
[Not implemented yet.]\r
\r
PrevNextPage instances have the following methods:\r
\r
    .start()\r
\r
The index (true index of origList) that that page starts at.  You may also use\r
'.start().index()', '.start().number()', etc.  Also\r
'.start().item(field=None)'.  (Oh, so *that*'s what .item is for!)\r
\r
    .end()\r
\r
The index (true index of origList) that that page ends at.  You may also use\r
'.end().index()', '.end().number()', etc.   Also\r
'.end().item(field=None)'.\r
\r
    .length()\r
\r
Number of records on that page.\r
\r
    .query(label=None, attribName="start", attribs={}, before="", after="")\r
\r
[Not implemented yet.]\r
\r
Similar to 'a.query()' and 'b.query()', but automatically calculates the start\r
value for the appropriate page.  \r
\r
For fancy HTML formatting, 'before' is prepended to the returned text and \r
'after' is appended.  (There was an argument 'else_' for if there is no such\r
batch, but it was removed because you can't even get to this method at all in\r
that case.)\r
\r
* * * * * *\r
SUMMARY STATISTICS\r
\r
These methods are supported by the Summary instances returned by\r
MondoReport.Summary():\r
\r
    .sum(field=None)\r
\r
Sum of all numeric values in a field, or sum of all records.\r
\r
    .total(field=None)\r
\r
Same.\r
\r
    .count(field=None)\r
\r
Number of fields/records with non-None values.\r
\r
    .min(field=None)\r
\r
Minimum value in that field/record.  Ignores None values.\r
\r
    .max(field=None)\r
\r
Maximum value in that field/record.  Ignores None values.\r
\r
    .mean(field=None)\r
\r
The mean (=average) of all numeric values in that field/record.\r
\r
    .average(field=None)\r
\r
Same.\r
\r
    .median(field=None)\r
\r
The median of all numeric values in that field/record.  This is done by sorting\r
the values and taking the middle value.\r
\r
    .variance(field=None), .variance_n(field=None)\r
    .standardDeviation(field=None), .standardDeviation_n(field=None)\r
\r
[Not implemented yet.]\r
\r
\r
* * * * *\r
To run the regression tests (requires unittest.py, which is standard with\r
Python 2.2), run MondoReportTest.py from the command line.  The regression test\r
double as usage examples.\r
\r
\r
# vim: shiftwidth=4 tabstop=4 expandtab textwidth=79\r