Welcome to the Rice-Aron Library's Periodicals Database!

This database is still under construction, so be on the lookout for added functionality in the near future. Here's what we've got for now:

• The database is defined by this script. (ERD included) Currently only has a small amount of test data in it.
• The autohandler sets up some necesary environment stuff, and loads the perl moduals. This doesn't show up to well in a browser, so you might want to open it localy in emacs or something.
• All the perl modules for Class::DBI live in cs/~dgg/mason/periodicals_db/periodicals. The modules are periodicals.pm, journal.pm, frequency.pm, issue.pm, publisher.pm, and vendor.pm
• The add_entries page allows the user to add Journals, Publishers, and Vednors to the database, as well as inputing new journal frequencies. Where ever there is a foriegn key in a table, there is a drop-down menu which pulls its values from the table it's linking to. See code.
• edit_entries is still under construction. When complete, it will allow the user to edit entries already in the database.
• show_tables allows the user to see all the entries in the Journal, Publisher, and Vendor tables by selecting the desired table from a drop-down. See code for the show_tables page here. Here's code for journals, publishers and vendors.
• Also in the show_tables drop-down is the 'Overdue Issues' option. This uses a SQL Query created with the add_constructor method. The query selects issues whose expected arrival date was before today's date, and which have not yet been recieved. This page also allows they user to mark issues as recieved. See code.
• manage_issues allows the user to add new issues to the database, and shows all the issues currently in the database. See code.
• Search page allows user to search issues by title and ISSN. It searches the journal table for maching entries, then lists all issues which have that use that journal as a foreign key. See code.