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
  • Working With Oracle Date Fields
  • Setting Session Globals
• 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

To-Do

• retrofitting over an existing schema