args to Local::DB either dsn or dbname; integration with other apps and Local::QueryLogger; switched off query logging for test scripts

passed D2 config through app to model so authenticate_user can exempt passwd for development platform

fix for 'mysql server has gone away' message - new DB check_db_connection() method clears dbix object if no ping received from db, forcing dbix object recreation; wrapped 'horrible' deferred keyword in flash() method; dev logger uses Console::Colored output

moved get_diagnoses string length test from routes class to model

returns message to report screen after submission; forced 'updated_at' timestamp as ON UPDATE doesn't seem to work; moved generation of previous reports list from login to search page and out of session into var; prevented ajax lookup if < 3 chars (seems to generate persistent error if db does search with undef param); moved SQL::Lib methods query construction to new create_query() method; moved 'deferred' display to main layout tt

retrieve list of previously reported requests at login

modified HTML::FormHandler validation class to return same data structure as Data::FormValidator class

new D2::Session::DB class for db sessions

switched model & app validation classes - DFV currently more suitable for model than HTML::FormHandler: eg manipulating validation profile required fields in model instead of template

retrieves previous requests on nhs_number match; fixed t/validation.t after validation code change

separated Reporter::Validation class into RV::SearchForm & RV::ReportForm to isolate profiles; handles failure to find request from search form; ajax find diagnosis function required info key (ICDO3) to be not undef; hide some page elements in print view

replaced HTTP::Validate with Data::Formvalidator in Reporter::Validator; retrieval of request data includes previous report if submitted by same user otherwise new draft report created; request data saved in session for template in case db update/insert fails and original data needs to be re-displayed; changed validation from HTML::FormHandler to Data::FormValidator, pending ability to select validation profiles; app now fully functional

queries to retrieve test results & result summaries from db; new route class for ajax calls; formatted report_form.tt; provided some tt vars via before_template_render hook

moved sql query construction to new Reporter::SQL::Library class using Local::QueryLibrary & SQL::Abstract::More

added validation class; made login a global requirement; added more model methods