Search results for "dist:SPOPS DBI"
SPOPS::DBI - Implement SPOPS class, serializing into a DBI database
This SPOPS class is not meant to be used directly. Instead, you inherit certain methods from it while implementing your own. Your module should implement: * (optional) Methods to sort member objects or perform operations on groups of them at once. * ...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::DBI::Pg - PostgreSQL-specific routines for the SPOPS::DBI
This just implements some Postgres-specific routines so we can abstract them out. One of them optionally returns the sequence value of the just-inserted id field. Of course, this only works if you have a the field marked as 'SERIAL' or using a sequen...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::DBI::MySQL - MySQL-specific code for DBI collections
This just implements some MySQL-specific routines so we can abstract them out. One of these items is to return the just-inserted ID. Only works for tables that have at least one auto-increment field: CREATE TABLE my_table ( id int not null auto_incre...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Secure::DBI - Implement a security object and basic operations for DBI datasources
This class implements the methods necessary to create a DBI datastore for security objects. See SPOPS::Manual::Security for a definition of the interface in broader terms. Each security setting to an object is itself an object. In this manner we can ...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::DBI::SQLite - SQLite-specific code for DBI collections
This just implements some SQLite-specific routines so we can abstract them out. One of these items is to auto-generate keys. SQLite supports auto-generated keys in one instance only -- when you specify the first column as an "integer" field (not "int...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::DBI::Sybase - Sybase-specific routines for the SPOPS::DBI
This just implements some Sybase-specific routines so we can abstract them out. One of them optionally returns the IDENTITY value returned by the last insert. Of course, this only works if you have an IDENTITY field in your table: CREATE TABLE my_tab...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::DBI::Oracle - Oracle-specific routines for the SPOPS::DBI
This subclass allows you to specify a sequence name from which you can retrieve the next ID value....
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::DBI::TypeInfo - Represent type information for a single table
This is a lightweight object to maintain state about a field names and DBI types for a particular table in a particular database. It is generally used by SPOPS::SQLInterface, but it is sufficiently decoupled so you might find it useful elsewhere. It ...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Iterator::DBI - Implementation of SPOPS::Iterator for SPOPS::DBI
This is an implementation of the "SPOPS::Iterator" interface -- for usage guidelines please see the documentation for that module. The methods documented here are for SPOPS developers (versus SPOPS users)....
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Key::DBI::Pool - Retrieves ID field information from a pool
This module retrieves a value from a pool of key values matched up to tables. It is not as fast as IDENTITY fields (SPOPS::Key::DBI::Identity, auto_incrementing values or sequences, but can be portable among databases and, most importantly, works in ...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Exception::DBI - SPOPS exception with extra DBI parameters
Same as SPOPS::Exception but we add three new properties: sql ($) The SQL statement SPOPS tried to run. Note that this may be empty if the exception was thrown before the statement could be prepared. (For instance, if SPOPS cannot find a datasource.)...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::DBI::InterBase - InterBase-specific routines for the SPOPS::DBI
This just implements some InterBase-specific routines so we can abstract them out. The main one is to be able to utilize an existing "generator" object for creating unique key values. We cannot use the same pattern as with Oracle/PostgreSQL sequences...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Export::DBI::Data - Export SPOPS objects as data for importing directly into a DBI table
Implement raw DBI data output for SPOPS::Export. This is almost exactly like SPOPS::Export::Object except we export the table name instead of the object class. Output from this should be usable by SPOPS::Import::DBI::Data....
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Import::DBI::Data - Import raw data to a DBI table
Import raw (non-object) data to a DBI table....
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::ClassFactory::DBI - Define additional configuration methods
This class implements a behavior for the 'links_to' slot as described in SPOPS::ClassFactory. It is possible -- and perhaps desirable for the sake of clarity -- to create a method within *SPOPS::DBI* that does all the work that this behavior does, th...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Key::DBI::Sequence - Retrieve sequence values from a supported DBI database
This class makes a call to a 'sequence' to retrieve a value for use as a unique ID. Sequence implementations vary among databases, but generally they ensure that the sequence always generates a unique number no matter how many times it is accesed and...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Key::DBI::Identity - Retrieve IDENTITY values from a supported DBI database
This class enables a just-created object to the IDENTITY value returned by its last insert. Of course, this only works if you have an IDENTITY field in your table, such as: CREATE TABLE my_table ( id NUMERIC( 8, 0 ) IDENTITY NOT NULL, ... ) This meth...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Import::DBI::Table - Import a DBI table structure
This class allows you to transform and import (or simply display) a DBI table structure. Transformations are done via two means. The first is the database-specific classes and the standard modifications provided by SPOPS::Import::DBI::TableTransform....
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Import::DBI::Update - Update existing data in a DBI table
This importer updates existing data in a DBI table. This may seem out of place in the SPOPS::Import hierarchy, but not if you think of importing in the more abstract manner of manipulating data in the database rather than getting data out of it... Re...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC
SPOPS::Import::DBI::Delete - Delete existing data from a DBI table
This importer deletes existing data from a DBI table. This may seem out of place in the SPOPS::Import hierarchy, but not if you think of importing in the more abstract manner of manipulating data in the database rather than getting data out of it... ...
CWINTERS/SPOPS-0.87 - 02 Jun 2004 01:03:25 UTC