Cdbi cookbook
From ClassDBI
How to, why to, tips and tricks:
- common problems
- Class::DBI and Template Toolkit
- using Class::Date to handle dates with ease
- using DateTime another way of working with dates
- complex many to many with a complex many to many example
- setting system date fields (or equivalent)
- Oracle specific stuff
- setting default values
- using transactions (a.k.a. atomic updates)
- using with mod_perl
- working with blobs
- case insensitive searches
- order by multiple columns
- see all SQL
- edit data in a text editor
- delete by setting deleted column to not null
- confirm password at registration
- directly execute SQL
- using joins
- load file from STDIN
- query aggregates
- deleting related objects
- conflicting updates
- self-referencing tables
- searching for NULL and IS NOT NULL
- working with triggers
- using multiple databases
- re-using legacy DBI handles
- overriding autogenerated accessors
- get a database handle from your Class::DBI object
- transform SQL
- select distinct
- parent child relationships
- overriding retrieve_all for specific ordering
- storing encrypted passwords
- versioning with two tables
- implementing an object factory, or using multiple classes for one table
- inflating and deflating storable data
- turning a row id into an accessor, or how to turn tables on their side
[edit]
