Posted By: John Chufar
Date: 2006-09-06 08:33
Summary: Personal Media Library 0.2.0
Project: Personal Media Library
Catalog your CDs, DVDs, and Books! Automated CD and Book entry using Web services.
New Version is Database independent (works with ActiveRecord supported databases)
Major changes:
Changed PML to make it independent of database type
Added validations on object fields
Fixed many bugs
Improved navigation by creating more hyperlinks
Implemented "Cascading Deletes" for child objects, with a warning, of course
Added more configuration options in the config/application.yml file
Log of changes:
- removed all find_by_sql queries, application is now database independent
-- rewrote CD list queries, removed find_by_sql for MySQL specific queries
-- rewrote MusicCategory show query, removed find_by_sql for MySQL specific queries
-- rewrote Category (CD) show query, removed find_by_sql for MySQL specific queries
- added (moved from code) CD start and end years to config file, used in lookup values in new and edit
- added hyperlink in CD/show to associated Category
- fixed bug in bookcategories; when adding new category, parent categories were not alpha-sorted
- fixed bookcategores
-- when deleting a category, all books and subcategories and those books are deleted (cascaded)
-- created Not Assigned listing, and hyperlinks to books when listing categories
- fixed validations on:
-- CD New (Add manually)
- created cascade deletes on:
- Artists with CDs
- Music Categories with CDs
- *** Changed PHYSICAL SCHEMA; default NULL for foreign keys for cds table
-- artist_id (see new schema.rb)
-- musiccategory_id (see new schema.rb)
-refactored (DRYed out) multiple add methods (addFrom Artist, addFromCategory) in CDs controller
-NOTE: Database "foreign keys" MUST be changed to default of "NULL"
- table cds: artist_id, musiccategory_id
- refactored (DRYed out) multiple list views by re-using list with flash + parms
- fixed validations and cascaded deletes on Videos:
-- parent models
-- Media Types, Ratings, Category
- refactored (DRYed out) multiple add methods (addFromRating, addFromCategory, addFrom Mediatype) in Video controller
- fixed track duration bug on cd-show (only displayed minutes and seconds, now shows hours for long tracks)
|
|