/ 
SPOPS-0.57
River stage one • 2 direct dependents • 2 total dependents

Changes for version 0.57 - 2002-02-23

  • Overall:
    • SPOPS now works with Oracle! All tests pass and all the scripts under eg/ work ok as well, but you might consider this support beta until someone who actually knows Oracle takes a look.
    • SPOPS now works with SQLite! SQLite is an embeddable database, and DBD::SQLite comes with the database source ready to compile. You can use it instead of DBD::Sprite or DBD::CSV -- it is much faster and behaves like a real database. Kudos to the indefatigable Matt Sergant!
    • Fix tests and (hopefully) Makefile.PL to follow all dependencies properly.
  • Individual:
    • Makefile.PL:
      • Add 'Class::Factory' as a dependency
    • eg/fetch_all.pl:
      • Display all known objects in eg/ modules
    • eg/users_groups_oracle.sql, eg/users_groups_clear_oracle.sql:
      • Data create/clear scripts for Oracle
    • eg/users_groups_sqlite.pl:
      • Data create script for SQLite
    • eg/My/(User|Group|Doodad|Security).pm:
      • Use named sequences versus relying on default behavior
    • SPOPS.pm:
      • Modified clone() to respect false-but-defined values passed in for the new object. Thanks to Ray Zimmerman <rz10@cornell.edu> for the patch.
    • SPOPS/DBI.pm:
      • Add 'sql_case_insensitive' to allow drivers to specify a case-insensitive operator. (Default: 'LIKE', which may or may not work for all databases but at least it will not break anything.)
      • Add docs for the pre_fetch_id() and post_fetch_id() callbacks to get/find ID values on an insert.
      • The return value from pre_fetch_id() is by default set to no_quote -- the implementer of pre_fetch_id() is responsible for either quoting it or for telling SPOPS::DBI that it is ok to quote it using the normal means.
    • SPOPS/DBI/Pg.pm:
      • Specify the '~*' case-insensitive operator
      • Modify how we fetch/retrieve sequence values.
    • SPOPS/DBI/Oracle.pm:
      • Hey, we support Oracle now! (See above)
    • SPOPS/DBI/SQLite.pm:
      • Hey, we support SQLite now! (See above)
    • SPOPS/Exception.pm:
      • You can now pass as many arguments as you want to throw() -- they will all get concatenated into the exception message unless the last one is a hashref, which will be set to the optional parameter hashref.
    • SPOPS/Import.pm, SPOPS/Export.pm:
      • Modify to use Class::Factory
    • SPOPS/Import/TableTransform/(Oracle|SQLite).pm:
      • Add table transforms for Oracle and SQLite
    • SPOPS/Key/(Random|UUID).pm:
      • Quote the return value from pre_fetch_id()
    • SPOPS/Secure.pm:
      • Add a 'require SPOPS::Exception::Security' to bring in the module, but add it after all the constants have been defined so we don't get into a deadlock
    • t/05_exception.t:
      • Modify stringification comparison to work properly all the time
    • t/30_dbi.t, t/31_dbi_multifield.t, t/40_ldap.t:
      • Only run the END {} if we're running the tests
    • t/dbi_config.pl:
      • Add Oracle-specific info

Documentation

SPOPS::Manual
User Guide and Reference Manual for SPOPS
SPOPS::Manual::CodeGeneration
How SPOPS builds classes
SPOPS::Manual::Configuration
Description of variables used in the SPOPS configuration process
SPOPS::Manual::Cookbook
Recipes for SPOPS usage
SPOPS::Manual::Datasource
SPOPS datasource use and how you can customize
SPOPS::Manual::Exceptions
Error handling in SPOPS
SPOPS::Manual::ImportExport
Moving data (and more) with SPOPS
SPOPS::Manual::Intro
Introduction and overview of SPOPS
SPOPS::Manual::Object
Shows how you interact with SPOPS objects.
SPOPS::Manual::ObjectRules
Use rules to give your object custom behavior
SPOPS::Manual::Relationships
SPOPS object relationships
SPOPS::Manual::Security
SPOPS security system and how you can customize
SPOPS::Manual::Serialization
How SPOPS serializes objects
test_dbd_driver.pl
Perform tests on a DBD driver to see if it may work with SPOPS

Modules

SPOPS
Simple Perl Object Persistence with Security
SPOPS::ClassFactory
Create SPOPS classes from configuration and code
SPOPS::ClassFactory::DBI
Define additional configuration methods
SPOPS::ClassFactory::DefaultBehavior
Default configuration methods called from SPOPS.pm
SPOPS::ClassFactory::LDAP
Create relationships among LDAP objects
SPOPS::Configure
DEPRECATED
SPOPS::Configure::DBI
DEPRECATED
SPOPS::Configure::Ruleset
DEPRECATED
SPOPS::DBI
Implement SPOPS class, serializing into a DBI database
SPOPS::DBI::MySQL
MySQL-specific code for DBI collections
SPOPS::DBI::Oracle
Oracle-specific routines for the SPOPS::DBI
SPOPS::DBI::Pg
PostgreSQL-specific routines for the SPOPS::DBI
SPOPS::DBI::SQLite
SQLite-specific code for DBI collections
SPOPS::DBI::Sybase
Sybase-specific routines for the SPOPS::DBI
SPOPS::Error
(DEPRECATED) Centralized error messages from all SPOPS objects.
SPOPS::Exception
Base class for exceptions in SPOPS
SPOPS::Exception::DBI
SPOPS exception with extra DBI parameters
SPOPS::Exception::LDAP
SPOPS exception with extra LDAP parameters
SPOPS::Exception::Security
SPOPS exception with extra security parameters
SPOPS::Export
Export SPOPS objects to various formats
SPOPS::Export::DBI::Data
Export SPOPS objects as data for importing directly into a DBI table
SPOPS::Export::Object
Dump SPOPS objects to a portable format
SPOPS::Export::Perl
Dump SPOPS objects to a pure serialized Perl format
SPOPS::Export::SQL
Export SPOPS objects as a series of SQL statements
SPOPS::Export::XML
Export SPOPS objects in XML format
SPOPS::GDBM
Store SPOPS objects in a GDBM database
SPOPS::HashFile
Implement as objects files containing perl hashrefs dumped to text
SPOPS::Import
Factory and parent for importing SPOPS objects
SPOPS::Import::DBI::Data
Import raw data to a DBI table
SPOPS::Import::DBI::Table
Import a DBI table structure
SPOPS::Import::DBI::TableTransform
Factory class for database-specific transformations
SPOPS::Import::Object
Import SPOPS objects
SPOPS::Initialize
Provide methods for initializing groups of SPOPS objects at once
SPOPS::Iterator
Class to cycle through results and return SPOPS objects
SPOPS::Iterator::DBI
Implementation of SPOPS::Iterator for SPOPS::DBI
SPOPS::Iterator::LDAP
Implementation of SPOPS::Iterator for SPOPS::LDAP
SPOPS::Iterator::WrapList
SPOPS::Iterator wrapper around object lists
SPOPS::Key::DBI::HandleField
Retrieve an auto-increment value from a DBI statement or database handle
SPOPS::Key::DBI::Identity
Retrieve IDENTITY values from a supported DBI database
SPOPS::Key::DBI::Pool
Retrieves ID field information from a pool
SPOPS::Key::DBI::Sequence
Retrieve sequence values from a supported DBI database
SPOPS::Key::Random
Creates a random alphanumeric code for the ID field
SPOPS::Key::UUID
Creates a Universally Unique ID (UUID) as a key
SPOPS::LDAP
Implement object persistence in an LDAP datastore
SPOPS::LDAP::MultiDatasource
SPOPS::LDAP functionality but fetching objects from multiple datasources
SPOPS::Loopback
Simple SPOPS class used for testing rules and other goodies
SPOPS::SQLInterface
Generic routines for DBI database interaction
SPOPS::Secure
Implement security across one or more classes of SPOPS objects
SPOPS::Secure::Hierarchy
Define hierarchical security
SPOPS::Tie
Simple class implementing tied hash with some goodies
SPOPS::Tie::StrictField
Enable field checking for SPOPS objects
SPOPS::Utility
Utility methods for SPOPS objects
My::DBI::DatasourceConfigure
My::DBI::FindDefaults
My::DiscoverField
My::LDAP::DatasourceConfigure
My::Security
My::UTFConvert
My::User

Provides

SPOPS::Import::DBI::TableTransform::MySQL
in SPOPS/Import/DBI/TableTransform/MySQL.pm
SPOPS::Import::DBI::TableTransform::Oracle
in SPOPS/Import/DBI/TableTransform/Oracle.pm
SPOPS::Import::DBI::TableTransform::Pg
in SPOPS/Import/DBI/TableTransform/Pg.pm
SPOPS::Import::DBI::TableTransform::SQLite
in SPOPS/Import/DBI/TableTransform/SQLite.pm
SPOPS::Import::DBI::TableTransform::Sybase
in SPOPS/Import/DBI/TableTransform/Sybase.pm
SPOPS::TieFileHash
in SPOPS/HashFile.pm

Examples

Other files