NAME
   ORDB::CPANUploads - An ORLite-based ORM Database API for all CPAN
   uploads

DESCRIPTION
   ORDB::CPANUploads is a simple module which provides a query interface to
   the historic list of all CPAN uploads.

   It is based on the bzip2 export file located at the following URL.

   <http://devel.cpantesters.org/uploads/uploads.db.bz2>

   It contains one primary class implementation class, located at
   ORDB::CPANUploads::Uploads.

METHODS
 age
     my $seconds = ORDB::CPANUploads->age;

   The "age" method uses the release time of the most recent upload
   contained in the upload archive to estimate the approximate age of the
   SQLite database.

   Returns duration in integer seconds or throws an exception on error.

 dsn
     my $string = ORDB::CPANUploads->dsn;

   The "dsn" accessor returns the DBI connection string used to connect to
   the SQLite database as a string.

 dbh
     my $handle = ORDB::CPANUploads->dbh;

   To reliably prevent potential SQLite deadlocks resulting from multiple
   connections in a single process, each ORLite package will only ever
   maintain a single connection to the database.

   During a transaction, this will be the same (cached) database handle.

   Although in most situations you should not need a direct DBI connection
   handle, the "dbh" method provides a method for getting a direct
   connection in a way that is compatible with connection management in
   ORLite.

   Please note that these connections should be short-lived, you should
   never hold onto a connection beyond your immediate scope.

   The transaction system in ORLite is specifically designed so that code
   using the database should never have to know whether or not it is in a
   transation.

   Because of this, you should never call the "->disconnect" method on the
   database handles yourself, as the handle may be that of a currently
   running transaction.

   Further, you should do your own transaction management on a handle
   provided by the "dbh" method.

   In cases where there are extreme needs, and you absolutely have to
   violate these connection handling rules, you should create your own
   completely manual "DBI->connect" call to the database, using the connect
   string provided by the "dsn" method.

   The "dbh" method returns a DBI::db object, or throws an exception on
   error.

 begin
     ORDB::CPANUploads->begin;

   The "begin" method indicates the start of a transaction.

   In the same way that ORLite allows only a single connection, likewise it
   allows only a single application-wide transaction.

   No indication is given as to whether you are currently in a transaction
   or not, all code should be written neutrally so that it works either way
   or doesn't need to care.

   Returns true or throws an exception on error.

 rollback
   The "rollback" method rolls back the current transaction. If called
   outside of a current transaction, it is accepted and treated as a null
   operation.

   Once the rollback has been completed, the database connection falls back
   into auto-commit state. If you wish to immediately start another
   transaction, you will need to issue a separate "->begin" call.

   If a transaction exists at "END"-time as the process exits, it will be
   automatically rolled back.

   Returns true or throws an exception on error.

 do
     ORDB::CPANUploads->do(
         'insert into table ( foo, bar ) values ( ?, ? )', {},
         \$foo_value,
         \$bar_value,
     );

   The "do" method is a direct wrapper around the equivalent DBI method,
   but applied to the appropriate locally-provided connection or
   transaction.

   It takes the same parameters and has the same return values and error
   behaviour.

 selectall_arrayref
   The "selectall_arrayref" method is a direct wrapper around the
   equivalent DBI method, but applied to the appropriate locally-provided
   connection or transaction.

   It takes the same parameters and has the same return values and error
   behaviour.

 selectall_hashref
   The "selectall_hashref" method is a direct wrapper around the equivalent
   DBI method, but applied to the appropriate locally-provided connection
   or transaction.

   It takes the same parameters and has the same return values and error
   behaviour.

 selectcol_arrayref
   The "selectcol_arrayref" method is a direct wrapper around the
   equivalent DBI method, but applied to the appropriate locally-provided
   connection or transaction.

   It takes the same parameters and has the same return values and error
   behaviour.

 selectrow_array
   The "selectrow_array" method is a direct wrapper around the equivalent
   DBI method, but applied to the appropriate locally-provided connection
   or transaction.

   It takes the same parameters and has the same return values and error
   behaviour.

 selectrow_arrayref
   The "selectrow_arrayref" method is a direct wrapper around the
   equivalent DBI method, but applied to the appropriate locally-provided
   connection or transaction.

   It takes the same parameters and has the same return values and error
   behaviour.

 selectrow_hashref
   The "selectrow_hashref" method is a direct wrapper around the equivalent
   DBI method, but applied to the appropriate locally-provided connection
   or transaction.

   It takes the same parameters and has the same return values and error
   behaviour.

 prepare
   The "prepare" method is a direct wrapper around the equivalent DBI
   method, but applied to the appropriate locally-provided connection or
   transaction

   It takes the same parameters and has the same return values and error
   behaviour.

   In general though, you should try to avoid the use of your own prepared
   statements if possible, although this is only a recommendation and by no
   means prohibited.

 pragma
     # Get the user_version for the schema
     my $version = ORDB::CPANUploads->pragma('user_version');

   The "pragma" method provides a convenient method for fetching a pragma
   for a database. See the SQLite documentation for more details.

SUPPORT
   ORDB::CPANUploads is based on ORLite::Mirror.

   Documentation created by ORLite::Pod 0.10.

   Bugs should be reported via the CPAN bug tracker at

   <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=ORDB-CPANUploads>

   For other issues, contact the author.

AUTHOR
   Adam Kennedy <[email protected]>

COPYRIGHT
   Copyright 2009 - 2011 Adam Kennedy.

   This program is free software; you can redistribute it and/or modify it
   under the same terms as Perl itself.

   The full text of the license can be found in the LICENSE file included
   with this module.

You are viewing proxied material from ftp.icm.edu.pl. The copyright of proxied material belongs to its original authors. Any comments or complaints in relation to proxied material should be directed to the original authors of the content concerned. Please see the disclaimer for more details.