Module Hierarchy

• picalo
  • base
    • Boolean
    • Calendar
    • Column
    • Currency
    • Error
    • Expression
    • Global
    • Number
    • Record
    • Table
    • TableArray
    • TableList
  • Benfords: The Benfords module performs digital analyses on data sets.
  • Crosstable: The Crosstable module creates crosstables of data.
  • Database: This module provides easy access to DB-API 2.0 tables.
  • Financial: Encodes financial ratios used for analysis of financial statements.
  • Grouping: The Grouping module contains functions that stratify and summarize records in different ways.
  • Simple: The Simple module contains base functions that are useful throughout the Picalo package, such as indexing, sorting, selecting, and matching of tables.
  • Trending: The Trending module contains functions that highlight trends in data.

Class Hierarchy

• __builtin__.object: The most base type
  • datetime.date: date(year, month, day) --> date object
    • picalo.base.Calendar.Date: The Picalo date type to represent dates.
    • datetime.datetime: datetime(year, month, day[, hour[, minute[, second[, microsecond[,tzinfo]]]]])
      • picalo.base.Calendar.DateTime: The Picalo date/time type to represent dates and times.
  • decimal.Decimal: Floating point class for decimal arithmetic.
    • picalo.base.Number.number: A number with a decimal point.
      • picalo.base.Currency.currency: A simple extension to number to deliniate a currency type.
  • __builtin__.list: list() -> new list list(sequence) -> new list initialized from sequence's items
    • picalo.base.Column.Column: A single column of the table.
    • picalo.base.TableArray.TableArray
    • picalo.base.TableList.TableList
  • picalo.lib.progressbar.ProgressBarWidget: This is an element of ProgressBar formatting.
    • picalo.base.Global.MessageProgressBarWidget: Extension to display a message
  • __builtin__.type: type(object) -> the object's type type(name, bases, dict) -> a new type
• exceptions.Exception: Common base class for all exceptions.
  • picalo.Database.QueryBuilderException: Simple exception to report query builder problems, with an embedded error.
• picalo.Benfords.Result: A simple class to represent a result statistic for an individual data point
• picalo.Crosstable.Crosstabler: Crosstables data sets.
• picalo.Database.Query: Represents a query on a database.
• picalo.Database._BaseQueryBuilder: The base of query builder with common code.
  • picalo.Database.InsertQueryBuilder: Helps in building a simple insert SQL call.
  • picalo.Database.SelectQueryBuilder: Helps in building a simple select SQL call.
  • picalo.Database.UpdateQueryBuilder: Helps in building a simple update SQL call.
• picalo.base.Boolean.boolean: A flag type, such as on/off, true/false, etc.
• picalo.base.Calendar.DateFormatInfo: A simple class to represent information about a date format
• picalo.base.Column._ColumnLoader: Little class that helps in loading columns
• picalo.base.Error.error
• picalo.base.Expression.PicaloExpression: A class that compiles an expression.
• picalo.base.Global.AbstractDecorator: An abstract decorator that directs all attribute/method access first here, then to the decorated object, then back here (for the first time something is set).
  • picalo.Database._Connection: The base class of connections
    • picalo.Database._MySQLdbConnection: A specialization class for MySQLdb connections
    • picalo.Database._OdbcConnection: A specialization class for PyODBC connections
    • picalo.Database._Psycopg2Connection: A specialization class for psycopg2 connections
  • picalo.Database._Cursor: A database cursor.
• picalo.base.Record.Record: An individual record of a Table.
• picalo.base.Table.Table: The primary data structure used in Picalo modules.
• picalo.base.Table.TableDataPageFile: A single page file on disk
• picalo.base.Table.UnicodeCSVReader
• picalo.base.Table.UnicodeCSVWriter