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.73 - 2003-01-02

  • Overall:
    • Bugfix in SPOPS::DBI->field_update
    • New tool to maintain bidirectional object links
    • Lots of small POD fixes throughout many files
    • Removed some previously deprecated classes
  • Individual:
    • SPOPS/Configure.pm, SPOPS/Configure/(DBI|Ruleset).pm:
      • Removed classes that have been marked as deprecated since 0.50.
    • SPOPS/DBI.pm:
      • Fix field_update() to return the number of rows updated -- if you call it from an object it will always return 1 if the update succeeded. Thanks to Ray Zimmerman for catch.
      • In save(), move the (saved) and (changed) flags *before* the post_save_action(); if you don't, any updates you do to the object in the post_save_action will be regarded as another INSERT which will either fail (duplicate primary keys) or throw you into an infinite loop (post_save_action keeps inserting new objects).
      • In save(), ensure that the field/value parameters are cleared out before we tell SQLInterface what we want to insert/update.
    • SPOPS/Tool/DBI/MaintainLinkedList.pm:
      • Add new tool to maintain previous/next links in a particular object so you can always navigate. Links are created on an object insert and reshuffled on an object remove. The tool also creates methods 'next_in_list' and 'previous_in_list' so you don't have to craft them by hand.
    • t/30_dbi.t:
      • Add more tests for field_update()
    • t/36_dbi_linked_list.t:
      • Create tests for SPOPS::Tool::DBI::MaintainLinkedList

Documentation

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

Modules

Simple Perl Object Persistence with Security
Create SPOPS classes from configuration and code
Define additional configuration methods
Default configuration methods called from SPOPS.pm
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
Represent type information for a single table
(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
Table transformations for InterBase/FirebirdSQL
Table transformations for MySQL
Table transformations for Oracle
Table transformations for PostgreSQL
Table transformations for SQLite
Table transformations for Sybase/MSSQL
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
Implement a security object and basic operations for DBI datasources
Define hierarchical security
Security object implementation for testing (loopback) objects
Common utilities for SPOPS::Secure and subclasses
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
Support objects that automatically maintain a link to the previous and next objects
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

Provides

in SPOPS/HashFile.pm