The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

Changes for version 0.69 - 2002-09-11

  • Overall:
    • Add new tool (SPOPS::Tool::DateConvert) to convert a date into a date object on object fetch().
    • Add tests for SPOPS::Export implementations and add features to loopback tester.
    • Other small bugfixes.
  • Individual:
      • Add USE_CACHE() and set_global_use_cache() methods, which checks and sets caching for all SPOPS objects in a process. Add docs about caching.
    • SPOPS/ClassFactory/
      • In conf_modify_config() - ensure that the 'field' property is an arrayref before derefenecing.
    • SPOPS/
      • fetch(), fetch_group(), save() and remove() will now interact with simple in-memory storage so we can be a little trickier with testing
      • Add peek() for testing purposes.
      • fetch_group() allows simple querying of in-memory storage (only of the type field = value)
      • Add fetch_iterator() which just wraps the result of fetch_group() in a SPOPS::Iterator::WrapList object
    • SPOPS/Tool/
      • Add new tool for converting dates into object (Class::Date or Time::Piece) on fetch and into date string in save.
    • SPOPS/Tool/DBI/
      • Check for valid info should only ensure that DSN and username are defined. An empty password should be ok. (Thanks to Ray Zimmerman for the bug report.)
    • SPOPS/
      • Modify format for today() to be %Y-%m-%d (Thanks to Swen Thuemmler ( for pointing it out.)
    • t/41_ldap_inline_config.t:
      • Create simple test for inlining an LDAP configuration.
    • t/52_rule_date_convert.t:
      • Add tests for SPOPS::Tool::DateConvert
    • t/[60_export_object.t,61_export_xml.t,62_export_perl.t, 63_export_sql.t,64_export_dbdata.t]:
      • Add tests for various SPOPS::Export implementations


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


Simple Perl Object Persistence with Security
Create SPOPS classes from configuration and code
Define additional configuration methods
Default configuration methods called from
Create relationships among LDAP objects
Implement SPOPS class, serializing into a DBI database
InterBase-specific routines for the SPOPS::DBI
MySQL-specific code for DBI collections
Oracle-specific routines for the SPOPS::DBI
PostgreSQL-specific routines for the SPOPS::DBI
SQLite-specific code for DBI collections
Sybase-specific routines for the SPOPS::DBI
(DEPRECATED) Centralized error messages from all SPOPS objects.
Base class for exceptions in SPOPS
SPOPS exception with extra DBI parameters
SPOPS exception with extra LDAP parameters
SPOPS exception with extra security parameters
Export SPOPS objects to various formats
Export SPOPS objects as data for importing directly into a DBI table
Dump SPOPS objects to a portable format
Dump SPOPS objects to a pure serialized Perl format
Export SPOPS objects as a series of SQL statements
Export SPOPS objects in XML format
Store SPOPS objects in a GDBM database
Implement as objects files containing perl hashrefs dumped to text
Factory and parent for importing SPOPS objects
Import raw data to a DBI table
Import a DBI table structure
Factory class for database-specific transformations
Import SPOPS objects
Provide methods for initializing groups of SPOPS objects at once
Class to cycle through results and return SPOPS objects
Implementation of SPOPS::Iterator for SPOPS::DBI
Implementation of SPOPS::Iterator for SPOPS::LDAP
SPOPS::Iterator wrapper around object lists
Retrieve an auto-increment value from a DBI statement or database handle
Retrieve IDENTITY values from a supported DBI database
Retrieves ID field information from a pool
Retrieve sequence values from a supported DBI database
Creates a random alphanumeric code for the ID field
Creates a Universally Unique ID (UUID) as a key
Implement object persistence in an LDAP datastore
SPOPS::LDAP functionality but fetching objects from multiple datasources
Simple SPOPS class used for testing rules and other goodies
Generic routines for DBI database interaction
Implement security across one or more classes of SPOPS objects
Define hierarchical security
Simple class implementing tied hash with some goodies
Enable field checking for SPOPS objects
Make a particular object create-only -- it cannot be updated
Embed the parameters for a DBI handle in object configuration
SPOPS::ClassFactory rule implementing autofield discovery
Load default values from a particular record
Convert dates to objects to/from your datastore
Embed the parameters for a LDAP handle in object configuration
Make a particular object read-only
Provide automatic UTF-8 conversion
Utility methods for SPOPS objects


in SPOPS/Import/DBI/TableTransform/
in SPOPS/Import/DBI/TableTransform/
in SPOPS/Import/DBI/TableTransform/
in SPOPS/Import/DBI/TableTransform/
in SPOPS/Import/DBI/TableTransform/
in SPOPS/Import/DBI/TableTransform/