YAPC::Canada An Introduction to Class::DBI Index

Table of Contents

Introduction

1. An Introduction to Class::DBI - Database Abstraction
2. The Problem
3. The Problem - Awkward
4. The Problem - Ugly
5. The Problem - Error Prone
6. Class::DBI Features - Solves the important things
7. What Class::DBI Does and Doesn't Do
8. One Table, One Class

Comparing DBI and Class::DBI

9. SQL tasks and their Class::DBI equivalents - Creating New Records
10. SQL tasks and their Class::DBI equivalents - Updating Records
11. SQL tasks and their Class::DBI equivalents - Deleting Records
12. SQL tasks and their Class::DBI equivalents - Deleting a Range of Records
13. SQL tasks and their Class::DBI equivalents - Finding A Record (by primary key)
14. SQL tasks and their Class::DBI equivalents - Finding A Record (by any field)
15. SQL tasks and their Class::DBI equivalents - Finding A Record (by pattern match)

First Example

16. Example - And the winner is...
17. Example - And the winner is... - Using DBI
18. Example - And the winner is... - Using Class::DBI
19. Scalability - DBI
20. Scalability - Class::DBI

Primary Keys

21. Portably Generating new primary key values
22. Portably Generating new primary key values

Table Relationships

23. Multi Table Relationships
24. Multi Table Relationships - Setting up Class::DBI
25. Multi Table Relationships - A Digression on Style
26. Multi Table Relationships - A Digression on Style
27. Multi Table Relationships - One to Many and One to One (has_a)
28. Multi Table Relationships - Cleaning up accessor names
29. Multi Table Relationships - Many to Many
30. Multi Table Relationships - Many to Many
31. Multi Table Relationships - Many to Many

Cascading Deletes

32. Deleting Records from Related Tables

Gotchas

33. Class::DBI Gotchas - The Stuff you Need to Know about

Advanced Topics

34. Advanced Topics - Extending your Class::DBI Classes
35. Advanced Topics - Wrapping more complicated SQL in methods
36. Advanced Topics - Advanced Abstract Searches with Class::DBI::AbstractSearch
37. Advanced Topics - Adding extra functionality to your classes

Conclusion

38. Further Reading
39. Thank You!

Bonus Material

40. Other Database Abstraction Solutions - The Dangers of Abstraction
41. Constraints and Data Integrity
42. Copying records
43. Class::DBI Gotchas - Create and NOT NULL columns
44. Class::DBI Gotchas - Manual updating with update()
45. Class::DBI Gotchas - Automatic updating with autoupdate()
46. Class::DBI Gotchas - A strategy for when to use autoupdate()
47. Class::DBI Gotchas - Two Objects in Memory, One Object in the DB
48. Class::DBI Gotchas - Collision of Accessor Names
49. Class::DBI Gotchas - Searching context: scalar/list
50. The Joy of Installing Class::DBI

 

<< Previous | Index | Next >> Copyright © 2003 Michael Graham