The following module was proposed for inclusion in the Module List:
modid: DBIx::TableHash DSLIP: MnpOp description: Hash refs tied to full/partial SQL tables userid: CHTHORMAN (Chris Thorman) chapterid: 7 (Database_Interfaces) communities: similar: DBIx::Table, DBIx::Recordset rationale: This is a helper module for DBI, so it belongs in DBIx. It is similar to DBIx::Table in functionality, but has some other features, too and a different style of interface and usage. TableHash is most often used to create tied hash refs that connect to an entire table or subset of a table in an SQL database via DBI (currently only tested with mysql). The tied hashes can be used to add, update, retrieve, or delete either entire records OR individual fields from the live database using simple hash assignments. "copy" options can be used to simply get a non-tied, static hash in memory that is no longer tied to the database but required only one query to retrieve. The tied object also has a number of utility methods for constructing a few of the more common general-purpose SQL queries (using the same DBH handle owned by the object). It has some similarity to DBIx::Recordset but is less ambitious. However, it has several more-flexible options as well. It is designed for ease of sub-classing, and has been in production use on a major, high-availability Web site for many years. enteredby: CHTHORMAN (Chris Thorman) enteredon: Fri Mar 22 23:33:42 2002 GMT The resulting entry would be: DBIx:: ::TableHash MnpOp Hash refs tied to full/partial SQL tables CHTHORMAN Thanks for registering, The Pause Team PS: The following links are only valid for module list maintainers: Registration form with editing capabilities: https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=af000000_681ea8757890166e&SUBMIT_pause99_add_mod_preview=1 Immediate (one click) registration: https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=af000000_681ea8757890166e&SUBMIT_pause99_add_mod_insertit=1