Class::DBI::Query - phpMan

NAME
    Class::DBI::Query - Deprecated SQL manager for Class::DBI

SYNOPSIS
            my $sth = Class::DBI::Query
                    ->new({
                            owner => $class,
                            sqlname => $type,
                            essential => \@columns,
                            where_columns => \@where_cols,
                    })
                    ->run($val);

DESCRIPTION
    This abstracts away many of the details of the Class::DBI underlying SQL
    mechanism. For the most part you probably don't want to be interfacing
    directly with this.

    The underlying mechanisms are not yet stable, and are subject to change
    at any time.

OPTIONS
    A Query can have many options set before executing. Most can either be
    passed as an option to new(), or set later if you are building the query
    up dynamically:

  owner
    The Class::DBI subclass that 'owns' this query. In the vast majority of
    cases a query will return objects - the owner is the class of which
    instances will be returned.

  sqlname
    This should be the name of a query set up using set_sql.

  where_clause
    This is the raw SQL that will substituted into the 'WHERE %s' in your
    query. If you have multiple %s's in your query then you should supply a
    listref of where_clauses. This SQL can include placeholders, which will
    be used when you call run().

  essential
    When retrieving rows from the database that match the WHERE clause of
    the query, these are the columns that we fetch back and pre-load the
    resulting objects with. By default this is the Essential column group of
    the owner class.

METHODS
  where()
            $query->where($match, @columns);

    This will extend your 'WHERE' clause by adding a 'AND $column = ?' (or
    whatever $match is, isntead of "=") for each column passed. If you have
    multiple WHERE clauses this will extend the last one.