------------------------------------------------------------------------------ ooooooooooooooooooooooooooo WDK Version 1.6 oooooooooooooooooooooooooooooooo ------------------------------------------------------------------------------ ==================== Model - Fixed Bugs ======================== postgres support bugs: * 100, fix postgres support. Support for postgres is now tested. wdkSanityTest runs successfully against postgres. attribute query rewriting bugs: * 56, attribute query with nested where clause not handled correctly * 57, attribute query can not be an aggregate query * 83, union queries mangled by caching rewrite * 89, column count mismatch for attribute queries command line tools: * 98, wdkQuery: don't allow isCacheable to be set on command line * 99, wdkSanityTest: missing queries, etc, must cause the test to fail * 111, Summary paging broken * 91, wdkQuery does not allow isCacheable='false' * 107, wdkSanityTest mis-counts and mis-reports * 82, wdkSummary throws exception on uncached attribute queries * 60, wdkQuery should be able to display the SQL it's running code cleanup: * 97, refactor and clean up of Answer and friends ===================== Model - Features ========================== * 81, wdkSanity needs to handle questions * 88, require summary tests in sanityTest * 62, add -showQuery flag to wdkQuery and wdkSummary * 103, make release script ===================== Controller - Fixed Bugs =================== ===================== Controller - Features ===================== ===================== View - Fixed Bugs ========================= * 109, method renames in model.PrimaryKeyValue broken the view ===================== View - Features =========================== ------------------------------------------------------------------------------ ooooooooooooooooooooooooooo WDK Version 1.5 oooooooooooooooooooooooooooooooo ------------------------------------------------------------------------------ Model - Fixed Bugs * 22, SQL query replacement code couldn't handle keywords (e.g. "select", "where") of different cases. Now a case insensitive seach is in place. * 56, naive parsing of attribute query SQL to join with id query result cache table might result in non-functional SQL in many non-trivial cases. Implemented quick fix for simple cases, more robust solution proposed in tracker item 57. * 82, wdkSummary throws exception on uncached attribute queries. Note isCacheable attribute for attributes queries does not matter - it is intended for id queries instead. However the model does have bug when it reads this value in determining whether to check for the multi-mode column in the mangled attribute query. * Made the SQL query replacement code to support UNION queries, as well as INTERSECT and EXCEPT Model - Features * add -showQuery option to wdkQuery and wdkSummary command to print out the SQL * Provide support for federated primary key. Now the primary key can be a combination of project_id and local_primary_key, where project_id is a unique name-id pair that identifies the GUS instance involved in the federated system, and local_primary_key is the current key used to identify the piece of information, such as locus_tag, source_id, etc. * Provide backward compatibility to the current non-federation models; that is, the federated key is totally options. Controller - Fixed Bugs Controller - Features * Provide support for federated primary key. View - Fixed Bugs * 76, record page showing Federation specific headings such as Project ID View - Features * Provide support for federated primary key. * Allow questionSets to be displayed either as a flattened list of quesitons (cp index.jsp.flat to index.jsp) or as drop down lists, each of which representing a questionSet (cp index.jsp.sets to index.jsp). * Added custom page hooks (under customPages/) so that you do not need to modify default view files in order to customize your site: I) site wide customizations: questionSets.jsp -- customQuestionSets.jsp question.jsp -- customQuestion.jsp questionSetsFlat.jsp -- customQuestionSetsFlat.jsp summary.jsp -- customSummary.jsp record.jsp -- customRecord.jsp II) record-type specific customizations: question.jsp -- ..question.jsp summary.jsp -- ..summary.jsp record.jsp -- ..jsp III) question-name specific customizations: question.jsp -- ..jsp summary.jsp -- ..summary.jsp Note: 1) there is no .question in ..jsp 2) there is no .record in ..jsp 3) more specific customization take precedence when more than one levels of customization exist for the same default view. ------------------------------------------------------------------------------ oooooooooooooooooooooooo WDKToySite Version 1.6 oooooooooooooooooooooooooooo ------------------------------------------------------------------------------ ==================== Model - Fixed Bugs ======================== * included some previously missed out query tests ===================== Model - Features ========================== * trimmed test data so that it now takes about 15 minutes to load test database instead of hours (note: need to re-create test database after installing this version) * modified toyModel.xml to reflect test data trimming (note: need to re-create cache after installing this version) * added test cases for all Questions defined (testing summary) ===================== Site - Fixed Bugs ========================= ===================== Site - Features =========================== ------------------------------------------------------------------------------ oooooooooooooooooooooooo WDKToySite Version 1.5 oooooooooooooooooooooooooooo ------------------------------------------------------------------------------ Model - Fixed Bugs * fixed bugs of sanity test model, and it now includes all queries (except special cases) defined in toyModel.xml. Model - Features * added one column, row_project_id, into each of the test table data file * provided a new set of configuration files, toyFedModel, which demonstrate the use of federated primary key Site - Fixed Bugs Site - Features